Frank-Robert Kline created CASSANDRA-8079:
---------------------------------------------
Summary: 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)