drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3797) Filter not pushed down as part of scan (for JSON data)
Date Thu, 17 Sep 2015 22:07:04 GMT
Khurram Faraaz created DRILL-3797:

             Summary: Filter not pushed down as part of scan (for JSON data)
                 Key: DRILL-3797
                 URL: https://issues.apache.org/jira/browse/DRILL-3797
             Project: Apache Drill
          Issue Type: New Feature
          Components: Execution - Relational Operators
    Affects Versions: 1.2.0
            Reporter: Khurram Faraaz
            Assignee: Chris Westin
            Priority: Minor

Filter is not part of the scan operator.

0: jdbc:drill:schema=dfs.tmp> explain plan for select key1, key2 from `twoKeyJsn.json`
where key1 = 1.26807240856E8;
| text | json |
| 00-00    Screen
00-01      Project(key1=[$0], key2=[$1])
00-02        SelectionVectorRemover
00-03          Filter(condition=[=($0, 1.26807240856E8)])
00-04            Scan(groupscan=[EasyGroupScan [selectionRoot=maprfs:/tmp/twoKeyJsn.json,
numFiles=1, columns=[`key1`, `key2`], files=[maprfs:///tmp/twoKeyJsn.json]]])


Here is snippet of data from JSON file
root@centos-01 ~]# head -n 10 twoKeyJsn.json

This message was sent by Atlassian JIRA

View raw message