Strange error on Hive

[#1]

Hello guys!

I'm trying to run the following commands in Hive:

use dataengsandbox;
hive.mapred.supports.subdirectories=true;
insert overwrite directory '/tmp/hmb/test' select max(id) from nodename;

If I remove the text marked in orange it works without issues, but I want my output to be written into a HDFS directory.

Here is the error that I've received:

Error while compiling statement: FAILED: SemanticException No valid privileges User lrm0613 does not have privileges for QUERY The required privileges: Server=server1->URI=hdfs://nameservice1/tmp/hmb/test->action=*;

[#2 · Accepted solution]

@Heri 

There seems to be missing sentry privileges on the hdfs URI

Please refer below document to add the privileges.

https://docs.cloudera.com/documentation/enterprise/latest/topics/sg_hive_sql.html#grant_privilege_on...

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.