/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_xpath_long.q.out
text | 85 lines | 85 code | 0 blank | 0 comment | 0 complexity | 039ada914184d8ad597ef154cba54aef MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: DESCRIBE FUNCTION xpath_long
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION xpath_long
- POSTHOOK: type: DESCFUNCTION
- xpath_long(xml, xpath) - Returns a long value that matches the xpath expression
- PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_long
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_long
- POSTHOOK: type: DESCFUNCTION
- xpath_long(xml, xpath) - Returns a long value that matches the xpath expression
- Example:
- > SELECT xpath_long('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
- 3
- PREHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-02_746_8603604246445980017/10000
- POSTHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-02_746_8603604246445980017/10000
- 0
- PREHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-08_469_245302283686945807/10000
- POSTHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-08_469_245302283686945807/10000
- 0
- PREHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-13_128_903796629701395552/10000
- POSTHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-13_128_903796629701395552/10000
- 9223372036854775807
- PREHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-17_475_887719902767497475/10000
- POSTHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-17_475_887719902767497475/10000
- 0
- PREHOOK: query: SELECT xpath_long ('<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
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-22_489_58636595447270112/10000
- POSTHOOK: query: SELECT xpath_long ('<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
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-22_489_58636595447270112/10000
- 1
- PREHOOK: query: SELECT xpath_long ('<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
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-27_102_7513620137103622420/10000
- POSTHOOK: query: SELECT xpath_long ('<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
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-27_102_7513620137103622420/10000
- 15
- PREHOOK: query: SELECT xpath_long ('<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
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-37_776_6632052997392146833/10000
- POSTHOOK: query: SELECT xpath_long ('<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
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-37_776_6632052997392146833/10000
- 7
- PREHOOK: query: SELECT xpath_long ('<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
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-43_979_587396224869265022/10000
- POSTHOOK: query: SELECT xpath_long ('<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
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-38-43_979_587396224869265022/10000
- 5