CODEWITHSUNDEEP
cassandra-2.0cqlsh
Venkata Ramu Kandulapati
Venkata Ramu Kandulapati

Reputation: 21

How to Increment the ID value in Cassandra Table Automatically?

I have a challenge when I am inserting a values in Cassandra table , I have one column name is "ID", this ID column values are increase the automatically like mysql auto_increment column. I think Counter DataType is not suitable in this Scenario. Please any one help me to design the Schema, I don't want use the UUID's also for Replace the ID column

Upvotes: 1

Views: 588

Answers (1)

Roman Tumaykin
Roman Tumaykin

Reputation: 1931

In short I don't believe it is possible. The nature of Cassandra is that it does not do a read before write. With only one exception, lightweight transactions, but all they do is what's called "compare and swap", but there is no way, the autoincrement can be implemented on the server side.

Even with counters, you won't be able to achieve the desired result, if you increase the counter every time you add a record to the table, because you will not know whether the current value (even if it is totally consistent), is a result of an increment from your process, or from a concurrent process.

The only way is to implement this mechanism on the application side.

Upvotes: 2

Related Questions