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

--! qt:dataset:src1
--! qt:dataset:src
-- SORT_QUERY_RESULTS

EXPLAIN
 SELECT a.key, a.value, b.key, b.value1,  b.value2
 FROM 
  (
  SELECT src1.key as key, count(src1.value) AS value FROM src src1 group by src1.key
  ) a
 FULL OUTER JOIN 
 (
  SELECT src2.key as key, count(distinct(src2.value)) AS value1, 
  count(distinct(src2.key)) AS value2
  FROM src1 src2 group by src2.key
 ) b 
 ON (a.key = b.key);

 SELECT a.key, a.value, b.key, b.value1,  b.value2
 FROM 
  (
  SELECT src1.key as key, count(src1.value) AS value FROM src src1 group by src1.key
  ) a
 FULL OUTER JOIN 
 (
  SELECT src2.key as key, count(distinct(src2.value)) AS value1,
  count(distinct(src2.key)) AS value2
  FROM src1 src2 group by src2.key
 ) b 
 ON (a.key = b.key);