drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-783) Convert function support in HBase filter push down.
Date Tue, 20 May 2014 00:09:39 GMT
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)

Mime
View raw message