permutations

Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.PermutationUDTF More functions can be added to WhereOS via Python

percent_rank

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

or

expr1 or expr2 – Logical OR. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Or More functions can

parse_url

parse_url(url, partToExtract[, key]) – Extracts a part from a URL. Platforms: WhereOS, Spark, Hive Class:

nvl

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

nvl2

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