| set hive.stats.column.autogather=false; |
| set hive.stats.fetch.column.stats=true; |
| set hive.compute.query.using.stats=true; |
| set hive.mapred.mode=nonstrict; |
| |
| drop table calendar_n0; |
| |
| CREATE TABLE calendar_n0 (year int, month int); |
| |
| insert into calendar_n0 values (2010, 10), (2011, 11), (2012, 12); |
| |
| desc formatted calendar_n0; |
| |
| analyze table calendar_n0 compute statistics; |
| |
| desc formatted calendar_n0; |
| |
| explain select count(1) from calendar_n0; |
| |
| explain select max(year) from calendar_n0; |
| |
| select max(year) from calendar_n0; |
| |
| select max(month) from calendar_n0; |
| |
| analyze table calendar_n0 compute statistics for columns; |
| |
| desc formatted calendar_n0; |
| |
| explain select max(year) from calendar_n0; |
| |
| select max(year) from calendar_n0; |
| |
| insert into calendar_n0 values (2015, 15); |
| |
| desc formatted calendar_n0; |
| |
| explain select max(year) from calendar_n0; |
| |
| select max(year) from calendar_n0; |
| |
| explain select max(month) from calendar_n0; |
| |
| select max(month) from calendar_n0; |
| |
| analyze table calendar_n0 compute statistics for columns year; |
| |
| desc formatted calendar_n0; |
| |
| explain select max(year) from calendar_n0; |
| |
| select max(year) from calendar_n0; |
| |
| explain select max(month) from calendar_n0; |
| |
| select max(month) from calendar_n0; |
| |
| analyze table calendar_n0 compute statistics for columns month; |
| |
| desc formatted calendar_n0; |
| |
| explain select max(month) from calendar_n0; |
| |
| select max(month) from calendar_n0; |
| |
| CREATE TABLE calendarp (`year` int) partitioned by (p int); |
| |
| insert into table calendarp partition (p=1) values (2010), (2011), (2012); |
| |
| desc formatted calendarp partition (p=1); |
| |
| explain select max(year) from calendarp where p=1; |
| |
| select max(year) from calendarp where p=1; |
| |
| analyze table calendarp partition (p=1) compute statistics for columns; |
| |
| desc formatted calendarp partition (p=1); |
| |
| explain select max(year) from calendarp where p=1; |
| |
| insert into table calendarp partition (p=1) values (2015); |
| |
| desc formatted calendarp partition (p=1); |
| |
| explain select max(year) from calendarp where p=1; |
| |
| select max(year) from calendarp where p=1; |
| |
| create table t_n31 (key string, value string); |
| |
| load data local inpath '../../data/files/kv1.txt' into table t_n31; |
| |
| desc formatted t_n31; |
| |
| analyze table t_n31 compute statistics; |
| |
| desc formatted t_n31; |
| |
| |
| |
| |