[jira] [Created] (DRILL-1272) Filters are not being pushed down to hbase from drill

["Krystal (JIRA)" <ji...@apache.org>]

Krystal created DRILL-1272:
------------------------------

             Summary: Filters are not being pushed down to hbase from drill
                 Key: DRILL-1272
                 URL: https://issues.apache.org/jira/browse/DRILL-1272
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - HBase
            Reporter: Krystal


git.commit.id.abbrev=98b208e

I ran the following queries in drill:
explain plan for select cast(row_key as integer) voter_id, convert_from(onecf['name'], 'UTF8') name, cast(twocf['age'] as integer) age, cast(twocf['registration'] as varchar(20)) registration, cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,cast(fourcf['create_date'] as timestamp) create_date from voter where onecf['name'] not similar to '%(young|u|a)%';

explain plan for select cast(student.onecf['name'] as varchar(35)) name, cast(student.twocf['age'] as integer) age, cast(student.threecf['gpa'] as decimal(4,2)) gpa, cast(voter.twocf['registration'] as varchar(20)) registration from student join voter on (student.onecf['name'] = voter.onecf['name']) where cast(student.twocf['age'] as integer) = 70;

explain plan for select cast(student.onecf['name'] as varchar(35)) name, cast(student.twocf['age'] as integer) age, cast(student.threecf['gpa'] as decimal(4,2)) gpa, cast(voter.twocf['registration'] as varchar(20)) registration from student join voter on (student.onecf['name'] = voter.onecf['name']) where cast(student.twocf['age'] as integer) > 70;

The explain plans for each of the query shows the following:
 "graph" : [ {
    "pop" : "hbase-scan",
    "@id" : 5,
    "hbaseScanSpec" : {
      "tableName" : "voter",
      "startRow" : null,
      "stopRow" : null,
      "serializedFilter" : null
    },

Looks like the serializedFilter should not be null.



--
This message was sent by Atlassian JIRA
(v6.2#6252)