This is an automated email from the ASF dual-hosted git repository.
joemcdonnell pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
The following commit(s) were added to refs/heads/master by this push:
new eaee02ffd IMPALA-14026: Migrate test files that assert Beeswax dml
result.
eaee02ffd is described below
commit eaee02ffd4346dadf23ae3bf329b2477a7ac40bd
Author: Riza Suminto <[email protected]>
AuthorDate: Sat Mar 29 06:23:25 2025 -0700
IMPALA-14026: Migrate test files that assert Beeswax dml result.
This patch migrate the remaining test file under testdata/ that verify
the beeswax-specific dml result. The RESULTS section is replaced by
RUNTIME_PROFILE section that validates Partition name, NumModifiedRows,
and sum of NumModifiedRows if necessary.
Added HS2_TYPES section where necessary to let tests pass.
Testing:
Pass core tests.
Change-Id: I36efbe66b654a5af6c44710e55d0b755280ad3be
Reviewed-on: http://gerrit.cloudera.org:8080/22846
Reviewed-by: Michael Smith <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Joe McDonnell <[email protected]>
---
.../queries/DataErrorsTest/orc-type-checks.test | 2 +
.../queries/QueryTest/alter-table.test | 35 +-
.../queries/QueryTest/calcite.test | 2 +
.../QueryTest/compute-stats-incremental.test | 11 +-
.../queries/QueryTest/compute-stats.test | 11 +-
.../queries/QueryTest/create-table-like-table.test | 5 +-
.../queries/QueryTest/create-table.test | 12 +-
.../queries/QueryTest/hdfs-caching.test | 8 +-
.../QueryTest/incompatible_avro_partition.test | 6 +
.../functional-query/queries/QueryTest/insert.test | 374 +++--
.../queries/QueryTest/insert_null.test | 30 +-
.../queries/QueryTest/insert_overwrite.test | 44 +-
.../queries/QueryTest/insert_part_key.test | 5 +-
.../queries/QueryTest/insert_permutation.test | 61 +-
.../functional-query/queries/QueryTest/joins.test | 2 +
.../functional-query/queries/QueryTest/load.test | 5 +-
.../queries/QueryTest/partition-col-types.test | 29 +-
.../QueryTest/spilling-regression-exhaustive.test | 4 +
.../tpcds-insert/queries/partitioned-insert.test | 1568 +++++++++++++-------
19 files changed, 1428 insertions(+), 786 deletions(-)
diff --git
a/testdata/workloads/functional-query/queries/DataErrorsTest/orc-type-checks.test
b/testdata/workloads/functional-query/queries/DataErrorsTest/orc-type-checks.test
index 52d8595e6..47547cf7c 100644
---
a/testdata/workloads/functional-query/queries/DataErrorsTest/orc-type-checks.test
+++
b/testdata/workloads/functional-query/queries/DataErrorsTest/orc-type-checks.test
@@ -68,6 +68,8 @@ Type mismatch: table column TIMESTAMP is map to column date
in ORC file
select * from safetypes order by id
---- TYPES
bigint,boolean,smallint,int,bigint,bigint,double,double,char,string,timestamp,int,int
+---- HS2_TYPES
+bigint,boolean,smallint,int,bigint,bigint,double,double,char,varchar,timestamp,int,int
---- RESULTS
0,true,0,0,0,0,0,0,'01/','0',2009-01-01 00:00:00,2009,1
1,false,1,1,1,10,1.100000023841858,10.1,'01/','1',2009-01-01 00:01:00,2009,1
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/alter-table.test
b/testdata/workloads/functional-query/queries/QueryTest/alter-table.test
index 09d28ac20..ebdd2b3e5 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/alter-table.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/alter-table.test
@@ -381,19 +381,22 @@ location
'$FILESYSTEM_PREFIX/test-warehouse/$DATABASE.db/part_data/'
====
---- QUERY
insert overwrite table t_part partition(j=1, s='2012') select 2 from
functional.alltypes limit 2
----- RESULTS
-j=1/s=2012: 2
+---- RUNTIME_PROFILE
+Partition: j=1/s=2012
+NumModifiedRows: 2
====
---- QUERY
insert overwrite table t_part partition(j=1, s='2013') select 3 from
functional.alltypes limit 3
----- RESULTS
-j=1/s=2013: 3
+---- RUNTIME_PROFILE
+Partition: j=1/s=2013
+NumModifiedRows: 3
====
---- QUERY
insert overwrite table t_part partition(j=1, s='2012/withslash')
select 1 from functional.alltypes limit 1
----- RESULTS
-j=1/s=2012%2Fwithslash: 1
+---- RUNTIME_PROFILE
+Partition: j=1/s=2012%2Fwithslash
+NumModifiedRows: 1
====
---- QUERY
# Refresh the table to ensure all partitions have up-to-date list of file and
block
@@ -445,8 +448,9 @@ string
---- QUERY
insert overwrite table t_part partition(j=NULL, s=NULL)
select 4 from functional.alltypes limit 5
----- RESULTS
-j=__HIVE_DEFAULT_PARTITION__/s=__HIVE_DEFAULT_PARTITION__: 5
+---- RUNTIME_PROFILE
+Partition: j=__HIVE_DEFAULT_PARTITION__/s=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 5
====
---- QUERY
select i, j, s from t_part
@@ -468,8 +472,9 @@ int,int,string
---- QUERY
insert overwrite table t_part partition(j=NULL, s='2013')
select 5 from functional.alltypes limit 5
----- RESULTS
-j=__HIVE_DEFAULT_PARTITION__/s=2013: 5
+---- RUNTIME_PROFILE
+Partition: j=__HIVE_DEFAULT_PARTITION__/s=2013
+NumModifiedRows: 5
====
---- QUERY
select i, j, s from t_part
@@ -572,16 +577,18 @@ int,int,string
# using static partition insert
insert into table t_part partition(j=2, s='')
select 1 from functional.alltypes limit 1
----- RESULTS
-j=2/s=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: j=2/s=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# Test that empty string as partition column maps onto NULL
# using dynamic partition insert
insert into table t_part partition(j=2, s)
select 10, '' from functional.alltypes limit 1
----- RESULTS
-j=2/s=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: j=2/s=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# Validate the previous inserts
diff --git a/testdata/workloads/functional-query/queries/QueryTest/calcite.test
b/testdata/workloads/functional-query/queries/QueryTest/calcite.test
index 0279778e1..e90dc03d3 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/calcite.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/calcite.test
@@ -66,6 +66,8 @@ select * from functional.chars_tiny;
---- TYPES
# varchar shows up as string, just as it does in the chars.test file
char,char,string
+---- HS2_TYPES
+char,char,varchar
---- RUNTIME_PROFILE
row_regex: .*PlannerType: CalcitePlanner.*
====
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/compute-stats-incremental.test
b/testdata/workloads/functional-query/queries/QueryTest/compute-stats-incremental.test
index 6a8b90740..4e8400e6d 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/compute-stats-incremental.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/compute-stats-incremental.test
@@ -537,10 +537,13 @@ cast(year as char(5)),
cast(day as varchar(13))
from functional.alltypesagg
where day is null or day in (3, 7);
----- RESULTS: VERIFY_IS_EQUAL_SORTED
-year=2010 /day=7: 1000
-year=2010 /day=3: 1000
-year=2010 /day=__HIVE_DEFAULT_PARTITION__: 1000
+---- RUNTIME_PROFILE
+Partition: year=2010 /day=3
+NumModifiedRows: 1000
+Partition: year=2010 /day=7
+NumModifiedRows: 1000
+Partition: year=2010 /day=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1000
====
---- QUERY
compute incremental stats chars_tbl
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
b/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
index 22e58bc14..2f5ed1f5d 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
@@ -782,10 +782,13 @@ cast(year as char(5)),
cast(day as varchar(13))
from functional.alltypesagg
where day is null or day in (3, 7);
----- RESULTS: VERIFY_IS_EQUAL_SORTED
-year=2010 /day=7: 1000
-year=2010 /day=3: 1000
-year=2010 /day=__HIVE_DEFAULT_PARTITION__: 1000
+---- RUNTIME_PROFILE
+Partition: year=2010 /day=3
+NumModifiedRows: 1000
+Partition: year=2010 /day=7
+NumModifiedRows: 1000
+Partition: year=2010 /day=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1000
====
---- QUERY
compute stats chars_tbl
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/create-table-like-table.test
b/testdata/workloads/functional-query/queries/QueryTest/create-table-like-table.test
index c9f7c5f6a..223ca9eea 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/create-table-like-table.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/create-table-like-table.test
@@ -21,8 +21,9 @@ partition (year=2009, month=4)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypes where year=2009 and month=4
----- RESULTS
-year=2009/month=4: 300
+---- RUNTIME_PROFILE
+Partition: year=2009/month=4
+NumModifiedRows: 300
====
---- QUERY
# Make sure we can read the new data.
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/create-table.test
b/testdata/workloads/functional-query/queries/QueryTest/create-table.test
index 22add51ed..d53404436 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/create-table.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/create-table.test
@@ -71,14 +71,16 @@ STRING, STRING, STRING
---- QUERY
insert overwrite table $DATABASE.testtbl_part partition(id=1)
select 10, 'Ten' from functional.alltypes limit 1
----- RESULTS
-id=1: 1
+---- RUNTIME_PROFILE
+Partition: id=1
+NumModifiedRows: 1
====
---- QUERY
insert overwrite table $DATABASE.testtbl_part partition(id=2)
select 20, 'Twenty' from functional.alltypes limit 2
----- RESULTS
-id=2: 2
+---- RUNTIME_PROFILE
+Partition: id=2
+NumModifiedRows: 2
====
---- QUERY
select * from $DATABASE.testtbl_part
@@ -288,6 +290,8 @@ from $DATABASE.struct_keywords t, t.a, t.m
---- RESULTS
---- TYPES
INT, STRING, DECIMAL, BOOLEAN, STRING, STRING, INT, TIMESTAMP, INT, INT
+---- HS2_TYPES
+INT, STRING, DECIMAL, BOOLEAN, VARCHAR, STRING, INT, TIMESTAMP, INT, INT
====
---- QUERY
# Make sure that specifying sort columns sets the 'sort.columns' property
correctly.
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/hdfs-caching.test
b/testdata/workloads/functional-query/queries/QueryTest/hdfs-caching.test
index c00cad202..e6c2261fe 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/hdfs-caching.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/hdfs-caching.test
@@ -147,9 +147,11 @@ STRING, BIGINT, BIGINT, STRING, STRING, STRING, STRING,
STRING, STRING, STRING
---- QUERY
# dynamic partition insert inherits table properties
insert into cached_tbl_part partition(j) values(3, 3), (4, 4);
----- RESULTS
-j=3: 1
-j=4: 1
+---- RUNTIME_PROFILE
+Partition: j=3
+Partition: j=4
+NumModifiedRows: 1
+aggregation(SUM, RowsInserted): 2
====
---- QUERY
# Modify partition cache replication
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/incompatible_avro_partition.test
b/testdata/workloads/functional-query/queries/QueryTest/incompatible_avro_partition.test
index 23f7abc1b..77e3b2dc9 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/incompatible_avro_partition.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/incompatible_avro_partition.test
@@ -33,6 +33,8 @@ alter table mixed partition (part = 2) set fileformat avro;
select * from mixed;
---- TYPES
int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
string, int
+---- HS2_TYPES
+int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
varchar, int
---- RESULTS
1,false,2,3,4,5,6,7,'1985-07-15','c2','my va',1
====
@@ -42,6 +44,8 @@ invalidate metadata mixed;
select * from mixed;
---- TYPES
int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
string, int
+---- HS2_TYPES
+int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
varchar, int
---- RESULTS
1,false,2,3,4,5,6,7,'1985-07-15','c2','my va',1
====
@@ -62,5 +66,7 @@ Unresolvable types for column 'tinyint_col': declared column
type: TINYINT, tabl
select * from mixed where part = 1;
---- TYPES
int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
string, int
+---- HS2_TYPES
+int, boolean, tinyint, smallint, int, bigint, float, double, string, char,
varchar, int
---- RESULTS
1,false,2,3,4,5,6,7,'1985-07-15','c2','my va',1
diff --git a/testdata/workloads/functional-query/queries/QueryTest/insert.test
b/testdata/workloads/functional-query/queries/QueryTest/insert.test
index 19d5ca99b..f361b4fb2 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/insert.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/insert.test
@@ -77,8 +77,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=4
+NumModifiedRows: 25
====
---- QUERY
# search the overwritten partition to verify the results
@@ -124,8 +125,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=4
+NumModifiedRows: 25
====
---- QUERY
# search the partition to verify it contains all 25 rows
@@ -145,10 +147,12 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, month
from functional.alltypessmall
where year=2009 and month>1 and month<=4
----- RESULTS
-year=2009/month=2: 25
-year=2009/month=3: 25
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 75
====
---- QUERY
# search the overwritten partition to verify the results
@@ -244,10 +248,12 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, month
from functional.alltypessmall
where year=2009 and month>=1 and month<4
----- RESULTS
-year=2009/month=1: 25
-year=2009/month=2: 25
-year=2009/month=3: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 75
====
---- QUERY
# search the partitions to verify they contain all 75 rows
@@ -265,11 +271,13 @@ partition (year, month)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from functional.alltypessmall
----- RESULTS
-year=2009/month=1: 25
-year=2009/month=2: 25
-year=2009/month=3: 25
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 100
====
---- QUERY
# search the overwritten partition to verify the results
@@ -389,11 +397,13 @@ partition (year, month)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from functional.alltypessmall
----- RESULTS
-year=2009/month=1: 25
-year=2009/month=2: 25
-year=2009/month=3: 25
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 100
====
---- QUERY
# search the partitions to verify they contain all 100 rows
@@ -408,11 +418,13 @@ bigint
# test insert into ... select *
truncate alltypesinsert;
insert into alltypesinsert partition(year, month) select * from
functional.alltypessmall
----- RESULTS
-year=2009/month=1: 25
-year=2009/month=2: 25
-year=2009/month=3: 25
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 100
====
---- QUERY
# check size of alltypesinsert to ensure previous insert worked
@@ -426,8 +438,9 @@ bigint
# static partition insert into string-partitioned table with special
characters in partition key
truncate insert_string_partitioned;
INSERT INTO TABLE insert_string_partitioned PARTITION(s2="/\%.") SELECT
"value" FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=%2F%5C%25.: 1
+---- RUNTIME_PROFILE
+Partition: s2=%2F%5C%25.
+NumModifiedRows: 1
====
---- QUERY
# select with unencoded partition key
@@ -469,8 +482,9 @@ STRING, STRING
truncate insert_string_partitioned;
INSERT INTO TABLE insert_string_partitioned PARTITION(s2="_.~ +")
SELECT "value" FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=_.~ +: 1
+---- RUNTIME_PROFILE
+Partition: s2=_.~ +
+NumModifiedRows: 1
====
---- QUERY
# select with unencoded partition key
@@ -485,29 +499,33 @@ string, string
truncate insert_string_partitioned;
INSERT INTO TABLE insert_string_partitioned PARTITION(s2='')
SELECT "value1" FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: s2=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# dynamic partition insert into string-partitioned table with empty partition
key
INSERT INTO TABLE insert_string_partitioned PARTITION(s2)
SELECT "value2","" FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: s2=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# static partition insert into string-partitioned table with NULL partition key
INSERT INTO TABLE insert_string_partitioned PARTITION(s2=NULL)
SELECT "value3" FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: s2=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# dynamic partition insert into string-partitioned table with NULL partition
key
INSERT INTO TABLE insert_string_partitioned PARTITION(s2)
SELECT "value4",NULL FROM functional.alltypessmall LIMIT 1;
----- RESULTS
-s2=__HIVE_DEFAULT_PARTITION__: 1
+---- RUNTIME_PROFILE
+Partition: s2=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 1
====
---- QUERY
# select with empty partition key as predicate should return nothing, because
"" is
@@ -535,8 +553,9 @@ truncate alltypesinsert;
insert into alltypesinsert partition(year=cast(100*20+10 as int),
month=cast(2*2 as int))
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col,
double_col, date_string_col, string_col, timestamp_col from
functional.alltypessmall where month = 4
----- RESULTS
-year=2010/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2010/month=4
+NumModifiedRows: 25
====
---- QUERY
# static partition insert from a constant select
@@ -545,8 +564,9 @@ insert into alltypesinsert
partition(year=2010, month=4)
select 100, false, 1, 1, 1, 10,
10.0, 10.0, "02/01/09", "1", cast("2009-02-01 00:01:00" as timestamp)
----- RESULTS
-year=2010/month=4: 1
+---- RUNTIME_PROFILE
+Partition: year=2010/month=4
+NumModifiedRows: 1
====
---- QUERY
# dynamic partition insert from a constant select
@@ -554,8 +574,9 @@ insert into table alltypesinsert
partition (year, month)
select 200, true, 2, 2, 2, 20,
20.0, 20.0, "02/01/09", "1", cast("2009-02-01 00:02:00" as timestamp), 2010, 4
----- RESULTS
-year=2010/month=4: 1
+---- RUNTIME_PROFILE
+Partition: year=2010/month=4
+NumModifiedRows: 1
====
---- QUERY
# verify contents of alltypesinsert
@@ -574,8 +595,9 @@ partition(year=2010, month=4) values
(1, false, 1, 1, 1, 10, NULL, 10.0, "02/01/09", "1", cast("2009-02-01
00:01:00" as timestamp)),
(2, true, 2, NULL, 2, 20, 20.0, 20.0, "02/02/09", "2", NULL),
(3, false, 3, 3, 3, 30, 30.0, 30.0, "02/03/09", NULL, cast("2009-02-03
00:01:00" as timestamp))
----- RESULTS
-year=2010/month=4: 3
+---- RUNTIME_PROFILE
+Partition: year=2010/month=4
+NumModifiedRows: 3
====
---- QUERY
# dynamic partition insert from values statement
@@ -584,9 +606,11 @@ partition (year, month) values
(4, true, 4, 4, 4, 40, NULL, 40.0, "02/04/09", "4", cast("2009-02-04 00:01:00"
as timestamp), 2010, 4),
(5, false, 5, NULL, 5, 50, 50.0, 50.0, "02/05/09", "5", NULL, 2010, 8),
(6, true, 6, 6, 6, 60, 60.0, 60.0, "02/06/09", NULL, cast("2009-02-06
00:01:00" as timestamp), 2010, 8)
----- RESULTS
-year=2010/month=4: 1
-year=2010/month=8: 2
+---- RUNTIME_PROFILE
+Partition: year=2010/month=4
+NumModifiedRows: 1
+Partition: year=2010/month=8
+NumModifiedRows: 2
====
---- QUERY
# verify contents of alltypesinsert
@@ -606,11 +630,13 @@ INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT,
DOUBLE, STRING, STRING, TIM
truncate alltypesinsert;
with t1 as (select * from functional.alltypestiny)
insert into alltypesinsert partition(year, month) select * from t1
----- RESULTS
-year=2009/month=1: 2
-year=2009/month=2: 2
-year=2009/month=3: 2
-year=2009/month=4: 2
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 2
+aggregation(SUM, RowsInserted): 8
====
---- QUERY
# Test with clause in an insert statement and in its query statement.
@@ -619,11 +645,13 @@ with t1 as (select * from functional.alltypestiny)
insert into alltypesinsert partition(year, month)
with t2 as (select * from functional.alltypestiny)
select * from t1 union all select * from t2
----- RESULTS
-year=2009/month=1: 4
-year=2009/month=2: 4
-year=2009/month=3: 4
-year=2009/month=4: 4
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 4
+aggregation(SUM, RowsInserted): 16
====
---- QUERY
# Test inserting NULLs for all types
@@ -713,15 +741,17 @@ sum(bigint_col) over(order by string_col),
float_col, double_col, date_string_col, string_col, timestamp_col,
int_col, month
from functional.alltypestiny
----- RESULTS: VERIFY_IS_EQUAL_SORTED
-year=0/month=1: 1
-year=0/month=2: 1
-year=0/month=3: 1
-year=0/month=4: 1
-year=1/month=1: 1
-year=1/month=2: 1
-year=1/month=3: 1
-year=1/month=4: 1
+---- RUNTIME_PROFILE
+Partition: year=0/month=1
+Partition: year=0/month=2
+Partition: year=0/month=3
+Partition: year=0/month=4
+Partition: year=1/month=1
+Partition: year=1/month=2
+Partition: year=1/month=3
+Partition: year=1/month=4
+NumModifiedRows: 1
+aggregation(SUM, RowsInserted): 8
====
---- QUERY
# IMPALA-2203: Test insert from a select statement that has outer-joined
inline views with
@@ -739,8 +769,9 @@ full outer join
cast("2009-02-06 00:01:00" as timestamp) timestamp_col
from functional.alltypestiny where id between 1 and 3) b
on (a.id = b.id)
----- RESULTS: VERIFY_IS_EQUAL_SORTED
-year=2015/month=8: 4
+---- RUNTIME_PROFILE
+Partition: year=2015/month=8
+NumModifiedRows: 4
====
---- QUERY
select * from alltypesinsert
@@ -780,8 +811,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=4
+NumModifiedRows: 25
====
---- QUERY
# search the overwritten partition to verify the results
@@ -827,11 +859,13 @@ partition (year, month)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from functional.alltypessmall
----- RESULTS
-year=2009/month=1: 25
-year=2009/month=2: 25
-year=2009/month=3: 25
-year=2009/month=4: 25
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 25
+aggregation(SUM, RowsInserted): 100
====
---- QUERY
# search the partitions to verify they contain all 100 rows
@@ -848,31 +882,35 @@ truncate alltypesinsert;
insert into table alltypesinsert
partition (year, month) /*+ noclustered,shuffle */
select * from functional.alltypes;
----- RESULTS
-year=2009/month=1: 310
-year=2009/month=10: 310
-year=2009/month=11: 300
-year=2009/month=12: 310
-year=2009/month=2: 280
-year=2009/month=3: 310
-year=2009/month=4: 300
-year=2009/month=5: 310
-year=2009/month=6: 300
-year=2009/month=7: 310
-year=2009/month=8: 310
-year=2009/month=9: 300
-year=2010/month=1: 310
-year=2010/month=10: 310
-year=2010/month=11: 300
-year=2010/month=12: 310
-year=2010/month=2: 280
-year=2010/month=3: 310
-year=2010/month=4: 300
-year=2010/month=5: 310
-year=2010/month=6: 300
-year=2010/month=7: 310
-year=2010/month=8: 310
-year=2010/month=9: 300
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=10
+Partition: year=2009/month=11
+Partition: year=2009/month=12
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+Partition: year=2009/month=5
+Partition: year=2009/month=6
+Partition: year=2009/month=7
+Partition: year=2009/month=8
+Partition: year=2009/month=9
+Partition: year=2010/month=1
+Partition: year=2010/month=10
+Partition: year=2010/month=11
+Partition: year=2010/month=12
+Partition: year=2010/month=2
+Partition: year=2010/month=3
+Partition: year=2010/month=4
+Partition: year=2010/month=5
+Partition: year=2010/month=6
+Partition: year=2010/month=7
+Partition: year=2010/month=8
+Partition: year=2010/month=9
+NumModifiedRows: 280
+NumModifiedRows: 300
+NumModifiedRows: 310
+aggregation(SUM, RowsInserted): 7300
====
---- QUERY
# IMPALA-5293: noclustered insert into table
@@ -880,11 +918,13 @@ truncate alltypesinsert;
insert into table alltypesinsert
partition (year, month) /*+ noclustered,shuffle */
select * from functional.alltypestiny;
----- RESULTS
-year=2009/month=1: 2
-year=2009/month=2: 2
-year=2009/month=3: 2
-year=2009/month=4: 2
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 2
+aggregation(SUM, RowsInserted): 8
====
---- QUERY
# IMPALA-5293: noclustered insert into table
@@ -892,11 +932,13 @@ truncate alltypesinsert;
insert into table alltypesinsert
partition (year, month) /*+ noclustered,noshuffle */
select * from functional.alltypestiny;
----- RESULTS
-year=2009/month=1: 2
-year=2009/month=2: 2
-year=2009/month=3: 2
-year=2009/month=4: 2
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 2
+aggregation(SUM, RowsInserted): 8
====
---- QUERY
# IMPALA-5293: noclustered insert into table
@@ -904,11 +946,13 @@ truncate alltypesinsert;
insert into table alltypesinsert
partition (year, month) /*+ noclustered,shuffle */
select * from functional.alltypestiny where int_col = 0;
----- RESULTS
-year=2009/month=1: 1
-year=2009/month=2: 1
-year=2009/month=3: 1
-year=2009/month=4: 1
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+NumModifiedRows: 1
+aggregation(SUM, RowsInserted): 4
====
---- QUERY
# IMPALA-5293: noclustered, unpartitioned insert into table
@@ -928,38 +972,43 @@ select v.id, t1.id, t1.month from
(select coalesce(id, 10) id from functional.alltypessmall) v
right outer join functional.alltypestiny t1 on t1.id = v.id
where v.id = 0
----- RESULTS
-year=0/month=1: 1
+---- RUNTIME_PROFILE
+Partition: year=0/month=1
+NumModifiedRows: 1
====
---- QUERY
# IMPALA-10233: Inserting to a partitioned table with zorder should work.
create table partitioned_zorder_tbl sort by zorder (id, string_col) like
$ORIGINAL_DB.alltypes;
insert into partitioned_zorder_tbl partition (year, month) select * from
functional.alltypes;
----- RESULTS
-year=2009/month=1: 310
-year=2009/month=10: 310
-year=2009/month=11: 300
-year=2009/month=12: 310
-year=2009/month=2: 280
-year=2009/month=3: 310
-year=2009/month=4: 300
-year=2009/month=5: 310
-year=2009/month=6: 300
-year=2009/month=7: 310
-year=2009/month=8: 310
-year=2009/month=9: 300
-year=2010/month=1: 310
-year=2010/month=10: 310
-year=2010/month=11: 300
-year=2010/month=12: 310
-year=2010/month=2: 280
-year=2010/month=3: 310
-year=2010/month=4: 300
-year=2010/month=5: 310
-year=2010/month=6: 300
-year=2010/month=7: 310
-year=2010/month=8: 310
-year=2010/month=9: 300
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+Partition: year=2009/month=10
+Partition: year=2009/month=11
+Partition: year=2009/month=12
+Partition: year=2009/month=2
+Partition: year=2009/month=3
+Partition: year=2009/month=4
+Partition: year=2009/month=5
+Partition: year=2009/month=6
+Partition: year=2009/month=7
+Partition: year=2009/month=8
+Partition: year=2009/month=9
+Partition: year=2010/month=1
+Partition: year=2010/month=10
+Partition: year=2010/month=11
+Partition: year=2010/month=12
+Partition: year=2010/month=2
+Partition: year=2010/month=3
+Partition: year=2010/month=4
+Partition: year=2010/month=5
+Partition: year=2010/month=6
+Partition: year=2010/month=7
+Partition: year=2010/month=8
+Partition: year=2010/month=9
+NumModifiedRows: 280
+NumModifiedRows: 300
+NumModifiedRows: 310
+aggregation(SUM, RowsInserted): 7300
====
---- QUERY
# IMPALA-10233: Inserting to a partitioned table with zorder should work.
@@ -967,19 +1016,23 @@ insert overwrite partitioned_zorder_tbl
partition(year=2010, month)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, month
from functional.alltypes
where year = 2010
----- RESULTS
-year=2010/month=1: 310
-year=2010/month=10: 310
-year=2010/month=11: 300
-year=2010/month=12: 310
-year=2010/month=2: 280
-year=2010/month=3: 310
-year=2010/month=4: 300
-year=2010/month=5: 310
-year=2010/month=6: 300
-year=2010/month=7: 310
-year=2010/month=8: 310
-year=2010/month=9: 300
+---- RUNTIME_PROFILE
+Partition: year=2010/month=1
+Partition: year=2010/month=10
+Partition: year=2010/month=11
+Partition: year=2010/month=12
+Partition: year=2010/month=2
+Partition: year=2010/month=3
+Partition: year=2010/month=4
+Partition: year=2010/month=5
+Partition: year=2010/month=6
+Partition: year=2010/month=7
+Partition: year=2010/month=8
+Partition: year=2010/month=9
+NumModifiedRows: 280
+NumModifiedRows: 300
+NumModifiedRows: 310
+aggregation(SUM, RowsInserted): 3650
====
---- QUERY
# IMPALA-10233: Inserting to a partitioned table with zorder should work.
@@ -987,6 +1040,7 @@ insert overwrite partitioned_zorder_tbl
partition(year=2010, month=1)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypes
where year = 2010 and month = 1
----- RESULTS
-year=2010/month=1: 310
+---- RUNTIME_PROFILE
+Partition: year=2010/month=1
+NumModifiedRows: 310
====
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/insert_null.test
b/testdata/workloads/functional-query/queries/QueryTest/insert_null.test
index b9e3ac1c7..1f18b4e8b 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/insert_null.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/insert_null.test
@@ -47,8 +47,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=__HIVE_DEFAULT_PARTITION__/month=__HIVE_DEFAULT_PARTITION__: 25
+---- RUNTIME_PROFILE
+Partition: year=__HIVE_DEFAULT_PARTITION__/month=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 25
====
---- QUERY
# Verify contents of alltypesinsert.
@@ -75,8 +76,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=__HIVE_DEFAULT_PARTITION__/month=10: 25
+---- RUNTIME_PROFILE
+Partition: year=__HIVE_DEFAULT_PARTITION__/month=10
+NumModifiedRows: 25
====
---- QUERY
# Verify contents of alltypesinsert.
@@ -95,8 +97,9 @@ select id, bool_col, tinyint_col, smallint_col, int_col,
bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS
-year=2008/month=__HIVE_DEFAULT_PARTITION__: 25
+---- RUNTIME_PROFILE
+Partition: year=2008/month=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 25
====
---- QUERY
# Verify contents of alltypesinsert.
@@ -115,11 +118,16 @@ float_col, double_col, date_string_col, string_col,
timestamp_col,
cast(if(bool_col, NULL, 2007) as int) as year, cast(if(tinyint_col % 3 = 0,
NULL, 6) as int) as month
from functional.alltypessmall
where year=2009 and month=4
----- RESULTS: VERIFY_IS_EQUAL_SORTED
-year=2007/month=6: 8
-year=2007/month=__HIVE_DEFAULT_PARTITION__: 5
-year=__HIVE_DEFAULT_PARTITION__/month=6: 7
-year=__HIVE_DEFAULT_PARTITION__/month=__HIVE_DEFAULT_PARTITION__: 5
+---- RUNTIME_PROFILE
+Partition: year=2007/month=6
+NumModifiedRows: 8
+Partition: year=2007/month=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 5
+Partition: year=__HIVE_DEFAULT_PARTITION__/month=6
+NumModifiedRows: 7
+Partition: year=__HIVE_DEFAULT_PARTITION__/month=__HIVE_DEFAULT_PARTITION__
+NumModifiedRows: 5
+aggregation(SUM, RowsInserted): 25
====
---- QUERY
# Verify contents of each new partition in alltypesinsert.
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/insert_overwrite.test
b/testdata/workloads/functional-query/queries/QueryTest/insert_overwrite.test
index fb8ffd066..3c1caf7bf 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/insert_overwrite.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/insert_overwrite.test
@@ -80,8 +80,9 @@ insert overwrite table insert_overwrite_partitioned
PARTITION(col2=5)
select int_col
from functional.tinyinttable
----- RESULTS
-col2=5: 10
+---- RUNTIME_PROFILE
+Partition: col2=5
+NumModifiedRows: 10
====
---- QUERY
# Check results of previous insert
@@ -108,8 +109,9 @@ insert overwrite table insert_overwrite_partitioned
PARTITION(col2=6)
select int_col
from functional.tinyinttable
----- RESULTS
-col2=6: 10
+---- RUNTIME_PROFILE
+Partition: col2=6
+NumModifiedRows: 10
====
---- QUERY
# Check results of previous insert
@@ -146,8 +148,9 @@ int,int
insert overwrite table insert_overwrite_partitioned
partition(col2=5)
select 10 from functional.tinyinttable
----- RESULTS
-col2=5: 10
+---- RUNTIME_PROFILE
+Partition: col2=5
+NumModifiedRows: 10
====
---- QUERY
# Confirm that one partition is still intact
@@ -183,17 +186,19 @@ insert overwrite table insert_overwrite_partitioned
partition(col2)
select int_col, int_col
from functional.tinyinttable
----- RESULTS
-col2=0: 1
-col2=1: 1
-col2=2: 1
-col2=3: 1
-col2=4: 1
-col2=5: 1
-col2=6: 1
-col2=7: 1
-col2=8: 1
-col2=9: 1
+---- RUNTIME_PROFILE
+Partition: col2=0
+Partition: col2=1
+Partition: col2=2
+Partition: col2=3
+Partition: col2=4
+Partition: col2=5
+Partition: col2=6
+Partition: col2=7
+Partition: col2=8
+Partition: col2=9
+NumModifiedRows: 1
+aggregation(SUM, RowsInserted): 10
====
---- QUERY
# Confirm results of previous insert
@@ -221,8 +226,9 @@ insert overwrite table insert_overwrite_partitioned
partition(col2)
select 10, 0 from functional.tinyinttable
where int_col = 0
----- RESULTS
-col2=0: 1
+---- RUNTIME_PROFILE
+Partition: col2=0
+NumModifiedRows: 1
====
---- QUERY
select col1, col2
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/insert_part_key.test
b/testdata/workloads/functional-query/queries/QueryTest/insert_part_key.test
index 988a05553..bad463dea 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/insert_part_key.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/insert_part_key.test
@@ -14,6 +14,7 @@ ALTER TABLE functional.insert_partition_key_type_promotion
ADD PARTITION(p=1025)
ALTER TABLE functional.insert_partition_key_type_promotion ADD
PARTITION(p=2049);
# Will fail pre IMPALA-875
INSERT INTO functional.insert_partition_key_type_promotion PARTITION(p=1)
VALUES(1)
----- RESULTS
-p=1: 1
+---- RUNTIME_PROFILE
+Partition: p=1
+NumModifiedRows: 1
====
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/insert_permutation.test
b/testdata/workloads/functional-query/queries/QueryTest/insert_permutation.test
index 7fba6b9af..6d8b34ff3 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/insert_permutation.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/insert_permutation.test
@@ -63,8 +63,9 @@ INT,STRING,INT
truncate insert_permutation_test.perm_part;
# Permute the partition columns
insert into perm_part(p1, string_col, int_col1, p2) values(10,'str',1, 'hello')
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -77,8 +78,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Same thing - permute the partition columns, but invert their order relative
to Hive
insert into perm_part(p2, string_col, int_col1, p1) values('hello','str',1, 10)
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -91,8 +93,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check NULL if only partition keys are mentioned
insert into perm_part(p2, p1) values('hello', 10)
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -105,8 +108,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check NULL if only partition keys are mentioned, one static
insert into perm_part(p2) PARTITION(p1=10) values('hello')
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -120,8 +124,9 @@ truncate insert_permutation_test.perm_part;
# Check dynamic keys mentioned in the PARTITION column are still looked for at
the end of
# the select-list
insert into perm_part(int_col1, string_col) PARTITION(p1=10, p2)
values(1,'perm_col','part_col')
----- RESULTS
-p1=10/p2=part_col: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=part_col
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -134,8 +139,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check behaviour of empty permutation clause with no query statement
insert into perm_part() PARTITION(p1=10, p2='foo')
----- RESULTS
-p1=10/p2=foo: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=foo
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -148,8 +154,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check behaviour of empty permutation clause
insert into perm_part() PARTITION(p1, p2='foo') values(5)
----- RESULTS
-p1=5/p2=foo: 1
+---- RUNTIME_PROFILE
+Partition: p1=5/p2=foo
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -176,8 +183,9 @@ INT,STRING,INT
# Test inserting NULLs due to an incomplete column mapping into a Parquet
table.
# Regression test against IMPALA-671.
insert into parquet_part() partition(p1, p2='foo') values(2)
----- RESULTS
-p1=2/p2=foo: 1
+---- RUNTIME_PROFILE
+Partition: p1=2/p2=foo
+NumModifiedRows: 1
====
---- QUERY
select * from parquet_part
@@ -233,8 +241,9 @@ INT,STRING,INT
truncate insert_permutation_test.perm_part;
# Permute the partition columns
insert into perm_part(p1, string_col, int_col1, p2) select 10,'str',1, 'hello'
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -247,9 +256,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Same thing - permute the partition columns, but invert their order relative
to Hive
insert into perm_part(p2, string_col, int_col1, p1) select 'hello','str',1, 10
-
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -262,8 +271,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check NULL if only partition keys are mentioned
insert into perm_part(p2, p1) select 'hello', 10
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
@@ -276,8 +286,9 @@ INT,STRING,INT,STRING
truncate insert_permutation_test.perm_part;
# Check NULL if only partition keys are mentioned, one static
insert into perm_part(p2) PARTITION(p1=10) select 'hello'
----- RESULTS
-p1=10/p2=hello: 1
+---- RUNTIME_PROFILE
+Partition: p1=10/p2=hello
+NumModifiedRows: 1
====
---- QUERY
select * from perm_part
diff --git a/testdata/workloads/functional-query/queries/QueryTest/joins.test
b/testdata/workloads/functional-query/queries/QueryTest/joins.test
index af6f918c1..0027b9e69 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/joins.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/joins.test
@@ -194,6 +194,8 @@ limit 6
20,NULL,NULL
---- TYPES
int, tinyint, null
+---- HS2_TYPES
+int, tinyint, boolean
====
---- QUERY
# check cross joins within a subquery
diff --git a/testdata/workloads/functional-query/queries/QueryTest/load.test
b/testdata/workloads/functional-query/queries/QueryTest/load.test
index 28b71ee89..82e7242c1 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/load.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/load.test
@@ -18,8 +18,9 @@ insert overwrite table functional.test_load partition
(year=2009, month=1)
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col
from functional.alltypes where year = 2009 and month = 1
----- RESULTS
-year=2009/month=1: 310
+---- RUNTIME_PROFILE
+Partition: year=2009/month=1
+NumModifiedRows: 310
====
---- QUERY
select count(*) from functional.test_load
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/partition-col-types.test
b/testdata/workloads/functional-query/queries/QueryTest/partition-col-types.test
index 9d1610e47..8b1ff8803 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/partition-col-types.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/partition-col-types.test
@@ -36,17 +36,19 @@ SELECT id, tinyint_col, smallint_col, int_col, bigint_col,
0.0, 1.1, string_col
FROM functional.alltypes
WHERE id >= 0 and id < 10;
----- RESULTS
-tinyint_col=8/smallint_col=8/int_col=8/bigint_col=80/float_col=0/double_col=1.1/string_col=8:
1
-tinyint_col=9/smallint_col=9/int_col=9/bigint_col=90/float_col=0/double_col=1.1/string_col=9:
1
-tinyint_col=2/smallint_col=2/int_col=2/bigint_col=20/float_col=0/double_col=1.1/string_col=2:
1
-tinyint_col=3/smallint_col=3/int_col=3/bigint_col=30/float_col=0/double_col=1.1/string_col=3:
1
-tinyint_col=5/smallint_col=5/int_col=5/bigint_col=50/float_col=0/double_col=1.1/string_col=5:
1
-tinyint_col=6/smallint_col=6/int_col=6/bigint_col=60/float_col=0/double_col=1.1/string_col=6:
1
-tinyint_col=4/smallint_col=4/int_col=4/bigint_col=40/float_col=0/double_col=1.1/string_col=4:
1
-tinyint_col=7/smallint_col=7/int_col=7/bigint_col=70/float_col=0/double_col=1.1/string_col=7:
1
-tinyint_col=0/smallint_col=0/int_col=0/bigint_col=0/float_col=0/double_col=1.1/string_col=0:
1
-tinyint_col=1/smallint_col=1/int_col=1/bigint_col=10/float_col=0/double_col=1.1/string_col=1:
1
+---- RUNTIME_PROFILE
+Partition:
tinyint_col=8/smallint_col=8/int_col=8/bigint_col=80/float_col=0/double_col=1.1/string_col=8
+Partition:
tinyint_col=9/smallint_col=9/int_col=9/bigint_col=90/float_col=0/double_col=1.1/string_col=9
+Partition:
tinyint_col=2/smallint_col=2/int_col=2/bigint_col=20/float_col=0/double_col=1.1/string_col=2
+Partition:
tinyint_col=3/smallint_col=3/int_col=3/bigint_col=30/float_col=0/double_col=1.1/string_col=3
+Partition:
tinyint_col=5/smallint_col=5/int_col=5/bigint_col=50/float_col=0/double_col=1.1/string_col=5
+Partition:
tinyint_col=6/smallint_col=6/int_col=6/bigint_col=60/float_col=0/double_col=1.1/string_col=6
+Partition:
tinyint_col=4/smallint_col=4/int_col=4/bigint_col=40/float_col=0/double_col=1.1/string_col=4
+Partition:
tinyint_col=7/smallint_col=7/int_col=7/bigint_col=70/float_col=0/double_col=1.1/string_col=7
+Partition:
tinyint_col=0/smallint_col=0/int_col=0/bigint_col=0/float_col=0/double_col=1.1/string_col=0
+Partition:
tinyint_col=1/smallint_col=1/int_col=1/bigint_col=10/float_col=0/double_col=1.1/string_col=1
+NumModifiedRows: 1
+aggregation(SUM, RowsInserted): 10
====
---- QUERY
# Add another partition that contains different float/double values.
@@ -54,8 +56,9 @@ INSERT OVERWRITE all_insert_partition_col_types
PARTITION (tinyint_col=11, smallint_col=11, int_col=11, bigint_col=110,
float_col=2, double_col=3.1, string_col='11')
SELECT 11;
----- RESULTS
-tinyint_col=11/smallint_col=11/int_col=11/bigint_col=110/float_col=2/double_col=3.1/string_col=11:
1
+---- RUNTIME_PROFILE
+Partition:
tinyint_col=11/smallint_col=11/int_col=11/bigint_col=110/float_col=2/double_col=3.1/string_col=11
+NumModifiedRows: 1
====
---- QUERY
SELECT * FROM all_insert_partition_col_types
diff --git
a/testdata/workloads/functional-query/queries/QueryTest/spilling-regression-exhaustive.test
b/testdata/workloads/functional-query/queries/QueryTest/spilling-regression-exhaustive.test
index e2c2f8d59..87e1874dc 100644
---
a/testdata/workloads/functional-query/queries/QueryTest/spilling-regression-exhaustive.test
+++
b/testdata/workloads/functional-query/queries/QueryTest/spilling-regression-exhaustive.test
@@ -150,6 +150,8 @@ limit 20;
' Tiresias above the stealthily p'
---- TYPES
STRING
+---- HS2_TYPES
+VARCHAR
---- RUNTIME_PROFILE
# Verify that the sort actually spilled
row_regex: .*SpilledRuns: .* \([1-9][0-9]*\)
@@ -189,6 +191,8 @@ limit 20;
' Tiresias above the stealthily p'
---- TYPES
STRING
+---- HS2_TYPES
+VARCHAR
---- RUNTIME_PROFILE
# Verify that the sort actually spilled
row_regex: .*SpilledRuns: .* \([1-9][0-9]*\)
diff --git a/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
b/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
index 166a99c36..d6e1448bf 100644
--- a/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
+++ b/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
@@ -10,544 +10,1066 @@ STORED AS $FILE_FORMAT
INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk)
SELECT * FROM tpcds.store_sales
WHERE ss_sold_date_sk = 2451239
----- RESULTS
-ss_sold_date_sk=2451239: 847
+---- RUNTIME_PROFILE
+Partition: ss_sold_date_sk=2451239
+NumModifiedRows: 847
====
---- QUERY: TPCDS-SS-INSERT-MONTH
INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk)
SELECT * FROM tpcds.store_sales
WHERE ss_sold_date_sk >= 2451270 and ss_sold_date_sk <= 2451299
----- RESULTS
-ss_sold_date_sk=2451270: 822
-ss_sold_date_sk=2451271: 813
-ss_sold_date_sk=2451272: 888
-ss_sold_date_sk=2451273: 946
-ss_sold_date_sk=2451274: 868
-ss_sold_date_sk=2451275: 917
-ss_sold_date_sk=2451276: 851
-ss_sold_date_sk=2451277: 675
-ss_sold_date_sk=2451278: 902
-ss_sold_date_sk=2451279: 769
-ss_sold_date_sk=2451280: 674
-ss_sold_date_sk=2451281: 934
-ss_sold_date_sk=2451282: 826
-ss_sold_date_sk=2451283: 894
-ss_sold_date_sk=2451284: 794
-ss_sold_date_sk=2451285: 991
-ss_sold_date_sk=2451286: 973
-ss_sold_date_sk=2451287: 800
-ss_sold_date_sk=2451288: 818
-ss_sold_date_sk=2451289: 904
-ss_sold_date_sk=2451290: 780
-ss_sold_date_sk=2451291: 758
-ss_sold_date_sk=2451292: 870
-ss_sold_date_sk=2451293: 999
-ss_sold_date_sk=2451294: 741
-ss_sold_date_sk=2451295: 1072
-ss_sold_date_sk=2451296: 1032
-ss_sold_date_sk=2451297: 698
-ss_sold_date_sk=2451298: 991
-ss_sold_date_sk=2451299: 703
+---- RUNTIME_PROFILE
+Partition: ss_sold_date_sk=2451270
+NumModifiedRows: 822
+Partition: ss_sold_date_sk=2451271
+NumModifiedRows: 813
+Partition: ss_sold_date_sk=2451272
+NumModifiedRows: 888
+Partition: ss_sold_date_sk=2451273
+NumModifiedRows: 946
+Partition: ss_sold_date_sk=2451274
+NumModifiedRows: 868
+Partition: ss_sold_date_sk=2451275
+NumModifiedRows: 917
+Partition: ss_sold_date_sk=2451276
+NumModifiedRows: 851
+Partition: ss_sold_date_sk=2451277
+NumModifiedRows: 675
+Partition: ss_sold_date_sk=2451278
+NumModifiedRows: 902
+Partition: ss_sold_date_sk=2451279
+NumModifiedRows: 769
+Partition: ss_sold_date_sk=2451280
+NumModifiedRows: 674
+Partition: ss_sold_date_sk=2451281
+NumModifiedRows: 934
+Partition: ss_sold_date_sk=2451282
+NumModifiedRows: 826
+Partition: ss_sold_date_sk=2451283
+NumModifiedRows: 894
+Partition: ss_sold_date_sk=2451284
+NumModifiedRows: 794
+Partition: ss_sold_date_sk=2451285
+NumModifiedRows: 991
+Partition: ss_sold_date_sk=2451286
+NumModifiedRows: 973
+Partition: ss_sold_date_sk=2451287
+NumModifiedRows: 800
+Partition: ss_sold_date_sk=2451288
+NumModifiedRows: 818
+Partition: ss_sold_date_sk=2451289
+NumModifiedRows: 904
+Partition: ss_sold_date_sk=2451290
+NumModifiedRows: 780
+Partition: ss_sold_date_sk=2451291
+NumModifiedRows: 758
+Partition: ss_sold_date_sk=2451292
+NumModifiedRows: 870
+Partition: ss_sold_date_sk=2451293
+NumModifiedRows: 999
+Partition: ss_sold_date_sk=2451294
+NumModifiedRows: 741
+Partition: ss_sold_date_sk=2451295
+NumModifiedRows: 1072
+Partition: ss_sold_date_sk=2451296
+NumModifiedRows: 1032
+Partition: ss_sold_date_sk=2451297
+NumModifiedRows: 698
+Partition: ss_sold_date_sk=2451298
+NumModifiedRows: 991
+Partition: ss_sold_date_sk=2451299
+NumModifiedRows: 703
+aggregation(SUM, RowsInserted): 25703
====
---- QUERY: TPCDS-SS-INSERT-QUARTER
INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk)
SELECT * FROM tpcds.store_sales
WHERE ss_sold_date_sk >= 2451423 and ss_sold_date_sk <= 2451544
----- RESULTS
-ss_sold_date_sk=2451423: 1881
-ss_sold_date_sk=2451424: 2276
-ss_sold_date_sk=2451425: 1807
-ss_sold_date_sk=2451426: 2220
-ss_sold_date_sk=2451427: 1783
-ss_sold_date_sk=2451428: 2046
-ss_sold_date_sk=2451429: 2041
-ss_sold_date_sk=2451430: 1930
-ss_sold_date_sk=2451431: 1967
-ss_sold_date_sk=2451432: 1885
-ss_sold_date_sk=2451433: 1889
-ss_sold_date_sk=2451434: 1712
-ss_sold_date_sk=2451435: 1943
-ss_sold_date_sk=2451436: 1903
-ss_sold_date_sk=2451437: 1989
-ss_sold_date_sk=2451438: 1855
-ss_sold_date_sk=2451439: 2109
-ss_sold_date_sk=2451440: 2281
-ss_sold_date_sk=2451441: 1986
-ss_sold_date_sk=2451442: 2029
-ss_sold_date_sk=2451443: 1939
-ss_sold_date_sk=2451444: 2084
-ss_sold_date_sk=2451445: 1748
-ss_sold_date_sk=2451446: 1823
-ss_sold_date_sk=2451447: 1875
-ss_sold_date_sk=2451448: 2209
-ss_sold_date_sk=2451449: 1747
-ss_sold_date_sk=2451450: 1833
-ss_sold_date_sk=2451451: 2049
-ss_sold_date_sk=2451452: 2074
-ss_sold_date_sk=2451453: 1941
-ss_sold_date_sk=2451454: 1885
-ss_sold_date_sk=2451455: 1885
-ss_sold_date_sk=2451456: 1854
-ss_sold_date_sk=2451457: 1993
-ss_sold_date_sk=2451458: 1864
-ss_sold_date_sk=2451459: 1848
-ss_sold_date_sk=2451460: 2190
-ss_sold_date_sk=2451461: 1860
-ss_sold_date_sk=2451462: 2016
-ss_sold_date_sk=2451463: 1606
-ss_sold_date_sk=2451464: 2006
-ss_sold_date_sk=2451465: 1914
-ss_sold_date_sk=2451466: 2146
-ss_sold_date_sk=2451467: 1908
-ss_sold_date_sk=2451468: 1974
-ss_sold_date_sk=2451469: 1720
-ss_sold_date_sk=2451470: 2072
-ss_sold_date_sk=2451471: 1823
-ss_sold_date_sk=2451472: 1861
-ss_sold_date_sk=2451473: 1804
-ss_sold_date_sk=2451474: 2368
-ss_sold_date_sk=2451475: 1940
-ss_sold_date_sk=2451476: 1921
-ss_sold_date_sk=2451477: 2055
-ss_sold_date_sk=2451478: 1957
-ss_sold_date_sk=2451479: 2034
-ss_sold_date_sk=2451480: 1983
-ss_sold_date_sk=2451481: 2057
-ss_sold_date_sk=2451482: 1966
-ss_sold_date_sk=2451483: 1965
-ss_sold_date_sk=2451484: 2075
-ss_sold_date_sk=2451485: 1831
-ss_sold_date_sk=2451486: 2947
-ss_sold_date_sk=2451487: 2835
-ss_sold_date_sk=2451488: 3242
-ss_sold_date_sk=2451489: 2871
-ss_sold_date_sk=2451490: 3179
-ss_sold_date_sk=2451491: 3029
-ss_sold_date_sk=2451492: 2908
-ss_sold_date_sk=2451493: 2968
-ss_sold_date_sk=2451494: 2977
-ss_sold_date_sk=2451495: 3006
-ss_sold_date_sk=2451496: 2747
-ss_sold_date_sk=2451497: 3178
-ss_sold_date_sk=2451498: 3007
-ss_sold_date_sk=2451499: 2895
-ss_sold_date_sk=2451500: 2774
-ss_sold_date_sk=2451501: 3218
-ss_sold_date_sk=2451502: 2728
-ss_sold_date_sk=2451503: 2637
-ss_sold_date_sk=2451504: 2778
-ss_sold_date_sk=2451505: 2739
-ss_sold_date_sk=2451506: 2582
-ss_sold_date_sk=2451507: 2865
-ss_sold_date_sk=2451508: 3178
-ss_sold_date_sk=2451509: 2975
-ss_sold_date_sk=2451510: 3008
-ss_sold_date_sk=2451511: 2779
-ss_sold_date_sk=2451512: 3046
-ss_sold_date_sk=2451513: 3279
-ss_sold_date_sk=2451514: 2980
-ss_sold_date_sk=2451515: 2844
-ss_sold_date_sk=2451516: 2960
-ss_sold_date_sk=2451517: 2814
-ss_sold_date_sk=2451518: 2950
-ss_sold_date_sk=2451519: 2925
-ss_sold_date_sk=2451520: 3197
-ss_sold_date_sk=2451521: 2617
-ss_sold_date_sk=2451522: 3013
-ss_sold_date_sk=2451523: 2693
-ss_sold_date_sk=2451524: 3049
-ss_sold_date_sk=2451525: 2912
-ss_sold_date_sk=2451526: 3067
-ss_sold_date_sk=2451527: 3053
-ss_sold_date_sk=2451528: 3144
-ss_sold_date_sk=2451529: 3086
-ss_sold_date_sk=2451530: 2996
-ss_sold_date_sk=2451531: 3301
-ss_sold_date_sk=2451532: 3190
-ss_sold_date_sk=2451533: 3152
-ss_sold_date_sk=2451534: 3064
-ss_sold_date_sk=2451535: 2796
-ss_sold_date_sk=2451536: 3068
-ss_sold_date_sk=2451537: 3293
-ss_sold_date_sk=2451538: 2892
-ss_sold_date_sk=2451539: 3016
-ss_sold_date_sk=2451540: 2975
-ss_sold_date_sk=2451541: 3422
-ss_sold_date_sk=2451542: 2920
-ss_sold_date_sk=2451543: 3052
-ss_sold_date_sk=2451544: 3046
+---- RUNTIME_PROFILE
+Partition: ss_sold_date_sk=2451423
+NumModifiedRows: 1881
+Partition: ss_sold_date_sk=2451424
+NumModifiedRows: 2276
+Partition: ss_sold_date_sk=2451425
+NumModifiedRows: 1807
+Partition: ss_sold_date_sk=2451426
+NumModifiedRows: 2220
+Partition: ss_sold_date_sk=2451427
+NumModifiedRows: 1783
+Partition: ss_sold_date_sk=2451428
+NumModifiedRows: 2046
+Partition: ss_sold_date_sk=2451429
+NumModifiedRows: 2041
+Partition: ss_sold_date_sk=2451430
+NumModifiedRows: 1930
+Partition: ss_sold_date_sk=2451431
+NumModifiedRows: 1967
+Partition: ss_sold_date_sk=2451432
+NumModifiedRows: 1885
+Partition: ss_sold_date_sk=2451433
+NumModifiedRows: 1889
+Partition: ss_sold_date_sk=2451434
+NumModifiedRows: 1712
+Partition: ss_sold_date_sk=2451435
+NumModifiedRows: 1943
+Partition: ss_sold_date_sk=2451436
+NumModifiedRows: 1903
+Partition: ss_sold_date_sk=2451437
+NumModifiedRows: 1989
+Partition: ss_sold_date_sk=2451438
+NumModifiedRows: 1855
+Partition: ss_sold_date_sk=2451439
+NumModifiedRows: 2109
+Partition: ss_sold_date_sk=2451440
+NumModifiedRows: 2281
+Partition: ss_sold_date_sk=2451441
+NumModifiedRows: 1986
+Partition: ss_sold_date_sk=2451442
+NumModifiedRows: 2029
+Partition: ss_sold_date_sk=2451443
+NumModifiedRows: 1939
+Partition: ss_sold_date_sk=2451444
+NumModifiedRows: 2084
+Partition: ss_sold_date_sk=2451445
+NumModifiedRows: 1748
+Partition: ss_sold_date_sk=2451446
+NumModifiedRows: 1823
+Partition: ss_sold_date_sk=2451447
+NumModifiedRows: 1875
+Partition: ss_sold_date_sk=2451448
+NumModifiedRows: 2209
+Partition: ss_sold_date_sk=2451449
+NumModifiedRows: 1747
+Partition: ss_sold_date_sk=2451450
+NumModifiedRows: 1833
+Partition: ss_sold_date_sk=2451451
+NumModifiedRows: 2049
+Partition: ss_sold_date_sk=2451452
+NumModifiedRows: 2074
+Partition: ss_sold_date_sk=2451453
+NumModifiedRows: 1941
+Partition: ss_sold_date_sk=2451454
+NumModifiedRows: 1885
+Partition: ss_sold_date_sk=2451455
+NumModifiedRows: 1885
+Partition: ss_sold_date_sk=2451456
+NumModifiedRows: 1854
+Partition: ss_sold_date_sk=2451457
+NumModifiedRows: 1993
+Partition: ss_sold_date_sk=2451458
+NumModifiedRows: 1864
+Partition: ss_sold_date_sk=2451459
+NumModifiedRows: 1848
+Partition: ss_sold_date_sk=2451460
+NumModifiedRows: 2190
+Partition: ss_sold_date_sk=2451461
+NumModifiedRows: 1860
+Partition: ss_sold_date_sk=2451462
+NumModifiedRows: 2016
+Partition: ss_sold_date_sk=2451463
+NumModifiedRows: 1606
+Partition: ss_sold_date_sk=2451464
+NumModifiedRows: 2006
+Partition: ss_sold_date_sk=2451465
+NumModifiedRows: 1914
+Partition: ss_sold_date_sk=2451466
+NumModifiedRows: 2146
+Partition: ss_sold_date_sk=2451467
+NumModifiedRows: 1908
+Partition: ss_sold_date_sk=2451468
+NumModifiedRows: 1974
+Partition: ss_sold_date_sk=2451469
+NumModifiedRows: 1720
+Partition: ss_sold_date_sk=2451470
+NumModifiedRows: 2072
+Partition: ss_sold_date_sk=2451471
+NumModifiedRows: 1823
+Partition: ss_sold_date_sk=2451472
+NumModifiedRows: 1861
+Partition: ss_sold_date_sk=2451473
+NumModifiedRows: 1804
+Partition: ss_sold_date_sk=2451474
+NumModifiedRows: 2368
+Partition: ss_sold_date_sk=2451475
+NumModifiedRows: 1940
+Partition: ss_sold_date_sk=2451476
+NumModifiedRows: 1921
+Partition: ss_sold_date_sk=2451477
+NumModifiedRows: 2055
+Partition: ss_sold_date_sk=2451478
+NumModifiedRows: 1957
+Partition: ss_sold_date_sk=2451479
+NumModifiedRows: 2034
+Partition: ss_sold_date_sk=2451480
+NumModifiedRows: 1983
+Partition: ss_sold_date_sk=2451481
+NumModifiedRows: 2057
+Partition: ss_sold_date_sk=2451482
+NumModifiedRows: 1966
+Partition: ss_sold_date_sk=2451483
+NumModifiedRows: 1965
+Partition: ss_sold_date_sk=2451484
+NumModifiedRows: 2075
+Partition: ss_sold_date_sk=2451485
+NumModifiedRows: 1831
+Partition: ss_sold_date_sk=2451486
+NumModifiedRows: 2947
+Partition: ss_sold_date_sk=2451487
+NumModifiedRows: 2835
+Partition: ss_sold_date_sk=2451488
+NumModifiedRows: 3242
+Partition: ss_sold_date_sk=2451489
+NumModifiedRows: 2871
+Partition: ss_sold_date_sk=2451490
+NumModifiedRows: 3179
+Partition: ss_sold_date_sk=2451491
+NumModifiedRows: 3029
+Partition: ss_sold_date_sk=2451492
+NumModifiedRows: 2908
+Partition: ss_sold_date_sk=2451493
+NumModifiedRows: 2968
+Partition: ss_sold_date_sk=2451494
+NumModifiedRows: 2977
+Partition: ss_sold_date_sk=2451495
+NumModifiedRows: 3006
+Partition: ss_sold_date_sk=2451496
+NumModifiedRows: 2747
+Partition: ss_sold_date_sk=2451497
+NumModifiedRows: 3178
+Partition: ss_sold_date_sk=2451498
+NumModifiedRows: 3007
+Partition: ss_sold_date_sk=2451499
+NumModifiedRows: 2895
+Partition: ss_sold_date_sk=2451500
+NumModifiedRows: 2774
+Partition: ss_sold_date_sk=2451501
+NumModifiedRows: 3218
+Partition: ss_sold_date_sk=2451502
+NumModifiedRows: 2728
+Partition: ss_sold_date_sk=2451503
+NumModifiedRows: 2637
+Partition: ss_sold_date_sk=2451504
+NumModifiedRows: 2778
+Partition: ss_sold_date_sk=2451505
+NumModifiedRows: 2739
+Partition: ss_sold_date_sk=2451506
+NumModifiedRows: 2582
+Partition: ss_sold_date_sk=2451507
+NumModifiedRows: 2865
+Partition: ss_sold_date_sk=2451508
+NumModifiedRows: 3178
+Partition: ss_sold_date_sk=2451509
+NumModifiedRows: 2975
+Partition: ss_sold_date_sk=2451510
+NumModifiedRows: 3008
+Partition: ss_sold_date_sk=2451511
+NumModifiedRows: 2779
+Partition: ss_sold_date_sk=2451512
+NumModifiedRows: 3046
+Partition: ss_sold_date_sk=2451513
+NumModifiedRows: 3279
+Partition: ss_sold_date_sk=2451514
+NumModifiedRows: 2980
+Partition: ss_sold_date_sk=2451515
+NumModifiedRows: 2844
+Partition: ss_sold_date_sk=2451516
+NumModifiedRows: 2960
+Partition: ss_sold_date_sk=2451517
+NumModifiedRows: 2814
+Partition: ss_sold_date_sk=2451518
+NumModifiedRows: 2950
+Partition: ss_sold_date_sk=2451519
+NumModifiedRows: 2925
+Partition: ss_sold_date_sk=2451520
+NumModifiedRows: 3197
+Partition: ss_sold_date_sk=2451521
+NumModifiedRows: 2617
+Partition: ss_sold_date_sk=2451522
+NumModifiedRows: 3013
+Partition: ss_sold_date_sk=2451523
+NumModifiedRows: 2693
+Partition: ss_sold_date_sk=2451524
+NumModifiedRows: 3049
+Partition: ss_sold_date_sk=2451525
+NumModifiedRows: 2912
+Partition: ss_sold_date_sk=2451526
+NumModifiedRows: 3067
+Partition: ss_sold_date_sk=2451527
+NumModifiedRows: 3053
+Partition: ss_sold_date_sk=2451528
+NumModifiedRows: 3144
+Partition: ss_sold_date_sk=2451529
+NumModifiedRows: 3086
+Partition: ss_sold_date_sk=2451530
+NumModifiedRows: 2996
+Partition: ss_sold_date_sk=2451531
+NumModifiedRows: 3301
+Partition: ss_sold_date_sk=2451532
+NumModifiedRows: 3190
+Partition: ss_sold_date_sk=2451533
+NumModifiedRows: 3152
+Partition: ss_sold_date_sk=2451534
+NumModifiedRows: 3064
+Partition: ss_sold_date_sk=2451535
+NumModifiedRows: 2796
+Partition: ss_sold_date_sk=2451536
+NumModifiedRows: 3068
+Partition: ss_sold_date_sk=2451537
+NumModifiedRows: 3293
+Partition: ss_sold_date_sk=2451538
+NumModifiedRows: 2892
+Partition: ss_sold_date_sk=2451539
+NumModifiedRows: 3016
+Partition: ss_sold_date_sk=2451540
+NumModifiedRows: 2975
+Partition: ss_sold_date_sk=2451541
+NumModifiedRows: 3422
+Partition: ss_sold_date_sk=2451542
+NumModifiedRows: 2920
+Partition: ss_sold_date_sk=2451543
+NumModifiedRows: 3052
+Partition: ss_sold_date_sk=2451544
+NumModifiedRows: 3046
+aggregation(SUM, RowsInserted): 299097
====
---- QUERY: TPCDS-SS-INSERT-YEAR
INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk)
SELECT * FROM tpcds.store_sales
WHERE ss_sold_date_sk >= 2451545 and ss_sold_date_sk < 2451911
----- RESULTS
-ss_sold_date_sk=2451545: 2743
-ss_sold_date_sk=2451546: 4074
-ss_sold_date_sk=2451547: 804
-ss_sold_date_sk=2451548: 948
-ss_sold_date_sk=2451549: 737
-ss_sold_date_sk=2451550: 932
-ss_sold_date_sk=2451551: 857
-ss_sold_date_sk=2451552: 881
-ss_sold_date_sk=2451553: 942
-ss_sold_date_sk=2451554: 884
-ss_sold_date_sk=2451555: 834
-ss_sold_date_sk=2451556: 942
-ss_sold_date_sk=2451557: 998
-ss_sold_date_sk=2451558: 742
-ss_sold_date_sk=2451559: 867
-ss_sold_date_sk=2451560: 831
-ss_sold_date_sk=2451561: 859
-ss_sold_date_sk=2451562: 759
-ss_sold_date_sk=2451563: 988
-ss_sold_date_sk=2451564: 956
-ss_sold_date_sk=2451565: 968
-ss_sold_date_sk=2451566: 944
-ss_sold_date_sk=2451567: 678
-ss_sold_date_sk=2451568: 912
-ss_sold_date_sk=2451569: 973
-ss_sold_date_sk=2451570: 772
-ss_sold_date_sk=2451571: 830
-ss_sold_date_sk=2451572: 872
-ss_sold_date_sk=2451573: 616
-ss_sold_date_sk=2451574: 792
-ss_sold_date_sk=2451575: 978
-ss_sold_date_sk=2451576: 819
-ss_sold_date_sk=2451577: 788
-ss_sold_date_sk=2451578: 950
-ss_sold_date_sk=2451579: 909
-ss_sold_date_sk=2451580: 763
-ss_sold_date_sk=2451581: 874
-ss_sold_date_sk=2451582: 1024
-ss_sold_date_sk=2451583: 907
-ss_sold_date_sk=2451584: 936
-ss_sold_date_sk=2451585: 802
-ss_sold_date_sk=2451586: 719
-ss_sold_date_sk=2451587: 816
-ss_sold_date_sk=2451588: 825
-ss_sold_date_sk=2451589: 871
-ss_sold_date_sk=2451590: 1004
-ss_sold_date_sk=2451591: 963
-ss_sold_date_sk=2451592: 884
-ss_sold_date_sk=2451593: 854
-ss_sold_date_sk=2451594: 888
-ss_sold_date_sk=2451595: 1049
-ss_sold_date_sk=2451596: 930
-ss_sold_date_sk=2451597: 991
-ss_sold_date_sk=2451598: 883
-ss_sold_date_sk=2451599: 771
-ss_sold_date_sk=2451600: 844
-ss_sold_date_sk=2451601: 786
-ss_sold_date_sk=2451602: 785
-ss_sold_date_sk=2451603: 936
-ss_sold_date_sk=2451604: 868
-ss_sold_date_sk=2451605: 707
-ss_sold_date_sk=2451606: 758
-ss_sold_date_sk=2451607: 934
-ss_sold_date_sk=2451608: 856
-ss_sold_date_sk=2451609: 781
-ss_sold_date_sk=2451610: 832
-ss_sold_date_sk=2451611: 756
-ss_sold_date_sk=2451612: 792
-ss_sold_date_sk=2451613: 914
-ss_sold_date_sk=2451614: 772
-ss_sold_date_sk=2451615: 921
-ss_sold_date_sk=2451616: 842
-ss_sold_date_sk=2451617: 878
-ss_sold_date_sk=2451618: 877
-ss_sold_date_sk=2451619: 923
-ss_sold_date_sk=2451620: 897
-ss_sold_date_sk=2451621: 776
-ss_sold_date_sk=2451622: 759
-ss_sold_date_sk=2451623: 883
-ss_sold_date_sk=2451624: 874
-ss_sold_date_sk=2451625: 918
-ss_sold_date_sk=2451626: 914
-ss_sold_date_sk=2451627: 1097
-ss_sold_date_sk=2451628: 953
-ss_sold_date_sk=2451629: 758
-ss_sold_date_sk=2451630: 783
-ss_sold_date_sk=2451631: 811
-ss_sold_date_sk=2451632: 873
-ss_sold_date_sk=2451633: 998
-ss_sold_date_sk=2451634: 1054
-ss_sold_date_sk=2451635: 956
-ss_sold_date_sk=2451636: 1001
-ss_sold_date_sk=2451637: 804
-ss_sold_date_sk=2451638: 998
-ss_sold_date_sk=2451639: 808
-ss_sold_date_sk=2451640: 1015
-ss_sold_date_sk=2451641: 951
-ss_sold_date_sk=2451642: 835
-ss_sold_date_sk=2451643: 779
-ss_sold_date_sk=2451644: 883
-ss_sold_date_sk=2451645: 1065
-ss_sold_date_sk=2451646: 751
-ss_sold_date_sk=2451647: 816
-ss_sold_date_sk=2451648: 1028
-ss_sold_date_sk=2451649: 756
-ss_sold_date_sk=2451650: 751
-ss_sold_date_sk=2451651: 839
-ss_sold_date_sk=2451652: 727
-ss_sold_date_sk=2451653: 898
-ss_sold_date_sk=2451654: 925
-ss_sold_date_sk=2451655: 908
-ss_sold_date_sk=2451656: 694
-ss_sold_date_sk=2451657: 880
-ss_sold_date_sk=2451658: 966
-ss_sold_date_sk=2451659: 807
-ss_sold_date_sk=2451660: 795
-ss_sold_date_sk=2451661: 781
-ss_sold_date_sk=2451662: 845
-ss_sold_date_sk=2451663: 742
-ss_sold_date_sk=2451664: 815
-ss_sold_date_sk=2451665: 842
-ss_sold_date_sk=2451666: 868
-ss_sold_date_sk=2451667: 926
-ss_sold_date_sk=2451668: 694
-ss_sold_date_sk=2451669: 834
-ss_sold_date_sk=2451670: 935
-ss_sold_date_sk=2451671: 869
-ss_sold_date_sk=2451672: 900
-ss_sold_date_sk=2451673: 962
-ss_sold_date_sk=2451674: 787
-ss_sold_date_sk=2451675: 778
-ss_sold_date_sk=2451676: 776
-ss_sold_date_sk=2451677: 799
-ss_sold_date_sk=2451678: 841
-ss_sold_date_sk=2451679: 921
-ss_sold_date_sk=2451680: 953
-ss_sold_date_sk=2451681: 878
-ss_sold_date_sk=2451682: 1072
-ss_sold_date_sk=2451683: 903
-ss_sold_date_sk=2451684: 803
-ss_sold_date_sk=2451685: 957
-ss_sold_date_sk=2451686: 902
-ss_sold_date_sk=2451687: 847
-ss_sold_date_sk=2451688: 989
-ss_sold_date_sk=2451689: 876
-ss_sold_date_sk=2451690: 1113
-ss_sold_date_sk=2451691: 883
-ss_sold_date_sk=2451692: 800
-ss_sold_date_sk=2451693: 880
-ss_sold_date_sk=2451694: 1049
-ss_sold_date_sk=2451695: 709
-ss_sold_date_sk=2451696: 749
-ss_sold_date_sk=2451697: 809
-ss_sold_date_sk=2451698: 831
-ss_sold_date_sk=2451699: 841
-ss_sold_date_sk=2451700: 717
-ss_sold_date_sk=2451701: 736
-ss_sold_date_sk=2451702: 994
-ss_sold_date_sk=2451703: 932
-ss_sold_date_sk=2451704: 911
-ss_sold_date_sk=2451705: 853
-ss_sold_date_sk=2451706: 898
-ss_sold_date_sk=2451707: 921
-ss_sold_date_sk=2451708: 994
-ss_sold_date_sk=2451709: 1051
-ss_sold_date_sk=2451710: 1077
-ss_sold_date_sk=2451711: 714
-ss_sold_date_sk=2451712: 1057
-ss_sold_date_sk=2451713: 919
-ss_sold_date_sk=2451714: 933
-ss_sold_date_sk=2451715: 835
-ss_sold_date_sk=2451716: 1009
-ss_sold_date_sk=2451717: 981
-ss_sold_date_sk=2451718: 888
-ss_sold_date_sk=2451719: 787
-ss_sold_date_sk=2451720: 937
-ss_sold_date_sk=2451721: 857
-ss_sold_date_sk=2451722: 982
-ss_sold_date_sk=2451723: 891
-ss_sold_date_sk=2451724: 785
-ss_sold_date_sk=2451725: 809
-ss_sold_date_sk=2451726: 638
-ss_sold_date_sk=2451727: 990
-ss_sold_date_sk=2451728: 1050
-ss_sold_date_sk=2451729: 867
-ss_sold_date_sk=2451730: 1000
-ss_sold_date_sk=2451731: 924
-ss_sold_date_sk=2451732: 731
-ss_sold_date_sk=2451733: 927
-ss_sold_date_sk=2451734: 805
-ss_sold_date_sk=2451735: 848
-ss_sold_date_sk=2451736: 796
-ss_sold_date_sk=2451737: 854
-ss_sold_date_sk=2451738: 775
-ss_sold_date_sk=2451739: 727
-ss_sold_date_sk=2451740: 907
-ss_sold_date_sk=2451741: 855
-ss_sold_date_sk=2451742: 664
-ss_sold_date_sk=2451743: 894
-ss_sold_date_sk=2451744: 1009
-ss_sold_date_sk=2451745: 780
-ss_sold_date_sk=2451746: 802
-ss_sold_date_sk=2451747: 764
-ss_sold_date_sk=2451748: 753
-ss_sold_date_sk=2451749: 794
-ss_sold_date_sk=2451750: 756
-ss_sold_date_sk=2451751: 791
-ss_sold_date_sk=2451752: 713
-ss_sold_date_sk=2451753: 1013
-ss_sold_date_sk=2451754: 810
-ss_sold_date_sk=2451755: 707
-ss_sold_date_sk=2451756: 978
-ss_sold_date_sk=2451757: 1016
-ss_sold_date_sk=2451758: 1071
-ss_sold_date_sk=2451759: 2075
-ss_sold_date_sk=2451760: 2188
-ss_sold_date_sk=2451761: 1832
-ss_sold_date_sk=2451762: 2187
-ss_sold_date_sk=2451763: 1935
-ss_sold_date_sk=2451764: 1905
-ss_sold_date_sk=2451765: 2108
-ss_sold_date_sk=2451766: 1985
-ss_sold_date_sk=2451767: 1641
-ss_sold_date_sk=2451768: 1845
-ss_sold_date_sk=2451769: 1844
-ss_sold_date_sk=2451770: 2017
-ss_sold_date_sk=2451771: 2054
-ss_sold_date_sk=2451772: 1985
-ss_sold_date_sk=2451773: 2125
-ss_sold_date_sk=2451774: 1864
-ss_sold_date_sk=2451775: 1814
-ss_sold_date_sk=2451776: 2009
-ss_sold_date_sk=2451777: 2101
-ss_sold_date_sk=2451778: 1835
-ss_sold_date_sk=2451779: 1711
-ss_sold_date_sk=2451780: 1865
-ss_sold_date_sk=2451781: 2063
-ss_sold_date_sk=2451782: 1942
-ss_sold_date_sk=2451783: 1800
-ss_sold_date_sk=2451784: 1805
-ss_sold_date_sk=2451785: 1969
-ss_sold_date_sk=2451786: 2101
-ss_sold_date_sk=2451787: 2073
-ss_sold_date_sk=2451788: 2011
-ss_sold_date_sk=2451789: 1984
-ss_sold_date_sk=2451790: 2049
-ss_sold_date_sk=2451791: 2070
-ss_sold_date_sk=2451792: 2030
-ss_sold_date_sk=2451793: 2085
-ss_sold_date_sk=2451794: 2046
-ss_sold_date_sk=2451795: 2014
-ss_sold_date_sk=2451796: 1955
-ss_sold_date_sk=2451797: 2031
-ss_sold_date_sk=2451798: 2053
-ss_sold_date_sk=2451799: 2174
-ss_sold_date_sk=2451800: 2128
-ss_sold_date_sk=2451801: 2014
-ss_sold_date_sk=2451802: 2264
-ss_sold_date_sk=2451803: 2306
-ss_sold_date_sk=2451804: 2151
-ss_sold_date_sk=2451805: 2062
-ss_sold_date_sk=2451806: 2204
-ss_sold_date_sk=2451807: 2020
-ss_sold_date_sk=2451808: 1950
-ss_sold_date_sk=2451809: 1948
-ss_sold_date_sk=2451810: 2171
-ss_sold_date_sk=2451811: 1713
-ss_sold_date_sk=2451812: 2006
-ss_sold_date_sk=2451813: 2297
-ss_sold_date_sk=2451814: 1784
-ss_sold_date_sk=2451815: 1976
-ss_sold_date_sk=2451816: 1945
-ss_sold_date_sk=2451817: 1888
-ss_sold_date_sk=2451818: 2003
-ss_sold_date_sk=2451819: 1753
-ss_sold_date_sk=2451820: 2122
-ss_sold_date_sk=2451821: 2006
-ss_sold_date_sk=2451822: 2046
-ss_sold_date_sk=2451823: 2117
-ss_sold_date_sk=2451824: 1943
-ss_sold_date_sk=2451825: 1830
-ss_sold_date_sk=2451826: 1867
-ss_sold_date_sk=2451827: 1944
-ss_sold_date_sk=2451828: 2065
-ss_sold_date_sk=2451829: 1784
-ss_sold_date_sk=2451830: 2169
-ss_sold_date_sk=2451831: 1974
-ss_sold_date_sk=2451832: 2157
-ss_sold_date_sk=2451833: 1629
-ss_sold_date_sk=2451834: 1963
-ss_sold_date_sk=2451835: 2035
-ss_sold_date_sk=2451836: 1926
-ss_sold_date_sk=2451837: 1976
-ss_sold_date_sk=2451838: 1887
-ss_sold_date_sk=2451839: 2053
-ss_sold_date_sk=2451840: 1758
-ss_sold_date_sk=2451841: 2067
-ss_sold_date_sk=2451842: 1892
-ss_sold_date_sk=2451843: 1879
-ss_sold_date_sk=2451844: 2203
-ss_sold_date_sk=2451845: 2275
-ss_sold_date_sk=2451846: 1917
-ss_sold_date_sk=2451847: 2008
-ss_sold_date_sk=2451848: 2193
-ss_sold_date_sk=2451849: 1867
-ss_sold_date_sk=2451850: 2184
-ss_sold_date_sk=2451851: 2716
-ss_sold_date_sk=2451852: 2676
-ss_sold_date_sk=2451853: 3405
-ss_sold_date_sk=2451854: 3302
-ss_sold_date_sk=2451855: 3086
-ss_sold_date_sk=2451856: 3060
-ss_sold_date_sk=2451857: 2844
-ss_sold_date_sk=2451858: 3160
-ss_sold_date_sk=2451859: 3106
-ss_sold_date_sk=2451860: 3019
-ss_sold_date_sk=2451861: 2746
-ss_sold_date_sk=2451862: 2991
-ss_sold_date_sk=2451863: 2971
-ss_sold_date_sk=2451864: 2975
-ss_sold_date_sk=2451865: 2985
-ss_sold_date_sk=2451866: 3068
-ss_sold_date_sk=2451867: 2885
-ss_sold_date_sk=2451868: 3291
-ss_sold_date_sk=2451869: 2694
-ss_sold_date_sk=2451870: 2975
-ss_sold_date_sk=2451871: 2923
-ss_sold_date_sk=2451872: 2949
-ss_sold_date_sk=2451873: 3373
-ss_sold_date_sk=2451874: 2847
-ss_sold_date_sk=2451875: 3111
-ss_sold_date_sk=2451876: 2790
-ss_sold_date_sk=2451877: 2945
-ss_sold_date_sk=2451878: 2641
-ss_sold_date_sk=2451879: 2961
-ss_sold_date_sk=2451880: 2966
-ss_sold_date_sk=2451881: 3246
-ss_sold_date_sk=2451882: 3029
-ss_sold_date_sk=2451883: 2990
-ss_sold_date_sk=2451884: 2981
-ss_sold_date_sk=2451885: 2668
-ss_sold_date_sk=2451886: 3125
-ss_sold_date_sk=2451887: 2681
-ss_sold_date_sk=2451888: 3343
-ss_sold_date_sk=2451889: 3053
-ss_sold_date_sk=2451890: 2957
-ss_sold_date_sk=2451891: 3060
-ss_sold_date_sk=2451892: 2876
-ss_sold_date_sk=2451893: 2719
-ss_sold_date_sk=2451894: 2999
-ss_sold_date_sk=2451895: 3245
-ss_sold_date_sk=2451896: 3115
-ss_sold_date_sk=2451897: 3070
-ss_sold_date_sk=2451898: 2978
-ss_sold_date_sk=2451899: 3004
-ss_sold_date_sk=2451900: 3194
-ss_sold_date_sk=2451901: 2833
-ss_sold_date_sk=2451902: 2826
-ss_sold_date_sk=2451903: 2850
-ss_sold_date_sk=2451904: 2789
-ss_sold_date_sk=2451905: 2867
-ss_sold_date_sk=2451906: 3129
-ss_sold_date_sk=2451907: 2876
-ss_sold_date_sk=2451908: 3114
-ss_sold_date_sk=2451909: 3060
-ss_sold_date_sk=2451910: 3109
+---- RUNTIME_PROFILE
+Partition: ss_sold_date_sk=2451545
+NumModifiedRows: 2743
+Partition: ss_sold_date_sk=2451546
+NumModifiedRows: 4074
+Partition: ss_sold_date_sk=2451547
+NumModifiedRows: 804
+Partition: ss_sold_date_sk=2451548
+NumModifiedRows: 948
+Partition: ss_sold_date_sk=2451549
+NumModifiedRows: 737
+Partition: ss_sold_date_sk=2451550
+NumModifiedRows: 932
+Partition: ss_sold_date_sk=2451551
+NumModifiedRows: 857
+Partition: ss_sold_date_sk=2451552
+NumModifiedRows: 881
+Partition: ss_sold_date_sk=2451553
+NumModifiedRows: 942
+Partition: ss_sold_date_sk=2451554
+NumModifiedRows: 884
+Partition: ss_sold_date_sk=2451555
+NumModifiedRows: 834
+Partition: ss_sold_date_sk=2451556
+NumModifiedRows: 942
+Partition: ss_sold_date_sk=2451557
+NumModifiedRows: 998
+Partition: ss_sold_date_sk=2451558
+NumModifiedRows: 742
+Partition: ss_sold_date_sk=2451559
+NumModifiedRows: 867
+Partition: ss_sold_date_sk=2451560
+NumModifiedRows: 831
+Partition: ss_sold_date_sk=2451561
+NumModifiedRows: 859
+Partition: ss_sold_date_sk=2451562
+NumModifiedRows: 759
+Partition: ss_sold_date_sk=2451563
+NumModifiedRows: 988
+Partition: ss_sold_date_sk=2451564
+NumModifiedRows: 956
+Partition: ss_sold_date_sk=2451565
+NumModifiedRows: 968
+Partition: ss_sold_date_sk=2451566
+NumModifiedRows: 944
+Partition: ss_sold_date_sk=2451567
+NumModifiedRows: 678
+Partition: ss_sold_date_sk=2451568
+NumModifiedRows: 912
+Partition: ss_sold_date_sk=2451569
+NumModifiedRows: 973
+Partition: ss_sold_date_sk=2451570
+NumModifiedRows: 772
+Partition: ss_sold_date_sk=2451571
+NumModifiedRows: 830
+Partition: ss_sold_date_sk=2451572
+NumModifiedRows: 872
+Partition: ss_sold_date_sk=2451573
+NumModifiedRows: 616
+Partition: ss_sold_date_sk=2451574
+NumModifiedRows: 792
+Partition: ss_sold_date_sk=2451575
+NumModifiedRows: 978
+Partition: ss_sold_date_sk=2451576
+NumModifiedRows: 819
+Partition: ss_sold_date_sk=2451577
+NumModifiedRows: 788
+Partition: ss_sold_date_sk=2451578
+NumModifiedRows: 950
+Partition: ss_sold_date_sk=2451579
+NumModifiedRows: 909
+Partition: ss_sold_date_sk=2451580
+NumModifiedRows: 763
+Partition: ss_sold_date_sk=2451581
+NumModifiedRows: 874
+Partition: ss_sold_date_sk=2451582
+NumModifiedRows: 1024
+Partition: ss_sold_date_sk=2451583
+NumModifiedRows: 907
+Partition: ss_sold_date_sk=2451584
+NumModifiedRows: 936
+Partition: ss_sold_date_sk=2451585
+NumModifiedRows: 802
+Partition: ss_sold_date_sk=2451586
+NumModifiedRows: 719
+Partition: ss_sold_date_sk=2451587
+NumModifiedRows: 816
+Partition: ss_sold_date_sk=2451588
+NumModifiedRows: 825
+Partition: ss_sold_date_sk=2451589
+NumModifiedRows: 871
+Partition: ss_sold_date_sk=2451590
+NumModifiedRows: 1004
+Partition: ss_sold_date_sk=2451591
+NumModifiedRows: 963
+Partition: ss_sold_date_sk=2451592
+NumModifiedRows: 884
+Partition: ss_sold_date_sk=2451593
+NumModifiedRows: 854
+Partition: ss_sold_date_sk=2451594
+NumModifiedRows: 888
+Partition: ss_sold_date_sk=2451595
+NumModifiedRows: 1049
+Partition: ss_sold_date_sk=2451596
+NumModifiedRows: 930
+Partition: ss_sold_date_sk=2451597
+NumModifiedRows: 991
+Partition: ss_sold_date_sk=2451598
+NumModifiedRows: 883
+Partition: ss_sold_date_sk=2451599
+NumModifiedRows: 771
+Partition: ss_sold_date_sk=2451600
+NumModifiedRows: 844
+Partition: ss_sold_date_sk=2451601
+NumModifiedRows: 786
+Partition: ss_sold_date_sk=2451602
+NumModifiedRows: 785
+Partition: ss_sold_date_sk=2451603
+NumModifiedRows: 936
+Partition: ss_sold_date_sk=2451604
+NumModifiedRows: 868
+Partition: ss_sold_date_sk=2451605
+NumModifiedRows: 707
+Partition: ss_sold_date_sk=2451606
+NumModifiedRows: 758
+Partition: ss_sold_date_sk=2451607
+NumModifiedRows: 934
+Partition: ss_sold_date_sk=2451608
+NumModifiedRows: 856
+Partition: ss_sold_date_sk=2451609
+NumModifiedRows: 781
+Partition: ss_sold_date_sk=2451610
+NumModifiedRows: 832
+Partition: ss_sold_date_sk=2451611
+NumModifiedRows: 756
+Partition: ss_sold_date_sk=2451612
+NumModifiedRows: 792
+Partition: ss_sold_date_sk=2451613
+NumModifiedRows: 914
+Partition: ss_sold_date_sk=2451614
+NumModifiedRows: 772
+Partition: ss_sold_date_sk=2451615
+NumModifiedRows: 921
+Partition: ss_sold_date_sk=2451616
+NumModifiedRows: 842
+Partition: ss_sold_date_sk=2451617
+NumModifiedRows: 878
+Partition: ss_sold_date_sk=2451618
+NumModifiedRows: 877
+Partition: ss_sold_date_sk=2451619
+NumModifiedRows: 923
+Partition: ss_sold_date_sk=2451620
+NumModifiedRows: 897
+Partition: ss_sold_date_sk=2451621
+NumModifiedRows: 776
+Partition: ss_sold_date_sk=2451622
+NumModifiedRows: 759
+Partition: ss_sold_date_sk=2451623
+NumModifiedRows: 883
+Partition: ss_sold_date_sk=2451624
+NumModifiedRows: 874
+Partition: ss_sold_date_sk=2451625
+NumModifiedRows: 918
+Partition: ss_sold_date_sk=2451626
+NumModifiedRows: 914
+Partition: ss_sold_date_sk=2451627
+NumModifiedRows: 1097
+Partition: ss_sold_date_sk=2451628
+NumModifiedRows: 953
+Partition: ss_sold_date_sk=2451629
+NumModifiedRows: 758
+Partition: ss_sold_date_sk=2451630
+NumModifiedRows: 783
+Partition: ss_sold_date_sk=2451631
+NumModifiedRows: 811
+Partition: ss_sold_date_sk=2451632
+NumModifiedRows: 873
+Partition: ss_sold_date_sk=2451633
+NumModifiedRows: 998
+Partition: ss_sold_date_sk=2451634
+NumModifiedRows: 1054
+Partition: ss_sold_date_sk=2451635
+NumModifiedRows: 956
+Partition: ss_sold_date_sk=2451636
+NumModifiedRows: 1001
+Partition: ss_sold_date_sk=2451637
+NumModifiedRows: 804
+Partition: ss_sold_date_sk=2451638
+NumModifiedRows: 998
+Partition: ss_sold_date_sk=2451639
+NumModifiedRows: 808
+Partition: ss_sold_date_sk=2451640
+NumModifiedRows: 1015
+Partition: ss_sold_date_sk=2451641
+NumModifiedRows: 951
+Partition: ss_sold_date_sk=2451642
+NumModifiedRows: 835
+Partition: ss_sold_date_sk=2451643
+NumModifiedRows: 779
+Partition: ss_sold_date_sk=2451644
+NumModifiedRows: 883
+Partition: ss_sold_date_sk=2451645
+NumModifiedRows: 1065
+Partition: ss_sold_date_sk=2451646
+NumModifiedRows: 751
+Partition: ss_sold_date_sk=2451647
+NumModifiedRows: 816
+Partition: ss_sold_date_sk=2451648
+NumModifiedRows: 1028
+Partition: ss_sold_date_sk=2451649
+NumModifiedRows: 756
+Partition: ss_sold_date_sk=2451650
+NumModifiedRows: 751
+Partition: ss_sold_date_sk=2451651
+NumModifiedRows: 839
+Partition: ss_sold_date_sk=2451652
+NumModifiedRows: 727
+Partition: ss_sold_date_sk=2451653
+NumModifiedRows: 898
+Partition: ss_sold_date_sk=2451654
+NumModifiedRows: 925
+Partition: ss_sold_date_sk=2451655
+NumModifiedRows: 908
+Partition: ss_sold_date_sk=2451656
+NumModifiedRows: 694
+Partition: ss_sold_date_sk=2451657
+NumModifiedRows: 880
+Partition: ss_sold_date_sk=2451658
+NumModifiedRows: 966
+Partition: ss_sold_date_sk=2451659
+NumModifiedRows: 807
+Partition: ss_sold_date_sk=2451660
+NumModifiedRows: 795
+Partition: ss_sold_date_sk=2451661
+NumModifiedRows: 781
+Partition: ss_sold_date_sk=2451662
+NumModifiedRows: 845
+Partition: ss_sold_date_sk=2451663
+NumModifiedRows: 742
+Partition: ss_sold_date_sk=2451664
+NumModifiedRows: 815
+Partition: ss_sold_date_sk=2451665
+NumModifiedRows: 842
+Partition: ss_sold_date_sk=2451666
+NumModifiedRows: 868
+Partition: ss_sold_date_sk=2451667
+NumModifiedRows: 926
+Partition: ss_sold_date_sk=2451668
+NumModifiedRows: 694
+Partition: ss_sold_date_sk=2451669
+NumModifiedRows: 834
+Partition: ss_sold_date_sk=2451670
+NumModifiedRows: 935
+Partition: ss_sold_date_sk=2451671
+NumModifiedRows: 869
+Partition: ss_sold_date_sk=2451672
+NumModifiedRows: 900
+Partition: ss_sold_date_sk=2451673
+NumModifiedRows: 962
+Partition: ss_sold_date_sk=2451674
+NumModifiedRows: 787
+Partition: ss_sold_date_sk=2451675
+NumModifiedRows: 778
+Partition: ss_sold_date_sk=2451676
+NumModifiedRows: 776
+Partition: ss_sold_date_sk=2451677
+NumModifiedRows: 799
+Partition: ss_sold_date_sk=2451678
+NumModifiedRows: 841
+Partition: ss_sold_date_sk=2451679
+NumModifiedRows: 921
+Partition: ss_sold_date_sk=2451680
+NumModifiedRows: 953
+Partition: ss_sold_date_sk=2451681
+NumModifiedRows: 878
+Partition: ss_sold_date_sk=2451682
+NumModifiedRows: 1072
+Partition: ss_sold_date_sk=2451683
+NumModifiedRows: 903
+Partition: ss_sold_date_sk=2451684
+NumModifiedRows: 803
+Partition: ss_sold_date_sk=2451685
+NumModifiedRows: 957
+Partition: ss_sold_date_sk=2451686
+NumModifiedRows: 902
+Partition: ss_sold_date_sk=2451687
+NumModifiedRows: 847
+Partition: ss_sold_date_sk=2451688
+NumModifiedRows: 989
+Partition: ss_sold_date_sk=2451689
+NumModifiedRows: 876
+Partition: ss_sold_date_sk=2451690
+NumModifiedRows: 1113
+Partition: ss_sold_date_sk=2451691
+NumModifiedRows: 883
+Partition: ss_sold_date_sk=2451692
+NumModifiedRows: 800
+Partition: ss_sold_date_sk=2451693
+NumModifiedRows: 880
+Partition: ss_sold_date_sk=2451694
+NumModifiedRows: 1049
+Partition: ss_sold_date_sk=2451695
+NumModifiedRows: 709
+Partition: ss_sold_date_sk=2451696
+NumModifiedRows: 749
+Partition: ss_sold_date_sk=2451697
+NumModifiedRows: 809
+Partition: ss_sold_date_sk=2451698
+NumModifiedRows: 831
+Partition: ss_sold_date_sk=2451699
+NumModifiedRows: 841
+Partition: ss_sold_date_sk=2451700
+NumModifiedRows: 717
+Partition: ss_sold_date_sk=2451701
+NumModifiedRows: 736
+Partition: ss_sold_date_sk=2451702
+NumModifiedRows: 994
+Partition: ss_sold_date_sk=2451703
+NumModifiedRows: 932
+Partition: ss_sold_date_sk=2451704
+NumModifiedRows: 911
+Partition: ss_sold_date_sk=2451705
+NumModifiedRows: 853
+Partition: ss_sold_date_sk=2451706
+NumModifiedRows: 898
+Partition: ss_sold_date_sk=2451707
+NumModifiedRows: 921
+Partition: ss_sold_date_sk=2451708
+NumModifiedRows: 994
+Partition: ss_sold_date_sk=2451709
+NumModifiedRows: 1051
+Partition: ss_sold_date_sk=2451710
+NumModifiedRows: 1077
+Partition: ss_sold_date_sk=2451711
+NumModifiedRows: 714
+Partition: ss_sold_date_sk=2451712
+NumModifiedRows: 1057
+Partition: ss_sold_date_sk=2451713
+NumModifiedRows: 919
+Partition: ss_sold_date_sk=2451714
+NumModifiedRows: 933
+Partition: ss_sold_date_sk=2451715
+NumModifiedRows: 835
+Partition: ss_sold_date_sk=2451716
+NumModifiedRows: 1009
+Partition: ss_sold_date_sk=2451717
+NumModifiedRows: 981
+Partition: ss_sold_date_sk=2451718
+NumModifiedRows: 888
+Partition: ss_sold_date_sk=2451719
+NumModifiedRows: 787
+Partition: ss_sold_date_sk=2451720
+NumModifiedRows: 937
+Partition: ss_sold_date_sk=2451721
+NumModifiedRows: 857
+Partition: ss_sold_date_sk=2451722
+NumModifiedRows: 982
+Partition: ss_sold_date_sk=2451723
+NumModifiedRows: 891
+Partition: ss_sold_date_sk=2451724
+NumModifiedRows: 785
+Partition: ss_sold_date_sk=2451725
+NumModifiedRows: 809
+Partition: ss_sold_date_sk=2451726
+NumModifiedRows: 638
+Partition: ss_sold_date_sk=2451727
+NumModifiedRows: 990
+Partition: ss_sold_date_sk=2451728
+NumModifiedRows: 1050
+Partition: ss_sold_date_sk=2451729
+NumModifiedRows: 867
+Partition: ss_sold_date_sk=2451730
+NumModifiedRows: 1000
+Partition: ss_sold_date_sk=2451731
+NumModifiedRows: 924
+Partition: ss_sold_date_sk=2451732
+NumModifiedRows: 731
+Partition: ss_sold_date_sk=2451733
+NumModifiedRows: 927
+Partition: ss_sold_date_sk=2451734
+NumModifiedRows: 805
+Partition: ss_sold_date_sk=2451735
+NumModifiedRows: 848
+Partition: ss_sold_date_sk=2451736
+NumModifiedRows: 796
+Partition: ss_sold_date_sk=2451737
+NumModifiedRows: 854
+Partition: ss_sold_date_sk=2451738
+NumModifiedRows: 775
+Partition: ss_sold_date_sk=2451739
+NumModifiedRows: 727
+Partition: ss_sold_date_sk=2451740
+NumModifiedRows: 907
+Partition: ss_sold_date_sk=2451741
+NumModifiedRows: 855
+Partition: ss_sold_date_sk=2451742
+NumModifiedRows: 664
+Partition: ss_sold_date_sk=2451743
+NumModifiedRows: 894
+Partition: ss_sold_date_sk=2451744
+NumModifiedRows: 1009
+Partition: ss_sold_date_sk=2451745
+NumModifiedRows: 780
+Partition: ss_sold_date_sk=2451746
+NumModifiedRows: 802
+Partition: ss_sold_date_sk=2451747
+NumModifiedRows: 764
+Partition: ss_sold_date_sk=2451748
+NumModifiedRows: 753
+Partition: ss_sold_date_sk=2451749
+NumModifiedRows: 794
+Partition: ss_sold_date_sk=2451750
+NumModifiedRows: 756
+Partition: ss_sold_date_sk=2451751
+NumModifiedRows: 791
+Partition: ss_sold_date_sk=2451752
+NumModifiedRows: 713
+Partition: ss_sold_date_sk=2451753
+NumModifiedRows: 1013
+Partition: ss_sold_date_sk=2451754
+NumModifiedRows: 810
+Partition: ss_sold_date_sk=2451755
+NumModifiedRows: 707
+Partition: ss_sold_date_sk=2451756
+NumModifiedRows: 978
+Partition: ss_sold_date_sk=2451757
+NumModifiedRows: 1016
+Partition: ss_sold_date_sk=2451758
+NumModifiedRows: 1071
+Partition: ss_sold_date_sk=2451759
+NumModifiedRows: 2075
+Partition: ss_sold_date_sk=2451760
+NumModifiedRows: 2188
+Partition: ss_sold_date_sk=2451761
+NumModifiedRows: 1832
+Partition: ss_sold_date_sk=2451762
+NumModifiedRows: 2187
+Partition: ss_sold_date_sk=2451763
+NumModifiedRows: 1935
+Partition: ss_sold_date_sk=2451764
+NumModifiedRows: 1905
+Partition: ss_sold_date_sk=2451765
+NumModifiedRows: 2108
+Partition: ss_sold_date_sk=2451766
+NumModifiedRows: 1985
+Partition: ss_sold_date_sk=2451767
+NumModifiedRows: 1641
+Partition: ss_sold_date_sk=2451768
+NumModifiedRows: 1845
+Partition: ss_sold_date_sk=2451769
+NumModifiedRows: 1844
+Partition: ss_sold_date_sk=2451770
+NumModifiedRows: 2017
+Partition: ss_sold_date_sk=2451771
+NumModifiedRows: 2054
+Partition: ss_sold_date_sk=2451772
+NumModifiedRows: 1985
+Partition: ss_sold_date_sk=2451773
+NumModifiedRows: 2125
+Partition: ss_sold_date_sk=2451774
+NumModifiedRows: 1864
+Partition: ss_sold_date_sk=2451775
+NumModifiedRows: 1814
+Partition: ss_sold_date_sk=2451776
+NumModifiedRows: 2009
+Partition: ss_sold_date_sk=2451777
+NumModifiedRows: 2101
+Partition: ss_sold_date_sk=2451778
+NumModifiedRows: 1835
+Partition: ss_sold_date_sk=2451779
+NumModifiedRows: 1711
+Partition: ss_sold_date_sk=2451780
+NumModifiedRows: 1865
+Partition: ss_sold_date_sk=2451781
+NumModifiedRows: 2063
+Partition: ss_sold_date_sk=2451782
+NumModifiedRows: 1942
+Partition: ss_sold_date_sk=2451783
+NumModifiedRows: 1800
+Partition: ss_sold_date_sk=2451784
+NumModifiedRows: 1805
+Partition: ss_sold_date_sk=2451785
+NumModifiedRows: 1969
+Partition: ss_sold_date_sk=2451786
+NumModifiedRows: 2101
+Partition: ss_sold_date_sk=2451787
+NumModifiedRows: 2073
+Partition: ss_sold_date_sk=2451788
+NumModifiedRows: 2011
+Partition: ss_sold_date_sk=2451789
+NumModifiedRows: 1984
+Partition: ss_sold_date_sk=2451790
+NumModifiedRows: 2049
+Partition: ss_sold_date_sk=2451791
+NumModifiedRows: 2070
+Partition: ss_sold_date_sk=2451792
+NumModifiedRows: 2030
+Partition: ss_sold_date_sk=2451793
+NumModifiedRows: 2085
+Partition: ss_sold_date_sk=2451794
+NumModifiedRows: 2046
+Partition: ss_sold_date_sk=2451795
+NumModifiedRows: 2014
+Partition: ss_sold_date_sk=2451796
+NumModifiedRows: 1955
+Partition: ss_sold_date_sk=2451797
+NumModifiedRows: 2031
+Partition: ss_sold_date_sk=2451798
+NumModifiedRows: 2053
+Partition: ss_sold_date_sk=2451799
+NumModifiedRows: 2174
+Partition: ss_sold_date_sk=2451800
+NumModifiedRows: 2128
+Partition: ss_sold_date_sk=2451801
+NumModifiedRows: 2014
+Partition: ss_sold_date_sk=2451802
+NumModifiedRows: 2264
+Partition: ss_sold_date_sk=2451803
+NumModifiedRows: 2306
+Partition: ss_sold_date_sk=2451804
+NumModifiedRows: 2151
+Partition: ss_sold_date_sk=2451805
+NumModifiedRows: 2062
+Partition: ss_sold_date_sk=2451806
+NumModifiedRows: 2204
+Partition: ss_sold_date_sk=2451807
+NumModifiedRows: 2020
+Partition: ss_sold_date_sk=2451808
+NumModifiedRows: 1950
+Partition: ss_sold_date_sk=2451809
+NumModifiedRows: 1948
+Partition: ss_sold_date_sk=2451810
+NumModifiedRows: 2171
+Partition: ss_sold_date_sk=2451811
+NumModifiedRows: 1713
+Partition: ss_sold_date_sk=2451812
+NumModifiedRows: 2006
+Partition: ss_sold_date_sk=2451813
+NumModifiedRows: 2297
+Partition: ss_sold_date_sk=2451814
+NumModifiedRows: 1784
+Partition: ss_sold_date_sk=2451815
+NumModifiedRows: 1976
+Partition: ss_sold_date_sk=2451816
+NumModifiedRows: 1945
+Partition: ss_sold_date_sk=2451817
+NumModifiedRows: 1888
+Partition: ss_sold_date_sk=2451818
+NumModifiedRows: 2003
+Partition: ss_sold_date_sk=2451819
+NumModifiedRows: 1753
+Partition: ss_sold_date_sk=2451820
+NumModifiedRows: 2122
+Partition: ss_sold_date_sk=2451821
+NumModifiedRows: 2006
+Partition: ss_sold_date_sk=2451822
+NumModifiedRows: 2046
+Partition: ss_sold_date_sk=2451823
+NumModifiedRows: 2117
+Partition: ss_sold_date_sk=2451824
+NumModifiedRows: 1943
+Partition: ss_sold_date_sk=2451825
+NumModifiedRows: 1830
+Partition: ss_sold_date_sk=2451826
+NumModifiedRows: 1867
+Partition: ss_sold_date_sk=2451827
+NumModifiedRows: 1944
+Partition: ss_sold_date_sk=2451828
+NumModifiedRows: 2065
+Partition: ss_sold_date_sk=2451829
+NumModifiedRows: 1784
+Partition: ss_sold_date_sk=2451830
+NumModifiedRows: 2169
+Partition: ss_sold_date_sk=2451831
+NumModifiedRows: 1974
+Partition: ss_sold_date_sk=2451832
+NumModifiedRows: 2157
+Partition: ss_sold_date_sk=2451833
+NumModifiedRows: 1629
+Partition: ss_sold_date_sk=2451834
+NumModifiedRows: 1963
+Partition: ss_sold_date_sk=2451835
+NumModifiedRows: 2035
+Partition: ss_sold_date_sk=2451836
+NumModifiedRows: 1926
+Partition: ss_sold_date_sk=2451837
+NumModifiedRows: 1976
+Partition: ss_sold_date_sk=2451838
+NumModifiedRows: 1887
+Partition: ss_sold_date_sk=2451839
+NumModifiedRows: 2053
+Partition: ss_sold_date_sk=2451840
+NumModifiedRows: 1758
+Partition: ss_sold_date_sk=2451841
+NumModifiedRows: 2067
+Partition: ss_sold_date_sk=2451842
+NumModifiedRows: 1892
+Partition: ss_sold_date_sk=2451843
+NumModifiedRows: 1879
+Partition: ss_sold_date_sk=2451844
+NumModifiedRows: 2203
+Partition: ss_sold_date_sk=2451845
+NumModifiedRows: 2275
+Partition: ss_sold_date_sk=2451846
+NumModifiedRows: 1917
+Partition: ss_sold_date_sk=2451847
+NumModifiedRows: 2008
+Partition: ss_sold_date_sk=2451848
+NumModifiedRows: 2193
+Partition: ss_sold_date_sk=2451849
+NumModifiedRows: 1867
+Partition: ss_sold_date_sk=2451850
+NumModifiedRows: 2184
+Partition: ss_sold_date_sk=2451851
+NumModifiedRows: 2716
+Partition: ss_sold_date_sk=2451852
+NumModifiedRows: 2676
+Partition: ss_sold_date_sk=2451853
+NumModifiedRows: 3405
+Partition: ss_sold_date_sk=2451854
+NumModifiedRows: 3302
+Partition: ss_sold_date_sk=2451855
+NumModifiedRows: 3086
+Partition: ss_sold_date_sk=2451856
+NumModifiedRows: 3060
+Partition: ss_sold_date_sk=2451857
+NumModifiedRows: 2844
+Partition: ss_sold_date_sk=2451858
+NumModifiedRows: 3160
+Partition: ss_sold_date_sk=2451859
+NumModifiedRows: 3106
+Partition: ss_sold_date_sk=2451860
+NumModifiedRows: 3019
+Partition: ss_sold_date_sk=2451861
+NumModifiedRows: 2746
+Partition: ss_sold_date_sk=2451862
+NumModifiedRows: 2991
+Partition: ss_sold_date_sk=2451863
+NumModifiedRows: 2971
+Partition: ss_sold_date_sk=2451864
+NumModifiedRows: 2975
+Partition: ss_sold_date_sk=2451865
+NumModifiedRows: 2985
+Partition: ss_sold_date_sk=2451866
+NumModifiedRows: 3068
+Partition: ss_sold_date_sk=2451867
+NumModifiedRows: 2885
+Partition: ss_sold_date_sk=2451868
+NumModifiedRows: 3291
+Partition: ss_sold_date_sk=2451869
+NumModifiedRows: 2694
+Partition: ss_sold_date_sk=2451870
+NumModifiedRows: 2975
+Partition: ss_sold_date_sk=2451871
+NumModifiedRows: 2923
+Partition: ss_sold_date_sk=2451872
+NumModifiedRows: 2949
+Partition: ss_sold_date_sk=2451873
+NumModifiedRows: 3373
+Partition: ss_sold_date_sk=2451874
+NumModifiedRows: 2847
+Partition: ss_sold_date_sk=2451875
+NumModifiedRows: 3111
+Partition: ss_sold_date_sk=2451876
+NumModifiedRows: 2790
+Partition: ss_sold_date_sk=2451877
+NumModifiedRows: 2945
+Partition: ss_sold_date_sk=2451878
+NumModifiedRows: 2641
+Partition: ss_sold_date_sk=2451879
+NumModifiedRows: 2961
+Partition: ss_sold_date_sk=2451880
+NumModifiedRows: 2966
+Partition: ss_sold_date_sk=2451881
+NumModifiedRows: 3246
+Partition: ss_sold_date_sk=2451882
+NumModifiedRows: 3029
+Partition: ss_sold_date_sk=2451883
+NumModifiedRows: 2990
+Partition: ss_sold_date_sk=2451884
+NumModifiedRows: 2981
+Partition: ss_sold_date_sk=2451885
+NumModifiedRows: 2668
+Partition: ss_sold_date_sk=2451886
+NumModifiedRows: 3125
+Partition: ss_sold_date_sk=2451887
+NumModifiedRows: 2681
+Partition: ss_sold_date_sk=2451888
+NumModifiedRows: 3343
+Partition: ss_sold_date_sk=2451889
+NumModifiedRows: 3053
+Partition: ss_sold_date_sk=2451890
+NumModifiedRows: 2957
+Partition: ss_sold_date_sk=2451891
+NumModifiedRows: 3060
+Partition: ss_sold_date_sk=2451892
+NumModifiedRows: 2876
+Partition: ss_sold_date_sk=2451893
+NumModifiedRows: 2719
+Partition: ss_sold_date_sk=2451894
+NumModifiedRows: 2999
+Partition: ss_sold_date_sk=2451895
+NumModifiedRows: 3245
+Partition: ss_sold_date_sk=2451896
+NumModifiedRows: 3115
+Partition: ss_sold_date_sk=2451897
+NumModifiedRows: 3070
+Partition: ss_sold_date_sk=2451898
+NumModifiedRows: 2978
+Partition: ss_sold_date_sk=2451899
+NumModifiedRows: 3004
+Partition: ss_sold_date_sk=2451900
+NumModifiedRows: 3194
+Partition: ss_sold_date_sk=2451901
+NumModifiedRows: 2833
+Partition: ss_sold_date_sk=2451902
+NumModifiedRows: 2826
+Partition: ss_sold_date_sk=2451903
+NumModifiedRows: 2850
+Partition: ss_sold_date_sk=2451904
+NumModifiedRows: 2789
+Partition: ss_sold_date_sk=2451905
+NumModifiedRows: 2867
+Partition: ss_sold_date_sk=2451906
+NumModifiedRows: 3129
+Partition: ss_sold_date_sk=2451907
+NumModifiedRows: 2876
+Partition: ss_sold_date_sk=2451908
+NumModifiedRows: 3114
+Partition: ss_sold_date_sk=2451909
+NumModifiedRows: 3060
+Partition: ss_sold_date_sk=2451910
+NumModifiedRows: 3109
+aggregation(SUM, RowsInserted): 553861
====
---- QUERY: TPCDS-SS-INSERT-VERIFY
SELECT COUNT(*) FROM store_sales_insert
