PageRenderTime 84ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 91 lines | 90 code | 1 blank | 0 comment | 0 complexity | 1aedd33f91e46de8924ded219bda63ee MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: DESCRIBE FUNCTION xpath_string
  2. PREHOOK: type: DESCFUNCTION
  3. POSTHOOK: query: DESCRIBE FUNCTION xpath_string
  4. POSTHOOK: type: DESCFUNCTION
  5. xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the xpath expression
  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
  7. PREHOOK: type: DESCFUNCTION
  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
  9. POSTHOOK: type: DESCFUNCTION
  10. xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the xpath expression
  11. Example:
  12. > SELECT xpath_string('<a><b>b</b><c>cc</c></a>','a/c') FROM src LIMIT 1;
  13. 'cc'
  14. > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a/b') FROM src LIMIT 1;
  15. 'b1'
  16. > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a/b[2]') FROM src LIMIT 1;
  17. 'b2'
  18. > SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a') FROM src LIMIT 1;
  19. 'b1b2'
  20. PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1
  21. PREHOOK: type: QUERY
  22. PREHOOK: Input: default@src
  23. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
  24. POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1
  25. POSTHOOK: type: QUERY
  26. POSTHOOK: Input: default@src
  27. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
  28. bbcc
  29. PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src LIMIT 1
  30. PREHOOK: type: QUERY
  31. PREHOOK: Input: default@src
  32. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
  33. POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src LIMIT 1
  34. POSTHOOK: type: QUERY
  35. POSTHOOK: Input: default@src
  36. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
  37. bb
  38. PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src LIMIT 1
  39. PREHOOK: type: QUERY
  40. PREHOOK: Input: default@src
  41. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
  42. POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src LIMIT 1
  43. POSTHOOK: type: QUERY
  44. POSTHOOK: Input: default@src
  45. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
  46. cc
  47. PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src LIMIT 1
  48. PREHOOK: type: QUERY
  49. PREHOOK: Input: default@src
  50. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
  51. POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src LIMIT 1
  52. POSTHOOK: type: QUERY
  53. POSTHOOK: Input: default@src
  54. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
  55. PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src LIMIT 1
  56. PREHOOK: type: QUERY
  57. PREHOOK: Input: default@src
  58. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
  59. POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src LIMIT 1
  60. POSTHOOK: type: QUERY
  61. POSTHOOK: Input: default@src
  62. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
  63. b1
  64. PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src LIMIT 1
  65. PREHOOK: type: QUERY
  66. PREHOOK: Input: default@src
  67. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
  68. POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src LIMIT 1
  69. POSTHOOK: type: QUERY
  70. POSTHOOK: Input: default@src
  71. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
  72. b1
  73. PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT 1
  74. PREHOOK: type: QUERY
  75. PREHOOK: Input: default@src
  76. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
  77. POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT 1
  78. POSTHOOK: type: QUERY
  79. POSTHOOK: Input: default@src
  80. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
  81. b2
  82. 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
  83. PREHOOK: type: QUERY
  84. PREHOOK: Input: default@src
  85. PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
  86. 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
  87. POSTHOOK: type: QUERY
  88. POSTHOOK: Input: default@src
  89. POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
  90. b2