blob: d27554ee3ad0ac6d417b16244a0d2ad00eeda516 [file] [log] [blame]
set hive.mapred.mode=nonstrict;
create table t1_n36 (a int);
analyze table t1_n36 compute statistics;
analyze table t1_n36 compute statistics for columns;
explain select count(1) from t1_n36 group by 1;
select count(1) from t1_n36 group by 1;
select count(1) from t1_n36;
explain select count(*) from t1_n36;
select count(*) from t1_n36;
select count(1) from t1_n36 group by 1=1;
select count(1), max(a) from t1_n36 group by 1=1;
set hive.compute.query.using.stats=false;
select count(1) from t1_n36 group by 1;
select count(1) from t1_n36;
select count(*) from t1_n36;
select count(1) from t1_n36 group by 1=1;
select count(1), max(a) from t1_n36 group by 1=1;