cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jack Krupansky" <j...@basetechnology.com>
Subject Re: I want either all the DML statements within the batch succeed or rollback all. is it possible?
Date Tue, 22 Jul 2014 15:30:59 GMT
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
Mime
View raw message