blob: a050beb4cd9be6871f1983decc24c3c150802141 [file] [log] [blame]
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;
create table coalesce_test(a int, b int) stored as orc;
insert into coalesce_test values (1, 2);
-- Add a single NULL row that will come from ORC as isRepeated.
insert into coalesce_test values (NULL, NULL);
explain vectorization detail
select coalesce(a, b) from coalesce_test order by a, b;
select coalesce(a, b) from coalesce_test order by a, b;;