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

Not able to add partition for views in hive when sentry is enabled

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: Parser
    • Labels:
      None

      Description

      Repro:
      create table tesnit (a int) partitioned by (p int);
      insert into table tesnit partition (p = 1) values (1);
      insert into table tesnit partition (p = 2) values (1);
      create view test_view partitioned on (p) as select * from tesnit where p =1;

      alter view test_view add partition (p = 2);
      Error: Error while compiling statement: FAILED: SemanticException [Error 10056]: The query does not reference any valid partition. To run this query, set hive.mapred.mode=nonstrict (state=42000,code=10056)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: