Blog

multiday_count(x) – Returns a count of events over several different periods, Platforms: WhereOS, Spark, Hive

named_struct(name1, val1, name2, val2, …) – Creates a struct with the given field names and

month(date) – Returns the month component of the date/timestamp. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Month

months_between(timestamp1, timestamp2[, roundOff]) – If `timestamp1` is later than `timestamp2`, then the result is positive.

return the moving average of a time series for a given timewindow Platforms: WhereOS, Spark,

minkowski_distance(list x, list y, double p) – Returns sum(|x – y|^p)^(1/p) WITH docs as (