Does the copy_table('original','duplicate') function automatically commit a transaction to the original table?
Once you run copy_table, original and duplicate tables are treated seperately. so when you commit a transaction on the duplicate table, it will not change anything in original table.
In addition, the copy_table statement initiate a COMMIT to any previous statement in that session even if the session AUTOCOMMIT is set to OFF.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.