cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank-Robert Kline (JIRA)" <>
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
             Project: Cassandra
          Issue Type: Improvement
          Components: Core
            Reporter: Frank-Robert Kline

Using the map type, we can set specific key+value pairs individually:
UPDATE users SET todo['first'] = 'value1'  WHERE user_id = 'frodo';
UPDATE users SET todo['second'] = 'value2'  WHERE user_id = 'frodo';

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:
SELECT todo['first'], todo['second'] FROM users WHERE user_id = 'frodo';

This message was sent by Atlassian JIRA

View raw message