[
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dong Chen updated HIVE-8155:
----------------------------
Attachment: HIVE-8155.patch
Upload a patch to fix this.
I think this SQL error could be caught at syntax or semantic layer. It might be
better to catch it earlier during parsing at syntax layer.
The patch updates the .g grammar definition file and constraint STAR cannot be
followed by any identifiers.
> In select statement after * any random characters are allowed in hive but in
> RDBMS its not allowed
> ---------------------------------------------------------------------------------------------------
>
> Key: HIVE-8155
> URL: https://issues.apache.org/jira/browse/HIVE-8155
> Project: Hive
> Issue Type: Improvement
> Reporter: Ferdinand Xu
> Assignee: Dong Chen
> Priority: Critical
> Attachments: HIVE-8155.patch
>
>
> In select statement after * any random characters are allowed in hive but in
> RDBMS its not allowed.
> Steps:
> In the below query "abcdef" is random characters.
> In RDBMS(oracle):
> select *abcdef from mytable;
> Output:
> ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
> In Hive:
> select *abcdef from mytable;
> Output:
> Query worked fine and display all the records of mytable.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
