Rahul Challapalli created DRILL-4844:
----------------------------------------
Summary: Partition pruning not working on a view which is created
using a '*' query
Key: DRILL-4844
URL: https://issues.apache.org/jira/browse/DRILL-4844
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.6.0, 1.5.0, 1.4.0, 1.7.0, 1.8.0
Reporter: Rahul Challapalli
git.commit.id.abbrev=ef6e522
{code}
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=[`*`]]])
{code}
As you see from the above plan, partition pruning is not taking place
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
