/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 

    

  1. add jar ${system:build.dir}/hive-contrib-${system:hive.version}.jar;
    2. 

  2. 

    3. 

  3. CREATE TEMPORARY FUNCTION example_group_concat AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleGroupConcat';

    4. 

  4. 

    5. 

  5. EXPLAIN

    6. 

  6. SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")")

    7. 

  7. FROM src

    8. 

  8. GROUP BY substr(value,5,1);

    9. 

  9. 

    10. 

  10. SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")")

    11. 

  11. FROM src

    12. 

  12. GROUP BY substr(value,5,1);

    13. 

  13. 

    14. 

  14. 

    15. 

  15. DROP TEMPORARY FUNCTION example_group_concat;
    16.