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)