hour(timestamp) – Returns the hour component of the string/timestamp. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Hour

hyperloglog(x, [b]) – Constructs a HyperLogLog++ estimator to estimate reach for large values, with optional

hex(expr) – Converts `expr` to hexadecimal. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Hex More functions can

hitrate(array rankItems, array correctItems [, const int recommendSize = rankItems.size]) – Returns HitRate Platforms: WhereOS,

hivemall_version() – Returns the version of Hivemall SELECT hivemall_version(); Platforms: WhereOS, Spark, Hive Class: hivemall.HivemallVersionUDF

hbase_batch_put(config_map, key, value) – Perform batch HBase updates of a table Platforms: WhereOS, Spark, Hive