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
Binning is not supported by this connector.
See also:
Details on Apache Spark SQL Connection