Re: Data from multiple tables (Join Data)

2010-07-20 Thread aaron morton
I'm not sure what your overload concern is. You either need to make multiple requests or de-normalise so that your query can be resolved from one CF. There are no joins. Try it and see would be the best advice. You can always add more nodes to the cluster. Aaron On 20 Jul 2010, at 19:19,

Re: Data from multiple tables (Join Data)

2010-07-20 Thread bujji
hi Aaron, Thanks for your reply I can integrate some transaction mechanism with Cassandra so that i can do the transactions. but is it possible to get data from more than one table without much overload and in an efficient way ? give me some good example if possible... Thanks, Visu On Tue, Jul

Re: Data from multiple tables (Join Data)

2010-07-19 Thread Aaron Morton
Cassandra may not be the best fit for a billing system. I'm guessing the lack of transactions would be a problem if you want to update inventory levels.If you want to get data from multiple column families you will need to make multiple calls, or de-normalise the data so you can get all the data yo

Data from multiple tables (Join Data)

2010-07-19 Thread bujji
Hi all, I am new to Cassandra... I want to use to cassandra for a billing system. As I saw in many places that Joins won't work in BigTable implementation but i feel i needed it for my App. I am unable to get the data from multiple tables (columnFamilies) like products and inventory As I am tr