Quanlong Huang created IMPALA-13336:
---------------------------------------
Summary: Syntax error in creating Iceberg test table on Apache
Hive 3
Key: IMPALA-13336
URL: https://issues.apache.org/jira/browse/IMPALA-13336
Project: IMPALA
Issue Type: Bug
Components: Infrastructure
Reporter: Quanlong Huang
Assignee: Quanlong Huang
IMPALA-13284 supports loading test data on Apache Hive 3. However, the
following statement has a syntax error:
{noformat}
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){noformat}
The TBLPROPERTIES clause should be put after the LOCATION clause.
CC [~boroknagyz]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
