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.

when i am create hive query its getting error

Solved Go to solution

when i am create hive query its getting error

New Contributor

Error occurred executing hive query: Error while compiling statement: No privilege 'Create' found for outputs { database:hdfs_db}

1 ACCEPTED SOLUTION

Accepted Solutions

Re: when i am create hive query its getting error

@prathap t

I see this is similar to the BUG reported - https://issues.apache.org/jira/browse/HIVE-11205

Also check this, this might help you work -http://www.openkb.info/2015/03/how-to-enable-hive-default-authorization.html

Make sure you have below property properly set and grants in place -

<property> <name>hive.security.authorization.enabled</name> <value>true</value> <description>enable or disable the hive client authorization</description> </property> <property> <name>hive.security.authorization.createtable.owner.grants</name> <value>ALL</value> <description>the privileges automatically granted to the owner whenever a table gets created. An example like "select,drop" will grant select and drop privilege to the owner of the table</description> </property>

4 REPLIES 4

Re: when i am create hive query its getting error

@prathap t

I see this is similar to the BUG reported - https://issues.apache.org/jira/browse/HIVE-11205

Also check this, this might help you work -http://www.openkb.info/2015/03/how-to-enable-hive-default-authorization.html

Make sure you have below property properly set and grants in place -

<property> <name>hive.security.authorization.enabled</name> <value>true</value> <description>enable or disable the hive client authorization</description> </property> <property> <name>hive.security.authorization.createtable.owner.grants</name> <value>ALL</value> <description>the privileges automatically granted to the owner whenever a table gets created. An example like "select,drop" will grant select and drop privilege to the owner of the table</description> </property>

Re: when i am create hive query its getting error

New Contributor

but its not sand box how to apply patch file in that please explain step by step...

Re: when i am create hive query its getting error

@prathap t

You cannot apply patch. The BUG will be taken care in upcomming version of HDP. There might be relavent BUG filed in hortonworks jira.

Re: when i am create hive query its getting error

New Contributor

but its not sand box how to apply patch file in that please explain step by step...

Don't have an account?
Coming from Hortonworks? Activate your account here