You can use lightweight transactions to achieve this. Example: UPDATE item SET customer = 'Joe' WHERE item_id = 2 IF customer = null;
Keep in mind that lightweight transactions have performance tradeoffs ( http://www.datastax.com/dev/blog/lightweight-transactions-in-cassandra-2-0) On Mon, 7 Nov 2016 at 11:52 S Ahmed <sahmed1...@gmail.com> wrote: > Say I have 100 products in inventory, instead of having a counter I want > to create 100 rows per inventory item. > > When someone purchases a product, how can I correctly assign that customer > a product from inventory without having any race conditions etc? > > Thanks. > -- Justin Cameron Senior Software Engineer | Instaclustr This email has been sent on behalf of Instaclustr Pty Ltd (Australia) and Instaclustr Inc (USA). This email and any attachments may contain confidential and legally privileged information. If you are not the intended recipient, do not copy or disclose its content, but please reply to this email immediately and highlight the error to the sender and then immediately delete the message.
