The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

COPY ON ANY NODE

I currently use COPY FROM LOCAL option with vsql connecting to a specific node. My questions is: 1) Is the defailt behaviour to run the COPY command on the node that is given in vsql? 2) Can I give ON ANY NODE option in COPY FROM LOCAL? 3) If answer for question 2 is yes then does it mean host given in vsql will be used only to make initial connection and COPY could actually run on any node in a cluster?

Comments

  • Hi Mohit, Technically, COPY (or, at least, a piece of any given COPY statement) always runs on all nodes. That said, COPY always parses data on the node that contains the file data. Or, for COPY LOCAL, the node that vsql is directly connected to. So: 1) Yes, or from the initiator node in case of COPY LOCAL or COPY FROM STDIN (which do not allow specifying a target node because it's always the same) 2) No Adam

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.