drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4844) Partition pruning not working on a view which is created using a '*' query
Date Fri, 12 Aug 2016 21:06:20 GMT
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)

Mime
View raw message