I want to give unique constraint on one column in scyllaDb table i am not able to find the solution here i attach my query below.thanks in advance

ScyllaDB
1

CREATE TABLE IF NOT EXISTS ${KEY_SPACE}.${this.name} (
session_id text,
user_id int,
organization_id int,
deviceData map<text,frozen<map<text,text>>>,
userData map<text,frozen<map<text,text>>>,
created_at TIMESTAMP,
updated_at TIMESTAMP,
PRIMARY KEY ((user_id,organization_id),created_at)
) WITH CLUSTERING ORDER BY (created_at DESC);

2

What do you mean by “unique constraint”? The UNIQUE from SQL?
Note that all columns that are part of the primary key (partition or clustering keys) are unique by definition.

3

The UNIQUE from SQL ? → yes i want to implement that

i tried this but it’s not working

4

What do you mean not working? Partition key columns are unique across the entire table, while clustering columns are unique across the partition they are located in.

5

if i add duplicate data then it will be stored

6

Yes, the only way to implement what you need in ScyllaDB is to add a check on the client side. This can be potentially prone to races, so you might need to use LWT.

7

Thanks sir, really appreciated it.

8

is it possible to give default value to column in scyllaDb

9

No, all columns default to null (no value).