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