You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2016/08/12 21:06:20 UTC
[jira] [Created] (DRILL-4844) Partition pruning not working on a
view which is created using a '*' query
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)