I need to join tables from two different clusters.
Do we have a way to do on Vertica.
any pointers is appreciated !
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.
@Jim_Knicely @SC_at_Microfocus : appreciate for your time. Thank you.