PREHOOK: query: DESCRIBE FUNCTION xpath_boolean
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION xpath_boolean
POSTHOOK: type: DESCFUNCTION
xpath_boolean(xml, xpath) - Evaluates a boolean xpath expression
PREHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_boolean
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED xpath_boolean
POSTHOOK: type: DESCFUNCTION
xpath_boolean(xml, xpath) - Evaluates a boolean xpath expression
Example:
> SELECT xpath_boolean('1','a/b') FROM src LIMIT 1;
true
> SELECT xpath_boolean('1','a/b = 2') FROM src LIMIT 1;
false
PREHOOK: query: SELECT xpath_boolean ('b', '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-10_20-03-28_114_6497232488979162957/10000
POSTHOOK: query: SELECT xpath_boolean ('b', '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-10_20-03-28_114_6497232488979162957/10000
true
PREHOOK: query: SELECT xpath_boolean ('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-10_20-03-34_680_245261282103280419/10000
POSTHOOK: query: SELECT xpath_boolean ('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-10_20-03-34_680_245261282103280419/10000
false
PREHOOK: query: SELECT xpath_boolean ('b', 'a/b = "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-10_20-03-39_762_4463036010834055605/10000
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/b = "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-10_20-03-39_762_4463036010834055605/10000
true
PREHOOK: query: SELECT xpath_boolean ('b', 'a/b = "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-10_20-03-44_907_6378242213319120163/10000
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/b = "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-10_20-03-44_907_6378242213319120163/10000
false
PREHOOK: query: SELECT xpath_boolean ('10', 'a/b < 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-10_20-03-49_791_1413682388477086591/10000
POSTHOOK: query: SELECT xpath_boolean ('10', 'a/b < 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-10_20-03-49_791_1413682388477086591/10000
false
PREHOOK: query: SELECT xpath_boolean ('10', 'a/b = 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-10_20-03-54_878_152160286885945584/10000
POSTHOOK: query: SELECT xpath_boolean ('10', 'a/b = 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-10_20-03-54_878_152160286885945584/10000
true