No joins in Cassandra. But... with DataStax Enterprise (DSE) which integrates Solr with Cassandra, limited Join support is available. In particular, an outer join between two tables provided that they share identical partition key values, so that the joined data is guaranteed to be on the same node. For example, you could join a “customer” table to a “customer-order” table. Or a “user” table to a “user-comment” table.
That said, the primary focus should always be to denormalize or flatten your data, sometimes with materialized views, to the extent possible since arbitrary, open-ended SQL-like joins can be horrendously expensive. -- Jack Krupansky From: M.Tarkeshwar Rao Sent: Tuesday, July 22, 2014 9:45 AM To: user@cassandra.apache.org Subject: I want either all the DML statements within the batch succeed or rollback all. is it possible? Hi all, In the user guide of Cassandra i got the information about the batch for atomic DML operations. I want either all the DML statements within the batch succeed or rollback all. is it possible? another question in my can i use joins in Cassandra or any other way to achieve it. Regards Tarkeshwar
