SQL Functions

xpath_int(xml, xpath) – Returns an integer value, or the value zero if no match is

This function writes metrics to the TSDB (metics names should look like proc.loadavg.1min, http.hits while

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

xpath(xml, xpath) – Returns a string array of values within the nodes of xml that

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

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