Hii, this is my 2nd day I learn CassandraDB.
I have read this: https://www.datastax.com/learn/data-modeling-by-example/order-management#application
In that article has table:
- oders_by_user
- orders_by_id
- orders_by_user_item
- orders_status_history_by_id
Assuming we receive some "order" from user and this is the part I want to ask:
Do I need inserting all across table when "order" been created?
If so, then the next question is, if My App failed inserting data into table `orders_by_user_item` for whatever reason, how I (as developer) should handle this use case? Considering cassandra doesn't support ACID.
I also have read this article: https://www.datastax.com/blog/lightweight-transactions-cassandra-20, to accomplish with that case, so how the `cql` look like?
Thankyou in advanced.