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

--! qt:dataset:src
set hive.stats.autogather=true;

CREATE TABLE stats_invalid (key string, value string);

insert overwrite table stats_invalid
select * from src;

analyze table stats_invalid compute statistics for columns key,value;

desc formatted stats_invalid;
alter table stats_invalid add  columns (new_col string);

desc formatted stats_invalid;
drop table stats_invalid;