Join tables from two different clusters

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.

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

  • edited October 2017

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

Leave a Comment

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