PREHOOK: query: DESCRIBE FUNCTION xpath PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION xpath POSTHOOK: type: DESCFUNCTION xpath(xml, xpath) - Returns a string array of values within xml nodes that match the xpath expression PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath POSTHOOK: type: DESCFUNCTION xpath(xml, xpath) - Returns a string array of values within xml nodes that match the xpath expression Example: > SELECT xpath('b1b2b3c1c2', 'a/text()') FROM src LIMIT 1 [] > SELECT xpath('b1b2b3c1c2', 'a/b/text()') FROM src LIMIT 1 ["b1","b2","b3"] > SELECT xpath('b1b2b3c1c2', 'a/c/text()') FROM src LIMIT 1 ["c1","c2"] PREHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/text()') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1416181007/10000 POSTHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/text()') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1416181007/10000 [] PREHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/*/text()') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1851591863/10000 POSTHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/*/text()') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1851591863/10000 ["b1","b2","b3","c1","c2"] PREHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/b/text()') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/113811557/10000 POSTHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/b/text()') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/113811557/10000 ["b1","b2","b3"] PREHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/c/text()') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1674548693/10000 POSTHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/c/text()') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1674548693/10000 ["c1","c2"] PREHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/*[@class="bb"]/text()') FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/378718949/10000 POSTHOOK: query: SELECT xpath ('b1b2b3c1c2', 'a/*[@class="bb"]/text()') FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/378718949/10000 ["b1","c1"]