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)

Reply via email to