Support Questions
Find answers, ask questions, and share your expertise
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'


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 : 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