[DRILL-7118] Filter not getting pushed down on MapR-DB tables.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Hanumath Rao Maduri
• Reporter: Hanumath Rao Maduri
• Reviewer: Aman Sinha
• Created: 19/Mar/19 18:31
• Updated: 24/Mar/19 23:54
• Resolved: 24/Mar/19 23:54

Description

A simple is null filter is not being pushed down for the mapr-db tables. Here is the repro for the same.

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]])

Issue Links

• links to: GitHub Pull Request #1708