I get the following error when trying to create a Hive table from an existing DynamoDB table:
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
The query looks like this (simplified to protect the innocent):
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");
Basically, I am trying to create a Hive table containing the contents of the Projects
DynamoDB table, but the create statement throws a parsing error from Hive / Hadoop.
source share