[
https://issues.apache.org/jira/browse/HIVE-198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13104948#comment-13104948
]
John Sichi commented on HIVE-198:
---------------------------------
Did you miss create_or_replace_view6.q.out? Perhaps it was committed after you
started.
jsichi-mac:clientnegative jsichi$ grep "cannot recognize" *.q.out
column_rename3.q.out:FAILED: Parse Error: line 1:27 cannot recognize input near
'<EOF>' '<EOF>' '<EOF>' in column type
create_or_replace_view6.q.out:FAILED: Parse Error: line 2:52 cannot recognize
input near 'blah' '<EOF>' '<EOF>' in select clause
invalid_select_expression.q.out:FAILED: Parse Error: line 1:32 cannot recognize
input near '.' 'foo' '<EOF>' in expression specification
invalid_tbl_name.q.out:FAILED: Parse Error: line 1:20 cannot recognize input
near '-' 'name' '(' in create table statement
> Parse errors report incorrectly.
> --------------------------------
>
> Key: HIVE-198
> URL: https://issues.apache.org/jira/browse/HIVE-198
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: S. Alex Smith
> Assignee: Aviv Eyal
> Labels: parse
> Attachments: HIVE-198.2.patch.txt, PraseErrorMessage.patch
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
