blob: a7396d0b47dbb161fc3305b943dec29623a54c1e [file] [log] [blame]
--! qt:dataset:src
set hive.fetch.task.conversion=more;
DESCRIBE FUNCTION array_contains;
DESCRIBE FUNCTION EXTENDED array_contains;
-- evalutes function for array of primitives
SELECT array_contains(array(1, 2, 3), 1) FROM src tablesample (1 rows);
-- evaluates function for nested arrays
SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
FROM src tablesample (1 rows);