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:

  • NONE: The table will not be created as transactional.
  • INSERT_ONLY: The table will be created as transactional. See Impala Transactions for details.

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

Parent topic: Query Options for the SET Statement