Insert a unique value using the Clustered ColumnStore Index

Question

I would like to know how I am going to create my table or select an insert that ensures that I do not get duplicate values.

create table test.dbo.test product, time, primary key(product, time) go 

When using the Clustered ColumnStore, I cannot have any unique restrictions to know that the data that was inserted is unique. Is there any other way to check this?

Answer 1

Here is a work that uses materialized representations.

http://sqlwithmanoj.com/2014/07/24/maintaining-uniqueness-with-clustered-columnstore-index-sql-server-2014/