Is there any way to connect two different tables on different databases on different Hive instances(Different ports) using a hive query?
I believe cross cluster hive connections are not available yet.
Hello RAJA K
You can use join normally i think as per the below sample
SELECT * FROM db1.table1 alias1 INNER JOIN db2.table2 alias2 ON alias1.field1 = alias2.field2;
Via Stephen Sprauge we have a solution to a true headbanger; joining two tables in two different databases in Hive. Hive objects to (1) the use of AS in JOINs to declare aliases, and (2) the use of the database.table.column format; the trick is to have database.table as a silent alias, and then alias.column, like so:
SELECT alias1.column1, alias1.column2, alias2.column1 FROM database1.table1 alias1 INNER JOIN database2.table2 alias2 ON alias1.column1 = alias2.column1;
At which point Hive begins behaving.
Thanks and Best Regards
Here the Two databases are in two different Hive Instances(Both DB's are on two different Ports)
are talking about cross cluster connections ?
Yes.I would like to know the answer for Cross cluster Connections too...
Retrieving data ...