hivesterix/src/test/resources/optimizerts/queries/u3_union.hive - asterixdb - Gitiles

 drop table IF EXISTS supplier;
 drop table IF EXISTS result;

 create external table supplier (S_SUPPKEY INT, S_NAME STRING, S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE, S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE LOCATION '/tpch/supplier';
 create table result (S_SUPPKEY INT, S_NAME STRING, S_ADDRESS STRING, S_NATIONKEY INT);

 select * from (select (2*s_suppkey), s_address, s_nationkey,  s_name  FROM supplier where S_SUPPKEY*2 < 20 union all select (2*s_suppkey), s_address, s_nationkey,  s_name   FROM supplier where S_SUPPKEY*2 > 50) t;
	drop table IF EXISTS supplier;
	drop table IF EXISTS result;

	create external table supplier (S_SUPPKEY INT, S_NAME STRING, S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE, S_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\|' STORED AS TEXTFILE LOCATION '/tpch/supplier';
	create table result (S_SUPPKEY INT, S_NAME STRING, S_ADDRESS STRING, S_NATIONKEY INT);

	select * from (select (2s_suppkey), s_address, s_nationkey, s_name FROM supplier where S_SUPPKEY2 < 20 union all select (2s_suppkey), s_address, s_nationkey, s_name FROM supplier where S_SUPPKEY2 > 50) t;