vertica vbr.py

sreeblrsreeblr - Select Field - Employee
in General Discussion

Can vbr.py be used to copy specific tables between vertica servers>?

Comments

  • kaurorakaurora

    When you say vertica servers, do you mean 2 different vertica clusters? 

     

    If yes, you can either use the connect export/Copy from vertica option. This requires some setup on the vertica side. 

     

    OR

     

    just use vsql  to dump data from your source cluster and vsql again to import it on the other cluster

     

    Run this on your source cluster. 

     

    vsql -c "select * from table"  | vsql -h target_cluster -c "Copy table_name from stdin"

     

    Hope you can figure out the rest. 

  • sreeblrsreeblr - Select Field - Employee

    there is no direct connectivity between servers hence cannot use vertica copy/export. Also the vertica create file with vsql and importing using copy is quite cumbersome and has some issues with using special charecters/data format data. Thats reason to ponder about using vbr.py

  • kaurorakaurora

    I wouldn't play recommend object backup and restore for what you are trying to do. 

    You could easily specify delimiters that are very unlikely to be in your data.IMHO that is a better option .  

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 ...