[
https://issues.apache.org/jira/browse/CASSANDRA-8079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne resolved CASSANDRA-8079.
-----------------------------------------
Resolution: Duplicate
This is a duplicate of CASSANDRA-7396 and will be added eventually.
> Query specific keys from the map type
> -------------------------------------
>
> Key: CASSANDRA-8079
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8079
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Reporter: Frank-Robert Kline
>
> Using the map type, we can set specific key+value pairs individually:
> {code}
> UPDATE users SET todo['first'] = 'value1' WHERE user_id = 'frodo';
> UPDATE users SET todo['second'] = 'value2' WHERE user_id = 'frodo';
> {code}
> There is no analogous way to request specific properties from a map by key.
> This is significant when a map could potentially store many properties from
> which only a subset is required.
> Ideally, the query syntax would reflect the mutation syntax, as in:
> {code}
> SELECT todo['first'], todo['second'] FROM users WHERE user_id = 'frodo';
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
