Thanks nnani. That is how I have them now.ie in two different schema on same database. there is some concern regarding CPU and resource utilization(not related to this query I am writing) which is causing one of the schema to move over to a new db cluster. I am trying to figure out how to perform my joins in that case.nnani wrote:#DGh
Welcome to Vertica Forums !
As of now, DB links feature in not present in Vertica.
More over you cannot run two databases simultaneously at one time in Vertica cluster.
The approach to your scenario can be : use two different schemas in same cluster which can act as two different database.
Once the databases are set, you can join the tables in two different database using the standard SQL.
Let us know your requirement precisely..
Hope this helps..