티스토리 뷰

### 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

'공부' 카테고리의 다른 글

[Chrome Extension] ActiveTab  (0) 2020.01.19
[NodeJS] ngrok command not found in MacOSX  (0) 2020.01.18
[Hive] FAILED: ParseException line 1:109 missing EOF at 'as' near ')'  (0) 2020.01.18
[Java] Deep copy Date  (0) 2020.01.18
[Nginx] 405 Not Allowed  (0) 2020.01.18
[Algorithm] Swap by 3 XOR  (0) 2020.01.18
댓글
댓글쓰기 폼