sql-tests/inputs/udaf.sql

0001 -- Test aggregate operator and UDAF with codegen on and off.
0002 --CONFIG_DIM1 spark.sql.codegen.wholeStage=true
0003 --CONFIG_DIM1 spark.sql.codegen.wholeStage=false,spark.sql.codegen.factoryMode=CODEGEN_ONLY
0004 --CONFIG_DIM1 spark.sql.codegen.wholeStage=false,spark.sql.codegen.factoryMode=NO_CODEGEN
0005
0006 CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES
0007 (1), (2), (3), (4)
0008 as t1(int_col1);
0009
0010 CREATE FUNCTION myDoubleAvg AS 'test.org.apache.spark.sql.MyDoubleAvg';
0011
0012 SELECT default.myDoubleAvg(int_col1) as my_avg from t1;
0013
0014 SELECT default.myDoubleAvg(int_col1, 3) as my_avg from t1;
0015
0016 CREATE FUNCTION udaf1 AS 'test.non.existent.udaf';
0017
0018 SELECT default.udaf1(int_col1) as udaf1 from t1;
0019
0020 DROP FUNCTION myDoubleAvg;
0021 DROP FUNCTION udaf1;