avg

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

base64

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

base91

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

atan

atan(expr) – Returns the inverse tangent (a.k.a. arc tangent) of `expr`, as if computed by

atan2

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

auc

auc(array rankItems | double score, array correctItems | int label [, const int recommendSize =