We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


CONNECT TO Vertica with same database names — Vertica Forum

CONNECT TO Vertica with same database names

Hello everyone!

 

I'm having the following issue:

I have two Vertica 7.1 clusters with equal database names: DWH.

 

I'm establishing connection from one cluster to another via CONNECT TO:

 

DWH=> connect to vertica DWH USER ETLUSER PASSWORD 'SomePassword' on 'remote_host',5433;
CONNECT
DWH=>

 

Then I'm trying to query data from remote_host:

 

DWH=> select count(1) from DWH.WORKSCHEMA.TEST_TABLE;
count
-------
0
(1 row)

 

But in fact it is NOT empty! When i connect to remote_host via VSQL and execute the same query, it returns non-zero value. So, my guess is that vertica sees equal database names and queries her local table WORKSCHEMA.TEST_TABLE instead of remote table from established connection. Local table IS empty.

 

I don't know, whether it is a Vertica bug or my misunderstandment.

Please, can anyone suggest the way to export data from one host to another via CONNECT\EXPORT without renaming databases? May be there is a way to create an alias for connection, like db_link in Oracle RDBMS.

 

Any help is appreciated!

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file