I found that the problem lies on a Hive UDF. I used this function to
create the view. I created the function using:
|CREATE FUNCTION json_paths AS 'com..JsonPathsUDTF' USING JAR
'hdfs:///user/admin/hive-jars/xxx-SNAPSHOT.jar'
Now I changed this with database.functionname.
The query wo
more info:
the query select * from database.viewname works with Hue and Beeline
that use HiveServer2
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 he
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 from
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 :
> Its hard to believe that select * from db.table does not work... Have used
> it man
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
Hallo,
my fact table is in another database rather than "default". I use hive
1.2 and it can not handle commands like hive -e 'select * from
another_database.table'. My cube build failed at the first step with error:
FAILED: SemanticException 1:567 AS clause has an invalid number of aliases.
