[
https://issues.apache.org/jira/browse/DRILL-1272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14167112#comment-14167112
]
Krystal commented on DRILL-1272:
--------------------------------
Does not look like that it's being pushed down.
0: jdbc:drill:schema=hbase> explain plan for select
convert_from(voter.onecf.name, 'UTF8') from voter where row_key=10;
+------------+------------+
| text | json |
+------------+------------+
| 00-00 Screen
00-01 Project(EXPR$0=[CONVERT_FROM($1, 'UTF8')])
00-02 SelectionVectorRemover
00-03 Filter(condition=[=(CAST($0):INTEGER NOT NULL, 10)])
00-04 Project(row_key=[$1], ITEM=[ITEM($0, 'name')])
00-05 Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec
[tableName=voter, startRow=null, stopRow=null, filter=null],
columns=[SchemaPath [`row_key`], SchemaPath [`onecf`.`name`]]]])
| {
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ ],
"queue" : 0,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "hbase-scan",
"@id" : 5,
"hbaseScanSpec" : {
"tableName" : "voter",
"startRow" : "",
"stopRow" : "",
"serializedFilter" : null
},
> 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
> Assignee: Parth Chandra
> Priority: Critical
> Fix For: 0.7.0
>
>
> 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.3.4#6332)
