Join tables from two different clusters

vishnu777vishnu777
edited October 2017 in General Discussion

I need to join tables from two different clusters.
Do we have a way to do on Vertica.

any pointers is appreciated !

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited October 2017

    Hmm. Do you need real time? If not, I would try the "COPY FROM VERTICA" feature. You can have local copy of the remote table.

  • [Deleted User][Deleted User]

    We don't currently have any federation (cross cluster queries) functionality in Vertica, so as Jim alludes to you'd need to get the two tables into the same cluster to be able to join them.

  • vishnu777vishnu777
    edited October 2017

    @Jim_Knicely @SC_at_Microfocus : appreciate for your time. Thank you.

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