DEFAULT_TRANSACTIONAL_TYPE Query Option

Use the DEFAULT_TRANSACTIONAL_TYPE query option to create insert-only transactional tables by default.

Note: The DEFAULT_TRANSACTIONAL_TYPE query option applies only when integrated with Hive 3.
The supported values are:

If either table properties, transactional or transactional_properties, are set, this query option is ignored.

Note: The DEFAULT_TRANSACTIONAL_TYPE query option does not affect external, Kudu, or HBase tables as these cannot be transactional.

Type: Enum as specified above

Default: NONE

Added in: Impala 3.3