--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;

drop table char_2_n0;

create table char_2_n0 (
  key char(10),
  value char(20)
) stored as orc;

insert overwrite table char_2_n0 select * from src;

-- Add a single NULL row that will come from ORC as isRepeated.
insert into char_2_n0 values (NULL, NULL);

select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value asc
limit 5;

explain vectorization expression select value, sum(cast(key as int)), count(*) numrows
from char_2_n0
group by value
order by value asc
limit 5;

-- should match the query from src
select value, sum(cast(key as int)), count(*) numrows
from char_2_n0
group by value
order by value asc
limit 5;

select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value desc
limit 5;

explain vectorization expression select value, sum(cast(key as int)), count(*) numrows
from char_2_n0
group by value
order by value desc
limit 5;

-- should match the query from src
select value, sum(cast(key as int)), count(*) numrows
from char_2_n0
group by value
order by value desc
limit 5;

drop table char_2_n0;