blob: 7b207a0eae9931f87509c69e677e795a7aa9868e [file] [log] [blame]
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;