INSERT OVERWRITE TABLE company
SELECT id, location FROM
(SELECT id, "newyork" AS location from employee where id=50)
UNION ALL
(SELECT id, location from company where id >50 and id <50);