Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.PermutationUDTF More functions can be added to WhereOS via Python
expr1 or expr2 – Logical OR. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Or More functions can
parse_url(url, partToExtract[, key]) – Extracts a part from a URL. Platforms: WhereOS, Spark, Hive Class:
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: