x_rank(KEY) – Generates a pseudo sequence number starting from 1 for each key Platforms: WhereOS,

CASE WHEN expr1 THEN expr2 [WHEN expr3 THEN expr4]* [ELSE expr5] END – When `expr1`

Writes metric or collection of metrics to graphite.write_to_graphite(String hostname, int port, Map nameToValue, Long timestampInSeconds)

word_ngrams(array words, int minSize, int maxSize]) – Returns list of n-grams for given words, where

Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.TimeWindow More functions can be added to WhereOS via Python

weight_voted_avg(expr) – Returns an averaged value by considering sum of positive/negative weights Platforms: WhereOS, Spark,