You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Pritesh Maker (JIRA)" <ji...@apache.org> on 2019/03/21 16:16:00 UTC
[jira] [Updated] (DRILL-7118) Filter not getting pushed down on
MapR-DB tables.
[ https://issues.apache.org/jira/browse/DRILL-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pritesh Maker updated DRILL-7118:
---------------------------------
Reviewer: Aman Sinha
> Filter not getting pushed down on MapR-DB tables.
> -------------------------------------------------
>
> Key: DRILL-7118
> URL: https://issues.apache.org/jira/browse/DRILL-7118
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.15.0
> Reporter: Hanumath Rao Maduri
> Assignee: Hanumath Rao Maduri
> Priority: Major
> Fix For: 1.16.0
>
>
> A simple is null filter is not being pushed down for the mapr-db tables. Here is the repro for the same.
> {code:java}
> 0: jdbc:drill:zk=local> explain plan for select * from dfs.`/tmp/js` where b is null;
> ANTLR Tool version 4.5 used for code generation does not match the current runtime version 4.7.1ANTLR Runtime version 4.5 used for parser compilation does not match the current runtime version 4.7.1ANTLR Tool version 4.5 used for code generation does not match the current runtime version 4.7.1ANTLR Runtime version 4.5 used for parser compilation does not match the current runtime version 4.7.1+----------------------------------------------------------------------------------+----------------------------------------------------------------------------------+
> | text | json |
> +----------------------------------------------------------------------------------+----------------------------------------------------------------------------------+
> | 00-00 Screen
> 00-01 Project(**=[$0])
> 00-02 Project(T0¦¦**=[$0])
> 00-03 SelectionVectorRemover
> 00-04 Filter(condition=[IS NULL($1)])
> 00-05 Project(T0¦¦**=[$0], b=[$1])
> 00-06 Scan(table=[[dfs, /tmp/js]], groupscan=[JsonTableGroupScan [ScanSpec=JsonScanSpec [tableName=/tmp/js, condition=null], columns=[`**`, `b`], maxwidth=1]])
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)