Merging Table Data

MERGE statements can perform update and insert operations on a target table based on the results of a join with a source data set. The join can match a source row with only one target row; otherwise, Vertica returns an error.

MERGE has the following syntax:

MERGE INTO target‑table USING source‑dataset ON  join-condition
   matching‑clause[ matching‑clause ]

Merge operations have at least three components:

In This Section