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

# · text · 228 lines · 228 code · 0 blank · 0 comment · 0 complexity · b924a306f61aaa9b942fca2bfbb9451f MD5 · raw file

  1. PREHOOK: query: SHOW FUNCTIONS
  2. PREHOOK: type: SHOWFUNCTIONS
  3. POSTHOOK: query: SHOW FUNCTIONS
  4. POSTHOOK: type: SHOWFUNCTIONS
  5. !
  6. !=
  7. %
  8. &
  9. *
  10. +
  11. -
  12. /
  13. <
  14. <=
  15. <>
  16. =
  17. ==
  18. >
  19. >=
  20. ^
  21. abs
  22. acos
  23. and
  24. array
  25. array_contains
  26. ascii
  27. asin
  28. atan
  29. avg
  30. bigint
  31. bin
  32. boolean
  33. case
  34. ceil
  35. ceiling
  36. coalesce
  37. collect_set
  38. concat
  39. concat_ws
  40. context_ngrams
  41. conv
  42. corr
  43. cos
  44. count
  45. covar_pop
  46. covar_samp
  47. create_union
  48. date_add
  49. date_sub
  50. datediff
  51. day
  52. dayofmonth
  53. degrees
  54. div
  55. double
  56. e
  57. elt
  58. exp
  59. explode
  60. field
  61. find_in_set
  62. float
  63. floor
  64. from_unixtime
  65. get_json_object
  66. hash
  67. hex
  68. histogram_numeric
  69. hour
  70. if
  71. in
  72. index
  73. instr
  74. int
  75. isnotnull
  76. isnull
  77. json_tuple
  78. lcase
  79. length
  80. like
  81. ln
  82. locate
  83. log
  84. log10
  85. log2
  86. lower
  87. lpad
  88. ltrim
  89. map
  90. max
  91. min
  92. minute
  93. month
  94. negative
  95. ngrams
  96. not
  97. or
  98. parse_url
  99. parse_url_tuple
  100. percentile
  101. percentile_approx
  102. pi
  103. pmod
  104. positive
  105. pow
  106. power
  107. radians
  108. rand
  109. reflect
  110. regexp
  111. regexp_extract
  112. regexp_replace
  113. repeat
  114. reverse
  115. rlike
  116. round
  117. rpad
  118. rtrim
  119. second
  120. sentences
  121. sign
  122. sin
  123. size
  124. smallint
  125. space
  126. split
  127. sqrt
  128. std
  129. stddev
  130. stddev_pop
  131. stddev_samp
  132. str_to_map
  133. string
  134. struct
  135. substr
  136. substring
  137. sum
  138. tan
  139. tinyint
  140. to_date
  141. trim
  142. ucase
  143. unhex
  144. unix_timestamp
  145. upper
  146. var_pop
  147. var_samp
  148. variance
  149. weekofyear
  150. when
  151. xpath
  152. xpath_boolean
  153. xpath_double
  154. xpath_float
  155. xpath_int
  156. xpath_long
  157. xpath_number
  158. xpath_short
  159. xpath_string
  160. year
  161. |
  162. ~
  163. PREHOOK: query: SHOW FUNCTIONS '^c.*'
  164. PREHOOK: type: SHOWFUNCTIONS
  165. POSTHOOK: query: SHOW FUNCTIONS '^c.*'
  166. POSTHOOK: type: SHOWFUNCTIONS
  167. case
  168. ceil
  169. ceiling
  170. coalesce
  171. collect_set
  172. concat
  173. concat_ws
  174. context_ngrams
  175. conv
  176. corr
  177. cos
  178. count
  179. covar_pop
  180. covar_samp
  181. create_union
  182. PREHOOK: query: SHOW FUNCTIONS '.*e$'
  183. PREHOOK: type: SHOWFUNCTIONS
  184. POSTHOOK: query: SHOW FUNCTIONS '.*e$'
  185. POSTHOOK: type: SHOWFUNCTIONS
  186. case
  187. coalesce
  188. double
  189. e
  190. explode
  191. from_unixtime
  192. json_tuple
  193. lcase
  194. like
  195. locate
  196. minute
  197. negative
  198. parse_url_tuple
  199. percentile
  200. positive
  201. regexp_replace
  202. reverse
  203. rlike
  204. size
  205. space
  206. to_date
  207. ucase
  208. variance
  209. xpath_double
  210. PREHOOK: query: SHOW FUNCTIONS 'log.*'
  211. PREHOOK: type: SHOWFUNCTIONS
  212. POSTHOOK: query: SHOW FUNCTIONS 'log.*'
  213. POSTHOOK: type: SHOWFUNCTIONS
  214. log
  215. log10
  216. log2
  217. PREHOOK: query: SHOW FUNCTIONS '.*date.*'
  218. PREHOOK: type: SHOWFUNCTIONS
  219. POSTHOOK: query: SHOW FUNCTIONS '.*date.*'
  220. POSTHOOK: type: SHOWFUNCTIONS
  221. date_add
  222. date_sub
  223. datediff
  224. to_date
  225. PREHOOK: query: SHOW FUNCTIONS '***'
  226. PREHOOK: type: SHOWFUNCTIONS
  227. POSTHOOK: query: SHOW FUNCTIONS '***'
  228. POSTHOOK: type: SHOWFUNCTIONS