Does Vertica provide upsert support while loading data?

I am evaluating pushing data to Vertica from one of our client applications. The client application receives database updates and inserts and we need to push this data to Vertica as and when it arrives. From the Vertical technical guide, I saw we can load data using COPY command. Since we receive incremental data over a period of time, I also explored Apache Kafka topic integration that Vertica provides. However, it's not clear how I can update a record that was inserted earlier. Because the documentation says that it uses COPY command internally in the Scheduler that reads messages from Kafka topic. Does Vertical internally handle upsert or is there a way I can tell Vertica to update this record and not insert?

Our client application is a .NET Core application.

Answers

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.