Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4844

Partition pruning not working on a view which is created using a '*' query

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.0, 1.5.0, 1.6.0, 1.7.0, 1.8.0
    • None
    • None

    Description

      git.commit.id.abbrev=ef6e522

      create view cust_star_view as select * from c_1level;
      +-------+---------------------------------------------------------------------------------+
      |  ok   |                                     summary                                     |
      +-------+---------------------------------------------------------------------------------+
      | true  | View 'cust_star_view' created successfully in 'dfs.metadata_caching_pp' schema  |
      +-------+---------------------------------------------------------------------------------+
      1 row selected (1.085 seconds)
      0: jdbc:drill:zk=10.10.100.190:5181> explain plan for select * from cust_star_view where dir0=1991;
      +------+------+
      | text | json |
      +------+------+
      | 00-00    Screen
      00-01      Project(*=[$0])
      00-02        SelectionVectorRemover
      00-03          Filter(condition=[=(ITEM($0, 'dir0'), 1991)])
      00-04            Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/drill/testdata/metadata_caching_pp/c_1level/1991/customer.parquet], ReadEntryWithPath [path=maprfs:/drill/testdata/metadata_caching_pp/c_1level/1992/customer.parquet]], selectionRoot=maprfs:/drill/testdata/metadata_caching_pp/c_1level, numFiles=2, usedMetadataFile=false, columns=[`*`]]])
      

      As you see from the above plan, partition pruning is not taking place

      Attachments

        Activity

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: