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 <[email protected]> Reviewed-by: David Knupp <[email protected]> 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 <[email protected]> Authored: Tue Apr 10 15:19:03 2018 -0700 Committer: Impala Public Jenkins <[email protected]> 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 +====
