blob: bda6705d4abf09c58c0760e5dfa9eb7c0ef118fa [file] [log] [blame]
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;
create table map_txt (
id int,
content map<int,string>
)
row format delimited
null defined as '\\N'
stored as textfile
;
LOAD DATA LOCAL INPATH '../../data/files/mapNull.txt' INTO TABLE map_txt;
explain vectorization expression
select * from map_txt;
select * from map_txt;
explain vectorization expression
select id, map_keys(content) from map_txt;
select id, map_keys(content) from map_txt;