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. >
