set vid = 18;
CREATE TABLE union_test2 AS
select * from larkin_workspace.afp_flat_2015_07_01
WHERE vertical_id = '${hiveconf:vid}'
UNION ALL
select * from larkin_workspace.afp_flat_2015_07_02
WHERE vertical_id = '${hiveconf:vid}'
UNION ALL
select * from larkin_workspace.afp_flat_2015_07_03
WHERE vertical_id = '${hiveconf:vid}';