Re: cube build failed if the fact_table is not in default database

[Jie Tao]

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.xxxx.JsonPathsUDTF' USING JAR 
'hdfs:///user/admin/hive-jars/xxx-SNAPSHOT.jar'


Now I changed this with database.functionname.

The query works now. I will try cube build again.

Thanks,

Jie


|
Am 09.03.2016 um 18:07 schrieb Sarnath:
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