--! qt:dataset:src1
--! qt:dataset:src
set hive.merge.tezfiles=true;
-- SORT_BEFORE_DIFF

EXPLAIN
CREATE TABLE x AS
  SELECT key, 1 as tag FROM src WHERE key = '238'
  UNION ALL
  SELECT key, tag FROM src1
  LATERAL VIEW EXPLODE(array(2)) tf as tag
  WHERE key = '238';

CREATE TABLE x AS
  SELECT key, 1 as tag FROM src WHERE key = '238'
  UNION ALL
  SELECT key, tag FROM src1
  LATERAL VIEW EXPLODE(array(2)) tf as tag
  WHERE key = '238';

SELECT * FROM x;