zscore


zscore(value, mean, stddev) – Returns a standard score (zscore)

Platforms: WhereOS, Spark, Hive
Class: hivemall.ftvec.scaling.ZScoreUDF

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

zip_with


zip_with(left, right, func) – Merges the two given arrays, element-wise, into a single array using function. If one array is shorter, nulls are appended at the end to match the length of the longer array, before applying function.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.ZipWith

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

year


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

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_string


xpath_string(xml, xpath) – Returns the text contents of the first xml node that matches the XPath expression.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathString

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_short


xpath_short(xml, xpath) – Returns a short integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathShort

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_number


xpath_number(xml, xpath) – Returns a double value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathDouble

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_long


xpath_long(xml, xpath) – Returns a long integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathLong

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_int


xpath_int(xml, xpath) – Returns an integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathInt

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_float


xpath_float(xml, xpath) – Returns a float value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathFloat

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.

xpath_double


xpath_double(xml, xpath) – Returns a double value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Platforms: WhereOS, Spark, Hive
Class: org.apache.spark.sql.catalyst.expressions.xml.XPathDouble

More functions can be added to WhereOS via Python or R bindings or as Java & Scala UDF (user-defined function), UDAF (user-defined aggregation function) and UDTF (user-defined table generating function) extensions. Custom libraries can be added on via Settings-page or installed from WhereOS Store.