'uuid()' function generates an uuid of type 4.
Example
INSERT INTO cassandratutorial.employee(id, first_name) VALUES (uuid(), 'Krishna');
CQL code snippet
CREATE KEYSPACE cassandratutorial WITH REPLICATION =
{
'class' : 'SimpleStrategy',
'replication_factor' : 1
};
CREATE TABLE IF NOT EXISTS cassandratutorial.employee (
id uuid PRIMARY KEY,
first_name VARCHAR
);
INSERT INTO cassandratutorial.employee(id, first_name) VALUES (uuid(), 'Krishna');
Cqlsh console output
cqlsh> CREATE KEYSPACE cassandratutorial WITH REPLICATION =
... {
... 'class' : 'SimpleStrategy',
... 'replication_factor' : 1
... };
cqlsh>
cqlsh> CREATE TABLE IF NOT EXISTS cassandratutorial.employee (
... id uuid PRIMARY KEY,
... first_name VARCHAR
... );
cqlsh>
cqlsh> INSERT INTO cassandratutorial.employee(id, first_name) VALUES (uuid(), 'Krishna');
cqlsh>
cqlsh> SELECT * FROM cassandratutorial.employee;
id | first_name
--------------------------------------+------------
5987fd93-1783-4a14-a17a-5fc4fb191c2c | Krishna
(1 rows)
No comments:
Post a Comment