Parse errors report incorrectly. -------------------------------- Key: HIVE-198 URL: https://issues.apache.org/jira/browse/HIVE-198 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: S. Alex Smith
The following two queries fail: CREATE TABLE output_table(userid, bigint); CREATE TABLE output_table(userid bigint, age int, sex string, location string); each giving the error message "FAILED: Parse Error: line 1:16 mismatched input 'TABLE' expecting KW_TEMPORARY" Although one might not catch it from the error message, the problem with the first is that there is a comma between "userid" and "bigint", and the problem with the second is that "location" is a reserved keyword. Reported errors should more accurately describe the nature of the error, such as "no type given for column 'userid'" or "'location' is not a valid column name". -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.