drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1522) Hbase convert_from queries are not pushed down
Date Tue, 22 Sep 2015 23:49:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14903677#comment-14903677
] 

Khurram Faraaz commented on DRILL-1522:
---------------------------------------

Also verified that using CONVERT_FROM(ROW_KEY,'INT_BE') in the predicate makes the Filter
to be pushed down to Scan.

{code}
0: jdbc:drill:schema=dfs.tmp> explain plan for select convert_from(voter.onecf.name, 'UTF8')
from voter where convert_from(voter.onecf.name, 'UTF8') = 'tom underhill' AND CONVERT_FROM(ROW_KEY,'INT_BE')=10;
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(EXPR$0=[CONVERT_FROMUTF8($1)])
00-02        Project(row_key=[$1], ITEM=[ITEM($0, 'name')])
00-03          Scan(groupscan=[HBaseGroupScan [HBaseScanSpec=HBaseScanSpec [tableName=voter,
startRow=\x00\x00\x00\x0A, stopRow=\x00\x00\x00\x0A\x00, filter=FilterList AND (2/2): [SingleColumnValueFilter
(onecf, name, EQUAL, tom underhill), RowFilter (EQUAL, \x00\x00\x00\x0A)]], columns=[`row_key`,
`onecf`.`name`]]])
{code}

> Hbase convert_from queries are not pushed down
> ----------------------------------------------
>
>                 Key: DRILL-1522
>                 URL: https://issues.apache.org/jira/browse/DRILL-1522
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - HBase
>    Affects Versions: 0.6.0
>            Reporter: Krystal
>            Assignee: Aditya Kishore
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> git.commit.id.abbrev=5c220e3
> The following hbase query contains the convert_from function but was not being pushed
down.
> 0: jdbc:drill:schema=hbase> explain plan for select convert_from(voter.onecf.name,
'UTF8') from voter where row_key=10;
> | {
>   "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
>     },



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message