Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.


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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.