hive建表关键词处理

FAILED: ParseException line 3:3 cannot recognize input near ‘=’ ‘0’ ‘(’ in column type
-bash: exchange: command not found
FAILED: ParseException line 4:1 cannot recognize input near ‘BIGINT’ ‘comment’ ‘’‘’ in column name or constraint

解决方案：关键词加``，同时需要加\转义

hive -e “”"
CREATE TABLE IF NOT EXISTS test_z_pe.test123 (
id BIGINT comment ‘递增主键’,
`exchange` BIGINT comment ‘拟上市公司id’
)PARTITIONED BY (add_partion_date string)
row format delimited fields terminated by ‘\u0001’
stored as orc
tblproperties(‘orc.compress’=‘SNAPPY’)

“”"