Blog

shuffle(array) – Returns a random permutation of the given array. Platforms: WhereOS, Spark, Hive Class:

sigmoid(x) – Returns 1.0 / (1.0 + exp(-x)) WITH input as ( SELECT 3.0 as

sha1(expr) – Returns a sha1 hash value as a hex string of the `expr`. Platforms:

sha2(expr, bitLength) – Returns a checksum of SHA-2 family as a hex string of `expr`.

shiftleft(base, expr) – Bitwise left shift. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.ShiftLeft More functions can

set_difference(a,b) – Returns a list of those items in a, but not in b Platforms: