How can I avoid duplicates in table

There is no possibility to set any column as primary key as well afaik.

That’s correct — you need to use the id if you want to deduplicate. You can use any hash function that returns a bigint for that purpose.

The related issue is Feature request: user defined constraints (unique key) · Issue #1015 · manticoresoftware/manticoresearch · GitHub

1 Like