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