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

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

              Dates

                Created:
                Updated:
                Resolved: