MULTISET TABLE WITH UPI using CREATE TABLES AS SYNTAX
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.