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)

Reply via email to