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

Exception hidden on complex type

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      Description

      create table t1 (
        id int,
        a array<struct<f1:int,f2:string>>,
        c3 array<struct<a1:array<int>,a2:array<struct<x:int,y:int,a3:array<int>>>>>,
        c5 map<int,struct<m1:map<int,string>,m2:map<int,struct<x:int,y:int,m3:map<int,int>>>>>
      );
      grant select(a) on table t1 to role foo_role;
      select 1 from t1.a.f1; -- ERROR: AuthorizationException: User 'impdev' does not have privileges to execute 'SELECT' on: t1.a

      Since we have column privilege on t1.a, the error message is wrong to say that we do not have privileges to execute 'SELECT on: t1.a. We should be getting a proper exception message like below instead.

      AnalysisException: Illegal table reference to non-collection type: 't1.a.f1' 

        Attachments

          Activity

            People

            • Assignee:
              fredyw Fredy Wijaya
              Reporter:
              aholley Adam Holley
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: