udaf_example_group_concat.q

/tags/release-0.2.0-rc0/hive/external/contrib/src/test/queries/clientpositive/udaf_example_group_concat.q

#
text | 15 lines | 10 code | 5 blank | 0 comment | 0 complexity | 1f92d7c7852871891ba787a7fe7c890f MD5 | raw file

 1add jar ${system:build.dir}/hive-contrib-${system:hive.version}.jar;
 2
 3CREATE TEMPORARY FUNCTION example_group_concat AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleGroupConcat';
 4
 5EXPLAIN
 6SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")")
 7FROM src
 8GROUP BY substr(value,5,1);
 9
10SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")")
11FROM src
12GROUP BY substr(value,5,1);
13
14
15DROP TEMPORARY FUNCTION example_group_concat;