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

Select query with view adds base table partition as direct input in spark engine

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.3.0
    • None
    • Authorization
    • None

    Description

      repro steps:

      set hive.execution.engine=spark;
      create table base(id int) partitioned by (dt string);
      alter table base add partition(dt='2017');
      
      create view view1 as select * from base where id < 10;
      select * from view1;
      

      it requires the access not only for view1 but also for base@dt=2017 partition, which should not be required.

      Attachments

        Activity

          People

            aihuaxu Aihua Xu
            niklaus.xiao Niklaus Xiao
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: