hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Pivovarov <apivova...@gmail.com>
Subject join 2 tables located on different clusters
Date Wed, 24 Jun 2015 20:33:10 GMT
Hello Everyone

Can I define external table on cluster_1 pointing to hdfs location on
cluster_2?
I tried and got some strange exception in hive
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:java.lang.reflect.InvocationTargetException)

I want to do full outer join btw table A which exist on cluster_1 and table
A on cluster_2.

My idea was to create external table A_2 (on cluster_1) which points to
cluster_2 and run hive query on cluster_1

select a.*, a_2.*
from a
full outer join a_2 on (a.id = a_2.id)

Mime
View raw message