-- union case: both subqueries are map jobs on same input, followed by filesink
DROP TABLE IF EXISTS src;

CREATE TABLE src(key int, value int);
CREATE TABLE src1(key int, value int);
CREATE TABLE src2(key int);

FROM src
INSERT overwrite table src1 select * where key < 5
INSERT overwrite table src2 select key where key > 10;