Date and Time functions
Year, Quarter, Month, WeekOfYear, Week, DayOfMonth, Day, Hour, Minute, Second, DateDiff, Date_Add, Date_sub, To_date, From_utc_timestamp, To_utc_timestamp,
Conversion functions
SN
Math functions
Abs, ACos, ASin, Bin, Hex, Conv, Ceil, Ceiling, Cos, Degrees, E, Exp, Floor, Ln, Log, Log10, Log2, Negative, Pi, Radians, Sign, Sin, Sqrt, Tan, Atan, Pow, Power, Pmod, Positive, Rand, Round,
Operators
%, +, -, *, /
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Variance, Var_Pop, Var_Samp, StdDev_Pop, StdDev_Samp, Covar_pop, Covar_samp, Corr, Percentile
Text functions
ASCII, Concat, Concat_ws, Find_in_set, Get_json_object, Instr, Length, Locate, Lower, Lcase, LPad, Parse_url, RPad, Rtrim, Trim, LTrim, Regexp_extract, Regexp_replace, Repeat, Space, Reverse, Translate, Upper, Ucase