CONNECT SQL RETURNING ERRR

What happens if you run:

\! /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h 10.42.22.207

Are the database in different subnets?

Hello @Jim_Knicely
Same trying to execute this on production(inet addr:10.65.3.7 Bcast:10.65.7.255 Mask:255.255.248.0)
to connect POC DB( inet 10.42.22.207 netmask 255.255.255.0 broadcast 10.42.22.255)
[dbadmin@verticadb-1 ~]$ /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h 10.42.22.207
vsql: could not connect to server: Connection timed out
Is the server running on host "10.42.22.207" and accepting
TCP/IP connections on port 5433?
You have mail in /var/spool/mail/dbadmin

Can you ping 10.42.22.207 or ssh into it? If you can ssh into it, check if Vertica is running

Also, is there a public IP address for the POC node? Maybe you can connect to it?

/opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<public ip-addres >>

If you can connect, you will have to change the export addresses on the nodes in prod (if possible).

See: Changing Node Export Address

Or, you can copy data using vsql. Say you want to copy data from table JIM in Prod to table JIM in POC:

/opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<prod DB >> -c "SELECT * FROM jim;" | /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<POC DB >> -c "COPY jim FROM STDIN;" 

Unfortunately with a lot of data that might be kind of slow. But you can run alot of those COPY commands in parrallel.

Hello @Jim_Knicely vertica is running in both clusters, ping is fine although ssh is not setup,can this be a possible problem?
Also are you sure about this command
/opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <> -c "SELECT * FROM jim;" | /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <> -c "COPY jim FROM STDIN;"
I mean the starting of it vsql -d vdb? from prod server?

No, you don't need SSH to be working. But if the database are different subnets, you have to change the EXPORT node addresses.

See: Configuring Network to Import and Export Data

For that command I sent, it first selects data from prod and then passes (i.e. pipes) the output to the second vsql commadn which loads it from standard in.