--! qt:dataset:src
-- SORT_QUERY_RESULTS

CREATE TABLE u1 as select key, value from src order by key limit 5;

CREATE TABLE u2 as select key, value from src order by key limit 3;

CREATE TABLE u3 as select key, value from src order by key desc limit 5;

select key, value from 
(
select key, value from u1
union 
select key, value from u2
union all
select key, value from u3
) tab;

select key, value from 
(
select key, value from u1
union distinct
select key, value from u2
union all
select key as key, value from u3
) tab;

select key, value from 
(
select key, value from u1
union all
select key, value from u2
union
select key, value from u3
) tab;

select key, value from 
(
select key, value from u1
union 
select key, value from u2
union
select key as key, value from u3
) tab;


select distinct * from 
(
select distinct * from u1
union  
select key, value from u2
union all
select key as key, value from u3
) tab;

drop view if exists v_n12;

create view v_n12 as select distinct * from 
(
select distinct * from u1
union  
select key, value from u2
union all
select key as key, value from u3
) tab;

describe extended v_n12;

select * from v_n12;

drop view if exists v_n12;

create view v_n12 as select tab.* from 
(
select distinct * from u1
union  
select distinct * from u2
) tab;

describe extended v_n12;

select * from v_n12;

drop view if exists v_n12;

create view v_n12 as select * from 
(
select distinct u1.* from u1
union all 
select distinct * from u2
) tab;

describe extended v_n12;

select * from v_n12;

select distinct * from 
(
select key, value from u1
union all 
select key, value from u2
union 
select key as key, value from u3
) tab;