PageRenderTime 52ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 29 lines | 27 code | 2 blank | 0 comment | 0 complexity | a34d1f8645912802d4460a8cac212dbf MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. DESCRIBE FUNCTION elt;
    2. 

  2. DESCRIBE FUNCTION EXTENDED elt;
    3. 

  3. 

  4. EXPLAIN
    5. 

  5. SELECT elt(2, 'abc', 'defg'),
    6. 

  6.        elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
    7. 

  7.        elt('1', 'abc', 'defg'),
    8. 

  8.        elt(2, 'aa', CAST('2' AS TINYINT)),
    9. 

  9.        elt(2, 'aa', CAST('12345' AS SMALLINT)),
    10. 

  10.        elt(2, 'aa', CAST('123456789012' AS BIGINT)),
    11. 

  11.        elt(2, 'aa', CAST(1.25 AS FLOAT)),
    12. 

  12.        elt(2, 'aa', CAST(16.0 AS DOUBLE)),
    13. 

  13.        elt(null, 'abc', 'defg'),
    14. 

  14.        elt(0, 'abc', 'defg'),
    15. 

  15.        elt(3, 'abc', 'defg')
    16. 

  16. FROM src LIMIT 1;
    17. 

  17. 

  18. SELECT elt(2, 'abc', 'defg'),
    19. 

  19.        elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
    20. 

  20.        elt('1', 'abc', 'defg'),
    21. 

  21.        elt(2, 'aa', CAST('2' AS TINYINT)),
    22. 

  22.        elt(2, 'aa', CAST('12345' AS SMALLINT)),
    23. 

  23.        elt(2, 'aa', CAST('123456789012' AS BIGINT)),
    24. 

  24.        elt(2, 'aa', CAST(1.25 AS FLOAT)),
    25. 

  25.        elt(2, 'aa', CAST(16.0 AS DOUBLE)),
    26. 

  26.        elt(null, 'abc', 'defg'),
    27. 

  27.        elt(0, 'abc', 'defg'),
    28. 

  28.        elt(3, 'abc', 'defg')
    29. 

  29. FROM src LIMIT 1;
    30. 

  30.