sql-tests/inputs/describe-part-after-analyze.sql

0001 CREATE TABLE t (key STRING, value STRING, ds STRING, hr INT) USING parquet
0002     PARTITIONED BY (ds, hr);
0003
0004 INSERT INTO TABLE t PARTITION (ds='2017-08-01', hr=10)
0005 VALUES ('k1', 100), ('k2', 200), ('k3', 300);
0006
0007 INSERT INTO TABLE t PARTITION (ds='2017-08-01', hr=11)
0008 VALUES ('k1', 101), ('k2', 201), ('k3', 301), ('k4', 401);
0009
0010 INSERT INTO TABLE t PARTITION (ds='2017-09-01', hr=5)
0011 VALUES ('k1', 102), ('k2', 202);
0012
0013 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=10);
0014
0015 -- Collect stats for a single partition
0016 ANALYZE TABLE t PARTITION (ds='2017-08-01', hr=10) COMPUTE STATISTICS;
0017
0018 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=10);
0019
0020 -- Collect stats for 2 partitions
0021 ANALYZE TABLE t PARTITION (ds='2017-08-01') COMPUTE STATISTICS;
0022
0023 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=10);
0024 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=11);
0025
0026 -- Collect stats for all partitions
0027 ANALYZE TABLE t PARTITION (ds, hr) COMPUTE STATISTICS;
0028
0029 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=10);
0030 DESC EXTENDED t PARTITION (ds='2017-08-01', hr=11);
0031 DESC EXTENDED t PARTITION (ds='2017-09-01', hr=5);
0032
0033 -- DROP TEST TABLES/VIEWS
0034 DROP TABLE t;