Soumitra Sulav created HIVE-25803: ------------------------------------- Summary: 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
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.1#820001)