PageRenderTime 16ms CodeModel.GetById 14ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_xpath_int.q.out

#
text | 85 lines | 85 code | 0 blank | 0 comment | 0 complexity | 9fd8e66b183f79adf70839e554108fcc MD5 | raw file
 1PREHOOK: query: DESCRIBE FUNCTION xpath_int
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION xpath_int
 4POSTHOOK: type: DESCFUNCTION
 5xpath_int(xml, xpath) - Returns an integer value that matches the xpath expression
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_int
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_int
 9POSTHOOK: type: DESCFUNCTION
10xpath_int(xml, xpath) - Returns an integer value that matches the xpath expression
11Example:
12  > SELECT xpath_int('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
13  3
14PREHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
15PREHOOK: type: QUERY
16PREHOOK: Input: default@src
17PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-51_875_437569805026140503/10000
18POSTHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
19POSTHOOK: type: QUERY
20POSTHOOK: Input: default@src
21POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-51_875_437569805026140503/10000
220
23PREHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
24PREHOOK: type: QUERY
25PREHOOK: Input: default@src
26PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-57_094_9168946979271622158/10000
27POSTHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
28POSTHOOK: type: QUERY
29POSTHOOK: Input: default@src
30POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-57_094_9168946979271622158/10000
310
32PREHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
33PREHOOK: type: QUERY
34PREHOOK: Input: default@src
35PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-01_568_5764046814540785002/10000
36POSTHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
37POSTHOOK: type: QUERY
38POSTHOOK: Input: default@src
39POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-01_568_5764046814540785002/10000
402147483647
41PREHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
42PREHOOK: type: QUERY
43PREHOOK: Input: default@src
44PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-06_220_6973728860376107951/10000
45POSTHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
46POSTHOOK: type: QUERY
47POSTHOOK: Input: default@src
48POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-06_220_6973728860376107951/10000
490
50PREHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1
51PREHOOK: type: QUERY
52PREHOOK: Input: default@src
53PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-10_880_7033077055949838171/10000
54POSTHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1
55POSTHOOK: type: QUERY
56POSTHOOK: Input: default@src
57POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-10_880_7033077055949838171/10000
581
59PREHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1
60PREHOOK: type: QUERY
61PREHOOK: Input: default@src
62PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-15_676_4494502415099433177/10000
63POSTHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1
64POSTHOOK: type: QUERY
65POSTHOOK: Input: default@src
66POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-15_676_4494502415099433177/10000
6715
68PREHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1
69PREHOOK: type: QUERY
70PREHOOK: Input: default@src
71PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-22_229_1539908466202895730/10000
72POSTHOOK: query: SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1
73POSTHOOK: type: QUERY
74POSTHOOK: Input: default@src
75POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-22_229_1539908466202895730/10000
767
77PREHOOK: query: SELECT xpath_int ('<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
78PREHOOK: type: QUERY
79PREHOOK: Input: default@src
80PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-28_425_5182303734060221915/10000
81POSTHOOK: query: SELECT xpath_int ('<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
82POSTHOOK: type: QUERY
83POSTHOOK: Input: default@src
84POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-28_425_5182303734060221915/10000
855