ql/src/test/queries/clientpositive/stats_nonpart.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.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.query.results.cache.enabled=false;

-- create source.
drop table if exists mysource;
create table mysource (p int,key int);
insert into mysource values (100,20), (101,40), (102,50);
insert into mysource values (100,30), (101,50), (102,60);

-- test nonpartitioned table
drop table if exists stats_nonpartitioned;

--create table stats_nonpartitioned(key int, value int) stored as orc;
create table stats_nonpartitioned(key int, value int) stored as orc tblproperties ("transactional"="true");
--create table stats_nonpartitioned(key int, value int) stored as orc tblproperties tblproperties ("transactional"="true", "transactional_properties"="insert_only");


explain select count(*) from stats_nonpartitioned;
select count(*) from stats_nonpartitioned;
desc formatted stats_nonpartitioned;

explain insert into table stats_nonpartitioned select * from mysource where p == 100; 
insert into table stats_nonpartitioned select * from mysource where p == 100; 

desc formatted stats_nonpartitioned;

explain select count(*) from stats_nonpartitioned;
select count(*) from stats_nonpartitioned;
explain select count(key) from stats_nonpartitioned;
select count(key) from stats_nonpartitioned;

--analyze table stats_nonpartitioned compute statistics;
analyze table stats_nonpartitioned compute statistics for columns key, value;

explain select count(*) from stats_nonpartitioned;
select count(*) from stats_nonpartitioned;
explain select count(key) from stats_nonpartitioned;
select count(key) from stats_nonpartitioned;