Add a default range to queries ------------------------------ Key: CASSANDRA-3340 URL: https://issues.apache.org/jira/browse/CASSANDRA-3340 Project: Cassandra Issue Type: New Feature Reporter: David Semeria Priority: Minor
Often we find ourselves having to make two nearly identical queries when in theory one could suffice. Assuming we're storing json properites in discrete columns, a typical user row might look like this: default:name, default:age,... address:street, address:number,... contacts:email, contacts,phone, contacts:mobile.... To extract the contacts for a given user we would pass startCol = 'contacts', endCol = 'contacts' + charAfter(':') However, we frequently also need to retrieve the properties under the 'default' key. To do this we currently need to make a second nearly identical query, with the only difference that startCol and endCol now refer to 'default' It would be nice if we could pass in a default range along with the standard range during queries. It seems inefficient to make Cassandra extract the same row(s) twice, with the only difference being how they are filtered. I'm not in a position to estimate how many other users might find this functionality, all I can say is that we certainly would. Thanks. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira