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

        

Reply via email to