Blog

if(expr1, expr2, expr3) – If `expr1` evaluates to true, then returns `expr2`; otherwise returns `expr3`.

ifnull(expr1, expr2) – Returns `expr2` if `expr1` is null, or `expr1` otherwise. Platforms: WhereOS, Spark,

hll_est_cardinality(x) – Estimate reach from a HyperLogLog++. Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.hll.EstimateCardinalityUDF More functions

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

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