buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame^] | 1 | -- union case: both subqueries are map jobs on same input, followed by filesink |
2 | DROP TABLE IF EXISTS src; | ||||
3 | |||||
4 | CREATE TABLE src(key int, value int); | ||||
5 | CREATE TABLE src1(key int, value int); | ||||
6 | CREATE TABLE src2(key int); | ||||
7 | |||||
8 | FROM src | ||||
9 | INSERT overwrite table src1 select * where key < 5 | ||||
10 | INSERT overwrite table src2 select key where key > 10; |