ql/src/test/queries/clientpositive/orc_schema_evolution.q

--! qt:dataset:src

set hive.vectorized.execution.enabled=false;
set hive.fetch.task.conversion=none;
SET hive.exec.schema.evolution=true;

create table src_orc_n3 (key smallint, val string) stored as orc;
create table src_orc2 (key smallint, val string) stored as orc;

-- integer type widening
insert overwrite table src_orc_n3 select * from src;
select sum(hash(*)) from src_orc_n3;

alter table src_orc_n3 change key key smallint;
select sum(hash(*)) from src_orc_n3;

alter table src_orc_n3 change key key int;
select sum(hash(*)) from src_orc_n3;

alter table src_orc_n3 change key key bigint;
select sum(hash(*)) from src_orc_n3;

-- replace columns for adding columns and type widening
insert overwrite table src_orc2 select * from src;
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key smallint, val string);
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key int, val string);
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key bigint, val string);
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key bigint, val string, z int);
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key bigint, val string, z bigint);
select sum(hash(*)) from src_orc2;

alter table src_orc2 replace columns (key bigint, val string, z bigint, y float);
select sum(hash(*)) from src_orc2;