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 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/b') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
PREHOOK: query: SELECT xpath_boolean ('b', 'a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
PREHOOK: query: SELECT xpath_boolean ('b', 'a/b = "b"') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/b = "b"') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
PREHOOK: query: SELECT xpath_boolean ('b', 'a/b = "c"') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('b', 'a/b = "c"') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
PREHOOK: query: SELECT xpath_boolean ('10', 'a/b < 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('10', 'a/b < 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
PREHOOK: query: SELECT xpath_boolean ('10', 'a/b = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT xpath_boolean ('10', 'a/b = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true