PREHOOK: query: DESCRIBE FUNCTION xpath_number
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION xpath_number
POSTHOOK: type: DESCFUNCTION
xpath_number(xml, xpath) - Returns a double value that matches the xpath expression
PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_number
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_number
POSTHOOK: type: DESCFUNCTION
xpath_number(xml, xpath) - Returns a double value that matches the xpath expression
Synonyms: xpath_double
Example:
> SELECT xpath_number('12','sum(a/b)') FROM src LIMIT 1;
3.0
PREHOOK: query: DESCRIBE FUNCTION xpath_double
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION xpath_double
POSTHOOK: type: DESCFUNCTION
xpath_double(xml, xpath) - Returns a double value that matches the xpath expression
PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_double
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_double
POSTHOOK: type: DESCFUNCTION
xpath_double(xml, xpath) - Returns a double value that matches the xpath expression
Synonyms: xpath_number
Example:
> SELECT xpath_double('12','sum(a/b)') FROM src LIMIT 1;
3.0
PREHOOK: query: SELECT xpath_double ('this is not a number', '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-18-01_508_1991321646977894225/10000
POSTHOOK: query: SELECT xpath_double ('this is not a number', '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-18-01_508_1991321646977894225/10000
NaN
PREHOOK: query: SELECT xpath_double ('this 2 is not a number', '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-18-09_978_5086370842391754693/10000
POSTHOOK: query: SELECT xpath_double ('this 2 is not a number', '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-18-09_978_5086370842391754693/10000
NaN
PREHOOK: query: SELECT xpath_double ('200000000040000000000', '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-18-14_600_2112341954786715050/10000
POSTHOOK: query: SELECT xpath_double ('200000000040000000000', '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-18-14_600_2112341954786715050/10000
8.0E19
PREHOOK: query: SELECT xpath_double ('try a boolean', '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-18-19_556_7887685109666627688/10000
POSTHOOK: query: SELECT xpath_double ('try a boolean', '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-18-19_556_7887685109666627688/10000
0.0
PREHOOK: query: SELECT xpath_double ('1248', '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-18-25_151_3332009817772884258/10000
POSTHOOK: query: SELECT xpath_double ('1248', '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-18-25_151_3332009817772884258/10000
1.0
PREHOOK: query: SELECT xpath_double ('1248', '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-18-30_323_3300427926281032367/10000
POSTHOOK: query: SELECT xpath_double ('1248', '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-18-30_323_3300427926281032367/10000
15.0
PREHOOK: query: SELECT xpath_double ('1248', '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-18-38_033_4823634237013936509/10000
POSTHOOK: query: SELECT xpath_double ('1248', '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-18-38_033_4823634237013936509/10000
7.0
PREHOOK: query: SELECT xpath_double ('1248', '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-18-44_959_2961106728187522931/10000
POSTHOOK: query: SELECT xpath_double ('1248', '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-18-44_959_2961106728187522931/10000
5.0