question How to avoid duplicate row insertion in Hive? in Support Questions

question How to avoid duplicate row insertion in Hive? in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-avoid-duplicate-row-insertion-in-Hive/m-p/286088#M212213 CREATE TABLE Test( recordId String, Advertiser_id STRING , Advertiser_name STRING, PRIMARY KEY (recordId) DISABLE NOVALIDATE);   insert into Test values('1','prakash','vtv'); insert into Test values('1','prakash','vtv');   Test.recordid | Test.advertiser_id | Test.advertiser_name | +-----------------------------+----------------------------------+------------------------------------+ | 1 | prakash | vtv | | 1 | prakash | vtv | +-----------------------------+----------------------------------+------------------------------------+   As per RDBMS terms Primary key constraint shouldn't allow me to create duplicate record with the same value.   How to achieve this in Hive?       Fri, 20 Dec 2019 14:22:40 GMT Prakashcit 2019-12-20T14:22:40Z