Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-9037

Cannot create kudu table after granting database permission

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Bug
    • Impala 3.0
    • None
    • Security
    • ghx-label-12

    Description

      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/bigdata5@TEST.COM' 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

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kevy kevy liu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: