CODEWITHSUNDEEP
codeignitercassandra
Vijayakumar
Vijayakumar

Reputation: 69

Auto increment ids in cassandra database

How to create unique id in cassandra column families( like auto-increment id in mysql database ) ?

Upvotes: 0

Views: 4722

Answers (3)

ssuperczynski
ssuperczynski

Reputation: 3426

You asked for simple query to create table with uuid, so there you are:

create:

CREATE TABLE event (uuid uuid, name varchar);

insert:

INSERT INTO event(uuid, name) values(uuid(), 'john');

select: 

SELECT * FROM event LIMIT 1;

to select on name column you must add new index:

CREATE index idx_event_name ON event(name);

and now you can select with where:

SELECT * FROM event WHERE name = 'john';

select

Upvotes: 1

ism
ism

Reputation: 11

If you really need integer autoincrement IDs I've written a simple python module that does that after going through stackoverflow and not seeing anything decent that does that specific function. If you don't care about the ID being an integer you're better off using something like UUID which is probably safer and more elegant.

link: https://github.com/qdatum/globalcounter

Upvotes: 0

Tyler Hobbs
Tyler Hobbs

Reputation: 6932

For unique IDs in Cassandra, you'll want to use UUIDs, which are probabilistically (nearly) guaranteed to be unique. There are a few built-in functions in CQL to help with UUIDs.

Upvotes: 2

Related Questions