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.

Is it possible to join two hive tables physically exists on two sepearte HDFS file systems (separate HDP cluster environments in different data center locations) ? If possible, please suggest how?

Is it possible to join two hive tables physically exists on two sepearte HDFS file systems (separate HDP cluster environments in different data center locations) ? If possible, please suggest how?

New Contributor

Trying to find a solution for HIVE users to be able to run HIVE query with join between two tables without physical data movement from one datalake to another datalake.

1 REPLY 1
Highlighted

Re: Is it possible to join two hive tables physically exists on two sepearte HDFS file systems (separate HDP cluster environments in different data center locations) ? If possible, please suggest how?

@kesavarao ande hiveql is not capable of query federation today. You might want to look at federation using SparkSQL and ThriftServer.

Don't have an account?
Coming from Hortonworks? Activate your account here