I have 2 tables located on 2 different servers running on different host. I want to join them using hive for my use case.
I was looking to query data from table 1 using %hive_server1 and 2nd one from %hive_server2 ( my own interpreters) and perform a join on them
My question is that how can I perform such a join?
I have come across no such example in documentation of zeppelin as of yet, nor at community.hortonworks.com. Can you please tell me a simple way to do it?
There may be other ways to do this like pyspark or maybe using 2 jdbc connections that I have limit knowledge on.
Can you please help in that?