You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Dong Chen (JIRA)" <ji...@apache.org> on 2014/12/22 07:23:13 UTC
[jira] [Updated] (HIVE-8155) In select statement after * any
random characters are allowed in hive but in RDBMS its not allowed
[ https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dong Chen updated HIVE-8155:
----------------------------
Assignee: Dong Chen
Status: Patch Available (was: Open)
> 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
>
> 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)