yql/essentials/udfs/common/histogram/test/cases/Distinct.sql


1
2
3
4
5
6
7
8
9

/* syntax version 1 */
SELECT
    HISTOGRAM(DISTINCT key) AS key_histogram,
    Histogram::Print(HISTOGRAM(key)) <> Histogram::Print(HISTOGRAM(DISTINCT key)) AS is_different
FROM (
    SELECT
        CAST(key AS Double) AS key
    FROM Input
);