kevy liu created IMPALA-9037:
--------------------------------

             Summary: Cannot create kudu table after granting database 
permission
                 Key: IMPALA-9037
                 URL: https://issues.apache.org/jira/browse/IMPALA-9037
             Project: IMPALA
          Issue Type: Bug
          Components: Security
    Affects Versions: Impala 3.0
            Reporter: kevy liu


Cannot create kudu table after granting database permission

How to solve this problem?

VERSION:
impala version 3.0.0,kudu version 1.6.0
CDH 6.0.0

Cannot create kudu table after granting database permission。

[bigdata5:21000] yydp_kudu> show grant role yydp;
Query: show grant role yydp
+----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+
| scope | database | table | column | uri | privilege | grant_option | 
create_time |
+----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+
| database | yydp_kudu | | | | all | false | Sat, Oct 12 2019 15:45:19.073 |
+----------+-----------+-------+--------+-----+-----------+--------------+-------------------------------+
Fetched 1 row(s) in 0.02s
[bigdata5:21000] yydp_kudu>

Cannot create kudu table:
[bigdata5:21000] yydp_kudu> CREATE TABLE test_kd4 (
 > id INT,
 > bk_date STRING,
 > PRIMARY KEY (id)
 > ) STORED AS kudu TBLPROPERTIES (
 > 'kudu.master_addresses' = 'bigdata1,bigdata2'
 > );
Query: CREATE TABLE test_kd4 (
 id INT,
 bk_date STRING,
 PRIMARY KEY (id)
) STORED AS kudu TBLPROPERTIES (
 'kudu.master_addresses' = 'bigdata1,bigdata2'
)
ERROR: AuthorizationException: User 'yydp/[email protected]' does not have 
privileges to access: server1


Ability to create non-kudu tables properly

[bigdata5:21000] yydp_kudu> CREATE TABLE test_kd5 (
 > id INT,
 > bk_date STRING);
Query: CREATE TABLE test_kd5 (
 id INT,
 bk_date STRING)
+-------------------------+
| summary |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.11s

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to