incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aklin_81 <asdk...@gmail.com>
Subject Re: Finding the intersection results of column sets of two rows
Date Sun, 06 Feb 2011 18:11:05 GMT
Hi,

@buddhasystem : yes that's well known solution. But obviously when
mysql couldnt satisfy my needs, I am here. My question is in context
of Cassandra, if it possible to achieve intersection result set of
columns in two rows, by the way I spoke about.

@Edward: yes that I know but how does that fit here for obtaining the
common columns among two rows.

Thanks for your comments..

-Asil


On Sun, Feb 6, 2011 at 9:55 PM, Edward Capriolo <edlinuxguru@gmail.com> wrote:
> 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