You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Robert Stupp (JIRA)" <ji...@apache.org> on 2014/06/27 12:49:24 UTC
[jira] [Updated] (CASSANDRA-7461) operator functionality in CQL

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

Robert Stupp updated CASSANDRA-7461:
------------------------------------

    Description: 
Intention: Allow operators in CQL

Operators could be decimal arithmetics {{+ - * /}} or boolen arithmetics {{| & !}} or string 'arithmetics' {{+}}

{{SELECT tab.label + ' = ' + tab.value FROM foo.tab}}
{{SELECT * FROM tab WHERE tab.label + ' = ' + tab.value = 'foo = bar'}}
as well as
{{CREATE INDEX idx ON tab ( tab.tabel + '=' + tab.value )}}
or
{{CREATE INDEX idx ON tab (label) WHERE contains(tab.tabel, 'very-important-key')}}

Operators could be mapped to UDFs like this:
{{+}} mapped to UDF {{cstarstd::oper_plus(...)}}
{{-}} mapped to UDF {{cstarstd::oper_minus(...)}}
or handled directly via {{Cql.g}} in 'special' code


  was:
Intention: Allow operators in CQL

Operators could be decimal arithmetics {{+ - * /}} or boolen arithmetics {{| & !}} or string 'arithmetics' {{+}}

{{SELECT tab.label + ' = ' + tab.value FROM foo.tab}}
{{SELECT * FROM tab WHERE tab.label + ' = ' + tab.value = 'foo = bar'}}
as well as
{{CREATE INDEX idx ON tab ( tab.tabel + '=' + tab.value )}}
or
{{CREATE INDEX idx ON tab (label) WHERE contains(tab.tabel, 'very-important-key')}}

Operators could be mapped to UDFs like this:
{{+}} mapped to UDF {{cstarstd::oper_plus(...)}}
{{-}} mapped to UDF {{cstarstd::oper_minus(...)}}
or handled directly via {{Cql.g}}



> operator functionality in CQL
> -----------------------------
>
>                 Key: CASSANDRA-7461
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7461
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API, Core
>            Reporter: Robert Stupp
>
> Intention: Allow operators in CQL
> Operators could be decimal arithmetics {{+ - * /}} or boolen arithmetics {{| & !}} or string 'arithmetics' {{+}}
> {{SELECT tab.label + ' = ' + tab.value FROM foo.tab}}
> {{SELECT * FROM tab WHERE tab.label + ' = ' + tab.value = 'foo = bar'}}
> as well as
> {{CREATE INDEX idx ON tab ( tab.tabel + '=' + tab.value )}}
> or
> {{CREATE INDEX idx ON tab (label) WHERE contains(tab.tabel, 'very-important-key')}}
> Operators could be mapped to UDFs like this:
> {{+}} mapped to UDF {{cstarstd::oper_plus(...)}}
> {{-}} mapped to UDF {{cstarstd::oper_minus(...)}}
> or handled directly via {{Cql.g}} in 'special' code



--
This message was sent by Atlassian JIRA
(v6.2#6252)