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

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

sessionize(long timeInSec, long thresholdInSec [, String subject])- Returns a UUID string of a session. SELECT

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

set_similarity(a,b) – Compute the Jaccard set similarity of two sketch sets. Platforms: WhereOS, Spark, Hive