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

CTAS with subquery throws AuthzException

    XMLWordPrintableJSON

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

            bharathv Bharath Vissapragada
            bharathv Bharath Vissapragada
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: