Search found 2 matches
- 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
- 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...