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)
