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 !


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

  • Options

    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.

  • Options
    edited October 2017

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

Leave a Comment

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