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.

{code}
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]]])
{code}

{code}

Here is snippet of data from JSON file
root@centos-01 ~]# head -n 10 twoKeyJsn.json
{"key1":1296815267.3,"key2":"d"}
{"key1":46736552.9012,"key2":"c"}
{"key1":93968206.5896,"key2":"b"}
{"key1":1015801729.33,"key2":"d"}
{"key1":498788888.641,"key2":"1"}
{"key1":152391833.107,"key2":"1"}
{"key1":731290386.917,"key2":"a"}
{"key1":692726688.161,"key2":"d"}
{"key1":1123835226.54,"key2":"a"}
{"key1":126807240.856,"key2":"1"}
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message