PREHOOK: query: DESCRIBE FUNCTION xpath_string
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION xpath_string
POSTHOOK: type: DESCFUNCTION
xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the xpath expression
PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_string
POSTHOOK: type: DESCFUNCTION
xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the xpath expression
Example:
> SELECT xpath_string('bcc','a/c') FROM src LIMIT 1;
'cc'
> SELECT xpath_string('b1b2','a/b') FROM src LIMIT 1;
'b1'
> SELECT xpath_string('b1b2','a/b[2]') FROM src LIMIT 1;
'b2'
> SELECT xpath_string('b1b2','a') FROM src LIMIT 1;
'b1b2'
PREHOOK: query: SELECT xpath_string ('bbcc', 'a') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
POSTHOOK: query: SELECT xpath_string ('bbcc', 'a') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/940874235/10000
bbcc
PREHOOK: query: SELECT xpath_string ('bbcc', 'a/b') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
POSTHOOK: query: SELECT xpath_string ('bbcc', 'a/b') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1447930808/10000
bb
PREHOOK: query: SELECT xpath_string ('bbcc', 'a/c') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
POSTHOOK: query: SELECT xpath_string ('bbcc', 'a/c') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1556430756/10000
cc
PREHOOK: query: SELECT xpath_string ('bbcc', 'a/d') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
POSTHOOK: query: SELECT xpath_string ('bbcc', 'a/d') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1353144403/10000
PREHOOK: query: SELECT xpath_string ('b1b2', '//b') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
POSTHOOK: query: SELECT xpath_string ('b1b2', '//b') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1184684106/10000
b1
PREHOOK: query: SELECT xpath_string ('b1b2', 'a/b[1]') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
POSTHOOK: query: SELECT xpath_string ('b1b2', 'a/b[1]') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/184679872/10000
b1
PREHOOK: query: SELECT xpath_string ('b1b2', 'a/b[2]') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
POSTHOOK: query: SELECT xpath_string ('b1b2', 'a/b[2]') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/1295801804/10000
b2
PREHOOK: query: SELECT xpath_string ('b1b2', 'a/b[@id="b_2"]') FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
POSTHOOK: query: SELECT xpath_string ('b1b2', 'a/b[@id="b_2"]') FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/patrick/Documents/workspace/hive-trunk/build/ql/tmp/885790551/10000
b2