Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this topic

Error Hive query - hive not allowed to do 'GET_METADATA' on 'hive'

Contributor

Hello - 

In HUE I can run two queries...on two different tables, but when I attempt to run a single query that joins them, I get the following error:

 

Error while compiling statement: FAILED: SemanticException Unable to compare key strength for hdfs://hanameservice/user/hive/warehouse/testdb.db/provider_md_hierarchy and hdfs://hanameservice/user/hive/warehouse/testdb.db/pg_md_survey : org.apache.hadoop.security.authorize.AuthorizationException: User:hive not allowed to do 'GET_METADATA' on 'hive'

 

I searched around and couldn't find anything that helps.  Does anyone have idea on where i can start looking to find a solution?

 

 

thanks - douglas

 

 

Who agreed with this topic