PageRenderTime 45ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/create_genericudf.q

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

  1. EXPLAIN

    2. 

  2. CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate';

    3. 

  3. 

    4. 

  4. CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate';

    5. 

  5. 

    6. 

  6. CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING);

    7. 

  7. 

    8. 

  8. FROM src 

    9. 

  9. INSERT OVERWRITE TABLE dest1 

    10. 

  10. SELECT 

    11. 

  11.     test_translate('abc', 'a', 'b'),

    12. 

  12.     test_translate('abc', 'ab', 'bc'),

    13. 

  13.     test_translate(NULL, 'a', 'b'),

    14. 

  14.     test_translate('a', NULL, 'b'),

    15. 

  15.     test_translate('a', 'a', NULL),

    16. 

  16.     test_translate('abc', 'ab', 'b'),

    17. 

  17.     test_translate('abc', 'a', 'ab');

    18. 

  18. 

    19. 

  19. SELECT dest1.* FROM dest1 LIMIT 1;

    20. 

  20. 

    21. 

  21. DROP TEMPORARY FUNCTION test_translate;

    22. 

  22.