[jira] [Updated] (DRILL-3797) Filter not pushed down as part of scan (for JSON data)

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Khurram Faraaz updated DRILL-3797:
----------------------------------
    Assignee: Sean Hsuan-Yi Chu

> 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: Sean Hsuan-Yi Chu
>            Priority: Minor
>             Fix For: Future
>
>
> 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)