How Copy command works
I have 3 node cluster and want load files in parallel.
I did not find in docs any exact info how Copy vertica command works with option ON ANY NODE.
For example on node1 i have file systems with files i want to load.
I run command from node 1 - copy ... ON ANY NODE
How vertica choose what file from what node load ?
Should i have the same files on every node in my cluster?
Oleg.
0
Comments
COPY fully supports the ON ANY NODE clause with a wildcard. You can invoke COPY for a large number of files in a shared directory accessible by all nodes in the cluster.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/SpecifyingCOPYFROMOptions.htm?Highlight="any node"