PREHOOK: query: DESCRIBE FUNCTION array_contains PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION array_contains POSTHOOK: type: DESCFUNCTION array_contains(array, value) - Returns TRUE if the array contains value. PREHOOK: query: DESCRIBE FUNCTION EXTENDED array_contains PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED array_contains POSTHOOK: type: DESCFUNCTION array_contains(array, value) - Returns TRUE if the array contains value. Example: > SELECT array_contains(array(1, 2, 3), 2) FROM src LIMIT 1; true PREHOOK: query: -- evalutes function for array of primitives SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- evalutes function for array of primitives SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### true PREHOOK: query: -- evaluates function for nested arrays SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2)) FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- evaluates function for nested arrays SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2)) FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### true