Search found 2 matches
- 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...
- 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...