cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Stupp (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-7461) operator functionality in CQL
Date Fri, 27 Jun 2014 10:49:24 GMT

     [ 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}}


  was:
Intention: Allow operators in CQL

Operators could be decimal arithmetics {{+ - * /}} or boolen 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}}



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

Mime
View raw message