[IMPALA-10318] default_transactional_type shouldn't affect Iceberg tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.0.0
• Labels: impala-iceberg
• Epic Color: ghx-label-8
• Assignee: Zoltán Borók-Nagy
• Reporter: Zoltán Borók-Nagy
• Created: 11/Nov/20 17:09
• Updated: 19/Nov/20 08:56
• Resolved: 19/Nov/20 08:56

Description

Setting default_transactional_type prevents the creation of Iceberg tables:

 

SET default_transactional_type=insert_only;
create table ice_hadoop_tables (i int)
stored as iceberg
location '/test-warehouse/ice_hive_cat/' tblproperties('iceberg.catalog'='hadoop.tables');

ERROR: ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore: CAUSED BY: MetaException: A managed table's location should be located within managed warehouse root directory or within its database's managedLocationUri. Table ice_hadoop_tables_def_trans's location is not valid:hdfs://localhost:20500/test-warehouse/ice_hive_cat, managed warehouse:hdfs://localhost:20500/test-warehouse/managed

We shouldn't set the transactional table properties for Iceberg tables.