I have two tables A and B.
How to implement the following logic?
If a doesn't exists in A: insert a into A and insert b into B. [NOTE: the insertions of a and b must be "Cassandra batch" style.]
If a exist in A, don't insert b into B.
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
How can I implement an INSERT into table B that is conditional on table A?
Lightweight transactions only provide isolation on a per-table basis.
It is not possible to do a conditional write (INSERT, UPDATE, DELETE) to table B based on the existence of a partition in table A. You can only specify a condition based on table B if you're writing to table B.
You will need to implement that logic in your application. Cheers!
[UPDATE] In the case where you want to do a conditional BATCH update, writing to multiple tables is not supported. Conditional batch updates can only contain statements for one table.
Again, the solution is to implement it in your application. Be aware that a read-before-write is expensive so use it sparingly.
thanks Erick. Sorry that my origin quesion was wrong. Now I refined the description.
Any insights would be much appreciated!
5 People are following this question.
