Hi Hive developers,
I am new to hive. Yesterday i installed apache hive-0.9.0 and start executing
some basics command and i found one abnormal behavior in select* command. In
select statement after * any random characters are allowed in hive but in RDBMS
its not allowed. I am not sure its expected behavior or bug in hive. Could
some please confirm?
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.
Thanks
Siva..