Details
-
Improvement
-
Status: Resolved
-
Normal
-
Resolution: Duplicate
-
None
-
None
-
None
Description
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';
Attachments
Issue Links
- duplicates
-
CASSANDRA-7396 Allow selecting Map values and Set elements
- Resolved
This is a duplicate of
CASSANDRA-7396and will be added eventually.