Remote data access
Under certain circumstances can query remote clusters that use a different version of Hive than the version installed on your cluster.
You can query the data on the remote cluster, including the ability to perform WRITE operations from the local cluster.
Examples of Supported Queries
CREATE TABLE orders_ctas AS SELECT * FROM orders_ext;
INSERT INTO orders_ctas SELECT * FROM orders_ext;
INSERT OVERWRITE TABLE orders_ctas SELECT * FROM orders_ext;