Saving all output to "!!{outputDirectory}!!/udf_array_contains.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/udf_array_contains.q >>> DESCRIBE FUNCTION array_contains; 'tab_name' 'array_contains(array, value) - Returns TRUE if the array contains value.' 1 row selected >>> DESCRIBE FUNCTION EXTENDED array_contains; 'tab_name' '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' 4 rows selected >>> >>> -- evalutes function for array of primitives >>> SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1; '_c0' 'true' 1 row selected >>> >>> -- 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; '_c0' 'true' 1 row selected >>> !record