[IMPALA-13336] Syntax error in creating Iceberg test table on Apache Hive 3

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Infrastructure
• Epic Color: ghx-label-2
• Assignee: Quanlong Huang
• Reporter: Quanlong Huang
• Created: 28/Aug/24 02:57
• Updated: 20/Sep/24 09:46

Description

IMPALA-13284 supports loading test data on Apache Hive 3. However, the following statement has a syntax error:

0: jdbc:hive2://localhost:11050/default> CREATE EXTERNAL TABLE IF NOT EXISTS fun 
ctional_parquet.iceberg_avro_format (
. . . . . . . . . . . . . . . . . . . .>   int_col int,
. . . . . . . . . . . . . . . . . . . .>   string_col string,
. . . . . . . . . . . . . . . . . . . .>   double_col double,
. . . . . . . . . . . . . . . . . . . .>   bool_col boolean
. . . . . . . . . . . . . . . . . . . .> )
. . . . . . . . . . . . . . . . . . . .> STORED BY 'org.apache.iceberg.mr.hive.H 
iveIcebergStorageHandler' TBLPROPERTIES('write.format.default'='AVRO')
. . . . . . . . . . . . . . . . . . . .> LOCATION '/test-warehouse/iceberg_test/ 
hadoop_catalog/ice/iceberg_avro_format';
going to print operations logs
printed operations logs
Getting log thread is interrupted, since query is done!
Error: Error while compiling statement: FAILED: ParseException line 8:0 missing EOF at 'LOCATION' near ')' (state=42000,code=40000)

The TBLPROPERTIES clause should be put after the LOCATION clause.
CC boroknagyz

Issue Links

• relates to: IMPALA-13284 Loading test data on Apache Hive3
• links to: Code Review