Is it possible for you to dernormalise and write all the intersection values? Will depend on how many I guess.
The other alternative is to pull back more data that you need and the intersection in code in the client. Hope that helps. Aaron On 7/02/2011, at 7:11 AM, Aklin_81 <asdk...@gmail.com> wrote: > 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 <edlinuxg...@gmail.com> wrote: >> On Sun, Feb 6, 2011 at 10:15 AM, buddhasystem <potek...@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-u...@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. >>
