Connecting two different databases

I have two databases namely Impala and Teradata. Both databases have the same table with different values. Each node is connected to the database, impala using (impala connector legacy), Teradata using (Database Connector legacy). How to make the two different databases can be connected in one node and use queries to retrieve the data?

1 Like

Hi @alvoholic,

why not thinking the other way arround. I mean sending the query statement to both databases and concatenate the retrieved results afterwards? This is in my opinion the easier way.

BR

@alvoholic there is this example by @tobias.koetter how to stream data between two databases. You might have to adapt that and see if it would work in a big data environment.

1 Like

solved guys, i use join table like this

image

Thankyou