Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Date: Sun, 7 May 2017 15:34:04 +0000 (UTC)
From: "vincent royer (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.13046334.1488064057000.146376.1494171244286@Atlassian.JIRA>
In-Reply-To: <JIRA.13046334.1488064057000@Atlassian.JIRA>
References: <JIRA.13046334.1488064057000@Atlassian.JIRA> <JIRA.13046334.1488064057292@jira-lw-us.apache.org>
Subject: [jira] [Comment Edited] (CASSANDRA-13267) Add new CQL functions
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 07 May 2017 15:34:09 -0000


    [ https://issues.apache.org/jira/browse/CASSANDRA-13267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15928942#comment-15928942 ] 

vincent royer edited comment on CASSANDRA-13267 at 5/7/17 3:33 PM:
-------------------------------------------------------------------

Well, deserializer.toString() returns a string representation that fit my needs (ByteType = signed decimal integer, BytesType = hexadecimal string), but as suggested by Sylvain, here is a working proposal to be able to support pluggable generic CQL functions, only for SELECT statement. 

By default, toJson would be the only registered generic function, but anyone could programmatically register other generic functions by calling GenericFunctionRegistry.registerFunction, or implements the IGenericFunction.Loader to automatically register functions available in the classpath. This would require to add a file META-INF/services/org.apache.cassandra.cql3.functions.IGenericFunction$Loader containing function classes (see java.util.ServiceLoader) and anyone could drop a jar file in cassandra lib directory to add some CQL generic functions (including my private weird functions, toString + toJsonArray ;-)).

include unit tests OK


was (Author: vroyer59):
Well, deserializer.toString() returns a string representation that fit my needs (ByteType = signed decimal integer, BytesType = hexadecimal string), but as suggested by Sylvain, here is a working proposal to be able to support pluggable generic CQL functions, only for SELECT statement. 

By default, toJson would be the only registered generic function, but anyone could programmatically register other generic functions by calling GenericFunctionRegistry.registerFunction, or implements the IGenericFunction.Loader to automatically register functions available in the classpath. This would require to add a file META-INF/services/org.apache.cassandra.cql3.functions.IGenericFunction$Loader containing function classes (see java.util.ServiceLoader) and anyone could drop a jar file in cassandra lib directory to add some CQL generic functions (including my private weird functions, toString + toJsonArray ;-)).

include unit tests OK, branch available at https://github.com/strapdata/cassandra/tree/cassandra-13267


> Add new CQL functions
> ---------------------
>
>                 Key: CASSANDRA-13267
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13267
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL
>            Reporter: vincent royer
>            Priority: Trivial
>              Labels: features
>             Fix For: 3.0.x
>
>         Attachments: 0001-CASSANDRA-13267-Add-CQL-functions.patch, 0001-CASSANDRA-13267-generic-function.patch
>
>
> Introduce 2 new CQL functions :
> -toString(x) converts a column to its string representation.
> -toJsonArray(x, y, z...) generates a JSON array of JSON string.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org