The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Vertica merge question for doing insert and delete
I am reading the documentation for the merge command here
https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/SQLReferenceManual/Statements/MERGE.htm
So in my case there are two conditions for "when not matched". not match can occur if the data is present in the source table and missing from the target table. in this case I do an insert.
if the data is missing in the source table but present in the target table, thn I have to do a delete.
by reading the documentatino above it seems I can do only one of them.
0
Comments