[IMPALA-6605] Exception hidden on complex type

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Frontend
• Labels: complextype
• Epic Link: Fix complex type related issues
• Epic Color: ghx-label-3
• Assignee: Fredy Wijaya
• Reporter: Adam Holley
• Created: 05/Mar/18 17:48
• Updated: 06/Jan/21 09:57

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'