[
https://issues.apache.org/jira/browse/IMPALA-9037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-9037.
-----------------------------------
Resolution: Not A Bug
> 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
> Priority: Major
>
> 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)
