Using lightweight transactions
INSERT and UPDATE statements that use the IF clause support lightweight transactions, also known as Compare and Set (CAS).
INSERT and UPDATE
statements using the IF
clause support lightweight transactions,
also known as Compare and Set (CAS). A common use for lightweight transactions is an
insertion operation that must be unique, such as a cyclist's identification. Lightweight transactions should not be used casually, as
the latency of operations increases fourfold due to the due to the round-trips
necessary between the CAS coordinators.
Cassandra supports non-equal conditions for lightweight transactions. You can use <, <=, >, >=, != and IN operators in WHERE clauses to query lightweight tables.
It is important to note that using IF NOT EXISTS
on an
INSERT
, the timestamp will be designated by the lightweight
transaction, and USING TIMESTAMP is
prohibited.