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

Operations not supported. Table test.t1 access type is: NONE

    XMLWordPrintableJSON

Details

    • Question
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • Impala 4.0.0
    • Impala 4.0.0
    • Catalog
    • None
    • hdp 3.1.1
      hive 4.0
      impala 4.0
    • ghx-label-12

    Description

      I can successfully create a table using impala

      [gpmaster:21050] test> create table t1 (a string);
      Query: create table t1 (a string)
      +-------------------------+
      | summary            |
      +-------------------------+
      | Table has been created. |
      +-------------------------+
      Fetched 1 row(s) in 0.42s
      [gpmaster:21050] test> show tables;
      Query: show tables
      +------+
      | name |
      +------+
      | t1  |
      +------+
      Fetched 1 row(s) in 0.01s
       

      But I failed to access this table

      [gpmaster:21050] test> select * from t1;
      Query: select * from t1
      Query submitted at: 2022-03-31 00:27:11 (Coordinator: http://gpmaster:25000)
      ERROR: AnalysisException: Operations not supported. Table test.t1  access type is: NONE 

      The error looks like a permission issue, but I don't know where to set the permission

       

       

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: