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!

Optimizing individual "update or insert" statements

We are switching to Vertica and one of our systems needs to periodically update or insert individual data rows in a Vertica table. If the record with the given key exists, it needs to update the non-key fields. If the record doesn't exist, it needs to insert it. In SQL Server, we used to do that using construct [update ... ] if \@\@rowcount = 0 [insert ...]
I believe Vertica doesn't support\ @\@rowcount or IF statement.
Can you please recommend the most efficient way to implement the same functionality for Vertica tables?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file