CODEWITHSUNDEEP
hivehbase
user2575502
user2575502

Reputation: 703

How to do join one hive table with another remote hive table

We have a computing scenario that is we need to do join operation for 2 tables in Hive.

For example, in clusterA we create a table A in Hive and in clusterB, we created a table B in Hive which is mapping to a Hbase table in clusterB. Then we want to write below SQL statement in Hive in clusterA like this : 

select a.col1, b.col2 from ta inner join tb@remote_hive on ta.col3 = tb.col3

Just like the conception database link in Oracle.
Is there a way allow us to do it like this? if yes, can you give us an example.

Upvotes: 1

Views: 679

Answers (1)

Guillaume
Guillaume

Reputation: 2869

It's not (directly) possible. There are at least 2 ways around it though:

Upvotes: 2

Related Questions