[ https://issues.apache.org/jira/browse/HIVE-1027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Angeles updated HIVE-1027: ---------------------------------- Attachment: hive-1027-v3.patch Cleaned up patch. The Eclipse code cleanup hook generated by 'ant eclipse-files' was automatically removing casts. This seems to only affect the build for version 0.17.2.1 > Create UDFs for XPath expression evaluation > ------------------------------------------- > > Key: HIVE-1027 > URL: https://issues.apache.org/jira/browse/HIVE-1027 > Project: Hadoop Hive > Issue Type: New Feature > Components: Query Processor > Reporter: Patrick Angeles > Assignee: Patrick Angeles > Priority: Minor > Fix For: 0.6.0 > > Attachments: hive-1027-v2.patch, hive-1027-v3.patch, hive-1027.patch, > udf_xpath.patch > > > Create UDFs for evaluating XPath expressions against XML documents. > Examples: > > SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b > > class="odd">4</b><c>8</c></a>', 'sum(a/b...@class="odd"])') FROM src LIMIT > > 1 ; > 5.0 > > SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT > > 1 ; > b2 > > SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', > > 'a/c/text()') FROM src LIMIT 1 ; > ["c1","c2"] > Included functions are: xpath_short, xpath_int, xpath_long, xpath_float, > xpath_double/xpath_number, xpath_string, xpath -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.