framework/resources/Functional/aggregates/aggregation/count_distinct/q6.sql.drill-2866

-- join, group by columns from both tables
-- merge join is 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,
	count(distinct t2.c2) as distinct_c2,
       	sum(t1.a1) as sum_a1, 
	count(t1.c1) as count_a1, 
	count(*) as count_star
from 
	t1,
	t2
where
	t1.a1 = t2.a2 and t1.b1 = t2.b2
group by 
	t1.a1, 
	t1.b1,
	t2.a2,
	t2.b2
order by 
	t1.a1, 
	t1.b1,
	t2.a2,
	t2.b2
;

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