blob: bd9557f110c44b908c05523baf06c2fb932c59d6 [file] [log] [blame]
--! qt:dataset:src
set hive.fetch.task.conversion=more;
DESCRIBE FUNCTION array_min;
DESCRIBE FUNCTION EXTENDED array_min;
-- evalutes function for array of primitives
SELECT array_min(array(1, 2, 3, null)) FROM src tablesample (1 rows);
SELECT array_min(array()) FROM src tablesample (1 rows);
SELECT array_min(array(null)) FROM src tablesample (1 rows);
SELECT array_min(array(1.12, 2.23, 3.34, null)) FROM src tablesample (1 rows);
SELECT array_min(array(1.1234567890, 2.234567890, 3.34567890, null)) FROM src tablesample (1 rows);
SELECT array_min(array(11234567890, 2234567890, 334567890, null)) FROM src tablesample (1 rows);