the query is:

hive -e 'select * from rawdata.user_logout limit 10'

where user_logout is a Hive view. Strange is:

hive -e 'select * from rawdata.raw_events limit 10'

works where raw_events is a table. The problem may lie on the view?

I created the view with: create view XXX as select xxxx from table


Thank you,

Jie

Am 10.03.2016 um 02:48 schrieb yu feng:
FAILED: SemanticException 1:567 AS clause has an invalid number of aliases.

I don't think it is error of hive, you should post you hive command here,
and let's talk about it.

2016-03-10 1:07 GMT+08:00 Sarnath <stell...@gmail.com>:

Its hard to believe that select * from db.table does not work... Have used
it many times in hive....

Are you in a secure envmt? Like sentry, ranger guarding the databases and
connected to active directory for authentication?

Best,
Sarnath


Reply via email to