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)
