inputs/udf/udf-count.sql

0001 -- This test file was converted from count.sql
0002 -- Test data.
0003 CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES
0004 (1, 1), (1, 2), (2, 1), (1, 1), (null, 2), (1, null), (null, null)
0005 AS testData(a, b);
0006
0007 -- count with single expression
0008 SELECT
0009   udf(count(*)), udf(count(1)), udf(count(null)), udf(count(a)), udf(count(b)), udf(count(a + b)), udf(count((a, b)))
0010 FROM testData;
0011
0012 -- distinct count with single expression
0013 SELECT
0014   udf(count(DISTINCT 1)),
0015   udf(count(DISTINCT null)),
0016   udf(count(DISTINCT a)),
0017   udf(count(DISTINCT b)),
0018   udf(count(DISTINCT (a + b))),
0019   udf(count(DISTINCT (a, b)))
0020 FROM testData;
0021
0022 -- count with multiple expressions
0023 SELECT udf(count(a, b)), udf(count(b, a)), udf(count(testData.*)) FROM testData;
0024
0025 -- distinct count with multiple expressions
0026 SELECT
0027   udf(count(DISTINCT a, b)), udf(count(DISTINCT b, a)), udf(count(DISTINCT *)), udf(count(DISTINCT testData.*))
0028 FROM testData;