Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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