Blog

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

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

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

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

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

xpath_number(xml, xpath) – Returns a double value, the value zero if no match is found,