cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Finding the intersection results of column sets of two rows
Date Sun, 06 Feb 2011 16:25:54 GMT
On Sun, Feb 6, 2011 at 10:15 AM, buddhasystem <potekhin@bnl.gov> wrote:
>
> Hello,
>
> If the amount of data is _that_ small, you'll have a much easier life with
> MySQL, which supports the "join" procedure -- because that's exactly what
> you want to achieve.
>
>
> asil klin wrote:
>>
>> Hi all,
>>
>> I want to procure the intersection of columns set of two rows (from 2
>> different column families).
>>
>> To achieve the intersection results, Can I, first retrieve all
>> columns(around 300) from first row and just query by those column
>> names in the second row(which contains maximum 100 000 columns) ?
>>
>> I am using the results during the write time & not before presentation
>> to the user, so latency wont be much concern while writing.
>>
>> Is it the proper way to procure intersection results of two rows ?
>>
>> Would love to hear your comments..
>>
>>
>> ---------
>>
>> Regards,
>> Asil
>>
>>
>
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Finding-the-intersection-results-of-column-sets-of-two-rows-tp5997248p5997743.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
>

You can use multi-get when fetching lists of already know keys
optimize your round rip time.

Mime
View raw message