when i am create hive query its getting error

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

@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.

[#5]

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