You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by jo...@apache.org on 2018/05/10 16:25:36 UTC
[4/5] impala git commit: IMPALA-6819: Add new queries to
targeted-perf workload
IMPALA-6819: Add new queries to targeted-perf workload
Description:
Adding new queries to the targeted-perf workload that is
used by Impala performance tests run via $IMPALA_HOME/bin/run-workload.py
Testing:
Ran the performance tests for the targeted-perf workload
and all the tests passed
Change-Id: I5c415924d0bb6da1b1f5df6cb16b95a1d2eaa3ab
Reviewed-on: http://gerrit.cloudera.org:8080/9979
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: David Knupp <dk...@cloudera.com>
Project: http://git-wip-us.apache.org/repos/asf/impala/repo
Commit: http://git-wip-us.apache.org/repos/asf/impala/commit/59ccbbd7
Tree: http://git-wip-us.apache.org/repos/asf/impala/tree/59ccbbd7
Diff: http://git-wip-us.apache.org/repos/asf/impala/diff/59ccbbd7
Branch: refs/heads/2.x
Commit: 59ccbbd70b90f322e486bb69796fbe2181ced98b
Parents: 1c21cd0
Author: njanarthanan <nj...@cloudera.com>
Authored: Tue Apr 10 15:19:03 2018 -0700
Committer: Impala Public Jenkins <im...@gerrit.cloudera.org>
Committed: Wed May 9 23:10:16 2018 +0000
----------------------------------------------------------------------
.../queries/primitive_conjunct_ordering_1.test | 9 +
.../queries/primitive_conjunct_ordering_2.test | 28 +
.../queries/primitive_conjunct_ordering_3.test | 14 +
.../queries/primitive_conjunct_ordering_4.test | 25 +
.../queries/primitive_count_star.test | 9 +
.../queries/primitive_decimal_arithmetic.test | 13 +
.../primitive_filter_bigint_in_list.test | 9 +
.../primitive_intrinsic_appx_median.test | 8 +
.../queries/primitive_intrinsic_to_date.test | 8 +
.../queries/primitive_long_predicate.test | 514 +++++++++++++------
.../queries/primitive_many_fragments.test | 9 +
.../primitive_many_independent_fragments.test | 29 ++
.../primitive_orderby_bigint_expression.test | 15 +
.../queries/primitive_shuffle_1mb_rows.test | 156 ++++++
14 files changed, 675 insertions(+), 171 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_1.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_1.test b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_1.test
new file mode 100644
index 0000000..568dde6
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_1.test
@@ -0,0 +1,9 @@
+====
+---- QUERY: primitive_conjunct_ordering_1
+-- Description : A simple select with one expensive conjunct and one cheap conjunct.
+SELECT *
+FROM lineitem
+WHERE (l_shipdate < current_timestamp() - interval 1 day) AND l_orderkey = -1;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_2.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_2.test b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_2.test
new file mode 100644
index 0000000..858cfa5
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_2.test
@@ -0,0 +1,28 @@
+====
+---- QUERY: primitive_conjunct_ordering_2
+-- Description: Based on TPCH-Q19
+SELECT sum(l_extendedprice * (1 - l_discount)) AS revenue
+FROM lineitem, part
+WHERE p_partkey = l_partkey
+ AND ((p_brand = 'Brand#12'
+ AND p_container IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
+ AND l_quantity >= 1 AND l_quantity <= 11
+ AND p_size BETWEEN 1 AND 5
+ AND l_shipmode IN ('AIR', 'AIR REG')
+ AND l_shipinstruct = 'DELIVER IN PERSON')
+ OR (p_brand = 'Brand#23'
+ AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
+ AND l_quantity >= 10 AND l_quantity <= 20
+ AND p_size BETWEEN 1 AND 10
+ AND l_shipmode IN ('AIR', 'AIR REG')
+ AND l_shipinstruct = 'DELIVER IN PERSON')
+ OR (p_brand = 'Brand#34'
+ AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
+ AND l_quantity >= 20 AND l_quantity <= 30
+ AND p_size BETWEEN 1 AND 15
+ AND l_shipmode IN ('AIR', 'AIR REG')
+ AND l_shipinstruct = 'DELIVER IN PERSON'))
+ AND (p_partkey = 0 OR l_partkey = 0)
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_3.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_3.test b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_3.test
new file mode 100644
index 0000000..265a573
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_3.test
@@ -0,0 +1,14 @@
+====
+---- QUERY: primitive_conjunct_ordering_3
+-- Description: Based on TPCDS-Q28
+SELECT avg(l_extendedprice), count(l_extendedprice), count(distinct l_extendedprice)
+FROM lineitem
+WHERE
+ (l_discount BETWEEN 0.2 AND 0.3
+ OR l_discount BETWEEN 0.4 AND 0.5
+ OR l_tax BETWEEN 0.1 AND 0.2
+ OR l_tax BETWEEN 0 AND 0.09)
+ AND l_extendedprice BETWEEN 100 AND 500
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_4.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_4.test b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_4.test
new file mode 100644
index 0000000..a147d48
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_conjunct_ordering_4.test
@@ -0,0 +1,25 @@
+====
+---- QUERY: primitive_conjunct_ordering_4
+-- Description: Based on TPCDS-Q41
+SELECT p_mfgr, count(*) as item_cnt
+FROM part
+WHERE ((p_type LIKE '%STEEL%'
+ AND p_size BETWEEN 10 AND 40
+ AND p_container IN ('LG BOX', 'LG BAG', 'LG CASE'))
+ OR (p_type LIKE '%COPPER%'
+ AND p_size BETWEEN 20 AND 50
+ AND p_container IN ('JUMBO BOX', 'JUMBO BAG', 'JUMBO CASE'))
+ OR (p_type LIKE '%TIN%'
+ AND p_size BETWEEN 0 AND 30
+ AND p_container IN ('MED BOX', 'MED BAG', 'MED CASE'))
+ OR (p_type LIKE '%BRASS%'
+ AND p_size BETWEEN 0 AND 20
+ AND p_container IN ('SMALL BOX', 'SMALL BAG', 'SMALL CASE')))
+ AND p_partkey = -1
+GROUP BY p_mfgr
+---- RESULTS
+---- TYPES
+====
+
+
+
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_count_star.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_count_star.test b/testdata/workloads/targeted-perf/queries/primitive_count_star.test
new file mode 100644
index 0000000..fc7bd06
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_count_star.test
@@ -0,0 +1,9 @@
+====
+---- QUERY: primitive_count_star
+-- Description : Excercise Parquet stats optimization when evaluating count(*)
+-- Target test case : Simple count(*) query.
+SELECT count(*)
+FROM lineitem;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_decimal_arithmetic.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_decimal_arithmetic.test b/testdata/workloads/targeted-perf/queries/primitive_decimal_arithmetic.test
new file mode 100644
index 0000000..9e12839
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_decimal_arithmetic.test
@@ -0,0 +1,13 @@
+====
+---- QUERY: primitive_decimal_arithmetic
+-- Description : Query dominated by decimal arithmetic
+-- Target test case : Validate and track decimal arithmetic performance .
+ select
+ sum(l_quantity * l_tax), sum(l_extendedprice * l_discount) ,
+ sum(l_quantity / l_tax), sum(l_extendedprice / l_discount),
+ sum(l_quantity + l_tax), sum(l_extendedprice + l_discount) ,
+ sum(l_quantity - l_tax), sum(l_extendedprice - l_discount)
+ from lineitem where l_tax > 0 and l_discount > 0;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_filter_bigint_in_list.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_filter_bigint_in_list.test b/testdata/workloads/targeted-perf/queries/primitive_filter_bigint_in_list.test
new file mode 100644
index 0000000..f8371ea
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_filter_bigint_in_list.test
@@ -0,0 +1,9 @@
+====
+---- QUERY: primitive_filter_bigint_in_list
+-- Description : Scan fact table while applying long in-list filter on bigint column.
+-- Target test case : Basic scan and filter.
+SELECT count(*)
+FROM lineitem where l_orderkey in (1,6,11,16,21,26,31,36,41,46,51,56,61,66,71,76,81,86,91,96,101,106,111,116,121,126,131,136,141,146,151,156,161,166,171,176,181,186,191,196,201,206,211,216,221,226,231,236,241,246,251,256,261,266,271,276,281,286,291,296,301,306,311,316,321,326,331,336,341,346,351,356,361,366,371,376,381,386,391,396,401,406,411,416,421,426,431,436,441,446,451,456,461,466,471,476,481,486,491,496,501,506,511,516,521,526,531,536,541,546,551,556,561,566,571,576,581,586,591,596,601,606,611,616,621,626,631,636,641,646,651,656,661,666,671,676,681,686,691,696,701,706,711,716,721,726,731,736,741,746,751,756,761,766,771,776,781,786,791,796,801,806,811,816,821,826,831,836,841,846,851,856,861,866,871,876,881,886,891,896,901,906,911,916,921,926,931,936,941,946,951,956,961,966,971,976,981,986,991,996,1001,1006,1011,1016,1021,1026,1031,1036,1041,1046,1051,1056,1061,1066,1071,1076,1081,1086,1091,1096,1101,1106,1111,1116,1121,1126,1131,1136,1141,1146,1151,1156,1161,1166,1171,1176,1181
,1186,1191,1196,1201,1206,1211,1216,1221,1226,1231,1236,1241,1246,1251,1256,1261,1266,1271,1276,1281,1286,1291,1296,1301,1306,1311,1316,1321,1326,1331,1336,1341,1346,1351,1356,1361,1366,1371,1376,1381,1386,1391,1396,1401,1406,1411,1416,1421,1426,1431,1436,1441,1446,1451,1456,1461,1466,1471,1476,1481,1486,1491,1496,1501,1506,1511,1516,1521,1526,1531,1536,1541,1546,1551,1556,1561,1566,1571,1576,1581,1586,1591,1596,1601,1606,1611,1616,1621,1626,1631,1636,1641,1646,1651,1656,1661,1666,1671,1676,1681,1686,1691,1696,1701,1706,1711,1716,1721,1726,1731,1736,1741,1746,1751,1756,1761,1766,1771,1776,1781,1786,1791,1796,1801,1806,1811,1816,1821,1826,1831,1836,1841,1846,1851,1856,1861,1866,1871,1876,1881,1886,1891,1896,1901,1906,1911,1916,1921,1926,1931,1936,1941,1946,1951,1956,1961,1966,1971,1976,1981,1986,1991,1996,2001,2006,2011,2016,2021,2026,2031,2036,2041,2046,2051,2056,2061,2066,2071,2076,2081,2086,2091,2096,2101,2106,2111,2116,2121,2126,2131,2136,2141,2146,2151,2156,2161,2166,2171,2176,2
181,2186,2191,2196,2201,2206,2211,2216,2221,2226,2231,2236,2241,2246,2251,2256,2261,2266,2271,2276,2281,2286);
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_intrinsic_appx_median.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_intrinsic_appx_median.test b/testdata/workloads/targeted-perf/queries/primitive_intrinsic_appx_median.test
new file mode 100644
index 0000000..309faf1
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_intrinsic_appx_median.test
@@ -0,0 +1,8 @@
+====
+---- QUERY: primitive_intrinsic_appx_median
+-- Description : Query dominated by APPX_MEDIAN
+-- Target test case : Validate and track memory consumption and perf for APPX_MEDIAN .
+select APPX_MEDIAN(o_totalprice),APPX_MEDIAN(o_orderpriority), count(*) from orders group by o_orderdate,o_orderpriority having count(*) > 100000;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_intrinsic_to_date.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_intrinsic_to_date.test b/testdata/workloads/targeted-perf/queries/primitive_intrinsic_to_date.test
new file mode 100644
index 0000000..1a357a8
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_intrinsic_to_date.test
@@ -0,0 +1,8 @@
+====
+---- QUERY: primitive_intrinsic_to_date
+-- Description : Cast string to date.
+-- Target test case : Validate and track performance of to_date().
+select max(to_date(l_shipdate)),min(to_date(l_commitdate)), max(to_date(l_receiptdate)) from lineitem ;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_long_predicate.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_long_predicate.test b/testdata/workloads/targeted-perf/queries/primitive_long_predicate.test
index b7ae8c8..294c7bc 100644
--- a/testdata/workloads/targeted-perf/queries/primitive_long_predicate.test
+++ b/testdata/workloads/targeted-perf/queries/primitive_long_predicate.test
@@ -6,177 +6,349 @@
-- in the FE to expose the long expressions to the BE.
SELECT COUNT(*)
FROM lineitem
-WHERE ((l_orderkey = 520 AND l_shipdate between "2017-01-01 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 534 AND l_shipdate between "2017-01-02 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 518 AND l_shipdate between "2017-01-03 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 535 AND l_shipdate between "2017-01-04 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 496 AND l_shipdate between "2017-01-05 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 497 AND l_shipdate between "2017-01-06 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 516 AND l_shipdate between "2017-01-07 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 531 AND l_shipdate between "2017-01-08 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 533 AND l_shipdate between "2017-01-09 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 532 AND l_shipdate between "2017-01-10 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 546 AND l_shipdate between "2017-01-11 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 549 AND l_shipdate between "2017-01-12 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 548 AND l_shipdate between "2017-01-13 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 547 AND l_shipdate between "2017-01-14 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 513 AND l_shipdate between "2017-01-15 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 515 AND l_shipdate between "2017-01-16 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 507 AND l_shipdate between "2017-01-17 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 509 AND l_shipdate between "2017-01-18 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 519 AND l_shipdate between "2017-01-19 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 527 AND l_shipdate between "2017-01-20 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 501 AND l_shipdate between "2017-01-21 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 544 AND l_shipdate between "2017-01-22 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 545 AND l_shipdate between "2017-01-23 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 541 AND l_shipdate between "2017-01-24 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 550 AND l_shipdate between "2017-01-25 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 529 AND l_shipdate between "2017-01-26 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 528 AND l_shipdate between "2017-01-27 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 537 AND l_shipdate between "2017-01-28 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 538 AND l_shipdate between "2017-01-29 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 506 AND l_shipdate between "2017-01-30 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 502 AND l_shipdate between "2017-01-31 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 543 AND l_shipdate between "2017-03-01 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 390 AND l_shipdate between "2017-03-02 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 389 AND l_shipdate between "2017-03-03 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 0 AND l_shipdate between "2017-03-04 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 852 AND l_shipdate between "2017-03-05 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 853 AND l_shipdate between "2017-03-06 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 854 AND l_shipdate between "2017-03-07 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 844 AND l_shipdate between "2017-03-08 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 846 AND l_shipdate between "2017-03-09 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 843 AND l_shipdate between "2017-03-10 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 849 AND l_shipdate between "2017-03-11 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 850 AND l_shipdate between "2017-03-12 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 847 AND l_shipdate between "2017-03-13 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 746 AND l_shipdate between "2017-03-14 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 745 AND l_shipdate between "2017-03-15 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 901 AND l_shipdate between "2017-03-16 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 899 AND l_shipdate between "2017-03-17 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 895 AND l_shipdate between "2017-03-18 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 878 AND l_shipdate between "2017-03-19 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 884 AND l_shipdate between "2017-03-20 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 871 AND l_shipdate between "2017-03-21 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 872 AND l_shipdate between "2017-03-22 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 886 AND l_shipdate between "2017-03-23 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 879 AND l_shipdate between "2017-03-24 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 864 AND l_shipdate between "2017-03-25 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 889 AND l_shipdate between "2017-03-26 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 885 AND l_shipdate between "2017-03-27 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 848 AND l_shipdate between "2017-03-28 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 888 AND l_shipdate between "2017-03-29 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 863 AND l_shipdate between "2017-03-30 12:00:00" AND "2017-04-17 02:22:02") OR
- (l_orderkey = 930 AND l_shipdate between "2017-03-31 12:00:00" AND "2017-04-17 02:22:03") OR
- (l_orderkey = 891 AND l_shipdate between "2017-05-01 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 890 AND l_shipdate between "2017-05-02 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 926 AND l_shipdate between "2017-05-03 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 927 AND l_shipdate between "2017-05-04 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 892 AND l_shipdate between "2017-05-05 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 925 AND l_shipdate between "2017-05-06 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 887 AND l_shipdate between "2017-05-07 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 898 AND l_shipdate between "2017-05-08 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 902 AND l_shipdate between "2017-05-09 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 903 AND l_shipdate between "2017-05-10 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 904 AND l_shipdate between "2017-05-11 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 897 AND l_shipdate between "2017-05-12 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 900 AND l_shipdate between "2017-05-13 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 598 AND l_shipdate between "2017-05-14 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 597 AND l_shipdate between "2017-05-15 12:00:00" AND "2017-06-17 02:22:02") OR
- (l_orderkey = 607 AND l_shipdate between "2017-05-16 12:00:00" AND "2017-06-17 02:22:03") OR
- (l_orderkey = 288 AND l_shipdate between "2017-01-01 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 289 AND l_shipdate between "2017-01-02 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 281 AND l_shipdate between "2017-01-03 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 287 AND l_shipdate between "2017-01-04 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 290 AND l_shipdate between "2017-01-05 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 264 AND l_shipdate between "2017-01-06 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 292 AND l_shipdate between "2017-01-07 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 241 AND l_shipdate between "2017-01-08 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 291 AND l_shipdate between "2017-01-09 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 286 AND l_shipdate between "2017-01-10 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 148 AND l_shipdate between "2017-01-11 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 298 AND l_shipdate between "2017-01-12 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 278 AND l_shipdate between "2017-01-13 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 284 AND l_shipdate between "2017-01-14 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 285 AND l_shipdate between "2017-01-15 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 283 AND l_shipdate between "2017-01-16 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 295 AND l_shipdate between "2017-01-17 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 296 AND l_shipdate between "2017-01-18 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 293 AND l_shipdate between "2017-01-19 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 294 AND l_shipdate between "2017-01-20 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 282 AND l_shipdate between "2017-01-21 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 263 AND l_shipdate between "2017-01-22 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 297 AND l_shipdate between "2017-01-23 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 299 AND l_shipdate between "2017-01-24 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 300 AND l_shipdate between "2017-01-25 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 265 AND l_shipdate between "2017-01-26 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 267 AND l_shipdate between "2017-01-27 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 520 AND l_shipdate between "2017-01-28 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 534 AND l_shipdate between "2017-01-29 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 518 AND l_shipdate between "2017-01-30 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 535 AND l_shipdate between "2017-01-31 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 496 AND l_shipdate between "2017-02-01 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 497 AND l_shipdate between "2017-02-02 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 516 AND l_shipdate between "2017-02-03 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 531 AND l_shipdate between "2017-02-04 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 533 AND l_shipdate between "2017-02-05 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 532 AND l_shipdate between "2017-02-06 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 546 AND l_shipdate between "2017-02-07 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 549 AND l_shipdate between "2017-02-08 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 548 AND l_shipdate between "2017-02-09 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 547 AND l_shipdate between "2017-02-10 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 513 AND l_shipdate between "2017-02-11 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 515 AND l_shipdate between "2017-02-12 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 507 AND l_shipdate between "2017-02-13 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 509 AND l_shipdate between "2017-02-14 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 519 AND l_shipdate between "2017-02-15 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 527 AND l_shipdate between "2017-02-16 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 503 AND l_shipdate between "2017-02-17 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 498 AND l_shipdate between "2017-02-18 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 501 AND l_shipdate between "2017-02-19 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 544 AND l_shipdate between "2017-02-20 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 545 AND l_shipdate between "2017-02-21 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 540 AND l_shipdate between "2017-02-22 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 541 AND l_shipdate between "2017-02-23 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 550 AND l_shipdate between "2017-02-24 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 529 AND l_shipdate between "2017-02-25 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 528 AND l_shipdate between "2017-03-01 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 537 AND l_shipdate between "2017-03-02 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 538 AND l_shipdate between "2017-03-03 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 506 AND l_shipdate between "2017-03-04 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 500 AND l_shipdate between "2017-03-05 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 539 AND l_shipdate between "2017-03-06 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 512 AND l_shipdate between "2017-03-07 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 502 AND l_shipdate between "2017-03-08 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 504 AND l_shipdate between "2017-03-09 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 543 AND l_shipdate between "2017-03-10 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 390 AND l_shipdate between "2017-03-11 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 389 AND l_shipdate between "2017-03-12 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 0 AND l_shipdate between "2017-03-13 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 844 AND l_shipdate between "2017-03-14 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 846 AND l_shipdate between "2017-03-15 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 894 AND l_shipdate between "2017-03-16 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 843 AND l_shipdate between "2017-03-17 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 744 AND l_shipdate between "2017-04-01 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 847 AND l_shipdate between "2017-04-02 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 746 AND l_shipdate between "2017-04-03 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 745 AND l_shipdate between "2017-04-04 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 893 AND l_shipdate between "2017-04-05 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 901 AND l_shipdate between "2017-04-06 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 899 AND l_shipdate between "2017-04-07 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 878 AND l_shipdate between "2017-04-08 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 884 AND l_shipdate between "2017-04-09 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 883 AND l_shipdate between "2017-04-10 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 879 AND l_shipdate between "2017-04-11 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 929 AND l_shipdate between "2017-04-12 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 885 AND l_shipdate between "2017-04-13 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 891 AND l_shipdate between "2017-04-14 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 892 AND l_shipdate between "2017-04-15 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 882 AND l_shipdate between "2017-04-16 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 898 AND l_shipdate between "2017-04-17 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 876 AND l_shipdate between "2017-04-18 12:00:00" AND "2017-04-18 02:22:02") OR
- (l_orderkey = 743 AND l_shipdate between "2017-04-19 12:00:00" AND "2017-06-18 02:22:02") OR
- (l_orderkey = 900 AND l_shipdate between "2017-04-20 12:00:00" AND "2017-06-18 02:22:02"));
+WHERE
+((l_orderkey = 520 AND l_shipdate between "2017-01-01 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 534 AND l_shipdate between "2017-01-02 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 518 AND l_shipdate between "2017-01-03 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 535 AND l_shipdate between "2017-01-04 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 496 AND l_shipdate between "2017-01-05 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 497 AND l_shipdate between "2017-01-06 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 516 AND l_shipdate between "2017-01-07 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 531 AND l_shipdate between "2017-01-08 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 533 AND l_shipdate between "2017-01-09 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 532 AND l_shipdate between "2017-01-10 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 546 AND l_shipdate between "2017-01-11 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 549 AND l_shipdate between "2017-01-12 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 548 AND l_shipdate between "2017-01-13 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 547 AND l_shipdate between "2017-01-14 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 513 AND l_shipdate between "2017-01-15 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 515 AND l_shipdate between "2017-01-16 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 507 AND l_shipdate between "2017-01-17 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 509 AND l_shipdate between "2017-01-18 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 519 AND l_shipdate between "2017-01-19 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 527 AND l_shipdate between "2017-01-20 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 501 AND l_shipdate between "2017-01-21 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 544 AND l_shipdate between "2017-01-22 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 545 AND l_shipdate between "2017-01-23 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 541 AND l_shipdate between "2017-01-24 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 550 AND l_shipdate between "2017-01-25 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 529 AND l_shipdate between "2017-01-26 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 528 AND l_shipdate between "2017-01-27 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 537 AND l_shipdate between "2017-01-28 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 538 AND l_shipdate between "2017-01-29 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 506 AND l_shipdate between "2017-01-30 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 502 AND l_shipdate between "2017-01-31 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 543 AND l_shipdate between "2017-03-01 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 390 AND l_shipdate between "2017-03-02 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 389 AND l_shipdate between "2017-03-03 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 0 AND l_shipdate between "2017-03-04 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 852 AND l_shipdate between "2017-03-05 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 853 AND l_shipdate between "2017-03-06 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 854 AND l_shipdate between "2017-03-07 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 844 AND l_shipdate between "2017-03-08 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 846 AND l_shipdate between "2017-03-09 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 843 AND l_shipdate between "2017-03-10 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 849 AND l_shipdate between "2017-03-11 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 850 AND l_shipdate between "2017-03-12 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 847 AND l_shipdate between "2017-03-13 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 746 AND l_shipdate between "2017-03-14 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 745 AND l_shipdate between "2017-03-15 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 901 AND l_shipdate between "2017-03-16 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 899 AND l_shipdate between "2017-03-17 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 895 AND l_shipdate between "2017-03-18 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 878 AND l_shipdate between "2017-03-19 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 884 AND l_shipdate between "2017-03-20 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 871 AND l_shipdate between "2017-03-21 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 872 AND l_shipdate between "2017-03-22 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 886 AND l_shipdate between "2017-03-23 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 879 AND l_shipdate between "2017-03-24 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 864 AND l_shipdate between "2017-03-25 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 889 AND l_shipdate between "2017-03-26 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 885 AND l_shipdate between "2017-03-27 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 848 AND l_shipdate between "2017-03-28 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 888 AND l_shipdate between "2017-03-29 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 863 AND l_shipdate between "2017-03-30 12:00:00" AND "2017-04-17 02:22:02") OR
+(l_orderkey = 930 AND l_shipdate between "2017-03-31 12:00:00" AND "2017-04-17 02:22:03") OR
+(l_orderkey = 891 AND l_shipdate between "2017-05-01 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 890 AND l_shipdate between "2017-05-02 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 926 AND l_shipdate between "2017-05-03 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 927 AND l_shipdate between "2017-05-04 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 892 AND l_shipdate between "2017-05-05 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 925 AND l_shipdate between "2017-05-06 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 887 AND l_shipdate between "2017-05-07 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 898 AND l_shipdate between "2017-05-08 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 902 AND l_shipdate between "2017-05-09 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 903 AND l_shipdate between "2017-05-10 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 904 AND l_shipdate between "2017-05-11 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 897 AND l_shipdate between "2017-05-12 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 900 AND l_shipdate between "2017-05-13 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 598 AND l_shipdate between "2017-05-14 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 597 AND l_shipdate between "2017-05-15 12:00:00" AND "2017-06-17 02:22:02") OR
+(l_orderkey = 607 AND l_shipdate between "2017-05-16 12:00:00" AND "2017-06-17 02:22:03") OR
+(l_orderkey = 288 AND l_shipdate between "2017-01-01 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 289 AND l_shipdate between "2017-01-02 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 281 AND l_shipdate between "2017-01-03 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 287 AND l_shipdate between "2017-01-04 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 290 AND l_shipdate between "2017-01-05 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 264 AND l_shipdate between "2017-01-06 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 292 AND l_shipdate between "2017-01-07 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 241 AND l_shipdate between "2017-01-08 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 291 AND l_shipdate between "2017-01-09 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 286 AND l_shipdate between "2017-01-10 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 148 AND l_shipdate between "2017-01-11 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 298 AND l_shipdate between "2017-01-12 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 278 AND l_shipdate between "2017-01-13 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 284 AND l_shipdate between "2017-01-14 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 285 AND l_shipdate between "2017-01-15 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 283 AND l_shipdate between "2017-01-16 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 295 AND l_shipdate between "2017-01-17 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 296 AND l_shipdate between "2017-01-18 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 293 AND l_shipdate between "2017-01-19 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 294 AND l_shipdate between "2017-01-20 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 282 AND l_shipdate between "2017-01-21 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 263 AND l_shipdate between "2017-01-22 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 297 AND l_shipdate between "2017-01-23 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 299 AND l_shipdate between "2017-01-24 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 300 AND l_shipdate between "2017-01-25 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 265 AND l_shipdate between "2017-01-26 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 267 AND l_shipdate between "2017-01-27 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 520 AND l_shipdate between "2017-01-28 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 534 AND l_shipdate between "2017-01-29 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 518 AND l_shipdate between "2017-01-30 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 535 AND l_shipdate between "2017-01-31 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 496 AND l_shipdate between "2017-02-01 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 497 AND l_shipdate between "2017-02-02 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 516 AND l_shipdate between "2017-02-03 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 531 AND l_shipdate between "2017-02-04 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 533 AND l_shipdate between "2017-02-05 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 532 AND l_shipdate between "2017-02-06 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 546 AND l_shipdate between "2017-02-07 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 549 AND l_shipdate between "2017-02-08 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 548 AND l_shipdate between "2017-02-09 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 547 AND l_shipdate between "2017-02-10 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 513 AND l_shipdate between "2017-02-11 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 515 AND l_shipdate between "2017-02-12 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 507 AND l_shipdate between "2017-02-13 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 509 AND l_shipdate between "2017-02-14 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 519 AND l_shipdate between "2017-02-15 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 527 AND l_shipdate between "2017-02-16 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 503 AND l_shipdate between "2017-02-17 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 498 AND l_shipdate between "2017-02-18 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 501 AND l_shipdate between "2017-02-19 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 544 AND l_shipdate between "2017-02-20 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 545 AND l_shipdate between "2017-02-21 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 540 AND l_shipdate between "2017-02-22 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 541 AND l_shipdate between "2017-02-23 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 550 AND l_shipdate between "2017-02-24 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 529 AND l_shipdate between "2017-02-25 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 528 AND l_shipdate between "2017-03-01 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 537 AND l_shipdate between "2017-03-02 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 538 AND l_shipdate between "2017-03-03 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 506 AND l_shipdate between "2017-03-04 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 500 AND l_shipdate between "2017-03-05 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 539 AND l_shipdate between "2017-03-06 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 512 AND l_shipdate between "2017-03-07 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 502 AND l_shipdate between "2017-03-08 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 504 AND l_shipdate between "2017-03-09 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 543 AND l_shipdate between "2017-03-10 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 390 AND l_shipdate between "2017-03-11 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 389 AND l_shipdate between "2017-03-12 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 0 AND l_shipdate between "2017-03-13 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 844 AND l_shipdate between "2017-03-14 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 846 AND l_shipdate between "2017-03-15 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 894 AND l_shipdate between "2017-03-16 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 843 AND l_shipdate between "2017-03-17 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 744 AND l_shipdate between "2017-04-01 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 847 AND l_shipdate between "2017-04-02 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 746 AND l_shipdate between "2017-04-03 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 745 AND l_shipdate between "2017-04-04 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 893 AND l_shipdate between "2017-04-05 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 901 AND l_shipdate between "2017-04-06 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 899 AND l_shipdate between "2017-04-07 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 878 AND l_shipdate between "2017-04-08 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 884 AND l_shipdate between "2017-04-09 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 883 AND l_shipdate between "2017-04-10 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 879 AND l_shipdate between "2017-04-11 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 929 AND l_shipdate between "2017-04-12 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 885 AND l_shipdate between "2017-04-13 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 891 AND l_shipdate between "2017-04-14 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 892 AND l_shipdate between "2017-04-15 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 882 AND l_shipdate between "2017-04-16 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 898 AND l_shipdate between "2017-04-17 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 876 AND l_shipdate between "2017-04-18 12:00:00" AND "2017-04-18 02:22:02") OR
+(l_orderkey = 743 AND l_shipdate between "2017-04-19 12:00:00" AND "2017-06-18 02:22:02") OR
+(l_orderkey = 900 AND l_shipdate between "2017-04-20 12:00:00" AND "2017-06-18 02:22:02") OR
+(l_orderkey = 520 AND l_shipdate between "2018-01-01 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 534 AND l_shipdate between "2018-01-02 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 518 AND l_shipdate between "2018-01-03 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 535 AND l_shipdate between "2018-01-04 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 496 AND l_shipdate between "2018-01-05 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 497 AND l_shipdate between "2018-01-06 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 516 AND l_shipdate between "2018-01-07 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 531 AND l_shipdate between "2018-01-08 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 533 AND l_shipdate between "2018-01-09 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 532 AND l_shipdate between "2018-01-10 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 546 AND l_shipdate between "2018-01-11 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 549 AND l_shipdate between "2018-01-12 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 548 AND l_shipdate between "2018-01-13 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 547 AND l_shipdate between "2018-01-14 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 513 AND l_shipdate between "2018-01-15 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 515 AND l_shipdate between "2018-01-16 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 507 AND l_shipdate between "2018-01-17 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 509 AND l_shipdate between "2018-01-18 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 519 AND l_shipdate between "2018-01-19 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 527 AND l_shipdate between "2018-01-20 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 501 AND l_shipdate between "2018-01-21 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 544 AND l_shipdate between "2018-01-22 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 545 AND l_shipdate between "2018-01-23 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 541 AND l_shipdate between "2018-01-24 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 550 AND l_shipdate between "2018-01-25 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 529 AND l_shipdate between "2018-01-26 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 528 AND l_shipdate between "2018-01-27 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 537 AND l_shipdate between "2018-01-28 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 538 AND l_shipdate between "2018-01-29 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 506 AND l_shipdate between "2018-01-30 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 502 AND l_shipdate between "2018-01-31 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 543 AND l_shipdate between "2018-03-01 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 390 AND l_shipdate between "2018-03-02 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 389 AND l_shipdate between "2018-03-03 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 0 AND l_shipdate between "2018-03-04 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 852 AND l_shipdate between "2018-03-05 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 853 AND l_shipdate between "2018-03-06 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 854 AND l_shipdate between "2018-03-07 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 844 AND l_shipdate between "2018-03-08 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 846 AND l_shipdate between "2018-03-09 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 843 AND l_shipdate between "2018-03-10 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 849 AND l_shipdate between "2018-03-11 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 850 AND l_shipdate between "2018-03-12 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 847 AND l_shipdate between "2018-03-13 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 746 AND l_shipdate between "2018-03-14 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 745 AND l_shipdate between "2018-03-15 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 901 AND l_shipdate between "2018-03-16 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 899 AND l_shipdate between "2018-03-17 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 895 AND l_shipdate between "2018-03-18 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 878 AND l_shipdate between "2018-03-19 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 884 AND l_shipdate between "2018-03-20 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 871 AND l_shipdate between "2018-03-21 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 872 AND l_shipdate between "2018-03-22 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 886 AND l_shipdate between "2018-03-23 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 879 AND l_shipdate between "2018-03-24 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 864 AND l_shipdate between "2018-03-25 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 889 AND l_shipdate between "2018-03-26 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 885 AND l_shipdate between "2018-03-27 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 848 AND l_shipdate between "2018-03-28 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 888 AND l_shipdate between "2018-03-29 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 863 AND l_shipdate between "2018-03-30 12:00:00" AND "2018-04-17 02:22:02") OR
+(l_orderkey = 930 AND l_shipdate between "2018-03-31 12:00:00" AND "2018-04-17 02:22:03") OR
+(l_orderkey = 891 AND l_shipdate between "2018-05-01 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 890 AND l_shipdate between "2018-05-02 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 926 AND l_shipdate between "2018-05-03 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 927 AND l_shipdate between "2018-05-04 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 892 AND l_shipdate between "2018-05-05 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 925 AND l_shipdate between "2018-05-06 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 887 AND l_shipdate between "2018-05-07 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 898 AND l_shipdate between "2018-05-08 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 902 AND l_shipdate between "2018-05-09 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 903 AND l_shipdate between "2018-05-10 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 904 AND l_shipdate between "2018-05-11 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 897 AND l_shipdate between "2018-05-12 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 900 AND l_shipdate between "2018-05-13 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 598 AND l_shipdate between "2018-05-14 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 597 AND l_shipdate between "2018-05-15 12:00:00" AND "2018-06-17 02:22:02") OR
+(l_orderkey = 607 AND l_shipdate between "2018-05-16 12:00:00" AND "2018-06-17 02:22:03") OR
+(l_orderkey = 288 AND l_shipdate between "2018-01-01 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 289 AND l_shipdate between "2018-01-02 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 281 AND l_shipdate between "2018-01-03 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 287 AND l_shipdate between "2018-01-04 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 290 AND l_shipdate between "2018-01-05 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 264 AND l_shipdate between "2018-01-06 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 292 AND l_shipdate between "2018-01-07 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 241 AND l_shipdate between "2018-01-08 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 291 AND l_shipdate between "2018-01-09 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 286 AND l_shipdate between "2018-01-10 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 148 AND l_shipdate between "2018-01-11 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 298 AND l_shipdate between "2018-01-12 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 278 AND l_shipdate between "2018-01-13 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 284 AND l_shipdate between "2018-01-14 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 285 AND l_shipdate between "2018-01-15 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 283 AND l_shipdate between "2018-01-16 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 295 AND l_shipdate between "2018-01-17 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 296 AND l_shipdate between "2018-01-18 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 293 AND l_shipdate between "2018-01-19 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 294 AND l_shipdate between "2018-01-20 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 282 AND l_shipdate between "2018-01-21 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 263 AND l_shipdate between "2018-01-22 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 297 AND l_shipdate between "2018-01-23 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 299 AND l_shipdate between "2018-01-24 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 300 AND l_shipdate between "2018-01-25 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 265 AND l_shipdate between "2018-01-26 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 267 AND l_shipdate between "2018-01-27 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 520 AND l_shipdate between "2018-01-28 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 534 AND l_shipdate between "2018-01-29 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 518 AND l_shipdate between "2018-01-30 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 535 AND l_shipdate between "2018-01-31 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 496 AND l_shipdate between "2018-02-01 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 497 AND l_shipdate between "2018-02-02 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 516 AND l_shipdate between "2018-02-03 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 531 AND l_shipdate between "2018-02-04 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 533 AND l_shipdate between "2018-02-05 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 532 AND l_shipdate between "2018-02-06 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 546 AND l_shipdate between "2018-02-07 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 549 AND l_shipdate between "2018-02-08 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 548 AND l_shipdate between "2018-02-09 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 547 AND l_shipdate between "2018-02-10 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 513 AND l_shipdate between "2018-02-11 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 515 AND l_shipdate between "2018-02-12 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 507 AND l_shipdate between "2018-02-13 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 509 AND l_shipdate between "2018-02-14 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 519 AND l_shipdate between "2018-02-15 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 527 AND l_shipdate between "2018-02-16 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 503 AND l_shipdate between "2018-02-17 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 498 AND l_shipdate between "2018-02-18 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 501 AND l_shipdate between "2018-02-19 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 544 AND l_shipdate between "2018-02-20 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 545 AND l_shipdate between "2018-02-21 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 540 AND l_shipdate between "2018-02-22 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 541 AND l_shipdate between "2018-02-23 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 550 AND l_shipdate between "2018-02-24 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 529 AND l_shipdate between "2018-02-25 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 528 AND l_shipdate between "2018-03-01 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 537 AND l_shipdate between "2018-03-02 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 538 AND l_shipdate between "2018-03-03 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 506 AND l_shipdate between "2018-03-04 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 500 AND l_shipdate between "2018-03-05 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 539 AND l_shipdate between "2018-03-06 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 512 AND l_shipdate between "2018-03-07 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 502 AND l_shipdate between "2018-03-08 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 504 AND l_shipdate between "2018-03-09 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 543 AND l_shipdate between "2018-03-10 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 390 AND l_shipdate between "2018-03-11 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 389 AND l_shipdate between "2018-03-12 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 0 AND l_shipdate between "2018-03-13 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 844 AND l_shipdate between "2018-03-14 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 846 AND l_shipdate between "2018-03-15 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 894 AND l_shipdate between "2018-03-16 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 843 AND l_shipdate between "2018-03-17 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 744 AND l_shipdate between "2018-04-01 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 847 AND l_shipdate between "2018-04-02 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 746 AND l_shipdate between "2018-04-03 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 745 AND l_shipdate between "2018-04-04 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 893 AND l_shipdate between "2018-04-05 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 901 AND l_shipdate between "2018-04-06 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 899 AND l_shipdate between "2018-04-07 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 878 AND l_shipdate between "2018-04-08 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 884 AND l_shipdate between "2018-04-09 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 883 AND l_shipdate between "2018-04-10 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 879 AND l_shipdate between "2018-04-11 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 929 AND l_shipdate between "2018-04-12 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 885 AND l_shipdate between "2018-04-13 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 891 AND l_shipdate between "2018-04-14 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 892 AND l_shipdate between "2018-04-15 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 882 AND l_shipdate between "2018-04-16 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 898 AND l_shipdate between "2018-04-17 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 876 AND l_shipdate between "2018-04-18 12:00:00" AND "2018-04-18 02:22:02") OR
+(l_orderkey = 743 AND l_shipdate between "2018-04-19 12:00:00" AND "2018-06-18 02:22:02") OR
+(l_orderkey = 900 AND l_shipdate between "2018-04-20 12:00:00" AND "2018-06-18 02:22:02")) and l_commitdate ="2019-01-01";
---- RESULTS
---- TYPES
====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_many_fragments.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_many_fragments.test b/testdata/workloads/targeted-perf/queries/primitive_many_fragments.test
new file mode 100644
index 0000000..4c46c50
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_many_fragments.test
@@ -0,0 +1,9 @@
+====
+---- QUERY: primitive_many_fragments
+-- Description : Query with a large number of shuffle joins
+-- Target test case : Run a query with a large number of fragments
+-- stressing query startup, connection creation and query teardown
+select /* +straight_join */ count(*),a.c_nationkey, max(b.c_comment) from customer A join /* +shuffle */ customer B on A.c_custkey = B.c_custkey join /* +shuffle */ customer C on c.c_custkey = B.c_custkey join /* +shuffle */ customer D on d.c_custkey = B.c_custkey join /* +shuffle */ customer E on e.c_custkey = B.c_custkey join /* +shuffle */ customer F on f.c_custkey = B.c_custkey join /* +shuffle */ customer G on g.c_custkey = B.c_custkey join /* +shuffle */ customer H on h.c_custkey = B.c_custkey join /* +shuffle */ customer I on i.c_custkey = B.c_custkey join /* +shuffle */ customer J on j.c_custkey = B.c_custkey join /* +shuffle */ customer K on k.c_custkey = B.c_custkey join /* +shuffle */ customer L on l.c_custkey = B.c_custkey join /* +shuffle */ customer M on m.c_custkey = B.c_custkey join /* +shuffle */ customer N on n.c_custkey = B.c_custkey join /* +shuffle */ customer O on o.c_custkey = B.c_custkey join /* +shuffle */ customer P on p.c_cus
tkey = B.c_custkey join /* +shuffle */ customer R on R.c_custkey = B.c_custkey join /* +shuffle */ customer S on S.c_custkey = B.c_custkey join /* +shuffle */ customer T on T.c_custkey = B.c_custkey join /* +shuffle */ customer U on U.c_custkey = B.c_custkey join /* +shuffle */ customer V on V.c_custkey = B.c_custkey join /* +shuffle */ customer W on W.c_custkey = B.c_custkey join /* +shuffle */ customer X on X.c_custkey = B.c_custkey join /* +shuffle */ customer Y on Y.c_custkey = B.c_custkey join /* +shuffle */ customer Z on Z.c_custkey = B.c_custkey join /* +shuffle */ customer z1 on Z1.c_custkey = B.c_custkey join /* +shuffle */ customer z2 on Z2.c_custkey = B.c_custkey join /* +shuffle */ customer z3 on Z3.c_custkey = B.c_custkey join /* +shuffle */ customer z4 on Z4.c_custkey = B.c_custkey join /* +shuffle */ customer z5 on Z5.c_custkey = B.c_custkey join /* +shuffle */ customer z6 on Z6.c_custkey = B.c_custkey join /* +shuffle */ customer
z7 on Z7.c_custkey = B.c_custkey join /* +shuffle */ customer z8 on Z8.c_custkey = B.c_custkey join /* +shuffle */ customer z9 on Z9.c_custkey = B.c_custkey join /* +shuffle */ customer z10 on Z10.c_custkey = B.c_custkey join /* +shuffle */ customer z11 on Z11.c_custkey = B.c_custkey join /* +shuffle */ customer z12 on Z12.c_custkey = B.c_custkey join /* +shuffle */ customer z13 on Z13.c_custkey = B.c_custkey join /* +shuffle */ customer z14 on Z14.c_custkey = B.c_custkey join /* +shuffle */ customer z15 on Z15.c_custkey = B.c_custkey join /* +shuffle */ customer z16 on Z16.c_custkey = B.c_custkey join /* +shuffle */ customer z17 on Z17.c_custkey = B.c_custkey join /* +shuffle */ customer z18 on Z18.c_custkey = B.c_custkey join /* +shuffle */ customer z19 on Z19.c_custkey = B.c_custkey join /* +shuffle */ customer z20 on Z20.c_custkey = B.c_custkey join /* +shuffle */ customer z21 on Z21.c_custkey = B.c_custkey join /* +shuffle */ custom
er z22 on Z22.c_custkey = B.c_custkey join /* +shuffle */ customer z23 on Z23.c_custkey = B.c_custkey join /* +shuffle */ customer z24 on Z24.c_custkey = B.c_custkey join /* +shuffle */ customer z25 on Z25.c_custkey = B.c_custkey join /* +shuffle */ customer z26 on Z26.c_custkey = B.c_custkey join /* +shuffle */ customer z27 on Z27.c_custkey = B.c_custkey join /* +shuffle */ customer z28 on Z28.c_custkey = B.c_custkey join /* +shuffle */ customer z29 on Z29.c_custkey = B.c_custkey join /* +shuffle */ customer z30 on Z30.c_custkey = B.c_custkey join /* +shuffle */ customer z31 on Z31.c_custkey = B.c_custkey join /* +shuffle */ customer z32 on Z32.c_custkey = B.c_custkey join /* +shuffle */ customer z33 on Z33.c_custkey = B.c_custkey join /* +shuffle */ customer z34 on Z34.c_custkey = B.c_custkey join /* +shuffle */ customer z35 on Z35.c_custkey = B.c_custkey join /* +shuffle */ customer z36 on Z36.c_custkey = B.c_custkey join /* +shuffle */
customer z37 on Z37.c_custkey = B.c_custkey join /* +shuffle */ customer z38 on Z38.c_custkey = B.c_custkey join /* +shuffle */ customer z39 on Z39.c_custkey = B.c_custkey join /* +shuffle */ customer z40 on Z40.c_custkey = B.c_custkey join /* +shuffle */ customer z41 on Z41.c_custkey = B.c_custkey join /* +shuffle */ customer z42 on Z42.c_custkey = B.c_custkey join /* +shuffle */ customer z43 on Z43.c_custkey = B.c_custkey join /* +shuffle */ customer z44 on z44.c_custkey = B.c_custkey join /* +shuffle */ customer z45 on z45.c_custkey = B.c_custkey join /* +shuffle */ customer z46 on z46.c_custkey = B.c_custkey join /* +shuffle */ customer z47 on z47.c_custkey = B.c_custkey join /* +shuffle */ customer z48 on z48.c_custkey = B.c_custkey join /* +shuffle */ customer z49 on z49.c_custkey = B.c_custkey join /* +shuffle */ customer z50 on z50.c_custkey = B.c_custkey join /* +shuffle */ customer z51 on z51.c_custkey = B.c_custkey join /* +shu
ffle */ customer z52 on z52.c_custkey = B.c_custkey join /* +shuffle */ customer z53 on z53.c_custkey = B.c_custkey join /* +shuffle */ customer z54 on z54.c_custkey = B.c_custkey join /* +shuffle */ customer z55 on z55.c_custkey = B.c_custkey join /* +shuffle */ customer z56 on z56.c_custkey = B.c_custkey join /* +shuffle */ customer z57 on z57.c_custkey = B.c_custkey join /* +shuffle */ customer z58 on z58.c_custkey = B.c_custkey join /* +shuffle */ customer z59 on z59.c_custkey = B.c_custkey join /* +shuffle */ customer z60 on z60.c_custkey = B.c_custkey join /* +shuffle */ customer z61 on z61.c_custkey = B.c_custkey join /* +shuffle */ customer z62 on z62.c_custkey = B.c_custkey join /* +shuffle */ customer z63 on z63.c_custkey = B.c_custkey join /* +shuffle */ customer z64 on z64.c_custkey = B.c_custkey join /* +shuffle */ customer z65 on z65.c_custkey = B.c_custkey join /* +shuffle */ customer z66 on z66.c_custkey = B.c_custkey join
/* +shuffle */ customer z67 on z67.c_custkey = B.c_custkey join /* +shuffle */ customer z68 on z68.c_custkey = B.c_custkey join /* +shuffle */ customer z69 on z69.c_custkey = B.c_custkey join /* +shuffle */ customer z70 on z70.c_custkey = B.c_custkey join /* +shuffle */ customer z71 on z71.c_custkey = B.c_custkey join /* +shuffle */ customer z72 on z72.c_custkey = B.c_custkey join /* +shuffle */ customer z73 on z73.c_custkey = B.c_custkey join /* +shuffle */ customer z74 on z74.c_custkey = B.c_custkey join /* +shuffle */ customer z75 on z75.c_custkey = B.c_custkey join /* +shuffle */ customer z76 on z76.c_custkey = B.c_custkey join /* +shuffle */ customer z77 on z77.c_custkey = B.c_custkey join /* +shuffle */ customer z78 on z78.c_custkey = B.c_custkey join /* +shuffle */ customer z79 on z79.c_custkey = B.c_custkey join /* +shuffle */ customer z80 on z80.c_custkey = B.c_custkey join /* +shuffle */ customer z81 on z81.c_custkey = B.c_cust
key join /* +shuffle */ customer z82 on z82.c_custkey = B.c_custkey join /* +shuffle */ customer z83 on z83.c_custkey = B.c_custkey join /* +shuffle */ customer z84 on z84.c_custkey = B.c_custkey join /* +shuffle */ customer z85 on z85.c_custkey = B.c_custkey join /* +shuffle */ customer z86 on z86.c_custkey = B.c_custkey join /* +shuffle */ customer z87 on z87.c_custkey = B.c_custkey join /* +shuffle */ customer z88 on z88.c_custkey = B.c_custkey join /* +shuffle */ customer z89 on z89.c_custkey = B.c_custkey join /* +shuffle */ customer z90 on z90.c_custkey = B.c_custkey join /* +shuffle */ customer z91 on z91.c_custkey = B.c_custkey join /* +shuffle */ customer z92 on z92.c_custkey = B.c_custkey join /* +shuffle */ customer z93 on z93.c_custkey = B.c_custkey join /* +shuffle */ customer z94 on z94.c_custkey = B.c_custkey join /* +shuffle */ customer z95 on z95.c_custkey = B.c_custkey join /* +shuffle */ customer z96 on z96.c_custkey =
B.c_custkey join /* +shuffle */ customer z97 on z97.c_custkey = B.c_custkey join /* +shuffle */ customer z98 on z98.c_custkey = B.c_custkey join /* +shuffle */ customer z99 on z99.c_custkey = B.c_custkey join /* +shuffle */ customer z100 on z100.c_custkey = B.c_custkey and b.c_custkey < 10000 group by a.c_nationkey;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_many_independent_fragments.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_many_independent_fragments.test b/testdata/workloads/targeted-perf/queries/primitive_many_independent_fragments.test
new file mode 100644
index 0000000..898d498
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_many_independent_fragments.test
@@ -0,0 +1,29 @@
+====
+---- QUERY: primitive_many_independent_fragments
+-- Description : Query with a large number of independant shuffle joins
+-- Target test case : Run a query with a large number of fragments
+-- stressing query startup, connection creation and query teardown
+with subquery as (select /* +straight_join */ count(*) from lineitem a join /* +shuffle */
+orders b on a.l_orderkey = b.o_orderkey where a.l_orderkey = b.o_orderkey and l_shipdate
+between "1992-01-01" and "1994-01-01" and o_orderdate between "1992-01-01" and
+"1994-01-01" group by a.l_orderkey having count(*) > 9999999999) select * from (select *
+from subquery) a1, (select * from subquery) a2, (select * from subquery) a3, (select * from subquery) a4,
+(select * from subquery) a5, (select * from subquery) a6, (select * from subquery) a7,
+(select * from subquery) a8, (select * from subquery) a9, (select * from subquery) a10,
+(select * from subquery) a11, (select * from subquery) a12, (select * from subquery) a13,
+(select * from subquery) a14, (select * from subquery) a15, (select * from subquery) a16,
+(select * from subquery) a17, (select * from subquery) a18, (select * from subquery) a19,
+(select * from subquery) a20, (select * from subquery) a21, (select * from subquery) a22,
+(select * from subquery) a23, (select * from subquery) a24, (select * from subquery) a25,
+(select * from subquery) a26, (select * from subquery) a27, (select * from subquery) a28,
+(select * from subquery) a29, (select * from subquery) a30, (select *from subquery) a31,
+(select * from subquery) a32, (select * from subquery) a33, (select * from subquery) a34,
+(select * from subquery) a35, (select * from subquery) a36, (select * from subquery) a37,
+(select * from subquery) a38, (select * from subquery) a39, (select * from subquery) a40,
+(select * from subquery) a41, (select * from subquery) a42, (select * from subquery) a43,
+(select * from subquery) a44, (select * from subquery) a45, (select * from subquery) a46,
+(select * from subquery) a47, (select * from subquery) a48, (select * from subquery) a49,
+(select * from subquery) a50;
+---- RESULTS
+---- TYPES
+====
http://git-wip-us.apache.org/repos/asf/impala/blob/59ccbbd7/testdata/workloads/targeted-perf/queries/primitive_orderby_bigint_expression.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/targeted-perf/queries/primitive_orderby_bigint_expression.test b/testdata/workloads/targeted-perf/queries/primitive_orderby_bigint_expression.test
new file mode 100644
index 0000000..a6b302f
--- /dev/null
+++ b/testdata/workloads/targeted-perf/queries/primitive_orderby_bigint_expression.test
@@ -0,0 +1,15 @@
+====
+---- QUERY: primitive_orderby_bigint_expression
+-- Description : Scan a fact table and sort 50Million rows by an expression.
+-- Target test case : Order by expensive expression without returning all
+-- rows to the client.
+SELECT *
+FROM (SELECT Rank()
+ OVER(
+ ORDER BY cast(substr( concat(cast(l_orderkey as string), cast (l_shipdate as string)),1,13) as bigint)) AS rank
+ FROM lineitem
+ WHERE l_shipdate < '1992-05-09') a
+WHERE rank < 10;
+---- RESULTS
+---- TYPES
+====