How do i query from a different hive cluster? I got two clusters, cluster1 and cluster2. I wanted to re-create a table from cluster2 to cluster1. I tried the conventional sql technique but that isn't working.
CREATE TABLE CLUSTER1.TBL_3 AS
select * from cluster2.tbl2