[doris] branch master updated: [stats](nereids)support partition stats (#22606)

[englefly]

This is an automated email from the ASF dual-hosted git repository.

englefly pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 80566f7fed [stats](nereids)support partition stats  (#22606)
80566f7fed is described below

commit 80566f7fed1c6305d0b5772d309d90d8e524a520
Author: minghong <engle...@gmail.com>
AuthorDate: Tue Aug 15 17:52:25 2023 +0800

    [stats](nereids)support partition stats  (#22606)
---
 .../doris/nereids/stats/StatsCalculator.java       |   16 +
 .../apache/doris/statistics/ColumnStatistic.java   |   10 +-
 .../doris/statistics/ColumnStatisticBuilder.java   |   33 +-
 .../doris/nereids/util/HyperGraphBuilder.java      |    2 +-
 .../org/apache/doris/statistics/CacheTest.java     |    2 +-
 .../doris/statistics/StatsDeriveResultTest.java    |    3 +-
 .../nereids_tpcds_shape_sf100_p0/shape/query29.out |    7 +-
 .../nereids_tpcds_shape_sf100_p0/shape/query50.out |    5 +-
 .../nereids_tpcds_shape_sf100_p0/shape/query61.out |   14 +-
 .../nereids_p0/join/bucket_shuffle_join.groovy     |    2 -
 .../nereids_tpcds_shape_sf100_p0/load.groovy       | 1582 ++++++++++++++++++++
 11 files changed, 1652 insertions(+), 24 deletions(-)

diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/nereids/stats/StatsCalculator.java 
b/fe/fe-core/src/main/java/org/apache/doris/nereids/stats/StatsCalculator.java
index d25a328c17..5f7b4cc3de 100644
--- 
a/fe/fe-core/src/main/java/org/apache/doris/nereids/stats/StatsCalculator.java
+++ 
b/fe/fe-core/src/main/java/org/apache/doris/nereids/stats/StatsCalculator.java
@@ -20,6 +20,7 @@ package org.apache.doris.nereids.stats;
 import org.apache.doris.catalog.Column;
 import org.apache.doris.catalog.Env;
 import org.apache.doris.catalog.OlapTable;
+import org.apache.doris.catalog.PartitionType;
 import org.apache.doris.catalog.SchemaTable;
 import org.apache.doris.catalog.TableIf;
 import org.apache.doris.common.Config;
@@ -600,6 +601,20 @@ public class StatsCalculator extends 
DefaultPlanVisitor<Statistics, Void> {
         return null;
     }
 
+    private ColumnStatistic setOlapPartitionInfo(TableIf tableIf, 
ColumnStatistic colStats) {
+        if (colStats.partitionIdToColStats.isEmpty()) {
+            return colStats;
+        }
+        if (!(tableIf instanceof OlapTable)) {
+            return colStats;
+        }
+        OlapTable table = (OlapTable) tableIf;
+        if (table.getPartitionInfo().getType() != PartitionType.UNPARTITIONED) 
{
+            colStats = new 
ColumnStatisticBuilder(colStats).setPartitionInfo(table.getPartitionInfo()).build();
+        }
+        return colStats;
+    }
+
     // TODO: 1. Subtract the pruned partition
     //       2. Consider the influence of runtime filter
     //       3. Get NDV and column data size from StatisticManger, 
StatisticManager doesn't support it now.
@@ -647,6 +662,7 @@ public class StatsCalculator extends 
DefaultPlanVisitor<Statistics, Void> {
                 continue;
             }
             rowCount = Math.max(rowCount, cache.count);
+            cache = setOlapPartitionInfo(table, cache);
             Histogram histogram = getColumnHistogram(table, colName);
             if (histogram != null) {
                 ColumnStatisticBuilder columnStatisticBuilder =
diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatistic.java 
b/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatistic.java
index bfc5c33302..c3ce951d79 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatistic.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatistic.java
@@ -19,6 +19,7 @@ package org.apache.doris.statistics;
 
 import org.apache.doris.analysis.LiteralExpr;
 import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.PartitionInfo;
 import org.apache.doris.catalog.Type;
 import org.apache.doris.statistics.util.InternalQueryResult.ResultRow;
 import org.apache.doris.statistics.util.StatisticsUtil;
@@ -109,7 +110,6 @@ public class ColumnStatistic {
      */
     public final ColumnStatistic original;
 
-    // For display only.
     public final LiteralExpr minExpr;
     public final LiteralExpr maxExpr;
 
@@ -117,14 +117,17 @@ public class ColumnStatistic {
     // assign value when do stats estimation.
     public final Histogram histogram;
 
+    @SerializedName("partitionIdToColStats")
     public final Map<Long, ColumnStatistic> partitionIdToColStats = new 
HashMap<>();
 
     public final String updatedTime;
 
+    public final PartitionInfo partitionInfo;
+
     public ColumnStatistic(double count, double ndv, ColumnStatistic original, 
double avgSizeByte,
             double numNulls, double dataSize, double minValue, double maxValue,
             double selectivity, LiteralExpr minExpr, LiteralExpr maxExpr, 
boolean isUnKnown, Histogram histogram,
-            String updatedTime) {
+            String updatedTime, PartitionInfo partitionInfo) {
         this.count = count;
         this.ndv = ndv;
         this.original = original;
@@ -139,6 +142,7 @@ public class ColumnStatistic {
         this.isUnKnown = isUnKnown;
         this.histogram = histogram;
         this.updatedTime = updatedTime;
+        this.partitionInfo = partitionInfo;
     }
 
     public static ColumnStatistic fromResultRow(List<ResultRow> resultRows) {
@@ -395,7 +399,7 @@ public class ColumnStatistic {
             null,
             stat.getBoolean("IsUnKnown"),
             Histogram.deserializeFromJson(stat.getString("Histogram")),
-            stat.getString("LastUpdatedTime")
+            stat.getString("LastUpdatedTime"), null
         );
     }
 
diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatisticBuilder.java
 
b/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatisticBuilder.java
index 07de092a17..feae54e3d6 100644
--- 
a/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatisticBuilder.java
+++ 
b/fe/fe-core/src/main/java/org/apache/doris/statistics/ColumnStatisticBuilder.java
@@ -18,6 +18,10 @@
 package org.apache.doris.statistics;
 
 import org.apache.doris.analysis.LiteralExpr;
+import org.apache.doris.catalog.PartitionInfo;
+
+import java.util.HashMap;
+import java.util.Map;
 
 public class ColumnStatisticBuilder {
     private double count;
@@ -37,11 +41,24 @@ public class ColumnStatisticBuilder {
 
     private ColumnStatistic original;
 
+    private Map<Long, ColumnStatistic> partitionIdToColStats = new HashMap<>();
+
     private String updatedTime;
 
+    private PartitionInfo partitionInfo;
+
     public ColumnStatisticBuilder() {
     }
 
+    public PartitionInfo getPartitionInfo() {
+        return partitionInfo;
+    }
+
+    public ColumnStatisticBuilder setPartitionInfo(PartitionInfo 
partitionInfo) {
+        this.partitionInfo = partitionInfo;
+        return this;
+    }
+
     public ColumnStatisticBuilder(ColumnStatistic columnStatistic) {
         this.count = columnStatistic.count;
         this.ndv = columnStatistic.ndv;
@@ -56,7 +73,9 @@ public class ColumnStatisticBuilder {
         this.isUnknown = columnStatistic.isUnKnown;
         this.histogram = columnStatistic.histogram;
         this.original = columnStatistic.original;
+        
this.partitionIdToColStats.putAll(columnStatistic.partitionIdToColStats);
         this.updatedTime = columnStatistic.updatedTime;
+        this.partitionInfo = columnStatistic.partitionInfo;
     }
 
     public ColumnStatisticBuilder setCount(double count) {
@@ -183,12 +202,16 @@ public class ColumnStatisticBuilder {
 
     public ColumnStatistic build() {
         dataSize = Math.max((count - numNulls + 1) * avgSizeByte, 0);
-        if (original == null && !isUnknown) {
+        if (original == null) {
             original = new ColumnStatistic(count, ndv, null, avgSizeByte, 
numNulls,
-                    dataSize, minValue, maxValue, selectivity, minExpr, 
maxExpr, false,
-                    histogram, updatedTime);
+                    dataSize, minValue, maxValue, selectivity, minExpr, 
maxExpr,
+                    isUnknown, histogram, updatedTime, partitionInfo);
+            original.partitionIdToColStats.putAll(partitionIdToColStats);
         }
-        return new ColumnStatistic(count, ndv, original, avgSizeByte, numNulls,
-            dataSize, minValue, maxValue, selectivity, minExpr, maxExpr, 
isUnknown, histogram, updatedTime);
+        ColumnStatistic colStats = new ColumnStatistic(count, ndv, original, 
avgSizeByte, numNulls,
+                dataSize, minValue, maxValue, selectivity, minExpr, maxExpr,
+                isUnknown, histogram, updatedTime, partitionInfo);
+        colStats.partitionIdToColStats.putAll(partitionIdToColStats);
+        return colStats;
     }
 }
diff --git 
a/fe/fe-core/src/test/java/org/apache/doris/nereids/util/HyperGraphBuilder.java 
b/fe/fe-core/src/test/java/org/apache/doris/nereids/util/HyperGraphBuilder.java
index ca594bdc99..885afe93f9 100644
--- 
a/fe/fe-core/src/test/java/org/apache/doris/nereids/util/HyperGraphBuilder.java
+++ 
b/fe/fe-core/src/test/java/org/apache/doris/nereids/util/HyperGraphBuilder.java
@@ -328,7 +328,7 @@ public class HyperGraphBuilder {
             slotIdToColumnStats.put(slot,
                     new ColumnStatistic(count, count, null, 1, 0, 0, 0,
                             count, 1, null, null, true, null,
-                            new Date().toString()));
+                            new Date().toString(), null));
         }
         return new Statistics(count, slotIdToColumnStats);
     }
diff --git 
a/fe/fe-core/src/test/java/org/apache/doris/statistics/CacheTest.java 
b/fe/fe-core/src/test/java/org/apache/doris/statistics/CacheTest.java
index d6570ecebc..197bdc11c5 100644
--- a/fe/fe-core/src/test/java/org/apache/doris/statistics/CacheTest.java
+++ b/fe/fe-core/src/test/java/org/apache/doris/statistics/CacheTest.java
@@ -291,7 +291,7 @@ public class CacheTest extends TestWithFeService {
                 table.getColumnStatistic("col");
                 result = new ColumnStatistic(1, 2,
                         null, 3, 4, 5, 6, 7, 8,
-                        null, null, false, null, new Date().toString());
+                        null, null, false, null, new Date().toString(), null);
             }
         };
         StatisticsCache statisticsCache = new StatisticsCache();
diff --git 
a/fe/fe-core/src/test/java/org/apache/doris/statistics/StatsDeriveResultTest.java
 
b/fe/fe-core/src/test/java/org/apache/doris/statistics/StatsDeriveResultTest.java
index 78872a547d..e9736d861e 100644
--- 
a/fe/fe-core/src/test/java/org/apache/doris/statistics/StatsDeriveResultTest.java
+++ 
b/fe/fe-core/src/test/java/org/apache/doris/statistics/StatsDeriveResultTest.java
@@ -29,7 +29,8 @@ public class StatsDeriveResultTest {
     public void testUpdateRowCountByLimit() {
         StatsDeriveResult stats = new StatsDeriveResult(100);
         ColumnStatistic a = new ColumnStatistic(100, 10,  null, 1, 5, 10,
-                1, 100, 0.5, null, null, false, null, new Date().toString());
+                1, 100, 0.5, null, null, false, null,
+                new Date().toString(), null);
         Id id = new Id(1);
         stats.addColumnStats(id, a);
         StatsDeriveResult res = stats.updateByLimit(0);
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query29.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query29.out
index 5f93ae5559..d3e1d4881a 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query29.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query29.out
@@ -18,9 +18,10 @@ PhysicalResultSink
 ----------------------PhysicalDistribute
 ------------------------PhysicalProject
 --------------------------hashJoin[INNER_JOIN](catalog_sales.cs_sold_date_sk = 
d3.d_date_sk)
-----------------------------PhysicalProject
-------------------------------filter(d_year IN (1999, 2000, 2001))
---------------------------------PhysicalOlapScan[date_dim]
+----------------------------PhysicalDistribute
+------------------------------PhysicalProject
+--------------------------------filter(d_year IN (1999, 2000, 2001))
+----------------------------------PhysicalOlapScan[date_dim]
 ----------------------------PhysicalDistribute
 ------------------------------PhysicalProject
 --------------------------------hashJoin[INNER_JOIN](store_returns.sr_item_sk 
= catalog_sales.cs_item_sk)(store_returns.sr_customer_sk = 
catalog_sales.cs_bill_customer_sk)
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query50.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query50.out
index e5ee383300..1fbd2f57a0 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query50.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query50.out
@@ -12,8 +12,9 @@ PhysicalResultSink
 ------------------PhysicalDistribute
 --------------------PhysicalProject
 ----------------------hashJoin[INNER_JOIN](store_sales.ss_sold_date_sk = 
d1.d_date_sk)
-------------------------PhysicalProject
---------------------------PhysicalOlapScan[date_dim]
+------------------------PhysicalDistribute
+--------------------------PhysicalProject
+----------------------------PhysicalOlapScan[date_dim]
 ------------------------PhysicalDistribute
 --------------------------PhysicalProject
 ----------------------------hashJoin[INNER_JOIN](store_sales.ss_item_sk = 
store_returns.sr_item_sk)(store_sales.ss_ticket_number = 
store_returns.sr_ticket_number)(store_sales.ss_customer_sk = 
store_returns.sr_customer_sk)
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query61.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query61.out
index bc1155555e..8d6a1fd181 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query61.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query61.out
@@ -31,9 +31,10 @@ PhysicalResultSink
 ----------------------------------------PhysicalOlapScan[promotion]
 ------------------------------------PhysicalDistribute
 
--------------------------------------hashJoin[INNER_JOIN](store_sales.ss_sold_date_sk
 = date_dim.d_date_sk)
-----------------------------------------PhysicalProject
-------------------------------------------filter((date_dim.d_moy = 
11)(date_dim.d_year = 1999))
---------------------------------------------PhysicalOlapScan[date_dim]
+----------------------------------------PhysicalDistribute
+------------------------------------------PhysicalProject
+--------------------------------------------filter((date_dim.d_moy = 
11)(date_dim.d_year = 1999))
+----------------------------------------------PhysicalOlapScan[date_dim]
 ----------------------------------------PhysicalDistribute
 ------------------------------------------PhysicalProject
 
--------------------------------------------hashJoin[INNER_JOIN](store_sales.ss_store_sk
 = store.s_store_sk)
@@ -60,9 +61,10 @@ PhysicalResultSink
 --------------------------PhysicalDistribute
 ----------------------------PhysicalProject
 ------------------------------hashJoin[INNER_JOIN](store_sales.ss_sold_date_sk 
= date_dim.d_date_sk)
---------------------------------PhysicalProject
-----------------------------------filter((date_dim.d_moy = 11)(date_dim.d_year 
= 1999))
-------------------------------------PhysicalOlapScan[date_dim]
+--------------------------------PhysicalDistribute
+----------------------------------PhysicalProject
+------------------------------------filter((date_dim.d_moy = 
11)(date_dim.d_year = 1999))
+--------------------------------------PhysicalOlapScan[date_dim]
 --------------------------------PhysicalDistribute
 
----------------------------------hashJoin[INNER_JOIN](store_sales.ss_customer_sk
 = customer.c_customer_sk)
 ------------------------------------PhysicalProject
diff --git a/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy 
b/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
index 786a478d20..f4bac3d2b6 100644
--- a/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
+++ b/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
@@ -75,6 +75,4 @@ suite("bucket-shuffle-join") {
         contains "BUCKET_SHFFULE_HASH_PARTITIONED: expr_cast(c as VARCHAR(*))"
     }
 
-    sql """ DROP TABLE IF EXISTS shuffle_join_t1 """
-    sql """ DROP TABLE IF EXISTS shuffle_join_t2 """
 }
diff --git a/regression-test/suites/nereids_tpcds_shape_sf100_p0/load.groovy 
b/regression-test/suites/nereids_tpcds_shape_sf100_p0/load.groovy
index 169c192a1e..c0b1a736eb 100644
--- a/regression-test/suites/nereids_tpcds_shape_sf100_p0/load.groovy
+++ b/regression-test/suites/nereids_tpcds_shape_sf100_p0/load.groovy
@@ -97,6 +97,17 @@ suite("load") {
         d_current_year char(1)
     )
     DUPLICATE KEY(d_date_sk)
+    PARTITION BY RANGE(d_date_sk)
+    (
+    PARTITION `ppast` values less than("2450815"),
+    PARTITION `p1998` values less than("2451180"),
+    PARTITION `p1999` values less than("2451545"),
+    PARTITION `p2000` values less than("2451911"),
+    PARTITION `p2001` values less than("2452276"),
+    PARTITION `p2002` values less than("2452641"),
+    PARTITION `p2003` values less than("2453006"),
+    PARTITION `pfuture` values less than("9999999")
+    )
     DISTRIBUTED BY HASH(d_date_sk) BUCKETS 12
     PROPERTIES (
     "replication_num" = "1"
@@ -2524,4 +2535,1575 @@ sql """
 alter table store_sales modify column ss_wholesale_cost set stats 
('row_count'='287997024', 'ndv'='100', 'min_value'='1.00', 
'max_value'='100.00', 'avg_size'='1151988096', 'max_size'='1151988096' )
 """
 
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='Y', 
'max_value'='Y', 'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2003-01-01', 
'max_value'='2003-12-31', 'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='1999-01-01', 
'max_value'='1999-12-31', 'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='35793', 
'ndv'='35630', 'num_nulls'='0', 'min_value'='1900-01-02', 
'max_value'='1997-12-31', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2002-01-01', 
'max_value'='2002-12-31', 'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='35065', 
'ndv'='35118', 'num_nulls'='0', 'min_value'='2004-01-01', 
'max_value'='2100-01-01', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2001-01-01', 
'max_value'='2001-12-31', 'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='1998-01-01', 
'max_value'='1998-12-31', 'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='366', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2000-01-01', 
'max_value'='2000-12-31', 'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='35793', 
'ndv'='35428', 'num_nulls'='0', 'min_value'='AAAAAAAAAAAAFCAA', 
'max_value'='AAAAAAAAPPPPECAA', 'data_size'='572688') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='368', 'num_nulls'='0', 'min_value'='AAAAAAAAAAGGFCAA', 
'max_value'='AAAAAAAAPPFGFCAA', 'data_size'='5840') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='AAAAAAAAAAHGFCAA', 
'max_value'='AAAAAAAAPPHGFCAA', 'data_size'='5840') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='AAAAAAAAAANGFCAA', 
'max_value'='AAAAAAAAPPNGFCAA', 'data_size'='5840') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='AAAAAAAAAAKGFCAA', 
'max_value'='AAAAAAAAPPKGFCAA', 'data_size'='5840') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='35065', 
'ndv'='35542', 'num_nulls'='0', 'min_value'='AAAAAAAAAAAHFCAA', 
'max_value'='AAAAAAAAPPPOFCAA', 'data_size'='561040') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='AAAAAAAAAAMGFCAA', 
'max_value'='AAAAAAAAPPLGFCAA', 'data_size'='5840') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='366', 
'ndv'='362', 'num_nulls'='0', 'min_value'='AAAAAAAAAAJGFCAA', 
'max_value'='AAAAAAAAPPIGFCAA', 'data_size'='5856') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451179', 
'data_size'='2920') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451544', 
'data_size'='2920') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452275', 
'data_size'='2920') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='366', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451910', 
'data_size'='2928') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='35065', 
'ndv'='35067', 'num_nulls'='0', 'min_value'='2453006', 'max_value'='2488070', 
'data_size'='280520') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452640', 
'data_size'='2920') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='35793', 
'ndv'='36266', 'num_nulls'='0', 'min_value'='2415022', 'max_value'='2450814', 
'data_size'='286344') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2452641', 'max_value'='2453005', 
'data_size'='2920') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='366', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2614') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='35065', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='250466') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2608') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='35793', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='255663') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2607') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2606') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2606') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2609') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='35793', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='35065', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='366', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='35793', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='366', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='35065', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452245', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451514', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='35793', 
'ndv'='1181', 'num_nulls'='0', 'min_value'='2415021', 'max_value'='2450784', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451880', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452641', 'max_value'='2452975', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452610', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='35065', 
'ndv'='1161', 'num_nulls'='0', 'min_value'='2453006', 'max_value'='2488070', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451149', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='35065', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='35793', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='366', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='413', 
'max_value'='417', 'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='366', 'ndv'='5', 'num_nulls'='0', 'min_value'='401', 
'max_value'='405', 'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='35793', 'ndv'='394', 'num_nulls'='0', 'min_value'='1', 
'max_value'='393', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='393', 
'max_value'='397', 'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='405', 
'max_value'='409', 'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='397', 
'max_value'='401', 'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='409', 
'max_value'='413', 'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='417', 
'max_value'='801', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5375', 'max_value'='5427', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5270', 'max_value'='5322', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5323', 'max_value'='5375', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats 
('row_count'='35793', 'ndv'='5136', 'num_nulls'='0', 'min_value'='1', 
'max_value'='5114', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats 
('row_count'='35065', 'ndv'='5008', 'num_nulls'='0', 'min_value'='5427', 
'max_value'='10436', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='366', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5218', 'max_value'='5270', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5114', 'max_value'='5166', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5166', 'max_value'='5218', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2000', 'max_value'='2000', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1998', 'max_value'='1998', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2002', 'max_value'='2002', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1999', 'max_value'='1999', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='35065', 
'ndv'='97', 'num_nulls'='0', 'min_value'='2004', 'max_value'='2100', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='35793', 
'ndv'='98', 'num_nulls'='0', 'min_value'='1900', 'max_value'='1997', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2001', 'max_value'='2001', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2003', 'max_value'='2003', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='35065', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='366', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='35793', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452275', 'max_value'='2452943', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451910', 'max_value'='2452578', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='35793', 
'ndv'='1186', 'num_nulls'='0', 'min_value'='2415020', 'max_value'='2451117', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452640', 'max_value'='2453308', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451179', 'max_value'='2451847', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='35065', 
'ndv'='1144', 'num_nulls'='0', 'min_value'='2453005', 'max_value'='2488372', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451544', 'max_value'='2452214', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2450814', 'max_value'='2451482', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1188', 'max_value'='1199', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='35793', 
'ndv'='1176', 'num_nulls'='0', 'min_value'='0', 'max_value'='1175', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1176', 'max_value'='1187', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1236', 'max_value'='1247', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='35065', 
'ndv'='1147', 'num_nulls'='0', 'min_value'='1248', 'max_value'='2400', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1212', 'max_value'='1223', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1200', 'max_value'='1211', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1224', 'max_value'='1235', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='35793', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='35065', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='366', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='35793', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='35065', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2001Q1', 
'max_value'='2001Q4', 'data_size'='2190') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='35793', 'ndv'='393', 'num_nulls'='0', 'min_value'='1900Q1', 
'max_value'='1997Q4', 'data_size'='214758') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2002Q1', 
'max_value'='2002Q4', 'data_size'='2190') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='366', 'ndv'='4', 'num_nulls'='0', 'min_value'='2000Q1', 
'max_value'='2000Q4', 'data_size'='2196') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='2004Q1', 
'max_value'='2100Q1', 'data_size'='210390') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2003Q1', 
'max_value'='2003Q4', 'data_size'='2190') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='1998Q1', 
'max_value'='1998Q4', 'data_size'='2190') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='1999Q1', 
'max_value'='1999Q4', 'data_size'='2190') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats 
('row_count'='35793', 'ndv'='394', 'num_nulls'='0', 'min_value'='1', 
'max_value'='393', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='405', 'max_value'='409', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='366', 
'ndv'='5', 'num_nulls'='0', 'min_value'='401', 'max_value'='405', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='397', 'max_value'='401', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='409', 'max_value'='413', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='393', 'max_value'='397', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='413', 'max_value'='417', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='417', 
'max_value'='801', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats 
('row_count'='35793', 'ndv'='35806', 'num_nulls'='0', 'min_value'='2414930', 
'max_value'='2450722', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2451088', 'max_value'='2451452', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2451819', 'max_value'='2452183', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='361', 'num_nulls'='0', 'min_value'='2450723', 'max_value'='2451087', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2452184', 'max_value'='2452548', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2452549', 'max_value'='2452913', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats 
('row_count'='35065', 'ndv'='34991', 'num_nulls'='0', 'min_value'='2452914', 
'max_value'='2487978', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='366', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2451453', 'max_value'='2451818', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452640', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats 
('row_count'='35793', 'ndv'='35878', 'num_nulls'='0', 'min_value'='2414657', 
'max_value'='2450449', 'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='366', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451544', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451910', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2450450', 'max_value'='2450814', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats 
('row_count'='35065', 'ndv'='35076', 'num_nulls'='0', 'min_value'='2452641', 
'max_value'='2487705', 'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451179', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452275', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5270', 'max_value'='5322', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5114', 'max_value'='5166', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5166', 'max_value'='5218', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5375', 'max_value'='5427', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5323', 'max_value'='5375', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='35065', 
'ndv'='5008', 'num_nulls'='0', 'min_value'='5427', 'max_value'='10436', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='35793', 
'ndv'='5136', 'num_nulls'='0', 'min_value'='1', 'max_value'='5114', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='366', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5218', 'max_value'='5270', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='366', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='366') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='35793', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35793') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='35065', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35065') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1999', 'max_value'='1999', 
'data_size'='1460') partition (p1999);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='35793', 
'ndv'='98', 'num_nulls'='0', 'min_value'='1900', 'max_value'='1997', 
'data_size'='143172') partition (ppast);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1998', 'max_value'='1998', 
'data_size'='1460') partition (p1998);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2001', 'max_value'='2001', 
'data_size'='1460') partition (p2001);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2002', 'max_value'='2002', 
'data_size'='1460') partition (p2002);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2000', 'max_value'='2000', 
'data_size'='1464') partition (p2000);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2003', 'max_value'='2003', 
'data_size'='1460') partition (p2003);"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='35065', 
'ndv'='97', 'num_nulls'='0', 'min_value'='2004', 'max_value'='2100', 
'data_size'='140260') partition (pfuture);"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_current_day set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='N', 'max_value'='N', 
'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_current_month set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_current_quarter set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_current_week set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='Y', 
'max_value'='Y', 'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='366', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='365', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='35793', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_current_year set stats 
('row_count'='35065', 'ndv'='1', 'num_nulls'='0', 'min_value'='N', 
'max_value'='N', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2003-01-01', 
'max_value'='2003-12-31', 'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='1999-01-01', 
'max_value'='1999-12-31', 'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='35793', 
'ndv'='35630', 'num_nulls'='0', 'min_value'='1900-01-02', 
'max_value'='1997-12-31', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2002-01-01', 
'max_value'='2002-12-31', 'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='35065', 
'ndv'='35118', 'num_nulls'='0', 'min_value'='2004-01-01', 
'max_value'='2100-01-01', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2001-01-01', 
'max_value'='2001-12-31', 'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='1998-01-01', 
'max_value'='1998-12-31', 'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_date set stats ('row_count'='366', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2000-01-01', 
'max_value'='2000-12-31', 'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='35793', 
'ndv'='35428', 'num_nulls'='0', 'min_value'='AAAAAAAAAAAAFCAA', 
'max_value'='AAAAAAAAPPPPECAA', 'data_size'='572688') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='368', 'num_nulls'='0', 'min_value'='AAAAAAAAAAGGFCAA', 
'max_value'='AAAAAAAAPPFGFCAA', 'data_size'='5840') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='AAAAAAAAAAHGFCAA', 
'max_value'='AAAAAAAAPPHGFCAA', 'data_size'='5840') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='AAAAAAAAAANGFCAA', 
'max_value'='AAAAAAAAPPNGFCAA', 'data_size'='5840') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='AAAAAAAAAAKGFCAA', 
'max_value'='AAAAAAAAPPKGFCAA', 'data_size'='5840') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='35065', 
'ndv'='35542', 'num_nulls'='0', 'min_value'='AAAAAAAAAAAHFCAA', 
'max_value'='AAAAAAAAPPPOFCAA', 'data_size'='561040') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='AAAAAAAAAAMGFCAA', 
'max_value'='AAAAAAAAPPLGFCAA', 'data_size'='5840') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_date_id set stats ('row_count'='366', 
'ndv'='362', 'num_nulls'='0', 'min_value'='AAAAAAAAAAJGFCAA', 
'max_value'='AAAAAAAAPPIGFCAA', 'data_size'='5856') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451179', 
'data_size'='2920') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='366', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451544', 
'data_size'='2920') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452275', 
'data_size'='2920') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='366', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451910', 
'data_size'='2928') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='35065', 
'ndv'='35067', 'num_nulls'='0', 'min_value'='2453006', 'max_value'='2488070', 
'data_size'='280520') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452640', 
'data_size'='2920') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='35793', 
'ndv'='36266', 'num_nulls'='0', 'min_value'='2415022', 'max_value'='2450814', 
'data_size'='286344') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_date_sk set stats ('row_count'='365', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2452641', 'max_value'='2453005', 
'data_size'='2920') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='366', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2614') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='35065', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='250466') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2608') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='35793', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='255663') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2607') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2606') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2606') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_day_name set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='Friday', 'max_value'='Wednesday', 
'data_size'='2609') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='35793', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='35065', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='366', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_dom set stats ('row_count'='365', 
'ndv'='31', 'num_nulls'='0', 'min_value'='1', 'max_value'='31', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='35793', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='365', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='366', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_dow set stats ('row_count'='35065', 
'ndv'='7', 'num_nulls'='0', 'min_value'='0', 'max_value'='6', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452245', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451514', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='35793', 
'ndv'='1181', 'num_nulls'='0', 'min_value'='2415021', 'max_value'='2450784', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451880', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452641', 'max_value'='2452975', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452610', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='35065', 
'ndv'='1161', 'num_nulls'='0', 'min_value'='2453006', 'max_value'='2488070', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_first_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451149', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='35065', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='35793', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='366', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_following_holiday set stats 
('row_count'='365', 'ndv'='2', 'num_nulls'='0', 'min_value'='N', 
'max_value'='Y', 'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='413', 
'max_value'='417', 'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='366', 'ndv'='5', 'num_nulls'='0', 'min_value'='401', 
'max_value'='405', 'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='35793', 'ndv'='394', 'num_nulls'='0', 'min_value'='1', 
'max_value'='393', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='393', 
'max_value'='397', 'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='405', 
'max_value'='409', 'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='397', 
'max_value'='401', 'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='365', 'ndv'='5', 'num_nulls'='0', 'min_value'='409', 
'max_value'='413', 'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_fy_quarter_seq set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='417', 
'max_value'='801', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5375', 'max_value'='5427', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5270', 'max_value'='5322', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5323', 'max_value'='5375', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats 
('row_count'='35793', 'ndv'='5136', 'num_nulls'='0', 'min_value'='1', 
'max_value'='5114', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats 
('row_count'='35065', 'ndv'='5008', 'num_nulls'='0', 'min_value'='5427', 
'max_value'='10436', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='366', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5218', 'max_value'='5270', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5114', 'max_value'='5166', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_fy_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5166', 'max_value'='5218', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2000', 'max_value'='2000', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1998', 'max_value'='1998', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2002', 'max_value'='2002', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1999', 'max_value'='1999', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='35065', 
'ndv'='97', 'num_nulls'='0', 'min_value'='2004', 'max_value'='2100', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='35793', 
'ndv'='98', 'num_nulls'='0', 'min_value'='1900', 'max_value'='1997', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2001', 'max_value'='2001', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_fy_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2003', 'max_value'='2003', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='35065', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='366', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='35793', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_holiday set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452275', 'max_value'='2452943', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451910', 'max_value'='2452578', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='35793', 
'ndv'='1186', 'num_nulls'='0', 'min_value'='2415020', 'max_value'='2451117', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2452640', 'max_value'='2453308', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451179', 'max_value'='2451847', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='35065', 
'ndv'='1144', 'num_nulls'='0', 'min_value'='2453005', 'max_value'='2488372', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2451544', 'max_value'='2452214', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_last_dom set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='2450814', 'max_value'='2451482', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1188', 'max_value'='1199', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='35793', 
'ndv'='1176', 'num_nulls'='0', 'min_value'='0', 'max_value'='1175', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1176', 'max_value'='1187', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1236', 'max_value'='1247', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='35065', 
'ndv'='1147', 'num_nulls'='0', 'min_value'='1248', 'max_value'='2400', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1212', 'max_value'='1223', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1200', 'max_value'='1211', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_month_seq set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1224', 'max_value'='1235', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='35793', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='35065', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='366', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_moy set stats ('row_count'='365', 
'ndv'='12', 'num_nulls'='0', 'min_value'='1', 'max_value'='12', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='366', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='365', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='35793', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_qoy set stats ('row_count'='35065', 
'ndv'='4', 'num_nulls'='0', 'min_value'='1', 'max_value'='4', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2001Q1', 
'max_value'='2001Q4', 'data_size'='2190') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='35793', 'ndv'='393', 'num_nulls'='0', 'min_value'='1900Q1', 
'max_value'='1997Q4', 'data_size'='214758') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2002Q1', 
'max_value'='2002Q4', 'data_size'='2190') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='366', 'ndv'='4', 'num_nulls'='0', 'min_value'='2000Q1', 
'max_value'='2000Q4', 'data_size'='2196') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='2004Q1', 
'max_value'='2100Q1', 'data_size'='210390') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='2003Q1', 
'max_value'='2003Q4', 'data_size'='2190') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='1998Q1', 
'max_value'='1998Q4', 'data_size'='2190') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_name set stats 
('row_count'='365', 'ndv'='4', 'num_nulls'='0', 'min_value'='1999Q1', 
'max_value'='1999Q4', 'data_size'='2190') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats 
('row_count'='35793', 'ndv'='394', 'num_nulls'='0', 'min_value'='1', 
'max_value'='393', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='405', 'max_value'='409', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='366', 
'ndv'='5', 'num_nulls'='0', 'min_value'='401', 'max_value'='405', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='397', 'max_value'='401', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='409', 'max_value'='413', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='393', 'max_value'='397', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats ('row_count'='365', 
'ndv'='5', 'num_nulls'='0', 'min_value'='413', 'max_value'='417', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_quarter_seq set stats 
('row_count'='35065', 'ndv'='387', 'num_nulls'='0', 'min_value'='417', 
'max_value'='801', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats 
('row_count'='35793', 'ndv'='35806', 'num_nulls'='0', 'min_value'='2414930', 
'max_value'='2450722', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2451088', 'max_value'='2451452', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2451819', 'max_value'='2452183', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='361', 'num_nulls'='0', 'min_value'='2450723', 'max_value'='2451087', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2452184', 'max_value'='2452548', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='365', 
'ndv'='362', 'num_nulls'='0', 'min_value'='2452549', 'max_value'='2452913', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats 
('row_count'='35065', 'ndv'='34991', 'num_nulls'='0', 'min_value'='2452914', 
'max_value'='2487978', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_lq set stats ('row_count'='366', 
'ndv'='365', 'num_nulls'='0', 'min_value'='2451453', 'max_value'='2451818', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2452276', 'max_value'='2452640', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats 
('row_count'='35793', 'ndv'='35878', 'num_nulls'='0', 'min_value'='2414657', 
'max_value'='2450449', 'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='366', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2451180', 'max_value'='2451544', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2451545', 'max_value'='2451910', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='364', 'num_nulls'='0', 'min_value'='2450450', 'max_value'='2450814', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats 
('row_count'='35065', 'ndv'='35076', 'num_nulls'='0', 'min_value'='2452641', 
'max_value'='2487705', 'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='363', 'num_nulls'='0', 'min_value'='2450815', 'max_value'='2451179', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_same_day_ly set stats ('row_count'='365', 
'ndv'='367', 'num_nulls'='0', 'min_value'='2451911', 'max_value'='2452275', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5270', 'max_value'='5322', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5114', 'max_value'='5166', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5166', 'max_value'='5218', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5375', 'max_value'='5427', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='365', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5323', 'max_value'='5375', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='35065', 
'ndv'='5008', 'num_nulls'='0', 'min_value'='5427', 'max_value'='10436', 
'data_size'='140260') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='35793', 
'ndv'='5136', 'num_nulls'='0', 'min_value'='1', 'max_value'='5114', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_week_seq set stats ('row_count'='366', 
'ndv'='53', 'num_nulls'='0', 'min_value'='5218', 'max_value'='5270', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='366', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='366') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='35793', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35793') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='35065', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='35065') partition (pfuture);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_weekend set stats ('row_count'='365', 
'ndv'='2', 'num_nulls'='0', 'min_value'='N', 'max_value'='Y', 
'data_size'='365') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1999', 'max_value'='1999', 
'data_size'='1460') partition (p1999);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='35793', 
'ndv'='98', 'num_nulls'='0', 'min_value'='1900', 'max_value'='1997', 
'data_size'='143172') partition (ppast);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='1998', 'max_value'='1998', 
'data_size'='1460') partition (p1998);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2001', 'max_value'='2001', 
'data_size'='1460') partition (p2001);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2002', 'max_value'='2002', 
'data_size'='1460') partition (p2002);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='366', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2000', 'max_value'='2000', 
'data_size'='1464') partition (p2000);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='365', 
'ndv'='1', 'num_nulls'='0', 'min_value'='2003', 'max_value'='2003', 
'data_size'='1460') partition (p2003);
+"""
+
+sql """
+alter table date_dim modify column d_year set stats ('row_count'='35065', 
'ndv'='97', 'num_nulls'='0', 'min_value'='2004', 'max_value'='2100', 
'data_size'='140260') partition (pfuture);
+"""
+
+
+
 }


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org