hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Angeles (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1027) Create UDFs for XPath expression evaluation
Date Tue, 05 Jan 2010 05:12:55 GMT
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
            Priority: Minor


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.


Mime
View raw message