How Copy command works

oleg_lll

 

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.

[Deleted User]

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"