Skip to main content

How Copy command works

  • March 3, 2015
  • 1 reply
  • 9 views
oleg_lll
Forum|alt.badge.img+1

 

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.

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • March 4, 2015

    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"

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement