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

shiftrightunsigned(base, expr) – Bitwise unsigned right shift. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.ShiftRightUnsigned More functions

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

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

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

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