set hive.mapred.mode=nonstrict;
set hive.stats.column.autogather=true;

drop table p_n1;

CREATE TABLE p_n1(insert_num int, c1 tinyint, c2 smallint);

desc formatted p_n1;

insert into p_n1 values (1,22,333);

desc formatted p_n1;

alter table p_n1 replace columns (insert_num int, c1 STRING, c2 STRING);

desc formatted p_n1;

desc formatted p_n1 insert_num;
desc formatted p_n1 c1;

insert into p_n1 values (2,11,111);

desc formatted p_n1;

desc formatted p_n1 insert_num;
desc formatted p_n1 c1;

set hive.stats.column.autogather=false;

drop table p_n1;

CREATE TABLE p_n1(insert_num int, c1 tinyint, c2 smallint);

desc formatted p_n1;

insert into p_n1 values (1,22,333);

desc formatted p_n1;

alter table p_n1 replace columns (insert_num int, c1 STRING, c2 STRING);

desc formatted p_n1;

desc formatted p_n1 insert_num;
desc formatted p_n1 c1;

insert into p_n1 values (2,11,111);

desc formatted p_n1;

desc formatted p_n1 insert_num;
desc formatted p_n1 c1;