Bulk load mechanism in a cluster
I read about MPP (massively parallel processing) mechanism in Vertica and Understand in a cluster, queries execute in each node separately and parallel( one initiator node and other nodes are executors)
So what about copy command ?
Does it have same mechanism?
0
Comments
Hi. Welcome to the board. I think you'll like the following information in our documentation:
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/COPY/Parameters.htm
I just checked with SKamat, another poster on this board, and the COPY command supports MPP through options, such as APPORTIONED LOAD
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ExtendingVertica/UDx/UDL/ApportionedLoad.htm?Highlight=apportioned
and COPY ON ANY NODE
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/Glossary/ParallelLoad.htm?Highlight=copy on any node