framework/resources/Functional/aggregates/aggregation/count_distinct/q4.sql

-- join, group by columns from one table 
-- merge join enabled

alter session set `planner.enable_mergejoin` = true;
alter session set `planner.enable_hashjoin` = false;

select 	t1.a1, 
	t1.b1, 
	count(distinct t1.c1) as distinct_c1,
       	sum(t1.a1) as sum_a1, 
	count(t1.c1) as count_a1, 
	count(*) as count_star
from 
	t1,
	t2
where
	t1.b1 = t2.b2
group by 
	t1.a1, 
	t1.b1 
order by 
	t1.a1, 
	t1.b1
;

alter session set `planner.enable_mergejoin` = true;
alter session set `planner.enable_hashjoin` = true;