cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6599) CQL updates should support "column = column - { key1, key2, ... }" syntax for removing map elements
Date Thu, 31 Jul 2014 13:37:41 GMT

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

Aleksey Yeschenko commented on CASSANDRA-6599:
----------------------------------------------

After thinking about it for a while, I'm not sure I like accepting set literals for map operations.

I personally would prefer allowing nulls as values in map literals, so that you could do something
like this instead, without inventing new syntax:

{code}
update table set map = map + {'key1': null, 'key2': null} where ...
{code}

I believe this already works with prepared statements, as is, but could be wrong.

> CQL updates should support "column = column - { key1, key2, ... }" syntax for removing
map elements
> ---------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6599
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6599
>             Project: Cassandra
>          Issue Type: Wish
>            Reporter: Gavin
>            Assignee: Benjamin Lerer
>            Priority: Minor
>              Labels: cql
>             Fix For: 2.1.1
>
>         Attachments: CASSANDRA-6599.txt
>
>
> A variable number number of elements can be removed from lists and sets using an update
statement of the form "update .... set column=column - {....} where ...".  This syntax should
also be supported for map columns.  This would be especially useful for prepared statements
(I know that you can use "set column[...] = null" to remove items in an update statement,
but that only works for one element at a time).



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

Mime
View raw message