Any other quick way to creating copy of huge dataset except 'Create or
replace table' or Insert into - for keeping original dataset intact and
using second one for experimenting
Thanks for the details!Tried import but execution duration are almost
same compared to current implementation. Seems CTAS/Insert into/Import
have similar performance to replicate table on same server.
Thanks for the input! If I understand correctly, import could be a
possibility to replicate a table faster. Can this be faster if it can be
made to execute parallelly across nodes. If yes, how to force import to
run parallely.
Hi, Thanks for the comments. Use case is to export data from a huge
table(~500M) to another server. Import takes long so wanted to check if
there any workaround to do that faster. Running or multiple nodes or
export to csv and import or something els...