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.