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

set metastore.colstats.retain.on.column.removal=true;

CREATE TABLE p1(a INT, b INTEGER) PARTITIONED BY(part INT);

insert into table p1 partition (part=1) VALUES (1, 'new');

select 'expected: column stats on a,b';
desc formatted p1 partition (part=1);

alter table p1 replace columns (a int, c string);

select 'expected: column stats on a';
desc formatted p1 partition (part=1);

analyze table p1 compute statistics for columns;

set metastore.colstats.retain.on.column.removal=false;

select 'expected: column stats on a,c';
desc formatted p1 partition (part=1);

alter table p1 replace columns (a string, d string);

select 'expected: no column stats present';
desc formatted p1 partition (part=1);