Use the DEFAULT_TRANSACTIONAL_TYPE
query option to create insert-only
transactional tables by default.
DEFAULT_TRANSACTIONAL_TYPE
query 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
or
transactional_properties
, are set, this query option is ignored.
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