hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nzh...@apache.org
Subject svn commit: r923070 [2/2] - in /hadoop/hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/udf/xml/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Mon, 15 Mar 2010 06:09:31 GMT
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out?rev=923070&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out Mon Mar 15
06:09:30 2010
@@ -0,0 +1,91 @@
+PREHOOK: query: DESCRIBE FUNCTION xpath_string
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION xpath_string
+POSTHOOK: type: DESCFUNCTION
+xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the
xpath expression
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
+POSTHOOK: type: DESCFUNCTION
+xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the
xpath expression
+Example:
+  > SELECT xpath_string('<a><b>b</b><c>cc</c></a>','a/c')
FROM src LIMIT 1;
+  'cc'
+  > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a/b')
FROM src LIMIT 1;
+  'b1'
+  > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a/b[2]')
FROM src LIMIT 1;
+  'b2'
+  > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a')
FROM src LIMIT 1;
+  'b1b2'
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
+bbcc
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/b') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/b') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
+bb
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/c') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/c') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
+cc
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/d') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>',
'a/d') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
+
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'//b') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'//b') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
+b1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'a/b[1]') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'a/b[1]') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
+b1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'a/b[2]') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>',
'a/b[2]') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
+b2
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>',
'a/b[@id="b_2"]') FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>',
'a/b[@id="b_2"]') FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
+b2



Mime
View raw message