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