Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10783

Allow literal value as parameter of UDF & UDA

    XMLWordPrintableJSON

Details

    • Clients

    Description

      I have defined the following UDF

      CREATE OR REPLACE FUNCTION  maxOf(current int, testValue int) RETURNS NULL ON NULL INPUT 
RETURNS int 
LANGUAGE java 
AS  'return Math.max(current,testValue);'

CREATE TABLE maxValue(id int primary key, val int);
INSERT INTO maxValue(id, val) VALUES(1, 100);

SELECT maxOf(val, 101) FROM maxValue WHERE id=1;

      I got the following error message:

      SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:19 no viable alternative at input '101' (SELECT maxOf(val1, [101]...)">

      It would be nice to allow literal value as parameter of UDF and UDA too.

      I was thinking about an use-case for an UDA groupBy() function where the end user can inject at runtime a literal value to select which aggregation he want to display, something similar to GROUP BY ... HAVING <filter clause>

      Attachments

        Issue Links

          depends upon

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-7396 Allow selecting Map values and Set elements

          • Normal -
          • Resolved
          is depended upon by

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-11871 Allow to aggregate by time intervals

          • Normal -
          • Resolved
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9243 Literals should be valid selectors in SELECT statements

          • Low -
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9253 Bind markers should be allowed in function arguments of Selectors

          • Low -
          • Resolved
          links to

          Web Link Cassci

          Web Link Git branch

          Activity

            People

              slebresne Sylvain Lebresne
              doanduyhai DuyHai Doan
              Sylvain Lebresne
              Benjamin Lerer
              Votes:
              1 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: