How to manipulate data which is on another Vertica cluster ?
We are developing a tool to automate and secure data transfer between different DBs (ex : DEV-->TEST). The tool works as follows
- it has to run on the cluster of the source DB
- it runs EXPORT command, to be able to transfer either a full object or the result of a query
We would like to include operations on **target tables **: optional truncate before copy, analyse_histograms after copy
But, even though we issue a successful remote connection to the target DB for the transfer, we cannot execute other commands, they are not allowed :
connect to vertica DEVDB user dbadmin password '*****' on 'HOST',5433;
SELECT * FROM DEVDB.COMMON.T1_TABLE;
11:22:54 [CONNECT - 0 rows, 0.064 secs] Command processed. No rows were affected
** 11:22:54 [SELECT - 0 rows, 0.058 secs] [Code: 2983, SQL State: 0A000] [Vertica]VJDBC ERROR: Database "GBADEV" does not exist**
Should we do a specific configuration on Server side? Is Vertica handling the notion known as dblink in Oracle ? Or is the cross-DB connection completely forbidden in Vertica's world because the clusters are separated ?
Thank you for any help on this topic