Blog

percent_rank() – Computes the percentage ranking of a value in a group of values. Platforms:

nvl(expr1, expr2) – Returns `expr2` if `expr1` is null, or `expr1` otherwise. Platforms: WhereOS, Spark,

nvl2(expr1, expr2, expr3) – Returns `expr2` if `expr1` is not null, or `expr3` otherwise. Platforms:

octet_length(expr) – Returns the byte length of string data or number of bytes of binary

onehot_encoding(PRIMITIVE feature, …) – Compute onehot encoded label for each feature WITH mapping as (

ntile(n) – Divides the rows for each window partition into `n` buckets ranging from 1