Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7118

Filter not getting pushed down on MapR-DB tables.

    XMLWordPrintableJSON

    Details

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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hanu.ncr Hanumath Rao Maduri
                Reporter:
                hanu.ncr Hanumath Rao Maduri
                Reviewer:
                Aman Sinha
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: