[ https://issues.apache.org/jira/browse/HIVE-25803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17794389#comment-17794389 ]
Sai Hemanth Gantasala commented on HIVE-25803: ---------------------------------------------- [~dkuzmenko] - Yeah, it is still a problem. This needs to be addressed. > URL Mapping appends hdfs:// even for LOCAL DIRECTORY ops > -------------------------------------------------------- > > Key: HIVE-25803 > URL: https://issues.apache.org/jira/browse/HIVE-25803 > Project: Hive > Issue Type: Bug > Components: Authorization, HiveServer2 > Affects Versions: 4.0.0 > Reporter: Soumitra Sulav > Assignee: Sai Hemanth Gantasala > Priority: Major > > Repro steps: > Connect to beeline > {code:java} > beeline -u > "jdbc:hive2://quasar-pxlypi-2.quasar-pxlypi.root.hwx.site:10001/;principal=hive/_h...@root.hwx.site;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=VOAnRk5l4oXsg0upJ1ApscSuNksirOKgyhJvoPv2o4j;transportMode=http;httpPath=cliservice;" > {code} > > Create a test table and run insert on local > {code:java} > > create table dual (id int); > > insert overwrite local directory "/tmp/" select * from dual; > {code} > {code:java} > Error: Error while compiling statement: FAILED: HiveAccessControlException > Permission denied: user [hrt_qa] does not have [ALL] privilege on > [hdfs://ns1/tmp] (state=42000,code=40000) > {code} > It always appends hdfs:// to the path even if the operation is meant for > local directory. -- This message was sent by Atlassian Jira (v8.20.10#820010)