Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-16875

Query against view with partitioned child on HoS fails with privilege exception.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0
    • Fix Version/s: 3.0.0, 2.4.0
    • Component/s: Spark
    • Labels:
      None

      Description

      Query against view with child table that has partitions fails with privilege exception even with correct privileges.

      Reproduce:

      create table jsamp1 (a string) partitioned by (b int);
      insert into table jsamp1 partition (b=1) values ("hello");
      create view jview as select * from jsamp1;
      
      create role viewtester;
      grant all on table jview to role viewtester;
      grant role viewtester to group testers;
      
      Use MR, the select will succeed:
      set hive.execution.engine=mr;
      select count(*) from jview;
      
      while use spark:
      set hive.execution.engine=spark;
      select count(*) from jview;
      
      it fails with:
      Error: Error while compiling statement: FAILED: SemanticException No valid privileges
       User tester does not have privileges for QUERY
       The required privileges: Server=server1->Db=default->Table=j1part->action=select; (state=42000,code=40000)
      
      

        Attachments

        1. HIVE-16875.1.patch
          5 kB
          Yongzhi Chen
        2. HIVE-16875.2.patch
          103 kB
          Yongzhi Chen
        3. HIVE-16875.3.patch
          104 kB
          Yongzhi Chen

          Activity

            People

            • Assignee:
              ychena Yongzhi Chen
              Reporter:
              ychena Yongzhi Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: