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 Tue, 23 Dec 2014 07:14: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.1.patch

The failed test case {{TestParseNegative.testParseNegative_wrong_distinct2}} is related. Update
patch V1 to fix it.

Cause: In .g file, the original selectExpression in selectItem, is split into expression and
tableAllColumns. This impact the error msg in wrong_distinct2.q.out.

>  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.1.patch, 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