cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank-Robert Kline (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-8079) Query specific keys from the map type
Date Wed, 08 Oct 2014 01:34:33 GMT
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)

Mime
View raw message