| --! qt:dataset:src1 |
| create table src_stat_n0 as select * from src1; |
| |
| create table src_stat_int_n0 ( |
| key double, |
| value string |
| ); |
| |
| LOAD DATA LOCAL INPATH '../../data/files/kv3.txt' INTO TABLE src_stat_int_n0; |
| |
| ANALYZE TABLE src_stat_n0 COMPUTE STATISTICS for columns key; |
| |
| describe formatted src_stat_n0 key; |
| |
| ALTER TABLE src_stat_n0 UPDATE STATISTICS for column key SET ('numDVs'='1111','avgColLen'='1.111'); |
| |
| describe formatted src_stat_n0 key; |
| |
| ALTER TABLE src_stat_n0 UPDATE STATISTICS for column value SET ('numDVs'='121','numNulls'='122','avgColLen'='1.23','maxColLen'='124'); |
| |
| describe formatted src_stat_n0 value; |
| |
| ANALYZE TABLE src_stat_int_n0 COMPUTE STATISTICS for columns key; |
| |
| describe formatted src_stat_int_n0 key; |
| |
| ALTER TABLE src_stat_int_n0 UPDATE STATISTICS for column key SET ('numDVs'='2222','lowValue'='333.22','highValue'='22.22'); |
| |
| describe formatted src_stat_int_n0 key; |
| |
| |
| |
| create database if not exists dummydb; |
| |
| use dummydb; |
| |
| ALTER TABLE default.src_stat_n0 UPDATE STATISTICS for column key SET ('numDVs'='3333','avgColLen'='2.222'); |
| |
| describe formatted default.src_stat_n0 key; |
| |
| ALTER TABLE default.src_stat_n0 UPDATE STATISTICS for column value SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235'); |
| |
| describe formatted default.src_stat_n0 value; |
| |
| use default; |
| |
| drop database dummydb; |
| |
| create table datatype_stats_n0( |
| 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_n0 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_n0 values(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); |
| DESC FORMATTED datatype_stats_n0 s; |
| DESC FORMATTED datatype_stats_n0 i; |
| DESC FORMATTED datatype_stats_n0 b; |
| DESC FORMATTED datatype_stats_n0 f; |
| DESC FORMATTED datatype_stats_n0 d; |
| DESC FORMATTED datatype_stats_n0 dem; |
| DESC FORMATTED datatype_stats_n0 ts; |
| DESC FORMATTED datatype_stats_n0 dt; |
| DESC FORMATTED datatype_stats_n0 str; |
| DESC FORMATTED datatype_stats_n0 v; |
| DESC FORMATTED datatype_stats_n0 c; |
| DESC FORMATTED datatype_stats_n0 bl; |
| DESC FORMATTED datatype_stats_n0 bin; |
| |
| --tinyint |
| DESC FORMATTED datatype_stats_n0 t; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column t SET ('numDVs'='232','numNulls'='233','highValue'='234','lowValue'='35'); |
| DESC FORMATTED datatype_stats_n0 t; |
| --smallint |
| DESC FORMATTED datatype_stats_n0 s; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column s SET ('numDVs'='56','numNulls'='56','highValue'='489','lowValue'='25'); |
| DESC FORMATTED datatype_stats_n0 s; |
| --int |
| DESC FORMATTED datatype_stats_n0 i; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column i SET ('numDVs'='59','numNulls'='1','highValue'='889','lowValue'='5'); |
| DESC FORMATTED datatype_stats_n0 i; |
| --bigint |
| DESC FORMATTED datatype_stats_n0 b; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column b SET ('numDVs'='9','numNulls'='14','highValue'='89','lowValue'='8'); |
| DESC FORMATTED datatype_stats_n0 b; |
| |
| --float |
| DESC FORMATTED datatype_stats_n0 f; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column f SET ('numDVs'='563','numNulls'='45','highValue'='2345.656','lowValue'='8.00'); |
| DESC FORMATTED datatype_stats_n0 f; |
| --double |
| DESC FORMATTED datatype_stats_n0 d; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column d SET ('numDVs'='5677','numNulls'='12','highValue'='560.3367','lowValue'='0.00455'); |
| DESC FORMATTED datatype_stats_n0 d; |
| --decimal |
| DESC FORMATTED datatype_stats_n0 dem; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column dem SET ('numDVs'='57','numNulls'='912','highValue'='560','lowValue'='0'); |
| DESC FORMATTED datatype_stats_n0 dem; |
| --timestamp |
| DESC FORMATTED datatype_stats_n0 ts; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column ts SET ('numDVs'='7','numNulls'='12','highValue'='1357030923','lowValue'='1357030924'); |
| DESC FORMATTED datatype_stats_n0 ts; |
| --decimal |
| DESC FORMATTED datatype_stats_n0 dt; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column dt SET ('numDVs'='57','numNulls'='912','highValue'='2012-01-01','lowValue'='2001-02-04'); |
| DESC FORMATTED datatype_stats_n0 dt; |
| --string |
| DESC FORMATTED datatype_stats_n0 str; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column str SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235'); |
| DESC FORMATTED datatype_stats_n0 str; |
| --varchar |
| DESC FORMATTED datatype_stats_n0 v; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column v SET ('numDVs'='22','numNulls'='33','avgColLen'='4.40','maxColLen'='25'); |
| DESC FORMATTED datatype_stats_n0 v; |
| --char |
| DESC FORMATTED datatype_stats_n0 c; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column c SET ('numDVs'='2','numNulls'='03','avgColLen'='9.00','maxColLen'='58'); |
| DESC FORMATTED datatype_stats_n0 c; |
| --boolean |
| DESC FORMATTED datatype_stats_n0 bl; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column bl SET ('numNulls'='1','numTrues'='9','numFalses'='8'); |
| DESC FORMATTED datatype_stats_n0 bl; |
| --binary |
| DESC FORMATTED datatype_stats_n0 bin; |
| ALTER TABLE default.datatype_stats_n0 UPDATE STATISTICS for column bin SET ('numNulls'='8','avgColLen'='2.0','maxColLen'='8'); |
| DESC FORMATTED datatype_stats_n0 bin; |
| |