hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sivasakthi <>
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;
ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected

In Hive:
select *abcdef from mytable;

Query worked fine and display all the records of mytable.

View raw message