Get invited to our slack community and get started for free

SQL Functions

word_ngrams

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

write_to_graphite

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

weekday

weekday(date) – Returns the day of the week for date/timestamp (0 = Monday, 1 =

weekofyear

weekofyear(date) – Returns the week of the year of the given date. A week is

weight_voted_avg

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

vector_magnitude

Magnitude of a vector. Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.timeseries.VectorMagnitudeUDF More functions can be added