Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to/ Can you run multiple interpreters like jdbs , spark and - or spark.sql all in a single paragraph?

Highlighted

How to/ Can you run multiple interpreters like jdbs , spark and - or spark.sql all in a single paragraph?

New Contributor

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?