You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2014/09/17 17:48:33 UTC
[jira] [Updated] (DRILL-1386) Enable Partition Pruning for
filesystem queries
[ https://issues.apache.org/jira/browse/DRILL-1386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha updated DRILL-1386:
------------------------------
Attachment: DirectorypartitionpruninginDrill.pdf
> Enable Partition Pruning for filesystem queries
> -----------------------------------------------
>
> Key: DRILL-1386
> URL: https://issues.apache.org/jira/browse/DRILL-1386
> Project: Apache Drill
> Issue Type: Improvement
> Components: Query Planning & Optimization, Storage - JSON, Storage - Parquet, Storage - Text & CSV
> Affects Versions: 0.5.0
> Reporter: Jacques Nadeau
> Assignee: Aman Sinha
> Fix For: 0.6.0
>
> Attachments: DirectorypartitionpruninginDrill.pdf
>
>
> If you have files:
> /files/2012/Jan/log.csv
> /files/2013/Jan/log.csv
> And write the query "select * from `/files/` where dir0 = 2012 and dir1='Jan' "
> Drill will read both files and then filter out all of the second file. Drill should recognize that dir0=2012 and dir1='Jan' can be pushed down into the storage layer to prune the files read as part of the query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)