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 ?