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