Join tables from two different clusters

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.