blob: cd0b3369f2ab137933578c8452cdfe7f1d44d96c [file] [log] [blame]
--! qt:dataset:src
set hive.fetch.task.conversion=more;
use default;
-- Test map_values() UDF
DESCRIBE FUNCTION map_values;
DESCRIBE FUNCTION EXTENDED map_values;
-- Evaluate function against STRING valued values
SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows);
-- Evaluate function against INT valued keys
SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows);