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