Hi,
I'm trying to export data from one Vertica cluster to another. Using http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/EXPORTTOVERTICA.htm?Highlight=export%20to%20vertica as a reference, I launch a vsql session on the source cluster and issue the CONNECT statement (database, password and server names are not the real values and are for illustration) :-
dbadmin=> CONNECT TO VERTICA MYDB USER dbadmin PASSWORD 'password' ON 'TARGET-SERVER',5433;
CONNECT
Vertica responds with the "CONNECT" message as above so that seems good. Then I issue the EXPORT TO VERTICA statement:-
dbadmin=> EXPORT TO VERTICA MYDB.public.TEST FROM TEST;
ERROR 4054: NetworkSend on v_MYDB_node0001: failed to open connection to node v_MYDB_node0001 (socket error: No route to host)
Vertica responds with the error 4054 as above.
I can ping the target cluster and also run a vsql session from the source cluster using the -h flag to connect to the target cluster as a test, so I can't see why I cannot issue the EXPORT command (the CONNECT statement seemed to work).
Can anyone assist?
Thanks!
