Joining two tables in different metastores

[KB]

Hi,

Where does the join happen when joining two tables which reside in different hive instances? Is there a way to route join to a specific hive instance?

[Patrick Duin]

Hi,

WD only proxies metadata, data is process in the cluster that fires the query.

Example:

I spin up an EMR cluster that I point to WD that federates across two metastores. The EMR cluster will be where all the data is crunched. So it needs to have access to HDFS or s3 buckets depending where your data is coming from.

Hope that helps,

 Patrick

[kbee...@gmail.com]

Got it, thanks!

--
KB