您好,欢迎来到伴沃教育。
搜索
您的当前位置:首页hive 建表报错:ParseException - canno

hive 建表报错:ParseException - canno

来源:伴沃教育

hive 建表报错:ParseException - cannot recognize input near 'end' 'string'

建表语句为

CREATE EXTERNAL TABLE moveProjects (cid string, end string, category string)
STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
TBLPROPERTIES ("dynamodb.table.name" = "Projects","dynamodb.column.mapping" = "cid:cid,end:end,category:category");

报错

NoViableAltException(88@[])at org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser.identifier(HiveParser_IdentifiersParser.java:9123)at org.apache.hadoop.hive.ql.parse.HiveParser.identifier(HiveParser.java:30750)...more stack trace...FAILED: ParseException line 1:77 cannot recognize input near 'end' 'string' ',' in column specification

end 字段为 hive 保留字段,修改之后即可。如果非要用这个字段名,就用反引号改起来:

CREATE EXTERNAL TABLE moveProjects (cid string, `end` string, category string) STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
TBLPROPERTIES ("dynamodb.table.name" = "Projects","dynamodb.column.mapping" = "cid:cid,end:end,category:category");

Copyright © 2019- bangwoyixia.com 版权所有 湘ICP备2023022004号-2

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务