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

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

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