You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Aditya Kishore (JIRA)" <ji...@apache.org> on 2014/05/20 02:09:39 UTC

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

Aditya Kishore created DRILL-783:
------------------------------------

             Summary: 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


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)