sha2
sha2(expr, bitLength) – Returns a checksum of SHA-2 family as a hex string of `expr`.
shiftleft
shiftleft(base, expr) – Bitwise left shift. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.ShiftLeft More functions can
sessionize
sessionize(long timeInSec, long thresholdInSec [, String subject])- Returns a UUID string of a session. SELECT
set_difference
set_difference(a,b) – Returns a list of those items in a, but not in b Platforms:
set_similarity
set_similarity(a,b) – Compute the Jaccard set similarity of two sketch sets. Platforms: WhereOS, Spark, Hive
sha
sha(expr) – Returns a sha1 hash value as a hex string of the `expr`. Platforms:
