PageRenderTime 9ms CodeModel.GetById 1ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_xpath.q.out

#
text | 62 lines | 62 code | 0 blank | 0 comment | 0 complexity | a079eba67a9ead5e12f45780837a6548 MD5 | raw file
 1PREHOOK: query: DESCRIBE FUNCTION xpath
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION xpath
 4POSTHOOK: type: DESCFUNCTION
 5xpath(xml, xpath) - Returns a string array of values within xml nodes that match the xpath expression
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath
 9POSTHOOK: type: DESCFUNCTION
10xpath(xml, xpath) - Returns a string array of values within xml nodes that match the xpath expression
11Example:
12  > SELECT xpath('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/text()') FROM src LIMIT 1
13  []
14  > SELECT xpath('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/b/text()') FROM src LIMIT 1
15  ["b1","b2","b3"]
16  > 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
17  ["c1","c2"]
18PREHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/text()') FROM src LIMIT 1
19PREHOOK: type: QUERY
20PREHOOK: Input: default@src
21PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1416181007/10000
22POSTHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/text()') FROM src LIMIT 1
23POSTHOOK: type: QUERY
24POSTHOOK: Input: default@src
25POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1416181007/10000
26[]
27PREHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/*/text()') FROM src LIMIT 1
28PREHOOK: type: QUERY
29PREHOOK: Input: default@src
30PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1851591863/10000
31POSTHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/*/text()') FROM src LIMIT 1
32POSTHOOK: type: QUERY
33POSTHOOK: Input: default@src
34POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1851591863/10000
35["b1","b2","b3","c1","c2"]
36PREHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/b/text()') FROM src LIMIT 1
37PREHOOK: type: QUERY
38PREHOOK: Input: default@src
39PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/113811557/10000
40POSTHOOK: query: SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/b/text()') FROM src LIMIT 1
41POSTHOOK: type: QUERY
42POSTHOOK: Input: default@src
43POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/113811557/10000
44["b1","b2","b3"]
45PREHOOK: query: 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
46PREHOOK: type: QUERY
47PREHOOK: Input: default@src
48PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1674548693/10000
49POSTHOOK: query: 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
50POSTHOOK: type: QUERY
51POSTHOOK: Input: default@src
52POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1674548693/10000
53["c1","c2"]
54PREHOOK: query: SELECT xpath ('<a><b class="bb">b1</b><b>b2</b><b>b3</b><c class="bb">c1</c><c>c2</c></a>', 'a/*[@class="bb"]/text()') FROM src LIMIT 1
55PREHOOK: type: QUERY
56PREHOOK: Input: default@src
57PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/378718949/10000
58POSTHOOK: query: SELECT xpath ('<a><b class="bb">b1</b><b>b2</b><b>b3</b><c class="bb">c1</c><c>c2</c></a>', 'a/*[@class="bb"]/text()') FROM src LIMIT 1
59POSTHOOK: type: QUERY
60POSTHOOK: Input: default@src
61POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/378718949/10000
62["b1","c1"]