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

SemanticException for query on view with masked table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0, 3.2.0
    • Component/s: Parser
    • Labels:
      None

      Description

      When view reference is fully qualified. Following q file can be used to reproduce the issue:

      --! qt:dataset:srcpart
      --! qt:dataset:src
      set hive.mapred.mode=nonstrict;
      set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
      
      create database atlasmask;
      use atlasmask;
      create table masking_test_n8 (key int, value int);
      insert into masking_test_n8 values(1,1), (2,2);
      create view testv(c,d) as select * from masking_test_n8;
      
      select * from `atlasmask`.`testv`;
      

        Attachments

        1. HIVE-21188.01.patch
          22 kB
          Jesus Camacho Rodriguez
        2. HIVE-21188.02.patch
          24 kB
          Jesus Camacho Rodriguez
        3. HIVE-21188.02.patch
          24 kB
          Jesus Camacho Rodriguez
        4. HIVE-21188.02.patch
          24 kB
          Jesus Camacho Rodriguez
        5. HIVE-21188.patch
          10 kB
          Jesus Camacho Rodriguez

          Activity

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez
              Reporter:
              jcamachorodriguez Jesus Camacho Rodriguez
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: