create table tst(a int, b int) partitioned by (d string); | |
alter table tst add partition (d='2009-01-01'); | |
alter table tst add partition (d='2009-02-02'); | |
explain | |
select * from ( | |
select * from (select * from tst x where x.d='2009-01-01' limit 10)a | |
union all | |
select * from (select * from tst x where x.d='2009-02-02' limit 10)b | |
) subq; | |
select * from ( | |
select * from (select * from tst x where x.d='2009-01-01' limit 10)a | |
union all | |
select * from (select * from tst x where x.d='2009-02-02' limit 10)b | |
) subq; | |