[IMPALA-3269] CTAS with subquery throws AuthzException

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.2, Impala 2.3.0, Impala 2.5.0
• Fix Version/s: Impala 2.6.0, impala 2.5.1
• Component/s: Frontend
• Labels: security usability
• Target Version: Impala 2.6.0, impala 2.5.1
• Assignee: Bharath Vissapragada
• Reporter: Bharath Vissapragada
• Created: 30/Mar/16 13:29
• Updated: 04/May/16 09:51
• Resolved: 12/Apr/16 07:20

Description

Bug Example:

-- create table t1(a int);
-- create table t2(b int);
-- create table t3 as select a from t1 where a < (select max(b) from t2);
Query: create table t3 as select a from t1 where a < (select max(c) from t2)

ERROR: AuthorizationException: User 'bharath' does not have privileges to access: hdfs://localhost:20500/test-warehouse/t3

Workaround: GRANT the privileges manually on hdfs://localhost:20500/test-warehouse/t3