Search found 2 matches

by sumitkchawla
Fri Mar 27, 2015 3:27 am
Forum: New to Vertica
Topic: WOS and ROS
Replies: 14
Views: 46564

Re: WOS and ROS

Here is my situation. I am constantly polling a postgres database, and trying to keep Vertica data in sync. Vertica tables are denormalized form of multiple postgres tables. Merge queries are quite simple. I copy differential data from OLTP into a temp table, and then merge the temp table into targe...
by sumitkchawla
Thu Mar 26, 2015 8:14 pm
Forum: New to Vertica
Topic: WOS and ROS
Replies: 14
Views: 46564

Re: WOS and ROS

Hi I am facing a peculiar issue with Merge command. I assume it to be related to WOS\ROS. Initially, I am loading close to 100K rows into a target table. Immediately after the initial load, I am running a unit test which updates the datasource and then tries to run a merge command from source to tar...

Go to advanced search