cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Haddad (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-12611) Allow UDFs to be used in predicates
Date Mon, 05 Sep 2016 15:12:21 GMT

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

Jon Haddad resolved CASSANDRA-12611.
------------------------------------
    Resolution: Duplicate

Dupe of CASSANDRA-8488

> Allow UDFs to be used in predicates
> -----------------------------------
>
>                 Key: CASSANDRA-12611
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12611
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Jon Haddad
>
> Now that allow filtering can be used more liberally, it would be nice to be able to apply
a function as a predicate.  For instance, if I store a bloom filter on each row, it would
be useful to be able to pass a value and a field into a function to check if the value is
possibly in the set of values the bloom filter has seen.  For example:
> {code}CREATE OR REPLACE FUNCTION inBloom (input int, field field) CALLED ON NULL INPUT
RETURNS boolean LANGUAGE java AS 'return true;'; // pretend this actual evaluates correctly

> {code}
>  As far as I can tell, there's no way to pass inputs to a function referencing a field,
and no way to use the result of the function in a predicate.  The following simple example
fails:
> {code}
> cqlsh:tutorials> CREATE OR REPLACE FUNCTION inBloom (input int) CALLED ON NULL INPUT
RETURNS boolean LANGUAGE java AS 'return true;';
> cqlsh:tutorials> select * from user where inBloom(1) = True;
> SyntaxException: line 1:32 no viable alternative at input '(' (select * from user where
[inBloom](...)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message