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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Parser
    • 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

        1. HIVE-16660.1.patch
          2 kB
          Yongzhi Chen

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: