[
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)
