PageRenderTime 48ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: DESCRIBE FUNCTION xpath_int
  2. PREHOOK: type: DESCFUNCTION
  3. POSTHOOK: query: DESCRIBE FUNCTION xpath_int
  4. POSTHOOK: type: DESCFUNCTION
  5. xpath_int(xml, xpath) - Returns an integer value that matches the xpath expression
  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_int
  7. PREHOOK: type: DESCFUNCTION
  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_int
  9. POSTHOOK: type: DESCFUNCTION
  10. xpath_int(xml, xpath) - Returns an integer value that matches the xpath expression
  11. Example:
  12. > SELECT xpath_int('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
  13. 3
  14. PREHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
  15. PREHOOK: type: QUERY
  16. PREHOOK: Input: default@src
  17. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-51_875_437569805026140503/10000
  18. POSTHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
  19. POSTHOOK: type: QUERY
  20. POSTHOOK: Input: default@src
  21. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-51_875_437569805026140503/10000
  22. 0
  23. PREHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
  24. PREHOOK: type: QUERY
  25. PREHOOK: Input: default@src
  26. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-57_094_9168946979271622158/10000
  27. POSTHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
  28. POSTHOOK: type: QUERY
  29. POSTHOOK: Input: default@src
  30. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-45-57_094_9168946979271622158/10000
  31. 0
  32. PREHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
  33. PREHOOK: type: QUERY
  34. PREHOOK: Input: default@src
  35. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-01_568_5764046814540785002/10000
  36. POSTHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
  37. POSTHOOK: type: QUERY
  38. POSTHOOK: Input: default@src
  39. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-01_568_5764046814540785002/10000
  40. 2147483647
  41. PREHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
  42. PREHOOK: type: QUERY
  43. PREHOOK: Input: default@src
  44. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-06_220_6973728860376107951/10000
  45. POSTHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
  46. POSTHOOK: type: QUERY
  47. POSTHOOK: Input: default@src
  48. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-06_220_6973728860376107951/10000
  49. 0
  50. PREHOOK: 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
  51. PREHOOK: type: QUERY
  52. PREHOOK: Input: default@src
  53. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-10_880_7033077055949838171/10000
  54. POSTHOOK: 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
  55. POSTHOOK: type: QUERY
  56. POSTHOOK: Input: default@src
  57. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-10_880_7033077055949838171/10000
  58. 1
  59. PREHOOK: 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
  60. PREHOOK: type: QUERY
  61. PREHOOK: Input: default@src
  62. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-15_676_4494502415099433177/10000
  63. POSTHOOK: 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
  64. POSTHOOK: type: QUERY
  65. POSTHOOK: Input: default@src
  66. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-15_676_4494502415099433177/10000
  67. 15
  68. PREHOOK: 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
  69. PREHOOK: type: QUERY
  70. PREHOOK: Input: default@src
  71. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-22_229_1539908466202895730/10000
  72. POSTHOOK: 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
  73. POSTHOOK: type: QUERY
  74. POSTHOOK: Input: default@src
  75. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-22_229_1539908466202895730/10000
  76. 7
  77. PREHOOK: 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
  78. PREHOOK: type: QUERY
  79. PREHOOK: Input: default@src
  80. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-28_425_5182303734060221915/10000
  81. POSTHOOK: 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
  82. POSTHOOK: type: QUERY
  83. POSTHOOK: Input: default@src
  84. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/scratchdir/hive_2010-03-11_06-46-28_425_5182303734060221915/10000
  85. 5