Blog

collect_max(x, val, n) – Returns an map of the max N numeric values in the

collect_set(expr) – Collects and returns a set of unique elements. Platforms: WhereOS, Spark, Hive Class:

chi2(array observed, array expected) – Returns chi2_val and p_val of each columns as Platforms: WhereOS,

chr(expr) – Returns the ASCII character having the binary equivalent to `expr`. If n is

coalesce(expr1, expr2, …) – Returns the first non-null argument if exists. Otherwise, null. Platforms: WhereOS,

char_length(expr) – Returns the character length of string data or number of bytes of binary