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