/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
- PREHOOK: query: SHOW FUNCTIONS
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS
- POSTHOOK: type: SHOWFUNCTIONS
- !
- !=
- %
- &
- *
- +
- -
- /
- <
- <=
- <>
- =
- ==
- >
- >=
- ^
- abs
- acos
- and
- array
- array_contains
- ascii
- asin
- atan
- avg
- bigint
- bin
- boolean
- case
- ceil
- ceiling
- coalesce
- collect_set
- concat
- concat_ws
- context_ngrams
- conv
- corr
- cos
- count
- covar_pop
- covar_samp
- create_union
- date_add
- date_sub
- datediff
- day
- dayofmonth
- degrees
- div
- double
- e
- elt
- exp
- explode
- field
- find_in_set
- float
- floor
- from_unixtime
- get_json_object
- hash
- hex
- histogram_numeric
- hour
- if
- in
- index
- instr
- int
- isnotnull
- isnull
- json_tuple
- lcase
- length
- like
- ln
- locate
- log
- log10
- log2
- lower
- lpad
- ltrim
- map
- max
- min
- minute
- month
- negative
- ngrams
- not
- or
- parse_url
- parse_url_tuple
- percentile
- percentile_approx
- pi
- pmod
- positive
- pow
- power
- radians
- rand
- reflect
- regexp
- regexp_extract
- regexp_replace
- repeat
- reverse
- rlike
- round
- rpad
- rtrim
- second
- sentences
- sign
- sin
- size
- smallint
- space
- split
- sqrt
- std
- stddev
- stddev_pop
- stddev_samp
- str_to_map
- string
- struct
- substr
- substring
- sum
- tan
- tinyint
- to_date
- trim
- ucase
- unhex
- unix_timestamp
- upper
- var_pop
- var_samp
- variance
- weekofyear
- when
- xpath
- xpath_boolean
- xpath_double
- xpath_float
- xpath_int
- xpath_long
- xpath_number
- xpath_short
- xpath_string
- year
- |
- ~
- PREHOOK: query: SHOW FUNCTIONS '^c.*'
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS '^c.*'
- POSTHOOK: type: SHOWFUNCTIONS
- case
- ceil
- ceiling
- coalesce
- collect_set
- concat
- concat_ws
- context_ngrams
- conv
- corr
- cos
- count
- covar_pop
- covar_samp
- create_union
- PREHOOK: query: SHOW FUNCTIONS '.*e$'
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS '.*e$'
- POSTHOOK: type: SHOWFUNCTIONS
- case
- coalesce
- double
- e
- explode
- from_unixtime
- json_tuple
- lcase
- like
- locate
- minute
- negative
- parse_url_tuple
- percentile
- positive
- regexp_replace
- reverse
- rlike
- size
- space
- to_date
- ucase
- variance
- xpath_double
- PREHOOK: query: SHOW FUNCTIONS 'log.*'
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS 'log.*'
- POSTHOOK: type: SHOWFUNCTIONS
- log
- log10
- log2
- PREHOOK: query: SHOW FUNCTIONS '.*date.*'
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS '.*date.*'
- POSTHOOK: type: SHOWFUNCTIONS
- date_add
- date_sub
- datediff
- to_date
- PREHOOK: query: SHOW FUNCTIONS '***'
- PREHOOK: type: SHOWFUNCTIONS
- POSTHOOK: query: SHOW FUNCTIONS '***'
- POSTHOOK: type: SHOWFUNCTIONS