I do not know what your exact problem is. Set you debug logging on. This can be done however assuming both clusters have network access to each other
On Wed, Jun 24, 2015 at 4:33 PM, Alexander Pivovarov <[email protected]> wrote: > 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) >
