i want to implement sequence in Scylladb so i created a table :

CREATE TABLE project.sequence (
 name ascii PRIMARY KEY,
 value bigint
);

Then i inserted a row:

INSERT INTO project.sequence (name,value) VALUES ('UID', 1000);

Now i just want to update sequence where name is ‘UID’ but i got a LWT error from Scylla.

UPDATE project.sequence SET value=? WHERE name='UID' IF value=?;

This is error :

InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot use LightWeight Transactions for table project.sequence: LWT is not yet supported with tablets"

In fact, i get this error every where I use LWT (if condition) !!!! What is the problem ?