zscore

zscore [WhereOS, SQL, Spark, Hive]

Class hivemall.ftvec.scaling.ZScoreUDF
Usage zscore(value, mean, stddev) - Returns a standard score (zscore)

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathString
Usage xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the XPath expression.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.Year
Usage year(date) - Returns the year component of the date/timestamp.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.ZipWith
Usage 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.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathLong
Usage 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.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathDouble
Usage 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.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathShort
Usage 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.

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_boolean

xpath_boolean [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathBoolean
Usage xpath_boolean(xml, xpath) - Returns true if the XPath expression evaluates to true, or if a matching node is found.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathDouble
Usage 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.

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 [WhereOS, SQL, Spark, Hive]

Class org.apache.spark.sql.catalyst.expressions.xml.XPathFloat
Usage 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.

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.