drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-783) Convert function support in HBase filter push down.
Date Tue, 20 May 2014 16:02:42 GMT

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

Jacques Nadeau commented on DRILL-783:
--------------------------------------

e9e63c4

> Convert function support in HBase filter push down.
> ---------------------------------------------------
>
>                 Key: DRILL-783
>                 URL: https://issues.apache.org/jira/browse/DRILL-783
>             Project: Apache Drill
>          Issue Type: Task
>            Reporter: Aditya Kishore
>            Assignee: Aditya Kishore
>             Fix For: 1.0.0-rc1
>
>         Attachments: DRILL-783-Convert-function-support-in-HBase-filter-p.patch
>
>
> We should be able to push down WHERE clause with certain convert_from() functions as
HBase filters into HBase scan.
> e.g.
> {noformat}
> SELECT *
> FROM hbase.MyTable
> WHERE convert_from(cf['eligible'], 'BOOLEAN_BYTE') = true
> {noformat}
> In the above query, assuming that the column "cf:eligible" has been stored as a 1 byte
value where '\x00' == false and \x01' == true, we can push this condition down as an HBase
filter.



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

Mime
View raw message