Unique key in memsql

Off-Topic
1

Hello Team,
We want to avoid duplicate data in the columnstore table for pariticular columns but i am not sure if that is supported in the MemSQL.

memsql> CREATE TABLE tuniq2 (id INT, KEY USING CLUSTERED COLUMNSTORE (id), UNIQUE KEY (id) UNENFORCED NORELY);
Query OK, 0 rows affected (0.05 sec)

memsql> insert into tuniq2 values (1);
Query OK, 1 row affected (0.04 sec)

memsql> insert into tuniq2 values (1);
Query OK, 1 row affected (0.02 sec)

memsql> select * from tuniq2;
±-----+
| id |
±-----+
| 1 |
| 1 |
±-----+
2 rows in set (0.04 sec)

I am able to insert the duplicate data into the DB.

2

The UNENFORCED keyword means the unique key will not be enforced and so duplicates will be able to be inserted into the table. To enforce the index, you should use unique key(id) using hash.