/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

  1. DESCRIBE FUNCTION elt;
  2. DESCRIBE FUNCTION EXTENDED elt;
  3. EXPLAIN
  4. SELECT elt(2, 'abc', 'defg'),
  5. elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
  6. elt('1', 'abc', 'defg'),
  7. elt(2, 'aa', CAST('2' AS TINYINT)),
  8. elt(2, 'aa', CAST('12345' AS SMALLINT)),
  9. elt(2, 'aa', CAST('123456789012' AS BIGINT)),
  10. elt(2, 'aa', CAST(1.25 AS FLOAT)),
  11. elt(2, 'aa', CAST(16.0 AS DOUBLE)),
  12. elt(null, 'abc', 'defg'),
  13. elt(0, 'abc', 'defg'),
  14. elt(3, 'abc', 'defg')
  15. FROM src LIMIT 1;
  16. SELECT elt(2, 'abc', 'defg'),
  17. elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
  18. elt('1', 'abc', 'defg'),
  19. elt(2, 'aa', CAST('2' AS TINYINT)),
  20. elt(2, 'aa', CAST('12345' AS SMALLINT)),
  21. elt(2, 'aa', CAST('123456789012' AS BIGINT)),
  22. elt(2, 'aa', CAST(1.25 AS FLOAT)),
  23. elt(2, 'aa', CAST(16.0 AS DOUBLE)),
  24. elt(null, 'abc', 'defg'),
  25. elt(0, 'abc', 'defg'),
  26. elt(3, 'abc', 'defg')
  27. FROM src LIMIT 1;