Bulk load mechanism in a cluster

Forum|Forum|9 years ago
June 6, 2017
1 reply
9 views

Forum|alt.badge.img

hoseiney
Participating Frequently

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?

Forum|alt.badge.img

TomM
Participating Frequently
Forum|Forum|9 years ago
June 6, 2017

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

Like