| --! qt:dataset:src1 |
| set hive.stats.fetch.bitvector=false; |
| |
| create table src_stat as select * from src1; |
| |
| create table src_stat_int ( |
| key double, |
| value string |
| ); |
| |
| LOAD DATA LOCAL INPATH '../../data/files/kv3.txt' INTO TABLE src_stat_int; |
| |
| ANALYZE TABLE src_stat COMPUTE STATISTICS for columns key; |
| |
| describe formatted src_stat key; |
| |
| ALTER TABLE src_stat UPDATE STATISTICS for column key SET ('numDVs'='1111','avgColLen'='1.111'); |
| |
| describe formatted src_stat key; |
| |
| ALTER TABLE src_stat UPDATE STATISTICS for column value SET ('numDVs'='121','numNulls'='122','avgColLen'='1.23','maxColLen'='124'); |
| |
| describe formatted src_stat value; |
| |
| ANALYZE TABLE src_stat_int COMPUTE STATISTICS for columns key; |
| |
| describe formatted src_stat_int key; |
| |
| ALTER TABLE src_stat_int UPDATE STATISTICS for column key SET ('numDVs'='2222','lowValue'='333.22','highValue'='22.22'); |
| |
| describe formatted src_stat_int key; |
| |
| |
| |
| create database if not exists dummydb; |
| |
| use dummydb; |
| |
| ALTER TABLE default.src_stat UPDATE STATISTICS for column key SET ('numDVs'='3333','avgColLen'='2.222'); |
| |
| describe formatted default.src_stat key; |
| |
| ALTER TABLE default.src_stat UPDATE STATISTICS for column value SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235'); |
| |
| describe formatted default.src_stat value; |
| |
| use default; |
| |
| drop database dummydb; |
| |
| create table datatype_stats( |
| t TINYINT, |
| s SMALLINT, |
| i INT, |
| b BIGINT, |
| f FLOAT, |
| d DOUBLE, |
| dem DECIMAL, --default decimal (10,0) |
| ts TIMESTAMP, |
| dt DATE, |
| str STRING, |
| v VARCHAR(12), |
| c CHAR(5), |
| bl BOOLEAN, |
| bin BINARY); |
| |
| INSERT INTO datatype_stats values(2, 3, 45, 456, 45454.4, 454.6565, 2355, '2012-01-01 01:02:03', '2012-01-01', 'update_statistics', 'stats', 'hive', 'true', 'bin'); |
| INSERT INTO datatype_stats values(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); |
| DESC FORMATTED datatype_stats s; |
| DESC FORMATTED datatype_stats i; |
| DESC FORMATTED datatype_stats b; |
| DESC FORMATTED datatype_stats f; |
| DESC FORMATTED datatype_stats d; |
| DESC FORMATTED datatype_stats dem; |
| DESC FORMATTED datatype_stats ts; |
| DESC FORMATTED datatype_stats dt; |
| DESC FORMATTED datatype_stats str; |
| DESC FORMATTED datatype_stats v; |
| DESC FORMATTED datatype_stats c; |
| DESC FORMATTED datatype_stats bl; |
| DESC FORMATTED datatype_stats bin; |
| |
| --tinyint |
| DESC FORMATTED datatype_stats t; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column t SET ('numDVs'='232','numNulls'='233','highValue'='234','lowValue'='35'); |
| DESC FORMATTED datatype_stats t; |
| --smallint |
| DESC FORMATTED datatype_stats s; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column s SET ('numDVs'='56','numNulls'='56','highValue'='489','lowValue'='25'); |
| DESC FORMATTED datatype_stats s; |
| --int |
| DESC FORMATTED datatype_stats i; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column i SET ('numDVs'='59','numNulls'='1','highValue'='889','lowValue'='5'); |
| DESC FORMATTED datatype_stats i; |
| --bigint |
| DESC FORMATTED datatype_stats b; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column b SET ('numDVs'='9','numNulls'='14','highValue'='89','lowValue'='8'); |
| DESC FORMATTED datatype_stats b; |
| |
| --float |
| DESC FORMATTED datatype_stats f; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column f SET ('numDVs'='563','numNulls'='45','highValue'='2345.656','lowValue'='8.00'); |
| DESC FORMATTED datatype_stats f; |
| --double |
| DESC FORMATTED datatype_stats d; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column d SET ('numDVs'='5677','numNulls'='12','highValue'='560.3367','lowValue'='0.00455'); |
| DESC FORMATTED datatype_stats d; |
| --decimal |
| DESC FORMATTED datatype_stats dem; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dem SET ('numDVs'='57','numNulls'='912','highValue'='560','lowValue'='0'); |
| DESC FORMATTED datatype_stats dem; |
| --timestamp |
| DESC FORMATTED datatype_stats ts; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column ts SET ('numDVs'='7','numNulls'='12','highValue'='1357030923','lowValue'='1357030924'); |
| DESC FORMATTED datatype_stats ts; |
| --decimal |
| DESC FORMATTED datatype_stats dt; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dt SET ('numDVs'='57','numNulls'='912','highValue'='2012-01-01','lowValue'='2001-02-04'); |
| DESC FORMATTED datatype_stats dt; |
| --string |
| DESC FORMATTED datatype_stats str; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column str SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235'); |
| DESC FORMATTED datatype_stats str; |
| --varchar |
| DESC FORMATTED datatype_stats v; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column v SET ('numDVs'='22','numNulls'='33','avgColLen'='4.40','maxColLen'='25'); |
| DESC FORMATTED datatype_stats v; |
| --char |
| DESC FORMATTED datatype_stats c; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column c SET ('numDVs'='2','numNulls'='03','avgColLen'='9.00','maxColLen'='58'); |
| DESC FORMATTED datatype_stats c; |
| --boolean |
| DESC FORMATTED datatype_stats bl; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bl SET ('numNulls'='1','numTrues'='9','numFalses'='8'); |
| DESC FORMATTED datatype_stats bl; |
| --binary |
| DESC FORMATTED datatype_stats bin; |
| ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bin SET ('numNulls'='8','avgColLen'='2.0','maxColLen'='8'); |
| DESC FORMATTED datatype_stats bin; |
| |