question Re: when i am create hive query its getting error in Archives of Support Questions (Read Only)

when i am create hive query its getting error

prathap6646 — Thu, 26 May 2016 18:24:17 GMT

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

Re: when i am create hive query its getting error

sshimpi — Thu, 26 May 2016 18:31:55 GMT

@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

prathap6646 — Thu, 26 May 2016 18:50:31 GMT

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

prathap6646 — Thu, 26 May 2016 18:51:04 GMT

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

sshimpi — Thu, 26 May 2016 18:56:30 GMT

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