inputs/udf/udf-having.sql

0001 -- This test file was converted from having.sql.
0002
0003 create temporary view hav as select * from values
0004   ("one", 1),
0005   ("two", 2),
0006   ("three", 3),
0007   ("one", 5)
0008   as hav(k, v);
0009
0010 -- having clause
0011 SELECT udf(k) AS k, udf(sum(v)) FROM hav GROUP BY k HAVING udf(sum(v)) > 2;
0012
0013 -- having condition contains grouping column
0014 SELECT udf(count(udf(k))) FROM hav GROUP BY v + 1 HAVING v + 1 = udf(2);
0015
0016 -- SPARK-11032: resolve having correctly
0017 SELECT udf(MIN(t.v)) FROM (SELECT * FROM hav WHERE v > 0) t HAVING(udf(COUNT(udf(1))) > 0);
0018
0019 -- SPARK-20329: make sure we handle timezones correctly
0020 SELECT udf(a + b) FROM VALUES (1L, 2), (3L, 4) AS T(a, b) GROUP BY a + b HAVING a + b > udf(1);