DEFAULT_TRANSACTIONAL_TYPE Query Option
DEFAULT_TRANSACTIONAL_TYPE query option to create insert-only
transactional tables by default.
DEFAULT_TRANSACTIONAL_TYPEquery option applies only when integrated with Hive 3.
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_properties, are set, this query option is ignored.
DEFAULT_TRANSACTIONAL_TYPEquery option does not affect external, Kudu, or HBase tables as these cannot be transactional.
Type: Enum as specified above
Added in: Impala 3.3