报错背景:
创建表时,报警FAILED: ParseException line 10:0 missing EOF at ‘location’ near ‘)’
报错现象:
建表语句
CREATE EXTERNAL TABLE IF NOT EXISTS dw_csai_cardiogram
(`start` STRING COMMENT '',`end` STRING COMMENT '',week STRING COMMENT '',account_id BIGINT COMMENT '',account_name STRING COMMENT '')
COMMENT '天的心电图'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
stored as parquet
tblproperties('parquet.compression'='snappy')
location '/user/hive/warehouse/test.db/ods/dw_csai_cardiogram/';
报错原因:
官网给的例子,也是要求tblproperties(‘parquet.compression’=‘snappy’)属性,需要放在最后面
报错解决:
将tblproperties(‘parquet.compression’=‘snappy’)语句放在最后面就可以啦、
请参考create table命令的官网定义:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable