PageRenderTime 41ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/contrib/src/test/queries/clientpositive/udaf_example_max_n.q

#
text | 14 lines | 10 code | 4 blank | 0 comment | 0 complexity | 16cf33d5ee8c1d47553dc0437a026821 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

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

  2. 

    3. 

  3. CREATE TEMPORARY FUNCTION example_max_n AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleMaxN';

    4. 

  4. 

    5. 

  5. EXPLAIN

    6. 

  6. SELECT example_max_n(substr(value,5),10),

    7. 

  7.        example_max_n(IF(substr(value,5) > 250, NULL, substr(value,5)),10)

    8. 

  8. FROM src;

    9. 

  9. 

    10. 

  10. SELECT example_max_n(substr(value,5),10),

    11. 

  11.        example_max_n(IF(substr(value,5) > 250, NULL, substr(value,5)),10)

    12. 

  12. FROM src;

    13. 

  13. 

    14. 

  14. DROP TEMPORARY FUNCTION example_max_n;

    15. 

  15.