You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "Andrew Kyle Purtell (Jira)" <ji...@apache.org> on 2022/06/11 20:26:00 UTC

[jira] [Closed] (HBASE-1002) Coprocessors: Support small query language as filter on server side

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

Andrew Kyle Purtell closed HBASE-1002.
--------------------------------------

> Coprocessors: Support small query language as filter on server side
> -------------------------------------------------------------------
>
>                 Key: HBASE-1002
>                 URL: https://issues.apache.org/jira/browse/HBASE-1002
>             Project: HBase
>          Issue Type: Sub-task
>          Components: Filters
>            Reporter: Andrew Kyle Purtell
>            Priority: Minor
>
> Improve the usability of filters by making them specifiable or executable using a little query language. 
> For example:
>     col("entry:price") > 3 && (col("entry:name") = "ABC" || col("entry:name") = "XYZ")
> Can be implemented as a little language compiler that takes filter specifications as input and builds the requisite hierarchy of filter API classes and actions as emitted java code. 
> Compiler can be a utility class, something like:
> {code}
> Scan scan = new Scan();
> scan.addFamily(Bytes.toBytes("entry"));
> // ...
> scan.setFilter(Filter.compile("col(\"entry:price\") > 3 && 
> (col(\"entry:name\") =  \"ABC\" || col(\"entry:name\") = \"XYZ\""));
> // ...
> {code}
> or even something like
> {code}
> Scan scan = Filter.compileScan("col(\"entry:price\") > 3 && 
> (col(\"entry:name\") =  \"ABC\" || col(\"entry:name\") = \"XYZ\""));
> // ...
> {code}
> Can also be implemented using JRuby snippets sent to the regionserver for execution, but this has troublesome security implications.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)