[Hive] FAILED: ParseException line 1:109 missing EOF at 'as' near ')'

### Use a subquery

SELECT * FROM (SELECT * FROM t1) a 
UNION ALL 
SELECT * FROM (SELECT * FROM t2) b;

 

[출처] https://stackoverflow.com/questions/56777440/hive-cant-perform-union-query-with-limit