You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/09/18 00:07:04 UTC
[jira] [Created] (DRILL-3797) Filter not pushed down as part of
scan (for JSON data)
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)