[
https://issues.apache.org/jira/browse/CASSANDRA-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511598#comment-14511598
]
Cristian Manuel Vertiz Fernandez commented on CASSANDRA-3069:
-------------------------------------------------------------
I know that UNION won't be efficient but what if I need to query something like
this (you know sometimes it's necessary):
SELECT * FROM columnFamily where id = 24398 LIMIT 1
UNION
SELECT * FROM columnFamily where id = 24399 LIMIT 1
UNION
SELECT * FROM columnFamily where id = 24399 LIMIT 1
columnFamily
id | time
| value
24398 | 2015-04-24 10:41:26SA Western Standard Time |
Stockroom
24398 | 2015-04-24 10:41:59SA Western Standard Time |
Salesfloor
24399 | 2015-04-24 10:41:43SA Western Standard Time |
38.04685048658663;43.94922140324821;0.0
24399 | 2015-04-24 10:41:44SA Western Standard Time |
38.58093827425737;43.81361859931893;0.0
24400 | 2015-04-24 11:37:18SA Western Standard Time |
-118.44390360502912;34.04828359327367;0.0
24400 | 2015-04-24 11:37:19SA Western Standard Time |
-118.44390210073725;34.04828341017305;0.0
ie extract the top n rows for each id
> multiget support in CQL (UNION / OR)
> ------------------------------------
>
> Key: CASSANDRA-3069
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3069
> Project: Cassandra
> Issue Type: New Feature
> Components: API, Core
> Reporter: Jonathan Ellis
> Priority: Minor
> Attachments: CASSANDRA-3069.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
