ql/src/test/queries/clientpositive/create_genericudaf.q

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
EXPLAIN
CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage';

CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage';

EXPLAIN
SELECT
    test_avg(1),
    test_avg(substr(value,5))
FROM src;

SELECT
    test_avg(1),
    test_avg(substr(value,5))
FROM src;

DROP TEMPORARY FUNCTIOn test_avg;