Search found 2 matches

by nygenomer
Fri Aug 26, 2016 8:33 pm
Forum: General
Topic: Propagation of duplicate rows into target table after MERGE INTO
Replies: 1
Views: 5151

Re: Propagation of duplicate rows into target table after MERGE INTO

The above described issue is gone when we moved from Vertica 7.1 to 7.2
by nygenomer
Tue Aug 16, 2016 11:47 pm
Forum: General
Topic: Propagation of duplicate rows into target table after MERGE INTO
Replies: 1
Views: 5151

Propagation of duplicate rows into target table after MERGE INTO

I am running a sequence of MERGE INTO operations of the following kind: MERGE /*+ direct */ INTO target_table T USING source_table S ON (T.key1 = S.key1 AND T.key2 = S.key2) WHEN NOT MATCHED THEN INSERT (key1, key2, field1, field2) VALUES (S.key1, S.key2, S.field1, S.field2) where both source and ta...

Go to advanced search