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

Reply via email to