ql/src/test/queries/clientpositive/union_pos_alias.q

--! qt:dataset:src
-- SORT_QUERY_RESULTS

set hive.mapred.mode=nonstrict;


explain 
select 'tst1' as key, count(1) as value from src s1
UNION ALL
select key, value from (select 'tst2' as key, count(1) as value from src s2 UNION ALL select 'tst3' as key, count(1) as value from src s3) s4
order by 1;

select 'tst1' as key, count(1) as value from src s1
UNION ALL
select key, value from (select 'tst2' as key, count(1) as value from src s2 UNION ALL select 'tst3' as key, count(1) as value from src s3) s4
order by 1;

drop table src_10;
create table src_10 as select * from src order by key, value limit 10;

explain 
select key as value, value as key from src_10
UNION ALL
select 'test', value from src_10 s3
order by 2, 1 desc;


select key as value, value as key from src_10
UNION ALL
select 'test', value from src_10 s3
order by 2, 1 desc;

drop table src_10;


drop view v_n8;
create view v_n8 as select key as k from src intersect all select key as k1 from src;
desc formatted v_n8;

set hive.mapred.mode=nonstrict;
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;

create table masking_test_n9 as select cast(key as int) as key, value from src;

explain
select * from masking_test_n9  union all select * from masking_test_n9 ;
select * from masking_test_n9  union all select * from masking_test_n9 ;

explain
select key as k1, value as v1 from masking_test_n9 where key > 0 intersect all select key as k2, value as v2 from masking_test_n9 where key > 0;
select key as k1, value as v1 from masking_test_n9 where key > 0 intersect all select key as k2, value as v2 from masking_test_n9 where key > 0;