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