函数和运算符

• 关系运算符

  <, <=, <=>, <>, =, ==, >, >=, isnull, isnotnull, like, rlike, regexp

• 算术运算符

  +, -, *, /, %, &, |, ^, ~

• 逻辑运算符

  AND, OR, |, NOT, !, IN, NOT IN, [NOT] EXISTS

• 数学函数

  round, floor, ceil, rand, exp, ln, log10, log2, log, pow, power, sqrt, bin, hex, unhex,conv, num, intto_base, intfrom_base, abs, pmond, sin, asin, cos, acos, positive, negative, sigh, pi, degrees, radians, tan, atan, e

• 日期函数

  add_months, extract, from_unixtime, to_unix_timestamp, unix_timestamp, to_timestamp, to_date, tdh_todate, day, dayofmonth, dayofyear, quater, hour, minute, second, weekofyear, datediff, date_add, date_sub, date_format, str_to_date, sysdate

• 条件函数

  If, coalesce, CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END, CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END

• 字符串函数

  ascii, base64, concat, context_ngrams, concat_ws, concat_ws, encode, find_in_set, format_number, get_json_object, in_file, instr, length, locate, lower, lcase, lpad, ltrim, ngrams, parse_url, printf, regexp_extract, regexp_replace, repeat, reverse, rpad, rtrim, sentences, space, split, str_to_map, substr, substring, translate, trim, unbase64, upper, ucase, chr, oracle_instr, to_number, trunk, to_char, to_semiangle, nvl, decode, greatest, lnnvl, nvl2, rangedecode

• 复杂类型函数

  map,struct,named_struct,array

• 表生成函数

  explode, inline, json_tuple, parse_url_tuple, stack

• 窗口函数

  sum, max, min, count, avg, first_value, last_value, lag, lead, row_number, rank, dense_rank, ntile, cume_dist, percent_rank