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

set hive.stats.dbclass=fs;
set hive.stats.fetch.column.stats=true;
set datanucleus.cache.collections=false;

set hive.merge.mapfiles=false;
set hive.merge.mapredfiles=false;

set hive.stats.autogather=true;
set hive.stats.column.autogather=true;
set hive.compute.query.using.stats=true;
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;

set hive.fetch.task.conversion=none;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.query.results.cache.enabled=false;
set hive.acid.truncate.usebase=false;

-- test truncate

create table stats_nonpart(key int,value string) tblproperties ("transactional"="true", "transactional_properties"="insert_only");
insert into table stats_nonpart values (1, "foo");
explain select count(key) from stats_nonpart;

truncate table stats_nonpart;
explain select count(key) from stats_nonpart;

analyze table stats_nonpart compute statistics for columns;
explain select count(key) from stats_nonpart;
drop table stats_nonpart;



create table stats_part(key int,value string) partitioned by (p int) tblproperties ("transactional"="true", "transactional_properties"="insert_only");
insert into table stats_part partition(p=101) values (1, "foo");
insert into table stats_part partition(p=102) values (2, "bar");
insert into table stats_part partition(p=103) values (3, "baz");
explain select count(key) from stats_part where p = 101;

truncate table stats_part partition(p=101);
explain select count(key) from stats_part where p = 102;
explain select count(key) from stats_part;

alter table stats_part drop partition (p=101);
explain select count(key) from stats_part;

truncate table stats_part partition(p=102);
analyze table stats_part partition(p) compute statistics for columns;

-- Note: this currently doesn't work from stats - for ACID tables or otherwise.

explain select count(key) from stats_part;
drop table stats_part;