Merge vs SWAP_PARTITIONS
Hi, dear Vertica community!
I have a table with accounts data (3,5kk rows) that updates from sources every 3 hours. As soon as update is quite slow operation, it takes about 1,5 hours to check and update changed rows.
So I would like to try inserting full actual data to temporary table and than SWAP_PARTITIONS_BETWEEN_TABLES() or RENAME to replace data in main table, that should be faster.
The concern is - what happens to users' queries at the moment of SWAP_PARTITIONS / RENAME execution? Will the queries be canceled / rerun or the users might get inconsistent information?
1