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)
