Ferdinand Xu created HIVE-8155:
----------------------------------

             Summary:  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: Ferdinand Xu
            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)

Reply via email to