CREATE TEMPORARY TABLE dfs.tmp.temp_tbl_unall as ( SELECT col_int, col_chr, col_vrchr1, col_vrchr2 FROM typeall_l order by col_int ) UNION ALL ( SELECT col_int, col_chr, col_vrchr1, col_vrchr2 FROM typeall_r order by col_int ); | |
SELECT * FROM dfs.tmp.temp_tbl_unall ORDER BY col_int LIMIT 100; | |
DROP TABLE dfs.tmp.temp_tbl_unall; |