MULTISET TABLE WITH UPI using CREATE TABLES AS SYNTAX

General
Highlighted
Tourist

MULTISET TABLE WITH UPI using CREATE TABLES AS SYNTAX

Hi,

I am trying to create a MULTISET table with UPI using "CREATE TABLE AS" and found that duplicates are silently ignored without any failure. My understanding was SET TABLE with UPI will ignore dupes silently and MULTISET with UPI will be failing with duplicate rows.

Can somebody help me explaining why it is not failing? 

Also, I created the table(MULTISET UPI ) separately and tried "insert into select" which failed with duplicate unique. 

 

Thanks