티스토리 뷰

### 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
댓글
댓글쓰기 폼
공지사항
최근에 달린 댓글
Total
28,468
Today
5
Yesterday
49
«   2020/02   »
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
글 보관함