CREATE TABLE multirow (
PRIMARY KEY (id, time)
So lets say we update status column multiple times. So first time we update we also have to make sure that the transaction exists otherwise normal update will insert it and then the original insert comes in and it will override the update.
So in order to fix that we need to use light weight transactions.
Is there another way i can model this so that we can avoid the lightweight transactions.