[jira] [Updated] (DRILL-783) Convert function support in HBase filter push down.

["Aditya Kishore (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aditya Kishore updated DRILL-783:
---------------------------------

    Attachment: DRILL-783-Convert-function-support-in-HBase-filter-p.patch

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