How to I convert this SAS query to Hive SQL

Viewed 25

I have this script that appends those 4 tables into one and I need to do this exactly same query but with Hive SQL Syntax.

CREATE TABLE append_table AS
SELECT * FROM table_1
 OUTER UNION CORR
SELECT * FROM table_2
 OUTER UNION CORR
SELECT * FROM table_3
 OUTER UNION CORR
SELECT * FROM table_4;

How do I do that ?

0 Answers
Related