bin(expr) – Returns the string representation of the long value `expr` represented in binary. Platforms:

binarize_label(int/long positive, int/long negative, …) – Returns positive/negative records that are represented as (…, int

avg(expr) – Returns the mean calculated from values of a group. Platforms: WhereOS, Spark, Hive

base64(bin) – Converts the argument from a binary `bin` to a base 64 string. Platforms:

base91(BINARY bin) – Convert the argument from binary to a BASE91 string SELECT base91(deflate(‘aaaaaaaaaaaaaaaabbbbccc’)); AA+=kaIM|WTt!+wbGAA

atan2(exprY, exprX) – Returns the angle in radians between the positive x-axis of a plane