SELECT DISTINCT is supported, but it is limited internally by the group by cardinality limits.
To make a distinct selection from a query that uses GROUP BY, you will need to add a new outer select.
SELECT DISTINCT fieldX
FROM ( SELECT fielda, fieldb, fieldX
GROUP BY fieldb
) AS inner_query