inputs/udf/udf-udaf.sql

0001     -- This test file was converted from udaf.sql.
0002
0003 CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES
0004 (1), (2), (3), (4)
0005 as t1(int_col1);
0006
0007 CREATE FUNCTION myDoubleAvg AS 'test.org.apache.spark.sql.MyDoubleAvg';
0008
0009 SELECT default.myDoubleAvg(udf(int_col1)) as my_avg, udf(default.myDoubleAvg(udf(int_col1))) as my_avg2, udf(default.myDoubleAvg(int_col1)) as my_avg3 from t1;
0010
0011 SELECT default.myDoubleAvg(udf(int_col1), udf(3)) as my_avg from t1;
0012
0013 CREATE FUNCTION udaf1 AS 'test.non.existent.udaf';
0014
0015 SELECT default.udaf1(udf(int_col1)) as udaf1, udf(default.udaf1(udf(int_col1))) as udaf2, udf(default.udaf1(int_col1)) as udaf3 from t1;
0016
0017 DROP FUNCTION myDoubleAvg;
0018 DROP FUNCTION udaf1;