hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dong Chen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed
Date Mon, 22 Dec 2014 06:32:13 GMT

     [ 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)

Mime
View raw message