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

CTAS with subquery throws AuthzException

    Details

      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

        Attachments

          Activity

            People

            • Assignee:
              bharathv bharath v
              Reporter:
              bharathv bharath v
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: