Options

COPY ON ANY NODE

Mohit_AnchliaMohit_Anchlia
in General Discussion
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

  • Options
    [Deleted User][Deleted User]
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...