hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sivasakthi <gctsak...@yahoo.com>
Subject Hive: Select * command not working similar to RDBMS
Date Tue, 16 Sep 2014 06:28:50 GMT




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..
Mime
View raw message