zscore

zscore(value, mean, stddev) – Returns a standard score (zscore) Platforms: WhereOS, Spark, Hive Class: hivemall.ftvec.scaling.ZScoreUDF

xpath_string

xpath_string(xml, xpath) – Returns the text contents of the first xml node that matches the

zip_with

zip_with(left, right, func) – Merges the two given arrays, element-wise, into a single array using

year

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

xpath_long

xpath_long(xml, xpath) – Returns a long integer value, or the value zero if no match

xpath_short

xpath_short(xml, xpath) – Returns a short integer value, or the value zero if no match