PageRenderTime 54ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_conv.q.out

#
text | 190 lines | 186 code | 4 blank | 0 comment | 0 complexity | 00a8dc64288b911c4f02ff3efe61c662 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: DESCRIBE FUNCTION conv
  2. PREHOOK: type: DESCFUNCTION
  3. POSTHOOK: query: DESCRIBE FUNCTION conv
  4. POSTHOOK: type: DESCFUNCTION
  5. conv(num, from_base, to_base) - convert num from from_base to to_base
  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED conv
  7. PREHOOK: type: DESCFUNCTION
  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED conv
  9. POSTHOOK: type: DESCFUNCTION
  10. conv(num, from_base, to_base) - convert num from from_base to to_base
  11. If to_base is negative, treat num as a signed integer,otherwise, treat it as an unsigned integer.
  12. Example:
  13. > SELECT conv('100', 2, 10) FROM src LIMIT 1;
  14. '4'
  15. > SELECT conv(-10, 16, -10) FROM src LIMIT 1;
  16. '16'
  17. PREHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
  18. -- Some simple conversions to test different bases
  19. SELECT
  20. conv('4521', 10, 36),
  21. conv('22', 10, 10),
  22. conv('110011', 2, 16),
  23. conv('facebook', 36, 16)
  24. FROM src LIMIT 1
  25. PREHOOK: type: QUERY
  26. PREHOOK: Input: default@src
  27. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
  28. POSTHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
  29. -- Some simple conversions to test different bases
  30. SELECT
  31. conv('4521', 10, 36),
  32. conv('22', 10, 10),
  33. conv('110011', 2, 16),
  34. conv('facebook', 36, 16)
  35. FROM src LIMIT 1
  36. POSTHOOK: type: QUERY
  37. POSTHOOK: Input: default@src
  38. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
  39. 3HL 22 33 116ED2B2FB4
  40. PREHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
  41. -- as a two's complement (64-bit)
  42. SELECT
  43. conv('-641', 10, -10),
  44. conv('1011', 2, -16),
  45. conv('-1', 10, 16),
  46. conv('-15', 10, 16)
  47. FROM src LIMIT 1
  48. PREHOOK: type: QUERY
  49. PREHOOK: Input: default@src
  50. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
  51. POSTHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
  52. -- as a two's complement (64-bit)
  53. SELECT
  54. conv('-641', 10, -10),
  55. conv('1011', 2, -16),
  56. conv('-1', 10, 16),
  57. conv('-15', 10, 16)
  58. FROM src LIMIT 1
  59. POSTHOOK: type: QUERY
  60. POSTHOOK: Input: default@src
  61. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
  62. -641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
  63. PREHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
  64. -- or MAX_LONG (if unsigned)
  65. SELECT
  66. conv('9223372036854775807', 36, 16),
  67. conv('9223372036854775807', 36, -16),
  68. conv('-9223372036854775807', 36, 16),
  69. conv('-9223372036854775807', 36, -16)
  70. FROM src LIMIT 1
  71. PREHOOK: type: QUERY
  72. PREHOOK: Input: default@src
  73. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
  74. POSTHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
  75. -- or MAX_LONG (if unsigned)
  76. SELECT
  77. conv('9223372036854775807', 36, 16),
  78. conv('9223372036854775807', 36, -16),
  79. conv('-9223372036854775807', 36, 16),
  80. conv('-9223372036854775807', 36, -16)
  81. FROM src LIMIT 1
  82. POSTHOOK: type: QUERY
  83. POSTHOOK: Input: default@src
  84. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
  85. FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
  86. PREHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
  87. -- be NULL. If there is an invalid digit in the number, the longest valid
  88. -- prefix should be converted.
  89. SELECT
  90. conv('123455', 3, 10),
  91. conv('131', 1, 5),
  92. conv('515', 5, 100),
  93. conv('10', -2, 2)
  94. FROM src LIMIT 1
  95. PREHOOK: type: QUERY
  96. PREHOOK: Input: default@src
  97. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/10000
  98. POSTHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
  99. -- be NULL. If there is an invalid digit in the number, the longest valid
  100. -- prefix should be converted.
  101. SELECT
  102. conv('123455', 3, 10),
  103. conv('131', 1, 5),
  104. conv('515', 5, 100),
  105. conv('10', -2, 2)
  106. FROM src LIMIT 1
  107. POSTHOOK: type: QUERY
  108. POSTHOOK: Input: default@src
  109. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/10000
  110. 5 NULL NULL NULL
  111. PREHOOK: query: -- Perform the same tests with number arguments.
  112. SELECT
  113. conv(4521, 10, 36),
  114. conv(22, 10, 10),
  115. conv(110011, 2, 16)
  116. FROM src LIMIT 1
  117. PREHOOK: type: QUERY
  118. PREHOOK: Input: default@src
  119. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
  120. POSTHOOK: query: -- Perform the same tests with number arguments.
  121. SELECT
  122. conv(4521, 10, 36),
  123. conv(22, 10, 10),
  124. conv(110011, 2, 16)
  125. FROM src LIMIT 1
  126. POSTHOOK: type: QUERY
  127. POSTHOOK: Input: default@src
  128. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
  129. 3HL 22 33
  130. PREHOOK: query: SELECT
  131. conv(-641, 10, -10),
  132. conv(1011, 2, -16),
  133. conv(-1, 10, 16),
  134. conv(-15, 10, 16)
  135. FROM src LIMIT 1
  136. PREHOOK: type: QUERY
  137. PREHOOK: Input: default@src
  138. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
  139. POSTHOOK: query: SELECT
  140. conv(-641, 10, -10),
  141. conv(1011, 2, -16),
  142. conv(-1, 10, 16),
  143. conv(-15, 10, 16)
  144. FROM src LIMIT 1
  145. POSTHOOK: type: QUERY
  146. POSTHOOK: Input: default@src
  147. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
  148. -641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
  149. PREHOOK: query: SELECT
  150. conv(9223372036854775807, 36, 16),
  151. conv(9223372036854775807, 36, -16),
  152. conv(-9223372036854775807, 36, 16),
  153. conv(-9223372036854775807, 36, -16)
  154. FROM src LIMIT 1
  155. PREHOOK: type: QUERY
  156. PREHOOK: Input: default@src
  157. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
  158. POSTHOOK: query: SELECT
  159. conv(9223372036854775807, 36, 16),
  160. conv(9223372036854775807, 36, -16),
  161. conv(-9223372036854775807, 36, 16),
  162. conv(-9223372036854775807, 36, -16)
  163. FROM src LIMIT 1
  164. POSTHOOK: type: QUERY
  165. POSTHOOK: Input: default@src
  166. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
  167. FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
  168. PREHOOK: query: SELECT
  169. conv(123455, 3, 10),
  170. conv(131, 1, 5),
  171. conv(515, 5, 100),
  172. conv('10', -2, 2)
  173. FROM src LIMIT 1
  174. PREHOOK: type: QUERY
  175. PREHOOK: Input: default@src
  176. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/10000
  177. POSTHOOK: query: SELECT
  178. conv(123455, 3, 10),
  179. conv(131, 1, 5),
  180. conv(515, 5, 100),
  181. conv('10', -2, 2)
  182. FROM src LIMIT 1
  183. POSTHOOK: type: QUERY
  184. POSTHOOK: Input: default@src
  185. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/10000
  186. 5 NULL NULL NULL