티스토리 뷰

728x90

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

728x90

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

[Chrome Extension] ActiveTab  (0) 2020.01.19
[NodeJS] ngrok command not found in MacOSX  (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
댓글