You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Soumitra Sulav (Jira)" <ji...@apache.org> on 2021/12/14 07:52:00 UTC

[jira] [Created] (HIVE-25803) URL Mapping appends hdfs:// even for LOCAL DIRECTORY ops

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/_HOST@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)