asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ti...@apache.org
Subject [3/4] asterixdb git commit: Fix async result delivery
Date Fri, 10 Feb 2017 17:38:56 GMT
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.1.ignore
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.1.ignore b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.1.ignore
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.2.json
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.2.json b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.2.json
new file mode 100644
index 0000000..6213a6b
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.2.json
@@ -0,0 +1 @@
+{"status":"SUCCESS"}

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.3.json
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.3.json b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.3.json
new file mode 100644
index 0000000..09e86cc
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/async/async.3.json
@@ -0,0 +1,10 @@
+{ "i": 1, "i2": 1 }
+{ "i": 2, "i2": 4 }
+{ "i": 3, "i2": 9 }
+{ "i": 4, "i2": 16 }
+{ "i": 5, "i2": 25 }
+{ "i": 6, "i2": 36 }
+{ "i": 7, "i2": 49 }
+{ "i": 8, "i2": 64 }
+{ "i": 9, "i2": 81 }
+{ "i": 10, "i2": 100 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.1.ignore
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.1.ignore b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.1.ignore
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.2.json
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.2.json b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.2.json
new file mode 100644
index 0000000..09e86cc
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/async-deferred/deferred/deferred.2.json
@@ -0,0 +1,10 @@
+{ "i": 1, "i2": 1 }
+{ "i": 2, "i2": 4 }
+{ "i": 3, "i2": 9 }
+{ "i": 4, "i2": 16 }
+{ "i": 5, "i2": 25 }
+{ "i": 6, "i2": 36 }
+{ "i": 7, "i2": 49 }
+{ "i": 8, "i2": 64 }
+{ "i": 9, "i2": 81 }
+{ "i": 10, "i2": 100 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.adm
deleted file mode 100644
index 74e1bb7..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.adm
+++ /dev/null
@@ -1,600 +0,0 @@
-{ "partkey": 1, "pid": 1, "shipdate": "1992-02-15" }
-{ "partkey": 1, "pid": 2, "shipdate": "1992-03-30" }
-{ "partkey": 1, "pid": 3, "shipdate": "1992-07-17" }
-{ "partkey": 2, "pid": 1, "shipdate": "1992-06-23" }
-{ "partkey": 2, "pid": 2, "shipdate": "1992-07-01" }
-{ "partkey": 2, "pid": 3, "shipdate": "1992-07-18" }
-{ "partkey": 3, "pid": 1, "shipdate": "1992-04-25" }
-{ "partkey": 3, "pid": 2, "shipdate": "1992-05-24" }
-{ "partkey": 3, "pid": 3, "shipdate": "1993-01-03" }
-{ "partkey": 4, "pid": 1, "shipdate": "1992-05-02" }
-{ "partkey": 4, "pid": 2, "shipdate": "1992-11-03" }
-{ "partkey": 4, "pid": 3, "shipdate": "1992-11-18" }
-{ "partkey": 5, "pid": 1, "shipdate": "1992-05-02" }
-{ "partkey": 5, "pid": 2, "shipdate": "1992-06-14" }
-{ "partkey": 5, "pid": 3, "shipdate": "1993-01-06" }
-{ "partkey": 6, "pid": 1, "shipdate": "1992-04-05" }
-{ "partkey": 6, "pid": 2, "shipdate": "1992-04-25" }
-{ "partkey": 6, "pid": 3, "shipdate": "1992-04-29" }
-{ "partkey": 7, "pid": 1, "shipdate": "1992-04-12" }
-{ "partkey": 7, "pid": 2, "shipdate": "1993-02-11" }
-{ "partkey": 7, "pid": 3, "shipdate": "1993-06-25" }
-{ "partkey": 8, "pid": 1, "shipdate": "1992-09-25" }
-{ "partkey": 8, "pid": 2, "shipdate": "1992-11-15" }
-{ "partkey": 8, "pid": 3, "shipdate": "1993-02-13" }
-{ "partkey": 9, "pid": 1, "shipdate": "1992-04-29" }
-{ "partkey": 9, "pid": 2, "shipdate": "1992-04-30" }
-{ "partkey": 9, "pid": 3, "shipdate": "1992-06-01" }
-{ "partkey": 10, "pid": 1, "shipdate": "1992-05-13" }
-{ "partkey": 10, "pid": 2, "shipdate": "1992-11-25" }
-{ "partkey": 10, "pid": 3, "shipdate": "1992-12-01" }
-{ "partkey": 11, "pid": 1, "shipdate": "1992-02-14" }
-{ "partkey": 11, "pid": 2, "shipdate": "1992-07-20" }
-{ "partkey": 11, "pid": 3, "shipdate": "1992-08-03" }
-{ "partkey": 12, "pid": 1, "shipdate": "1992-07-04" }
-{ "partkey": 12, "pid": 2, "shipdate": "1992-07-17" }
-{ "partkey": 12, "pid": 3, "shipdate": "1992-09-02" }
-{ "partkey": 13, "pid": 1, "shipdate": "1992-04-01" }
-{ "partkey": 13, "pid": 2, "shipdate": "1992-04-26" }
-{ "partkey": 13, "pid": 3, "shipdate": "1992-05-04" }
-{ "partkey": 14, "pid": 1, "shipdate": "1992-07-17" }
-{ "partkey": 14, "pid": 2, "shipdate": "1992-11-30" }
-{ "partkey": 14, "pid": 3, "shipdate": "1993-05-10" }
-{ "partkey": 15, "pid": 1, "shipdate": "1992-05-18" }
-{ "partkey": 15, "pid": 2, "shipdate": "1992-05-24" }
-{ "partkey": 15, "pid": 3, "shipdate": "1993-04-14" }
-{ "partkey": 16, "pid": 1, "shipdate": "1992-09-11" }
-{ "partkey": 16, "pid": 2, "shipdate": "1992-09-25" }
-{ "partkey": 16, "pid": 3, "shipdate": "1992-11-17" }
-{ "partkey": 17, "pid": 1, "shipdate": "1992-07-23" }
-{ "partkey": 17, "pid": 2, "shipdate": "1993-03-01" }
-{ "partkey": 17, "pid": 3, "shipdate": "1993-05-06" }
-{ "partkey": 18, "pid": 1, "shipdate": "1992-04-12" }
-{ "partkey": 18, "pid": 2, "shipdate": "1992-04-21" }
-{ "partkey": 18, "pid": 3, "shipdate": "1992-05-21" }
-{ "partkey": 19, "pid": 1, "shipdate": "1992-07-19" }
-{ "partkey": 19, "pid": 2, "shipdate": "1992-10-21" }
-{ "partkey": 19, "pid": 3, "shipdate": "1992-12-22" }
-{ "partkey": 20, "pid": 1, "shipdate": "1992-06-15" }
-{ "partkey": 20, "pid": 2, "shipdate": "1992-07-29" }
-{ "partkey": 20, "pid": 3, "shipdate": "1992-10-18" }
-{ "partkey": 21, "pid": 1, "shipdate": "1992-07-31" }
-{ "partkey": 21, "pid": 2, "shipdate": "1992-09-09" }
-{ "partkey": 21, "pid": 3, "shipdate": "1993-01-09" }
-{ "partkey": 22, "pid": 1, "shipdate": "1992-06-21" }
-{ "partkey": 22, "pid": 2, "shipdate": "1992-06-25" }
-{ "partkey": 22, "pid": 3, "shipdate": "1992-11-20" }
-{ "partkey": 23, "pid": 1, "shipdate": "1992-04-04" }
-{ "partkey": 23, "pid": 2, "shipdate": "1992-06-19" }
-{ "partkey": 23, "pid": 3, "shipdate": "1992-06-29" }
-{ "partkey": 24, "pid": 1, "shipdate": "1992-04-12" }
-{ "partkey": 24, "pid": 2, "shipdate": "1992-08-06" }
-{ "partkey": 24, "pid": 3, "shipdate": "1992-08-08" }
-{ "partkey": 25, "pid": 1, "shipdate": "1992-02-04" }
-{ "partkey": 25, "pid": 2, "shipdate": "1992-07-23" }
-{ "partkey": 25, "pid": 3, "shipdate": "1992-08-01" }
-{ "partkey": 26, "pid": 1, "shipdate": "1992-02-23" }
-{ "partkey": 26, "pid": 2, "shipdate": "1992-05-09" }
-{ "partkey": 26, "pid": 3, "shipdate": "1993-01-04" }
-{ "partkey": 27, "pid": 1, "shipdate": "1992-07-05" }
-{ "partkey": 27, "pid": 2, "shipdate": "1992-07-14" }
-{ "partkey": 27, "pid": 3, "shipdate": "1992-08-17" }
-{ "partkey": 28, "pid": 1, "shipdate": "1992-03-16" }
-{ "partkey": 28, "pid": 2, "shipdate": "1992-10-13" }
-{ "partkey": 28, "pid": 3, "shipdate": "1992-11-04" }
-{ "partkey": 29, "pid": 1, "shipdate": "1992-05-25" }
-{ "partkey": 29, "pid": 2, "shipdate": "1992-06-01" }
-{ "partkey": 29, "pid": 3, "shipdate": "1992-07-25" }
-{ "partkey": 30, "pid": 1, "shipdate": "1992-04-10" }
-{ "partkey": 30, "pid": 2, "shipdate": "1992-05-18" }
-{ "partkey": 30, "pid": 3, "shipdate": "1992-05-21" }
-{ "partkey": 31, "pid": 1, "shipdate": "1992-07-14" }
-{ "partkey": 31, "pid": 2, "shipdate": "1992-09-24" }
-{ "partkey": 31, "pid": 3, "shipdate": "1992-09-29" }
-{ "partkey": 32, "pid": 1, "shipdate": "1992-09-22" }
-{ "partkey": 32, "pid": 2, "shipdate": "1992-09-25" }
-{ "partkey": 32, "pid": 3, "shipdate": "1992-10-07" }
-{ "partkey": 33, "pid": 1, "shipdate": "1992-03-22" }
-{ "partkey": 33, "pid": 2, "shipdate": "1993-02-17" }
-{ "partkey": 33, "pid": 3, "shipdate": "1993-02-21" }
-{ "partkey": 34, "pid": 1, "shipdate": "1992-07-03" }
-{ "partkey": 34, "pid": 2, "shipdate": "1992-07-20" }
-{ "partkey": 34, "pid": 3, "shipdate": "1992-11-23" }
-{ "partkey": 35, "pid": 1, "shipdate": "1992-03-11" }
-{ "partkey": 35, "pid": 2, "shipdate": "1992-04-06" }
-{ "partkey": 35, "pid": 3, "shipdate": "1992-05-26" }
-{ "partkey": 36, "pid": 1, "shipdate": "1992-02-26" }
-{ "partkey": 36, "pid": 2, "shipdate": "1992-07-03" }
-{ "partkey": 36, "pid": 3, "shipdate": "1993-01-06" }
-{ "partkey": 37, "pid": 1, "shipdate": "1992-08-30" }
-{ "partkey": 37, "pid": 2, "shipdate": "1992-10-03" }
-{ "partkey": 37, "pid": 3, "shipdate": "1993-01-31" }
-{ "partkey": 38, "pid": 1, "shipdate": "1992-04-06" }
-{ "partkey": 38, "pid": 2, "shipdate": "1992-04-15" }
-{ "partkey": 38, "pid": 3, "shipdate": "1992-08-27" }
-{ "partkey": 39, "pid": 1, "shipdate": "1992-05-26" }
-{ "partkey": 39, "pid": 2, "shipdate": "1992-11-12" }
-{ "partkey": 39, "pid": 3, "shipdate": "1992-11-15" }
-{ "partkey": 40, "pid": 1, "shipdate": "1992-02-07" }
-{ "partkey": 40, "pid": 2, "shipdate": "1992-04-28" }
-{ "partkey": 40, "pid": 3, "shipdate": "1992-05-03" }
-{ "partkey": 41, "pid": 1, "shipdate": "1992-12-13" }
-{ "partkey": 41, "pid": 2, "shipdate": "1993-01-18" }
-{ "partkey": 41, "pid": 3, "shipdate": "1993-04-13" }
-{ "partkey": 42, "pid": 1, "shipdate": "1992-10-23" }
-{ "partkey": 42, "pid": 2, "shipdate": "1992-11-04" }
-{ "partkey": 42, "pid": 3, "shipdate": "1992-12-12" }
-{ "partkey": 43, "pid": 1, "shipdate": "1992-06-18" }
-{ "partkey": 43, "pid": 2, "shipdate": "1992-06-30" }
-{ "partkey": 43, "pid": 3, "shipdate": "1992-08-28" }
-{ "partkey": 44, "pid": 1, "shipdate": "1992-02-14" }
-{ "partkey": 44, "pid": 2, "shipdate": "1992-06-11" }
-{ "partkey": 44, "pid": 3, "shipdate": "1992-11-29" }
-{ "partkey": 45, "pid": 1, "shipdate": "1992-07-16" }
-{ "partkey": 45, "pid": 2, "shipdate": "1993-06-24" }
-{ "partkey": 45, "pid": 3, "shipdate": "1993-09-15" }
-{ "partkey": 46, "pid": 1, "shipdate": "1992-04-28" }
-{ "partkey": 46, "pid": 2, "shipdate": "1992-05-08" }
-{ "partkey": 46, "pid": 3, "shipdate": "1992-05-21" }
-{ "partkey": 47, "pid": 1, "shipdate": "1992-03-11" }
-{ "partkey": 47, "pid": 2, "shipdate": "1993-05-30" }
-{ "partkey": 47, "pid": 3, "shipdate": "1993-06-06" }
-{ "partkey": 48, "pid": 1, "shipdate": "1992-05-10" }
-{ "partkey": 48, "pid": 2, "shipdate": "1992-06-03" }
-{ "partkey": 48, "pid": 3, "shipdate": "1992-06-15" }
-{ "partkey": 49, "pid": 1, "shipdate": "1992-04-29" }
-{ "partkey": 49, "pid": 2, "shipdate": "1992-06-14" }
-{ "partkey": 49, "pid": 3, "shipdate": "1992-08-13" }
-{ "partkey": 50, "pid": 1, "shipdate": "1992-04-22" }
-{ "partkey": 50, "pid": 2, "shipdate": "1992-07-31" }
-{ "partkey": 50, "pid": 3, "shipdate": "1992-09-23" }
-{ "partkey": 51, "pid": 1, "shipdate": "1992-03-11" }
-{ "partkey": 51, "pid": 2, "shipdate": "1992-05-15" }
-{ "partkey": 51, "pid": 3, "shipdate": "1992-05-17" }
-{ "partkey": 52, "pid": 1, "shipdate": "1992-05-31" }
-{ "partkey": 52, "pid": 2, "shipdate": "1992-09-03" }
-{ "partkey": 52, "pid": 3, "shipdate": "1992-09-21" }
-{ "partkey": 53, "pid": 1, "shipdate": "1992-01-14" }
-{ "partkey": 53, "pid": 2, "shipdate": "1992-05-22" }
-{ "partkey": 53, "pid": 3, "shipdate": "1992-10-04" }
-{ "partkey": 54, "pid": 1, "shipdate": "1992-04-07" }
-{ "partkey": 54, "pid": 2, "shipdate": "1992-05-01" }
-{ "partkey": 54, "pid": 3, "shipdate": "1992-06-24" }
-{ "partkey": 55, "pid": 1, "shipdate": "1992-01-16" }
-{ "partkey": 55, "pid": 2, "shipdate": "1992-05-11" }
-{ "partkey": 55, "pid": 3, "shipdate": "1992-06-17" }
-{ "partkey": 56, "pid": 1, "shipdate": "1992-01-16" }
-{ "partkey": 56, "pid": 2, "shipdate": "1992-03-02" }
-{ "partkey": 56, "pid": 3, "shipdate": "1992-06-18" }
-{ "partkey": 57, "pid": 1, "shipdate": "1992-01-16" }
-{ "partkey": 57, "pid": 2, "shipdate": "1992-07-06" }
-{ "partkey": 57, "pid": 3, "shipdate": "1992-09-21" }
-{ "partkey": 58, "pid": 1, "shipdate": "1992-05-16" }
-{ "partkey": 58, "pid": 2, "shipdate": "1992-10-30" }
-{ "partkey": 58, "pid": 3, "shipdate": "1993-04-10" }
-{ "partkey": 59, "pid": 1, "shipdate": "1992-02-09" }
-{ "partkey": 59, "pid": 2, "shipdate": "1992-03-17" }
-{ "partkey": 59, "pid": 3, "shipdate": "1992-06-12" }
-{ "partkey": 60, "pid": 1, "shipdate": "1992-02-14" }
-{ "partkey": 60, "pid": 2, "shipdate": "1992-07-01" }
-{ "partkey": 60, "pid": 3, "shipdate": "1992-07-15" }
-{ "partkey": 61, "pid": 1, "shipdate": "1993-07-14" }
-{ "partkey": 61, "pid": 2, "shipdate": "1993-07-15" }
-{ "partkey": 61, "pid": 3, "shipdate": "1993-09-29" }
-{ "partkey": 62, "pid": 1, "shipdate": "1992-02-01" }
-{ "partkey": 62, "pid": 2, "shipdate": "1992-03-26" }
-{ "partkey": 62, "pid": 3, "shipdate": "1992-06-19" }
-{ "partkey": 63, "pid": 1, "shipdate": "1992-02-07" }
-{ "partkey": 63, "pid": 2, "shipdate": "1992-06-15" }
-{ "partkey": 63, "pid": 3, "shipdate": "1993-02-07" }
-{ "partkey": 64, "pid": 1, "shipdate": "1992-02-13" }
-{ "partkey": 64, "pid": 2, "shipdate": "1992-02-14" }
-{ "partkey": 64, "pid": 3, "shipdate": "1992-03-10" }
-{ "partkey": 65, "pid": 1, "shipdate": "1992-03-02" }
-{ "partkey": 65, "pid": 2, "shipdate": "1992-04-14" }
-{ "partkey": 65, "pid": 3, "shipdate": "1992-06-26" }
-{ "partkey": 66, "pid": 1, "shipdate": "1992-05-07" }
-{ "partkey": 66, "pid": 2, "shipdate": "1992-09-11" }
-{ "partkey": 66, "pid": 3, "shipdate": "1992-10-10" }
-{ "partkey": 67, "pid": 1, "shipdate": "1992-05-13" }
-{ "partkey": 67, "pid": 2, "shipdate": "1993-01-08" }
-{ "partkey": 67, "pid": 3, "shipdate": "1993-11-03" }
-{ "partkey": 68, "pid": 1, "shipdate": "1992-04-13" }
-{ "partkey": 68, "pid": 2, "shipdate": "1992-06-08" }
-{ "partkey": 68, "pid": 3, "shipdate": "1992-06-22" }
-{ "partkey": 69, "pid": 1, "shipdate": "1992-05-31" }
-{ "partkey": 69, "pid": 2, "shipdate": "1992-06-05" }
-{ "partkey": 69, "pid": 3, "shipdate": "1992-07-01" }
-{ "partkey": 70, "pid": 1, "shipdate": "1992-04-06" }
-{ "partkey": 70, "pid": 2, "shipdate": "1992-06-11" }
-{ "partkey": 70, "pid": 3, "shipdate": "1992-06-25" }
-{ "partkey": 71, "pid": 1, "shipdate": "1992-11-10" }
-{ "partkey": 71, "pid": 2, "shipdate": "1993-01-10" }
-{ "partkey": 71, "pid": 3, "shipdate": "1993-02-28" }
-{ "partkey": 72, "pid": 1, "shipdate": "1992-09-16" }
-{ "partkey": 72, "pid": 2, "shipdate": "1992-10-02" }
-{ "partkey": 72, "pid": 3, "shipdate": "1992-10-17" }
-{ "partkey": 73, "pid": 1, "shipdate": "1992-01-08" }
-{ "partkey": 73, "pid": 2, "shipdate": "1992-09-16" }
-{ "partkey": 73, "pid": 3, "shipdate": "1993-07-02" }
-{ "partkey": 74, "pid": 1, "shipdate": "1992-03-21" }
-{ "partkey": 74, "pid": 2, "shipdate": "1992-03-22" }
-{ "partkey": 74, "pid": 3, "shipdate": "1992-10-21" }
-{ "partkey": 75, "pid": 1, "shipdate": "1992-03-27" }
-{ "partkey": 75, "pid": 2, "shipdate": "1992-05-12" }
-{ "partkey": 75, "pid": 3, "shipdate": "1992-09-19" }
-{ "partkey": 76, "pid": 1, "shipdate": "1992-10-22" }
-{ "partkey": 76, "pid": 2, "shipdate": "1993-04-19" }
-{ "partkey": 76, "pid": 3, "shipdate": "1993-06-12" }
-{ "partkey": 77, "pid": 1, "shipdate": "1992-08-18" }
-{ "partkey": 77, "pid": 2, "shipdate": "1992-12-23" }
-{ "partkey": 77, "pid": 3, "shipdate": "1993-06-19" }
-{ "partkey": 78, "pid": 1, "shipdate": "1992-03-04" }
-{ "partkey": 78, "pid": 2, "shipdate": "1992-04-04" }
-{ "partkey": 78, "pid": 3, "shipdate": "1992-05-06" }
-{ "partkey": 79, "pid": 1, "shipdate": "1992-08-05" }
-{ "partkey": 79, "pid": 2, "shipdate": "1992-08-10" }
-{ "partkey": 79, "pid": 3, "shipdate": "1993-04-08" }
-{ "partkey": 80, "pid": 1, "shipdate": "1992-05-18" }
-{ "partkey": 80, "pid": 2, "shipdate": "1992-09-02" }
-{ "partkey": 80, "pid": 3, "shipdate": "1993-06-07" }
-{ "partkey": 81, "pid": 1, "shipdate": "1992-04-11" }
-{ "partkey": 81, "pid": 2, "shipdate": "1992-06-22" }
-{ "partkey": 81, "pid": 3, "shipdate": "1992-12-30" }
-{ "partkey": 82, "pid": 1, "shipdate": "1992-07-17" }
-{ "partkey": 82, "pid": 2, "shipdate": "1992-10-18" }
-{ "partkey": 82, "pid": 3, "shipdate": "1992-12-11" }
-{ "partkey": 83, "pid": 1, "shipdate": "1992-06-09" }
-{ "partkey": 83, "pid": 2, "shipdate": "1992-08-04" }
-{ "partkey": 83, "pid": 3, "shipdate": "1992-09-21" }
-{ "partkey": 84, "pid": 1, "shipdate": "1992-09-08" }
-{ "partkey": 84, "pid": 2, "shipdate": "1993-05-15" }
-{ "partkey": 84, "pid": 3, "shipdate": "1993-05-20" }
-{ "partkey": 85, "pid": 1, "shipdate": "1992-02-28" }
-{ "partkey": 85, "pid": 2, "shipdate": "1992-05-28" }
-{ "partkey": 85, "pid": 3, "shipdate": "1992-06-27" }
-{ "partkey": 86, "pid": 1, "shipdate": "1992-05-25" }
-{ "partkey": 86, "pid": 2, "shipdate": "1992-11-18" }
-{ "partkey": 86, "pid": 3, "shipdate": "1993-03-01" }
-{ "partkey": 87, "pid": 1, "shipdate": "1992-09-30" }
-{ "partkey": 87, "pid": 2, "shipdate": "1992-12-02" }
-{ "partkey": 87, "pid": 3, "shipdate": "1993-01-06" }
-{ "partkey": 88, "pid": 1, "shipdate": "1992-04-24" }
-{ "partkey": 88, "pid": 2, "shipdate": "1992-06-26" }
-{ "partkey": 88, "pid": 3, "shipdate": "1992-12-18" }
-{ "partkey": 89, "pid": 1, "shipdate": "1992-04-18" }
-{ "partkey": 89, "pid": 2, "shipdate": "1992-04-19" }
-{ "partkey": 89, "pid": 3, "shipdate": "1992-05-27" }
-{ "partkey": 90, "pid": 1, "shipdate": "1992-02-25" }
-{ "partkey": 90, "pid": 2, "shipdate": "1992-06-07" }
-{ "partkey": 90, "pid": 3, "shipdate": "1992-08-21" }
-{ "partkey": 91, "pid": 1, "shipdate": "1992-05-22" }
-{ "partkey": 91, "pid": 2, "shipdate": "1992-06-21" }
-{ "partkey": 91, "pid": 3, "shipdate": "1992-12-03" }
-{ "partkey": 92, "pid": 1, "shipdate": "1992-02-11" }
-{ "partkey": 92, "pid": 2, "shipdate": "1992-09-30" }
-{ "partkey": 92, "pid": 3, "shipdate": "1993-01-04" }
-{ "partkey": 93, "pid": 1, "shipdate": "1992-05-28" }
-{ "partkey": 93, "pid": 2, "shipdate": "1992-06-24" }
-{ "partkey": 93, "pid": 3, "shipdate": "1992-09-11" }
-{ "partkey": 94, "pid": 1, "shipdate": "1992-05-20" }
-{ "partkey": 94, "pid": 2, "shipdate": "1992-07-03" }
-{ "partkey": 94, "pid": 3, "shipdate": "1992-07-26" }
-{ "partkey": 95, "pid": 1, "shipdate": "1992-02-24" }
-{ "partkey": 95, "pid": 2, "shipdate": "1992-03-14" }
-{ "partkey": 95, "pid": 3, "shipdate": "1992-11-17" }
-{ "partkey": 96, "pid": 1, "shipdate": "1992-06-18" }
-{ "partkey": 96, "pid": 2, "shipdate": "1992-09-26" }
-{ "partkey": 96, "pid": 3, "shipdate": "1992-11-25" }
-{ "partkey": 97, "pid": 1, "shipdate": "1992-01-27" }
-{ "partkey": 97, "pid": 2, "shipdate": "1992-03-22" }
-{ "partkey": 97, "pid": 3, "shipdate": "1992-04-21" }
-{ "partkey": 98, "pid": 1, "shipdate": "1992-10-06" }
-{ "partkey": 98, "pid": 2, "shipdate": "1992-12-09" }
-{ "partkey": 98, "pid": 3, "shipdate": "1993-03-09" }
-{ "partkey": 99, "pid": 1, "shipdate": "1992-05-01" }
-{ "partkey": 99, "pid": 2, "shipdate": "1993-04-18" }
-{ "partkey": 99, "pid": 3, "shipdate": "1993-06-09" }
-{ "partkey": 100, "pid": 1, "shipdate": "1992-03-24" }
-{ "partkey": 100, "pid": 2, "shipdate": "1992-03-24" }
-{ "partkey": 100, "pid": 3, "shipdate": "1992-06-18" }
-{ "partkey": 101, "pid": 1, "shipdate": "1992-08-17" }
-{ "partkey": 101, "pid": 2, "shipdate": "1992-09-27" }
-{ "partkey": 101, "pid": 3, "shipdate": "1992-12-28" }
-{ "partkey": 102, "pid": 1, "shipdate": "1992-08-19" }
-{ "partkey": 102, "pid": 2, "shipdate": "1992-08-21" }
-{ "partkey": 102, "pid": 3, "shipdate": "1992-10-25" }
-{ "partkey": 103, "pid": 1, "shipdate": "1992-03-28" }
-{ "partkey": 103, "pid": 2, "shipdate": "1992-05-08" }
-{ "partkey": 103, "pid": 3, "shipdate": "1992-07-11" }
-{ "partkey": 104, "pid": 1, "shipdate": "1992-03-17" }
-{ "partkey": 104, "pid": 2, "shipdate": "1992-11-08" }
-{ "partkey": 104, "pid": 3, "shipdate": "1994-01-22" }
-{ "partkey": 105, "pid": 1, "shipdate": "1992-02-14" }
-{ "partkey": 105, "pid": 2, "shipdate": "1992-06-01" }
-{ "partkey": 105, "pid": 3, "shipdate": "1992-07-14" }
-{ "partkey": 106, "pid": 1, "shipdate": "1992-07-09" }
-{ "partkey": 106, "pid": 2, "shipdate": "1992-07-31" }
-{ "partkey": 106, "pid": 3, "shipdate": "1992-10-02" }
-{ "partkey": 107, "pid": 1, "shipdate": "1992-05-22" }
-{ "partkey": 107, "pid": 2, "shipdate": "1992-07-30" }
-{ "partkey": 107, "pid": 3, "shipdate": "1992-08-05" }
-{ "partkey": 108, "pid": 1, "shipdate": "1992-07-28" }
-{ "partkey": 108, "pid": 2, "shipdate": "1992-08-01" }
-{ "partkey": 108, "pid": 3, "shipdate": "1992-09-07" }
-{ "partkey": 109, "pid": 1, "shipdate": "1992-06-06" }
-{ "partkey": 109, "pid": 2, "shipdate": "1992-11-20" }
-{ "partkey": 109, "pid": 3, "shipdate": "1992-12-23" }
-{ "partkey": 110, "pid": 1, "shipdate": "1992-09-18" }
-{ "partkey": 110, "pid": 2, "shipdate": "1992-11-01" }
-{ "partkey": 110, "pid": 3, "shipdate": "1993-01-01" }
-{ "partkey": 111, "pid": 1, "shipdate": "1992-07-05" }
-{ "partkey": 111, "pid": 2, "shipdate": "1992-07-28" }
-{ "partkey": 111, "pid": 3, "shipdate": "1992-08-13" }
-{ "partkey": 112, "pid": 1, "shipdate": "1992-09-13" }
-{ "partkey": 112, "pid": 2, "shipdate": "1992-10-09" }
-{ "partkey": 112, "pid": 3, "shipdate": "1993-01-15" }
-{ "partkey": 113, "pid": 1, "shipdate": "1992-06-08" }
-{ "partkey": 113, "pid": 2, "shipdate": "1992-08-13" }
-{ "partkey": 113, "pid": 3, "shipdate": "1992-08-25" }
-{ "partkey": 114, "pid": 1, "shipdate": "1992-11-19" }
-{ "partkey": 114, "pid": 2, "shipdate": "1992-11-22" }
-{ "partkey": 114, "pid": 3, "shipdate": "1993-03-22" }
-{ "partkey": 115, "pid": 1, "shipdate": "1992-03-13" }
-{ "partkey": 115, "pid": 2, "shipdate": "1992-05-29" }
-{ "partkey": 115, "pid": 3, "shipdate": "1992-06-17" }
-{ "partkey": 116, "pid": 1, "shipdate": "1992-03-22" }
-{ "partkey": 116, "pid": 2, "shipdate": "1992-05-17" }
-{ "partkey": 116, "pid": 3, "shipdate": "1992-06-24" }
-{ "partkey": 117, "pid": 1, "shipdate": "1992-05-04" }
-{ "partkey": 117, "pid": 2, "shipdate": "1993-03-18" }
-{ "partkey": 117, "pid": 3, "shipdate": "1993-07-10" }
-{ "partkey": 118, "pid": 1, "shipdate": "1992-06-18" }
-{ "partkey": 118, "pid": 2, "shipdate": "1992-09-27" }
-{ "partkey": 118, "pid": 3, "shipdate": "1992-10-02" }
-{ "partkey": 119, "pid": 1, "shipdate": "1992-05-08" }
-{ "partkey": 119, "pid": 2, "shipdate": "1992-05-27" }
-{ "partkey": 119, "pid": 3, "shipdate": "1992-09-07" }
-{ "partkey": 120, "pid": 1, "shipdate": "1992-03-23" }
-{ "partkey": 120, "pid": 2, "shipdate": "1992-04-28" }
-{ "partkey": 120, "pid": 3, "shipdate": "1992-06-29" }
-{ "partkey": 121, "pid": 1, "shipdate": "1992-04-23" }
-{ "partkey": 121, "pid": 2, "shipdate": "1992-06-09" }
-{ "partkey": 121, "pid": 3, "shipdate": "1992-06-23" }
-{ "partkey": 122, "pid": 1, "shipdate": "1992-03-12" }
-{ "partkey": 122, "pid": 2, "shipdate": "1992-04-09" }
-{ "partkey": 122, "pid": 3, "shipdate": "1992-06-05" }
-{ "partkey": 123, "pid": 1, "shipdate": "1992-02-01" }
-{ "partkey": 123, "pid": 2, "shipdate": "1992-06-20" }
-{ "partkey": 123, "pid": 3, "shipdate": "1992-11-22" }
-{ "partkey": 124, "pid": 1, "shipdate": "1992-06-15" }
-{ "partkey": 124, "pid": 2, "shipdate": "1992-08-09" }
-{ "partkey": 124, "pid": 3, "shipdate": "1992-09-13" }
-{ "partkey": 125, "pid": 1, "shipdate": "1992-03-15" }
-{ "partkey": 125, "pid": 2, "shipdate": "1992-03-29" }
-{ "partkey": 125, "pid": 3, "shipdate": "1992-05-24" }
-{ "partkey": 126, "pid": 1, "shipdate": "1992-07-28" }
-{ "partkey": 126, "pid": 2, "shipdate": "1992-08-28" }
-{ "partkey": 126, "pid": 3, "shipdate": "1992-09-06" }
-{ "partkey": 127, "pid": 1, "shipdate": "1992-06-04" }
-{ "partkey": 127, "pid": 2, "shipdate": "1992-07-02" }
-{ "partkey": 127, "pid": 3, "shipdate": "1994-01-13" }
-{ "partkey": 128, "pid": 1, "shipdate": "1992-03-05" }
-{ "partkey": 128, "pid": 2, "shipdate": "1992-05-02" }
-{ "partkey": 128, "pid": 3, "shipdate": "1992-08-24" }
-{ "partkey": 129, "pid": 1, "shipdate": "1992-03-31" }
-{ "partkey": 129, "pid": 2, "shipdate": "1992-05-28" }
-{ "partkey": 129, "pid": 3, "shipdate": "1992-08-15" }
-{ "partkey": 130, "pid": 1, "shipdate": "1992-04-03" }
-{ "partkey": 130, "pid": 2, "shipdate": "1992-05-23" }
-{ "partkey": 130, "pid": 3, "shipdate": "1992-08-20" }
-{ "partkey": 131, "pid": 1, "shipdate": "1992-02-27" }
-{ "partkey": 131, "pid": 2, "shipdate": "1992-03-03" }
-{ "partkey": 131, "pid": 3, "shipdate": "1992-05-14" }
-{ "partkey": 132, "pid": 1, "shipdate": "1992-04-17" }
-{ "partkey": 132, "pid": 2, "shipdate": "1992-06-14" }
-{ "partkey": 132, "pid": 3, "shipdate": "1992-07-06" }
-{ "partkey": 133, "pid": 1, "shipdate": "1992-06-08" }
-{ "partkey": 133, "pid": 2, "shipdate": "1992-11-17" }
-{ "partkey": 133, "pid": 3, "shipdate": "1993-01-18" }
-{ "partkey": 134, "pid": 1, "shipdate": "1992-05-17" }
-{ "partkey": 134, "pid": 2, "shipdate": "1992-05-20" }
-{ "partkey": 134, "pid": 3, "shipdate": "1992-05-29" }
-{ "partkey": 135, "pid": 1, "shipdate": "1992-05-02" }
-{ "partkey": 135, "pid": 2, "shipdate": "1992-05-11" }
-{ "partkey": 135, "pid": 3, "shipdate": "1992-05-29" }
-{ "partkey": 136, "pid": 1, "shipdate": "1992-05-19" }
-{ "partkey": 136, "pid": 2, "shipdate": "1992-05-21" }
-{ "partkey": 136, "pid": 3, "shipdate": "1992-06-07" }
-{ "partkey": 137, "pid": 1, "shipdate": "1992-05-23" }
-{ "partkey": 137, "pid": 2, "shipdate": "1992-07-05" }
-{ "partkey": 137, "pid": 3, "shipdate": "1992-09-12" }
-{ "partkey": 138, "pid": 1, "shipdate": "1992-06-20" }
-{ "partkey": 138, "pid": 2, "shipdate": "1992-11-21" }
-{ "partkey": 138, "pid": 3, "shipdate": "1993-02-28" }
-{ "partkey": 139, "pid": 1, "shipdate": "1992-04-12" }
-{ "partkey": 139, "pid": 2, "shipdate": "1992-06-28" }
-{ "partkey": 139, "pid": 3, "shipdate": "1992-09-12" }
-{ "partkey": 140, "pid": 1, "shipdate": "1992-03-20" }
-{ "partkey": 140, "pid": 2, "shipdate": "1992-04-27" }
-{ "partkey": 140, "pid": 3, "shipdate": "1992-08-03" }
-{ "partkey": 141, "pid": 1, "shipdate": "1992-01-13" }
-{ "partkey": 141, "pid": 2, "shipdate": "1992-02-01" }
-{ "partkey": 141, "pid": 3, "shipdate": "1992-06-22" }
-{ "partkey": 142, "pid": 1, "shipdate": "1992-10-14" }
-{ "partkey": 142, "pid": 2, "shipdate": "1993-05-14" }
-{ "partkey": 142, "pid": 3, "shipdate": "1993-07-11" }
-{ "partkey": 143, "pid": 1, "shipdate": "1992-04-17" }
-{ "partkey": 143, "pid": 2, "shipdate": "1992-09-01" }
-{ "partkey": 143, "pid": 3, "shipdate": "1992-09-05" }
-{ "partkey": 144, "pid": 1, "shipdate": "1992-07-05" }
-{ "partkey": 144, "pid": 2, "shipdate": "1992-08-25" }
-{ "partkey": 144, "pid": 3, "shipdate": "1992-09-17" }
-{ "partkey": 145, "pid": 1, "shipdate": "1992-01-25" }
-{ "partkey": 145, "pid": 2, "shipdate": "1992-08-16" }
-{ "partkey": 145, "pid": 3, "shipdate": "1992-10-25" }
-{ "partkey": 146, "pid": 1, "shipdate": "1992-05-21" }
-{ "partkey": 146, "pid": 2, "shipdate": "1993-06-21" }
-{ "partkey": 146, "pid": 3, "shipdate": "1993-08-02" }
-{ "partkey": 147, "pid": 1, "shipdate": "1992-06-10" }
-{ "partkey": 147, "pid": 2, "shipdate": "1992-09-04" }
-{ "partkey": 147, "pid": 3, "shipdate": "1992-12-03" }
-{ "partkey": 148, "pid": 1, "shipdate": "1992-01-15" }
-{ "partkey": 148, "pid": 2, "shipdate": "1992-02-27" }
-{ "partkey": 148, "pid": 3, "shipdate": "1992-04-22" }
-{ "partkey": 149, "pid": 1, "shipdate": "1992-03-22" }
-{ "partkey": 149, "pid": 2, "shipdate": "1992-04-29" }
-{ "partkey": 149, "pid": 3, "shipdate": "1992-05-14" }
-{ "partkey": 150, "pid": 1, "shipdate": "1992-05-01" }
-{ "partkey": 150, "pid": 2, "shipdate": "1992-05-02" }
-{ "partkey": 150, "pid": 3, "shipdate": "1992-05-25" }
-{ "partkey": 151, "pid": 1, "shipdate": "1992-01-26" }
-{ "partkey": 151, "pid": 2, "shipdate": "1992-07-30" }
-{ "partkey": 151, "pid": 3, "shipdate": "1992-12-19" }
-{ "partkey": 152, "pid": 1, "shipdate": "1992-06-23" }
-{ "partkey": 152, "pid": 2, "shipdate": "1993-05-19" }
-{ "partkey": 152, "pid": 3, "shipdate": "1993-10-31" }
-{ "partkey": 153, "pid": 1, "shipdate": "1992-02-22" }
-{ "partkey": 153, "pid": 2, "shipdate": "1992-06-02" }
-{ "partkey": 153, "pid": 3, "shipdate": "1992-06-29" }
-{ "partkey": 154, "pid": 1, "shipdate": "1992-02-18" }
-{ "partkey": 154, "pid": 2, "shipdate": "1992-02-20" }
-{ "partkey": 154, "pid": 3, "shipdate": "1992-05-14" }
-{ "partkey": 155, "pid": 1, "shipdate": "1992-09-28" }
-{ "partkey": 155, "pid": 2, "shipdate": "1992-11-25" }
-{ "partkey": 155, "pid": 3, "shipdate": "1993-05-14" }
-{ "partkey": 156, "pid": 1, "shipdate": "1992-04-24" }
-{ "partkey": 156, "pid": 2, "shipdate": "1992-06-17" }
-{ "partkey": 156, "pid": 3, "shipdate": "1992-07-01" }
-{ "partkey": 157, "pid": 1, "shipdate": "1992-07-26" }
-{ "partkey": 157, "pid": 2, "shipdate": "1992-08-11" }
-{ "partkey": 157, "pid": 3, "shipdate": "1992-08-25" }
-{ "partkey": 158, "pid": 1, "shipdate": "1992-08-01" }
-{ "partkey": 158, "pid": 2, "shipdate": "1992-08-29" }
-{ "partkey": 158, "pid": 3, "shipdate": "1992-09-18" }
-{ "partkey": 159, "pid": 1, "shipdate": "1992-05-07" }
-{ "partkey": 159, "pid": 2, "shipdate": "1992-06-03" }
-{ "partkey": 159, "pid": 3, "shipdate": "1992-07-10" }
-{ "partkey": 160, "pid": 1, "shipdate": "1992-05-07" }
-{ "partkey": 160, "pid": 2, "shipdate": "1992-07-04" }
-{ "partkey": 160, "pid": 3, "shipdate": "1992-08-18" }
-{ "partkey": 161, "pid": 1, "shipdate": "1992-03-29" }
-{ "partkey": 161, "pid": 2, "shipdate": "1992-06-18" }
-{ "partkey": 161, "pid": 3, "shipdate": "1992-08-28" }
-{ "partkey": 162, "pid": 1, "shipdate": "1992-04-10" }
-{ "partkey": 162, "pid": 2, "shipdate": "1992-05-03" }
-{ "partkey": 162, "pid": 3, "shipdate": "1992-06-11" }
-{ "partkey": 163, "pid": 1, "shipdate": "1992-02-09" }
-{ "partkey": 163, "pid": 2, "shipdate": "1992-04-27" }
-{ "partkey": 163, "pid": 3, "shipdate": "1992-06-01" }
-{ "partkey": 164, "pid": 1, "shipdate": "1992-03-25" }
-{ "partkey": 164, "pid": 2, "shipdate": "1992-04-17" }
-{ "partkey": 164, "pid": 3, "shipdate": "1992-06-06" }
-{ "partkey": 165, "pid": 1, "shipdate": "1992-03-21" }
-{ "partkey": 165, "pid": 2, "shipdate": "1992-04-01" }
-{ "partkey": 165, "pid": 3, "shipdate": "1992-04-12" }
-{ "partkey": 166, "pid": 1, "shipdate": "1992-08-11" }
-{ "partkey": 166, "pid": 2, "shipdate": "1992-08-14" }
-{ "partkey": 166, "pid": 3, "shipdate": "1993-04-22" }
-{ "partkey": 167, "pid": 1, "shipdate": "1992-06-02" }
-{ "partkey": 167, "pid": 2, "shipdate": "1993-01-31" }
-{ "partkey": 167, "pid": 3, "shipdate": "1993-02-15" }
-{ "partkey": 168, "pid": 1, "shipdate": "1992-05-06" }
-{ "partkey": 168, "pid": 2, "shipdate": "1992-07-20" }
-{ "partkey": 168, "pid": 3, "shipdate": "1992-10-07" }
-{ "partkey": 169, "pid": 1, "shipdate": "1992-03-31" }
-{ "partkey": 169, "pid": 2, "shipdate": "1992-06-05" }
-{ "partkey": 169, "pid": 3, "shipdate": "1992-06-07" }
-{ "partkey": 170, "pid": 1, "shipdate": "1992-08-07" }
-{ "partkey": 170, "pid": 2, "shipdate": "1993-03-17" }
-{ "partkey": 170, "pid": 3, "shipdate": "1993-06-19" }
-{ "partkey": 171, "pid": 1, "shipdate": "1992-11-09" }
-{ "partkey": 171, "pid": 2, "shipdate": "1994-01-22" }
-{ "partkey": 171, "pid": 3, "shipdate": "1995-01-02" }
-{ "partkey": 172, "pid": 1, "shipdate": "1992-09-06" }
-{ "partkey": 172, "pid": 2, "shipdate": "1993-05-01" }
-{ "partkey": 172, "pid": 3, "shipdate": "1993-06-16" }
-{ "partkey": 173, "pid": 1, "shipdate": "1992-06-17" }
-{ "partkey": 173, "pid": 2, "shipdate": "1992-09-15" }
-{ "partkey": 173, "pid": 3, "shipdate": "1992-09-30" }
-{ "partkey": 174, "pid": 1, "shipdate": "1992-06-25" }
-{ "partkey": 174, "pid": 2, "shipdate": "1992-11-02" }
-{ "partkey": 174, "pid": 3, "shipdate": "1992-12-02" }
-{ "partkey": 175, "pid": 1, "shipdate": "1992-10-09" }
-{ "partkey": 175, "pid": 2, "shipdate": "1992-11-09" }
-{ "partkey": 175, "pid": 3, "shipdate": "1992-11-10" }
-{ "partkey": 176, "pid": 1, "shipdate": "1992-02-01" }
-{ "partkey": 176, "pid": 2, "shipdate": "1992-04-28" }
-{ "partkey": 176, "pid": 3, "shipdate": "1992-09-24" }
-{ "partkey": 177, "pid": 1, "shipdate": "1992-04-05" }
-{ "partkey": 177, "pid": 2, "shipdate": "1992-12-25" }
-{ "partkey": 177, "pid": 3, "shipdate": "1993-01-16" }
-{ "partkey": 178, "pid": 1, "shipdate": "1992-05-23" }
-{ "partkey": 178, "pid": 2, "shipdate": "1992-08-18" }
-{ "partkey": 178, "pid": 3, "shipdate": "1992-11-02" }
-{ "partkey": 179, "pid": 1, "shipdate": "1992-05-30" }
-{ "partkey": 179, "pid": 2, "shipdate": "1992-06-02" }
-{ "partkey": 179, "pid": 3, "shipdate": "1992-09-20" }
-{ "partkey": 180, "pid": 1, "shipdate": "1992-03-07" }
-{ "partkey": 180, "pid": 2, "shipdate": "1992-05-23" }
-{ "partkey": 180, "pid": 3, "shipdate": "1992-06-21" }
-{ "partkey": 181, "pid": 1, "shipdate": "1992-07-01" }
-{ "partkey": 181, "pid": 2, "shipdate": "1992-11-04" }
-{ "partkey": 181, "pid": 3, "shipdate": "1992-12-14" }
-{ "partkey": 182, "pid": 1, "shipdate": "1992-03-02" }
-{ "partkey": 182, "pid": 2, "shipdate": "1992-04-02" }
-{ "partkey": 182, "pid": 3, "shipdate": "1992-04-28" }
-{ "partkey": 183, "pid": 1, "shipdate": "1992-04-24" }
-{ "partkey": 183, "pid": 2, "shipdate": "1992-10-24" }
-{ "partkey": 183, "pid": 3, "shipdate": "1993-01-08" }
-{ "partkey": 184, "pid": 1, "shipdate": "1992-04-12" }
-{ "partkey": 184, "pid": 2, "shipdate": "1992-04-12" }
-{ "partkey": 184, "pid": 3, "shipdate": "1992-04-30" }
-{ "partkey": 185, "pid": 1, "shipdate": "1992-04-30" }
-{ "partkey": 185, "pid": 2, "shipdate": "1992-06-20" }
-{ "partkey": 185, "pid": 3, "shipdate": "1992-07-23" }
-{ "partkey": 186, "pid": 1, "shipdate": "1992-07-26" }
-{ "partkey": 186, "pid": 2, "shipdate": "1992-11-25" }
-{ "partkey": 186, "pid": 3, "shipdate": "1992-11-27" }
-{ "partkey": 187, "pid": 1, "shipdate": "1992-04-01" }
-{ "partkey": 187, "pid": 2, "shipdate": "1992-05-30" }
-{ "partkey": 187, "pid": 3, "shipdate": "1992-06-01" }
-{ "partkey": 188, "pid": 1, "shipdate": "1992-09-15" }
-{ "partkey": 188, "pid": 2, "shipdate": "1993-04-08" }
-{ "partkey": 188, "pid": 3, "shipdate": "1993-05-03" }
-{ "partkey": 189, "pid": 1, "shipdate": "1992-06-16" }
-{ "partkey": 189, "pid": 2, "shipdate": "1992-06-20" }
-{ "partkey": 189, "pid": 3, "shipdate": "1992-07-20" }
-{ "partkey": 190, "pid": 1, "shipdate": "1992-04-14" }
-{ "partkey": 190, "pid": 2, "shipdate": "1992-07-17" }
-{ "partkey": 190, "pid": 3, "shipdate": "1992-10-12" }
-{ "partkey": 191, "pid": 1, "shipdate": "1992-07-31" }
-{ "partkey": 191, "pid": 2, "shipdate": "1992-08-29" }
-{ "partkey": 191, "pid": 3, "shipdate": "1992-09-22" }
-{ "partkey": 192, "pid": 1, "shipdate": "1992-02-19" }
-{ "partkey": 192, "pid": 2, "shipdate": "1992-08-10" }
-{ "partkey": 192, "pid": 3, "shipdate": "1992-09-02" }
-{ "partkey": 193, "pid": 1, "shipdate": "1992-05-05" }
-{ "partkey": 193, "pid": 2, "shipdate": "1992-08-21" }
-{ "partkey": 193, "pid": 3, "shipdate": "1993-02-12" }
-{ "partkey": 194, "pid": 1, "shipdate": "1992-02-14" }
-{ "partkey": 194, "pid": 2, "shipdate": "1992-06-20" }
-{ "partkey": 194, "pid": 3, "shipdate": "1992-12-15" }
-{ "partkey": 195, "pid": 1, "shipdate": "1992-04-10" }
-{ "partkey": 195, "pid": 2, "shipdate": "1992-05-07" }
-{ "partkey": 195, "pid": 3, "shipdate": "1992-05-28" }
-{ "partkey": 196, "pid": 1, "shipdate": "1992-03-02" }
-{ "partkey": 196, "pid": 2, "shipdate": "1992-03-04" }
-{ "partkey": 196, "pid": 3, "shipdate": "1992-06-11" }
-{ "partkey": 197, "pid": 1, "shipdate": "1993-08-22" }
-{ "partkey": 197, "pid": 2, "shipdate": "1994-02-24" }
-{ "partkey": 197, "pid": 3, "shipdate": "1994-03-03" }
-{ "partkey": 198, "pid": 1, "shipdate": "1992-04-21" }
-{ "partkey": 198, "pid": 2, "shipdate": "1992-09-12" }
-{ "partkey": 198, "pid": 3, "shipdate": "1992-12-27" }
-{ "partkey": 199, "pid": 1, "shipdate": "1992-03-14" }
-{ "partkey": 199, "pid": 2, "shipdate": "1992-08-02" }
-{ "partkey": 199, "pid": 3, "shipdate": "1992-11-20" }
-{ "partkey": 200, "pid": 1, "shipdate": "1992-04-19" }
-{ "partkey": 200, "pid": 2, "shipdate": "1993-01-06" }
-{ "partkey": 200, "pid": 3, "shipdate": "1993-10-17" }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.ignore
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.ignore b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.2.ignore
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.4.ignore
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.4.ignore b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.4.ignore
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.5.json
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.5.json b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.5.json
new file mode 100644
index 0000000..6213a6b
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.5.json
@@ -0,0 +1 @@
+{"status":"SUCCESS"}

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.6.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.6.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.6.adm
new file mode 100644
index 0000000..74e1bb7
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/flwor/at00/at00.6.adm
@@ -0,0 +1,600 @@
+{ "partkey": 1, "pid": 1, "shipdate": "1992-02-15" }
+{ "partkey": 1, "pid": 2, "shipdate": "1992-03-30" }
+{ "partkey": 1, "pid": 3, "shipdate": "1992-07-17" }
+{ "partkey": 2, "pid": 1, "shipdate": "1992-06-23" }
+{ "partkey": 2, "pid": 2, "shipdate": "1992-07-01" }
+{ "partkey": 2, "pid": 3, "shipdate": "1992-07-18" }
+{ "partkey": 3, "pid": 1, "shipdate": "1992-04-25" }
+{ "partkey": 3, "pid": 2, "shipdate": "1992-05-24" }
+{ "partkey": 3, "pid": 3, "shipdate": "1993-01-03" }
+{ "partkey": 4, "pid": 1, "shipdate": "1992-05-02" }
+{ "partkey": 4, "pid": 2, "shipdate": "1992-11-03" }
+{ "partkey": 4, "pid": 3, "shipdate": "1992-11-18" }
+{ "partkey": 5, "pid": 1, "shipdate": "1992-05-02" }
+{ "partkey": 5, "pid": 2, "shipdate": "1992-06-14" }
+{ "partkey": 5, "pid": 3, "shipdate": "1993-01-06" }
+{ "partkey": 6, "pid": 1, "shipdate": "1992-04-05" }
+{ "partkey": 6, "pid": 2, "shipdate": "1992-04-25" }
+{ "partkey": 6, "pid": 3, "shipdate": "1992-04-29" }
+{ "partkey": 7, "pid": 1, "shipdate": "1992-04-12" }
+{ "partkey": 7, "pid": 2, "shipdate": "1993-02-11" }
+{ "partkey": 7, "pid": 3, "shipdate": "1993-06-25" }
+{ "partkey": 8, "pid": 1, "shipdate": "1992-09-25" }
+{ "partkey": 8, "pid": 2, "shipdate": "1992-11-15" }
+{ "partkey": 8, "pid": 3, "shipdate": "1993-02-13" }
+{ "partkey": 9, "pid": 1, "shipdate": "1992-04-29" }
+{ "partkey": 9, "pid": 2, "shipdate": "1992-04-30" }
+{ "partkey": 9, "pid": 3, "shipdate": "1992-06-01" }
+{ "partkey": 10, "pid": 1, "shipdate": "1992-05-13" }
+{ "partkey": 10, "pid": 2, "shipdate": "1992-11-25" }
+{ "partkey": 10, "pid": 3, "shipdate": "1992-12-01" }
+{ "partkey": 11, "pid": 1, "shipdate": "1992-02-14" }
+{ "partkey": 11, "pid": 2, "shipdate": "1992-07-20" }
+{ "partkey": 11, "pid": 3, "shipdate": "1992-08-03" }
+{ "partkey": 12, "pid": 1, "shipdate": "1992-07-04" }
+{ "partkey": 12, "pid": 2, "shipdate": "1992-07-17" }
+{ "partkey": 12, "pid": 3, "shipdate": "1992-09-02" }
+{ "partkey": 13, "pid": 1, "shipdate": "1992-04-01" }
+{ "partkey": 13, "pid": 2, "shipdate": "1992-04-26" }
+{ "partkey": 13, "pid": 3, "shipdate": "1992-05-04" }
+{ "partkey": 14, "pid": 1, "shipdate": "1992-07-17" }
+{ "partkey": 14, "pid": 2, "shipdate": "1992-11-30" }
+{ "partkey": 14, "pid": 3, "shipdate": "1993-05-10" }
+{ "partkey": 15, "pid": 1, "shipdate": "1992-05-18" }
+{ "partkey": 15, "pid": 2, "shipdate": "1992-05-24" }
+{ "partkey": 15, "pid": 3, "shipdate": "1993-04-14" }
+{ "partkey": 16, "pid": 1, "shipdate": "1992-09-11" }
+{ "partkey": 16, "pid": 2, "shipdate": "1992-09-25" }
+{ "partkey": 16, "pid": 3, "shipdate": "1992-11-17" }
+{ "partkey": 17, "pid": 1, "shipdate": "1992-07-23" }
+{ "partkey": 17, "pid": 2, "shipdate": "1993-03-01" }
+{ "partkey": 17, "pid": 3, "shipdate": "1993-05-06" }
+{ "partkey": 18, "pid": 1, "shipdate": "1992-04-12" }
+{ "partkey": 18, "pid": 2, "shipdate": "1992-04-21" }
+{ "partkey": 18, "pid": 3, "shipdate": "1992-05-21" }
+{ "partkey": 19, "pid": 1, "shipdate": "1992-07-19" }
+{ "partkey": 19, "pid": 2, "shipdate": "1992-10-21" }
+{ "partkey": 19, "pid": 3, "shipdate": "1992-12-22" }
+{ "partkey": 20, "pid": 1, "shipdate": "1992-06-15" }
+{ "partkey": 20, "pid": 2, "shipdate": "1992-07-29" }
+{ "partkey": 20, "pid": 3, "shipdate": "1992-10-18" }
+{ "partkey": 21, "pid": 1, "shipdate": "1992-07-31" }
+{ "partkey": 21, "pid": 2, "shipdate": "1992-09-09" }
+{ "partkey": 21, "pid": 3, "shipdate": "1993-01-09" }
+{ "partkey": 22, "pid": 1, "shipdate": "1992-06-21" }
+{ "partkey": 22, "pid": 2, "shipdate": "1992-06-25" }
+{ "partkey": 22, "pid": 3, "shipdate": "1992-11-20" }
+{ "partkey": 23, "pid": 1, "shipdate": "1992-04-04" }
+{ "partkey": 23, "pid": 2, "shipdate": "1992-06-19" }
+{ "partkey": 23, "pid": 3, "shipdate": "1992-06-29" }
+{ "partkey": 24, "pid": 1, "shipdate": "1992-04-12" }
+{ "partkey": 24, "pid": 2, "shipdate": "1992-08-06" }
+{ "partkey": 24, "pid": 3, "shipdate": "1992-08-08" }
+{ "partkey": 25, "pid": 1, "shipdate": "1992-02-04" }
+{ "partkey": 25, "pid": 2, "shipdate": "1992-07-23" }
+{ "partkey": 25, "pid": 3, "shipdate": "1992-08-01" }
+{ "partkey": 26, "pid": 1, "shipdate": "1992-02-23" }
+{ "partkey": 26, "pid": 2, "shipdate": "1992-05-09" }
+{ "partkey": 26, "pid": 3, "shipdate": "1993-01-04" }
+{ "partkey": 27, "pid": 1, "shipdate": "1992-07-05" }
+{ "partkey": 27, "pid": 2, "shipdate": "1992-07-14" }
+{ "partkey": 27, "pid": 3, "shipdate": "1992-08-17" }
+{ "partkey": 28, "pid": 1, "shipdate": "1992-03-16" }
+{ "partkey": 28, "pid": 2, "shipdate": "1992-10-13" }
+{ "partkey": 28, "pid": 3, "shipdate": "1992-11-04" }
+{ "partkey": 29, "pid": 1, "shipdate": "1992-05-25" }
+{ "partkey": 29, "pid": 2, "shipdate": "1992-06-01" }
+{ "partkey": 29, "pid": 3, "shipdate": "1992-07-25" }
+{ "partkey": 30, "pid": 1, "shipdate": "1992-04-10" }
+{ "partkey": 30, "pid": 2, "shipdate": "1992-05-18" }
+{ "partkey": 30, "pid": 3, "shipdate": "1992-05-21" }
+{ "partkey": 31, "pid": 1, "shipdate": "1992-07-14" }
+{ "partkey": 31, "pid": 2, "shipdate": "1992-09-24" }
+{ "partkey": 31, "pid": 3, "shipdate": "1992-09-29" }
+{ "partkey": 32, "pid": 1, "shipdate": "1992-09-22" }
+{ "partkey": 32, "pid": 2, "shipdate": "1992-09-25" }
+{ "partkey": 32, "pid": 3, "shipdate": "1992-10-07" }
+{ "partkey": 33, "pid": 1, "shipdate": "1992-03-22" }
+{ "partkey": 33, "pid": 2, "shipdate": "1993-02-17" }
+{ "partkey": 33, "pid": 3, "shipdate": "1993-02-21" }
+{ "partkey": 34, "pid": 1, "shipdate": "1992-07-03" }
+{ "partkey": 34, "pid": 2, "shipdate": "1992-07-20" }
+{ "partkey": 34, "pid": 3, "shipdate": "1992-11-23" }
+{ "partkey": 35, "pid": 1, "shipdate": "1992-03-11" }
+{ "partkey": 35, "pid": 2, "shipdate": "1992-04-06" }
+{ "partkey": 35, "pid": 3, "shipdate": "1992-05-26" }
+{ "partkey": 36, "pid": 1, "shipdate": "1992-02-26" }
+{ "partkey": 36, "pid": 2, "shipdate": "1992-07-03" }
+{ "partkey": 36, "pid": 3, "shipdate": "1993-01-06" }
+{ "partkey": 37, "pid": 1, "shipdate": "1992-08-30" }
+{ "partkey": 37, "pid": 2, "shipdate": "1992-10-03" }
+{ "partkey": 37, "pid": 3, "shipdate": "1993-01-31" }
+{ "partkey": 38, "pid": 1, "shipdate": "1992-04-06" }
+{ "partkey": 38, "pid": 2, "shipdate": "1992-04-15" }
+{ "partkey": 38, "pid": 3, "shipdate": "1992-08-27" }
+{ "partkey": 39, "pid": 1, "shipdate": "1992-05-26" }
+{ "partkey": 39, "pid": 2, "shipdate": "1992-11-12" }
+{ "partkey": 39, "pid": 3, "shipdate": "1992-11-15" }
+{ "partkey": 40, "pid": 1, "shipdate": "1992-02-07" }
+{ "partkey": 40, "pid": 2, "shipdate": "1992-04-28" }
+{ "partkey": 40, "pid": 3, "shipdate": "1992-05-03" }
+{ "partkey": 41, "pid": 1, "shipdate": "1992-12-13" }
+{ "partkey": 41, "pid": 2, "shipdate": "1993-01-18" }
+{ "partkey": 41, "pid": 3, "shipdate": "1993-04-13" }
+{ "partkey": 42, "pid": 1, "shipdate": "1992-10-23" }
+{ "partkey": 42, "pid": 2, "shipdate": "1992-11-04" }
+{ "partkey": 42, "pid": 3, "shipdate": "1992-12-12" }
+{ "partkey": 43, "pid": 1, "shipdate": "1992-06-18" }
+{ "partkey": 43, "pid": 2, "shipdate": "1992-06-30" }
+{ "partkey": 43, "pid": 3, "shipdate": "1992-08-28" }
+{ "partkey": 44, "pid": 1, "shipdate": "1992-02-14" }
+{ "partkey": 44, "pid": 2, "shipdate": "1992-06-11" }
+{ "partkey": 44, "pid": 3, "shipdate": "1992-11-29" }
+{ "partkey": 45, "pid": 1, "shipdate": "1992-07-16" }
+{ "partkey": 45, "pid": 2, "shipdate": "1993-06-24" }
+{ "partkey": 45, "pid": 3, "shipdate": "1993-09-15" }
+{ "partkey": 46, "pid": 1, "shipdate": "1992-04-28" }
+{ "partkey": 46, "pid": 2, "shipdate": "1992-05-08" }
+{ "partkey": 46, "pid": 3, "shipdate": "1992-05-21" }
+{ "partkey": 47, "pid": 1, "shipdate": "1992-03-11" }
+{ "partkey": 47, "pid": 2, "shipdate": "1993-05-30" }
+{ "partkey": 47, "pid": 3, "shipdate": "1993-06-06" }
+{ "partkey": 48, "pid": 1, "shipdate": "1992-05-10" }
+{ "partkey": 48, "pid": 2, "shipdate": "1992-06-03" }
+{ "partkey": 48, "pid": 3, "shipdate": "1992-06-15" }
+{ "partkey": 49, "pid": 1, "shipdate": "1992-04-29" }
+{ "partkey": 49, "pid": 2, "shipdate": "1992-06-14" }
+{ "partkey": 49, "pid": 3, "shipdate": "1992-08-13" }
+{ "partkey": 50, "pid": 1, "shipdate": "1992-04-22" }
+{ "partkey": 50, "pid": 2, "shipdate": "1992-07-31" }
+{ "partkey": 50, "pid": 3, "shipdate": "1992-09-23" }
+{ "partkey": 51, "pid": 1, "shipdate": "1992-03-11" }
+{ "partkey": 51, "pid": 2, "shipdate": "1992-05-15" }
+{ "partkey": 51, "pid": 3, "shipdate": "1992-05-17" }
+{ "partkey": 52, "pid": 1, "shipdate": "1992-05-31" }
+{ "partkey": 52, "pid": 2, "shipdate": "1992-09-03" }
+{ "partkey": 52, "pid": 3, "shipdate": "1992-09-21" }
+{ "partkey": 53, "pid": 1, "shipdate": "1992-01-14" }
+{ "partkey": 53, "pid": 2, "shipdate": "1992-05-22" }
+{ "partkey": 53, "pid": 3, "shipdate": "1992-10-04" }
+{ "partkey": 54, "pid": 1, "shipdate": "1992-04-07" }
+{ "partkey": 54, "pid": 2, "shipdate": "1992-05-01" }
+{ "partkey": 54, "pid": 3, "shipdate": "1992-06-24" }
+{ "partkey": 55, "pid": 1, "shipdate": "1992-01-16" }
+{ "partkey": 55, "pid": 2, "shipdate": "1992-05-11" }
+{ "partkey": 55, "pid": 3, "shipdate": "1992-06-17" }
+{ "partkey": 56, "pid": 1, "shipdate": "1992-01-16" }
+{ "partkey": 56, "pid": 2, "shipdate": "1992-03-02" }
+{ "partkey": 56, "pid": 3, "shipdate": "1992-06-18" }
+{ "partkey": 57, "pid": 1, "shipdate": "1992-01-16" }
+{ "partkey": 57, "pid": 2, "shipdate": "1992-07-06" }
+{ "partkey": 57, "pid": 3, "shipdate": "1992-09-21" }
+{ "partkey": 58, "pid": 1, "shipdate": "1992-05-16" }
+{ "partkey": 58, "pid": 2, "shipdate": "1992-10-30" }
+{ "partkey": 58, "pid": 3, "shipdate": "1993-04-10" }
+{ "partkey": 59, "pid": 1, "shipdate": "1992-02-09" }
+{ "partkey": 59, "pid": 2, "shipdate": "1992-03-17" }
+{ "partkey": 59, "pid": 3, "shipdate": "1992-06-12" }
+{ "partkey": 60, "pid": 1, "shipdate": "1992-02-14" }
+{ "partkey": 60, "pid": 2, "shipdate": "1992-07-01" }
+{ "partkey": 60, "pid": 3, "shipdate": "1992-07-15" }
+{ "partkey": 61, "pid": 1, "shipdate": "1993-07-14" }
+{ "partkey": 61, "pid": 2, "shipdate": "1993-07-15" }
+{ "partkey": 61, "pid": 3, "shipdate": "1993-09-29" }
+{ "partkey": 62, "pid": 1, "shipdate": "1992-02-01" }
+{ "partkey": 62, "pid": 2, "shipdate": "1992-03-26" }
+{ "partkey": 62, "pid": 3, "shipdate": "1992-06-19" }
+{ "partkey": 63, "pid": 1, "shipdate": "1992-02-07" }
+{ "partkey": 63, "pid": 2, "shipdate": "1992-06-15" }
+{ "partkey": 63, "pid": 3, "shipdate": "1993-02-07" }
+{ "partkey": 64, "pid": 1, "shipdate": "1992-02-13" }
+{ "partkey": 64, "pid": 2, "shipdate": "1992-02-14" }
+{ "partkey": 64, "pid": 3, "shipdate": "1992-03-10" }
+{ "partkey": 65, "pid": 1, "shipdate": "1992-03-02" }
+{ "partkey": 65, "pid": 2, "shipdate": "1992-04-14" }
+{ "partkey": 65, "pid": 3, "shipdate": "1992-06-26" }
+{ "partkey": 66, "pid": 1, "shipdate": "1992-05-07" }
+{ "partkey": 66, "pid": 2, "shipdate": "1992-09-11" }
+{ "partkey": 66, "pid": 3, "shipdate": "1992-10-10" }
+{ "partkey": 67, "pid": 1, "shipdate": "1992-05-13" }
+{ "partkey": 67, "pid": 2, "shipdate": "1993-01-08" }
+{ "partkey": 67, "pid": 3, "shipdate": "1993-11-03" }
+{ "partkey": 68, "pid": 1, "shipdate": "1992-04-13" }
+{ "partkey": 68, "pid": 2, "shipdate": "1992-06-08" }
+{ "partkey": 68, "pid": 3, "shipdate": "1992-06-22" }
+{ "partkey": 69, "pid": 1, "shipdate": "1992-05-31" }
+{ "partkey": 69, "pid": 2, "shipdate": "1992-06-05" }
+{ "partkey": 69, "pid": 3, "shipdate": "1992-07-01" }
+{ "partkey": 70, "pid": 1, "shipdate": "1992-04-06" }
+{ "partkey": 70, "pid": 2, "shipdate": "1992-06-11" }
+{ "partkey": 70, "pid": 3, "shipdate": "1992-06-25" }
+{ "partkey": 71, "pid": 1, "shipdate": "1992-11-10" }
+{ "partkey": 71, "pid": 2, "shipdate": "1993-01-10" }
+{ "partkey": 71, "pid": 3, "shipdate": "1993-02-28" }
+{ "partkey": 72, "pid": 1, "shipdate": "1992-09-16" }
+{ "partkey": 72, "pid": 2, "shipdate": "1992-10-02" }
+{ "partkey": 72, "pid": 3, "shipdate": "1992-10-17" }
+{ "partkey": 73, "pid": 1, "shipdate": "1992-01-08" }
+{ "partkey": 73, "pid": 2, "shipdate": "1992-09-16" }
+{ "partkey": 73, "pid": 3, "shipdate": "1993-07-02" }
+{ "partkey": 74, "pid": 1, "shipdate": "1992-03-21" }
+{ "partkey": 74, "pid": 2, "shipdate": "1992-03-22" }
+{ "partkey": 74, "pid": 3, "shipdate": "1992-10-21" }
+{ "partkey": 75, "pid": 1, "shipdate": "1992-03-27" }
+{ "partkey": 75, "pid": 2, "shipdate": "1992-05-12" }
+{ "partkey": 75, "pid": 3, "shipdate": "1992-09-19" }
+{ "partkey": 76, "pid": 1, "shipdate": "1992-10-22" }
+{ "partkey": 76, "pid": 2, "shipdate": "1993-04-19" }
+{ "partkey": 76, "pid": 3, "shipdate": "1993-06-12" }
+{ "partkey": 77, "pid": 1, "shipdate": "1992-08-18" }
+{ "partkey": 77, "pid": 2, "shipdate": "1992-12-23" }
+{ "partkey": 77, "pid": 3, "shipdate": "1993-06-19" }
+{ "partkey": 78, "pid": 1, "shipdate": "1992-03-04" }
+{ "partkey": 78, "pid": 2, "shipdate": "1992-04-04" }
+{ "partkey": 78, "pid": 3, "shipdate": "1992-05-06" }
+{ "partkey": 79, "pid": 1, "shipdate": "1992-08-05" }
+{ "partkey": 79, "pid": 2, "shipdate": "1992-08-10" }
+{ "partkey": 79, "pid": 3, "shipdate": "1993-04-08" }
+{ "partkey": 80, "pid": 1, "shipdate": "1992-05-18" }
+{ "partkey": 80, "pid": 2, "shipdate": "1992-09-02" }
+{ "partkey": 80, "pid": 3, "shipdate": "1993-06-07" }
+{ "partkey": 81, "pid": 1, "shipdate": "1992-04-11" }
+{ "partkey": 81, "pid": 2, "shipdate": "1992-06-22" }
+{ "partkey": 81, "pid": 3, "shipdate": "1992-12-30" }
+{ "partkey": 82, "pid": 1, "shipdate": "1992-07-17" }
+{ "partkey": 82, "pid": 2, "shipdate": "1992-10-18" }
+{ "partkey": 82, "pid": 3, "shipdate": "1992-12-11" }
+{ "partkey": 83, "pid": 1, "shipdate": "1992-06-09" }
+{ "partkey": 83, "pid": 2, "shipdate": "1992-08-04" }
+{ "partkey": 83, "pid": 3, "shipdate": "1992-09-21" }
+{ "partkey": 84, "pid": 1, "shipdate": "1992-09-08" }
+{ "partkey": 84, "pid": 2, "shipdate": "1993-05-15" }
+{ "partkey": 84, "pid": 3, "shipdate": "1993-05-20" }
+{ "partkey": 85, "pid": 1, "shipdate": "1992-02-28" }
+{ "partkey": 85, "pid": 2, "shipdate": "1992-05-28" }
+{ "partkey": 85, "pid": 3, "shipdate": "1992-06-27" }
+{ "partkey": 86, "pid": 1, "shipdate": "1992-05-25" }
+{ "partkey": 86, "pid": 2, "shipdate": "1992-11-18" }
+{ "partkey": 86, "pid": 3, "shipdate": "1993-03-01" }
+{ "partkey": 87, "pid": 1, "shipdate": "1992-09-30" }
+{ "partkey": 87, "pid": 2, "shipdate": "1992-12-02" }
+{ "partkey": 87, "pid": 3, "shipdate": "1993-01-06" }
+{ "partkey": 88, "pid": 1, "shipdate": "1992-04-24" }
+{ "partkey": 88, "pid": 2, "shipdate": "1992-06-26" }
+{ "partkey": 88, "pid": 3, "shipdate": "1992-12-18" }
+{ "partkey": 89, "pid": 1, "shipdate": "1992-04-18" }
+{ "partkey": 89, "pid": 2, "shipdate": "1992-04-19" }
+{ "partkey": 89, "pid": 3, "shipdate": "1992-05-27" }
+{ "partkey": 90, "pid": 1, "shipdate": "1992-02-25" }
+{ "partkey": 90, "pid": 2, "shipdate": "1992-06-07" }
+{ "partkey": 90, "pid": 3, "shipdate": "1992-08-21" }
+{ "partkey": 91, "pid": 1, "shipdate": "1992-05-22" }
+{ "partkey": 91, "pid": 2, "shipdate": "1992-06-21" }
+{ "partkey": 91, "pid": 3, "shipdate": "1992-12-03" }
+{ "partkey": 92, "pid": 1, "shipdate": "1992-02-11" }
+{ "partkey": 92, "pid": 2, "shipdate": "1992-09-30" }
+{ "partkey": 92, "pid": 3, "shipdate": "1993-01-04" }
+{ "partkey": 93, "pid": 1, "shipdate": "1992-05-28" }
+{ "partkey": 93, "pid": 2, "shipdate": "1992-06-24" }
+{ "partkey": 93, "pid": 3, "shipdate": "1992-09-11" }
+{ "partkey": 94, "pid": 1, "shipdate": "1992-05-20" }
+{ "partkey": 94, "pid": 2, "shipdate": "1992-07-03" }
+{ "partkey": 94, "pid": 3, "shipdate": "1992-07-26" }
+{ "partkey": 95, "pid": 1, "shipdate": "1992-02-24" }
+{ "partkey": 95, "pid": 2, "shipdate": "1992-03-14" }
+{ "partkey": 95, "pid": 3, "shipdate": "1992-11-17" }
+{ "partkey": 96, "pid": 1, "shipdate": "1992-06-18" }
+{ "partkey": 96, "pid": 2, "shipdate": "1992-09-26" }
+{ "partkey": 96, "pid": 3, "shipdate": "1992-11-25" }
+{ "partkey": 97, "pid": 1, "shipdate": "1992-01-27" }
+{ "partkey": 97, "pid": 2, "shipdate": "1992-03-22" }
+{ "partkey": 97, "pid": 3, "shipdate": "1992-04-21" }
+{ "partkey": 98, "pid": 1, "shipdate": "1992-10-06" }
+{ "partkey": 98, "pid": 2, "shipdate": "1992-12-09" }
+{ "partkey": 98, "pid": 3, "shipdate": "1993-03-09" }
+{ "partkey": 99, "pid": 1, "shipdate": "1992-05-01" }
+{ "partkey": 99, "pid": 2, "shipdate": "1993-04-18" }
+{ "partkey": 99, "pid": 3, "shipdate": "1993-06-09" }
+{ "partkey": 100, "pid": 1, "shipdate": "1992-03-24" }
+{ "partkey": 100, "pid": 2, "shipdate": "1992-03-24" }
+{ "partkey": 100, "pid": 3, "shipdate": "1992-06-18" }
+{ "partkey": 101, "pid": 1, "shipdate": "1992-08-17" }
+{ "partkey": 101, "pid": 2, "shipdate": "1992-09-27" }
+{ "partkey": 101, "pid": 3, "shipdate": "1992-12-28" }
+{ "partkey": 102, "pid": 1, "shipdate": "1992-08-19" }
+{ "partkey": 102, "pid": 2, "shipdate": "1992-08-21" }
+{ "partkey": 102, "pid": 3, "shipdate": "1992-10-25" }
+{ "partkey": 103, "pid": 1, "shipdate": "1992-03-28" }
+{ "partkey": 103, "pid": 2, "shipdate": "1992-05-08" }
+{ "partkey": 103, "pid": 3, "shipdate": "1992-07-11" }
+{ "partkey": 104, "pid": 1, "shipdate": "1992-03-17" }
+{ "partkey": 104, "pid": 2, "shipdate": "1992-11-08" }
+{ "partkey": 104, "pid": 3, "shipdate": "1994-01-22" }
+{ "partkey": 105, "pid": 1, "shipdate": "1992-02-14" }
+{ "partkey": 105, "pid": 2, "shipdate": "1992-06-01" }
+{ "partkey": 105, "pid": 3, "shipdate": "1992-07-14" }
+{ "partkey": 106, "pid": 1, "shipdate": "1992-07-09" }
+{ "partkey": 106, "pid": 2, "shipdate": "1992-07-31" }
+{ "partkey": 106, "pid": 3, "shipdate": "1992-10-02" }
+{ "partkey": 107, "pid": 1, "shipdate": "1992-05-22" }
+{ "partkey": 107, "pid": 2, "shipdate": "1992-07-30" }
+{ "partkey": 107, "pid": 3, "shipdate": "1992-08-05" }
+{ "partkey": 108, "pid": 1, "shipdate": "1992-07-28" }
+{ "partkey": 108, "pid": 2, "shipdate": "1992-08-01" }
+{ "partkey": 108, "pid": 3, "shipdate": "1992-09-07" }
+{ "partkey": 109, "pid": 1, "shipdate": "1992-06-06" }
+{ "partkey": 109, "pid": 2, "shipdate": "1992-11-20" }
+{ "partkey": 109, "pid": 3, "shipdate": "1992-12-23" }
+{ "partkey": 110, "pid": 1, "shipdate": "1992-09-18" }
+{ "partkey": 110, "pid": 2, "shipdate": "1992-11-01" }
+{ "partkey": 110, "pid": 3, "shipdate": "1993-01-01" }
+{ "partkey": 111, "pid": 1, "shipdate": "1992-07-05" }
+{ "partkey": 111, "pid": 2, "shipdate": "1992-07-28" }
+{ "partkey": 111, "pid": 3, "shipdate": "1992-08-13" }
+{ "partkey": 112, "pid": 1, "shipdate": "1992-09-13" }
+{ "partkey": 112, "pid": 2, "shipdate": "1992-10-09" }
+{ "partkey": 112, "pid": 3, "shipdate": "1993-01-15" }
+{ "partkey": 113, "pid": 1, "shipdate": "1992-06-08" }
+{ "partkey": 113, "pid": 2, "shipdate": "1992-08-13" }
+{ "partkey": 113, "pid": 3, "shipdate": "1992-08-25" }
+{ "partkey": 114, "pid": 1, "shipdate": "1992-11-19" }
+{ "partkey": 114, "pid": 2, "shipdate": "1992-11-22" }
+{ "partkey": 114, "pid": 3, "shipdate": "1993-03-22" }
+{ "partkey": 115, "pid": 1, "shipdate": "1992-03-13" }
+{ "partkey": 115, "pid": 2, "shipdate": "1992-05-29" }
+{ "partkey": 115, "pid": 3, "shipdate": "1992-06-17" }
+{ "partkey": 116, "pid": 1, "shipdate": "1992-03-22" }
+{ "partkey": 116, "pid": 2, "shipdate": "1992-05-17" }
+{ "partkey": 116, "pid": 3, "shipdate": "1992-06-24" }
+{ "partkey": 117, "pid": 1, "shipdate": "1992-05-04" }
+{ "partkey": 117, "pid": 2, "shipdate": "1993-03-18" }
+{ "partkey": 117, "pid": 3, "shipdate": "1993-07-10" }
+{ "partkey": 118, "pid": 1, "shipdate": "1992-06-18" }
+{ "partkey": 118, "pid": 2, "shipdate": "1992-09-27" }
+{ "partkey": 118, "pid": 3, "shipdate": "1992-10-02" }
+{ "partkey": 119, "pid": 1, "shipdate": "1992-05-08" }
+{ "partkey": 119, "pid": 2, "shipdate": "1992-05-27" }
+{ "partkey": 119, "pid": 3, "shipdate": "1992-09-07" }
+{ "partkey": 120, "pid": 1, "shipdate": "1992-03-23" }
+{ "partkey": 120, "pid": 2, "shipdate": "1992-04-28" }
+{ "partkey": 120, "pid": 3, "shipdate": "1992-06-29" }
+{ "partkey": 121, "pid": 1, "shipdate": "1992-04-23" }
+{ "partkey": 121, "pid": 2, "shipdate": "1992-06-09" }
+{ "partkey": 121, "pid": 3, "shipdate": "1992-06-23" }
+{ "partkey": 122, "pid": 1, "shipdate": "1992-03-12" }
+{ "partkey": 122, "pid": 2, "shipdate": "1992-04-09" }
+{ "partkey": 122, "pid": 3, "shipdate": "1992-06-05" }
+{ "partkey": 123, "pid": 1, "shipdate": "1992-02-01" }
+{ "partkey": 123, "pid": 2, "shipdate": "1992-06-20" }
+{ "partkey": 123, "pid": 3, "shipdate": "1992-11-22" }
+{ "partkey": 124, "pid": 1, "shipdate": "1992-06-15" }
+{ "partkey": 124, "pid": 2, "shipdate": "1992-08-09" }
+{ "partkey": 124, "pid": 3, "shipdate": "1992-09-13" }
+{ "partkey": 125, "pid": 1, "shipdate": "1992-03-15" }
+{ "partkey": 125, "pid": 2, "shipdate": "1992-03-29" }
+{ "partkey": 125, "pid": 3, "shipdate": "1992-05-24" }
+{ "partkey": 126, "pid": 1, "shipdate": "1992-07-28" }
+{ "partkey": 126, "pid": 2, "shipdate": "1992-08-28" }
+{ "partkey": 126, "pid": 3, "shipdate": "1992-09-06" }
+{ "partkey": 127, "pid": 1, "shipdate": "1992-06-04" }
+{ "partkey": 127, "pid": 2, "shipdate": "1992-07-02" }
+{ "partkey": 127, "pid": 3, "shipdate": "1994-01-13" }
+{ "partkey": 128, "pid": 1, "shipdate": "1992-03-05" }
+{ "partkey": 128, "pid": 2, "shipdate": "1992-05-02" }
+{ "partkey": 128, "pid": 3, "shipdate": "1992-08-24" }
+{ "partkey": 129, "pid": 1, "shipdate": "1992-03-31" }
+{ "partkey": 129, "pid": 2, "shipdate": "1992-05-28" }
+{ "partkey": 129, "pid": 3, "shipdate": "1992-08-15" }
+{ "partkey": 130, "pid": 1, "shipdate": "1992-04-03" }
+{ "partkey": 130, "pid": 2, "shipdate": "1992-05-23" }
+{ "partkey": 130, "pid": 3, "shipdate": "1992-08-20" }
+{ "partkey": 131, "pid": 1, "shipdate": "1992-02-27" }
+{ "partkey": 131, "pid": 2, "shipdate": "1992-03-03" }
+{ "partkey": 131, "pid": 3, "shipdate": "1992-05-14" }
+{ "partkey": 132, "pid": 1, "shipdate": "1992-04-17" }
+{ "partkey": 132, "pid": 2, "shipdate": "1992-06-14" }
+{ "partkey": 132, "pid": 3, "shipdate": "1992-07-06" }
+{ "partkey": 133, "pid": 1, "shipdate": "1992-06-08" }
+{ "partkey": 133, "pid": 2, "shipdate": "1992-11-17" }
+{ "partkey": 133, "pid": 3, "shipdate": "1993-01-18" }
+{ "partkey": 134, "pid": 1, "shipdate": "1992-05-17" }
+{ "partkey": 134, "pid": 2, "shipdate": "1992-05-20" }
+{ "partkey": 134, "pid": 3, "shipdate": "1992-05-29" }
+{ "partkey": 135, "pid": 1, "shipdate": "1992-05-02" }
+{ "partkey": 135, "pid": 2, "shipdate": "1992-05-11" }
+{ "partkey": 135, "pid": 3, "shipdate": "1992-05-29" }
+{ "partkey": 136, "pid": 1, "shipdate": "1992-05-19" }
+{ "partkey": 136, "pid": 2, "shipdate": "1992-05-21" }
+{ "partkey": 136, "pid": 3, "shipdate": "1992-06-07" }
+{ "partkey": 137, "pid": 1, "shipdate": "1992-05-23" }
+{ "partkey": 137, "pid": 2, "shipdate": "1992-07-05" }
+{ "partkey": 137, "pid": 3, "shipdate": "1992-09-12" }
+{ "partkey": 138, "pid": 1, "shipdate": "1992-06-20" }
+{ "partkey": 138, "pid": 2, "shipdate": "1992-11-21" }
+{ "partkey": 138, "pid": 3, "shipdate": "1993-02-28" }
+{ "partkey": 139, "pid": 1, "shipdate": "1992-04-12" }
+{ "partkey": 139, "pid": 2, "shipdate": "1992-06-28" }
+{ "partkey": 139, "pid": 3, "shipdate": "1992-09-12" }
+{ "partkey": 140, "pid": 1, "shipdate": "1992-03-20" }
+{ "partkey": 140, "pid": 2, "shipdate": "1992-04-27" }
+{ "partkey": 140, "pid": 3, "shipdate": "1992-08-03" }
+{ "partkey": 141, "pid": 1, "shipdate": "1992-01-13" }
+{ "partkey": 141, "pid": 2, "shipdate": "1992-02-01" }
+{ "partkey": 141, "pid": 3, "shipdate": "1992-06-22" }
+{ "partkey": 142, "pid": 1, "shipdate": "1992-10-14" }
+{ "partkey": 142, "pid": 2, "shipdate": "1993-05-14" }
+{ "partkey": 142, "pid": 3, "shipdate": "1993-07-11" }
+{ "partkey": 143, "pid": 1, "shipdate": "1992-04-17" }
+{ "partkey": 143, "pid": 2, "shipdate": "1992-09-01" }
+{ "partkey": 143, "pid": 3, "shipdate": "1992-09-05" }
+{ "partkey": 144, "pid": 1, "shipdate": "1992-07-05" }
+{ "partkey": 144, "pid": 2, "shipdate": "1992-08-25" }
+{ "partkey": 144, "pid": 3, "shipdate": "1992-09-17" }
+{ "partkey": 145, "pid": 1, "shipdate": "1992-01-25" }
+{ "partkey": 145, "pid": 2, "shipdate": "1992-08-16" }
+{ "partkey": 145, "pid": 3, "shipdate": "1992-10-25" }
+{ "partkey": 146, "pid": 1, "shipdate": "1992-05-21" }
+{ "partkey": 146, "pid": 2, "shipdate": "1993-06-21" }
+{ "partkey": 146, "pid": 3, "shipdate": "1993-08-02" }
+{ "partkey": 147, "pid": 1, "shipdate": "1992-06-10" }
+{ "partkey": 147, "pid": 2, "shipdate": "1992-09-04" }
+{ "partkey": 147, "pid": 3, "shipdate": "1992-12-03" }
+{ "partkey": 148, "pid": 1, "shipdate": "1992-01-15" }
+{ "partkey": 148, "pid": 2, "shipdate": "1992-02-27" }
+{ "partkey": 148, "pid": 3, "shipdate": "1992-04-22" }
+{ "partkey": 149, "pid": 1, "shipdate": "1992-03-22" }
+{ "partkey": 149, "pid": 2, "shipdate": "1992-04-29" }
+{ "partkey": 149, "pid": 3, "shipdate": "1992-05-14" }
+{ "partkey": 150, "pid": 1, "shipdate": "1992-05-01" }
+{ "partkey": 150, "pid": 2, "shipdate": "1992-05-02" }
+{ "partkey": 150, "pid": 3, "shipdate": "1992-05-25" }
+{ "partkey": 151, "pid": 1, "shipdate": "1992-01-26" }
+{ "partkey": 151, "pid": 2, "shipdate": "1992-07-30" }
+{ "partkey": 151, "pid": 3, "shipdate": "1992-12-19" }
+{ "partkey": 152, "pid": 1, "shipdate": "1992-06-23" }
+{ "partkey": 152, "pid": 2, "shipdate": "1993-05-19" }
+{ "partkey": 152, "pid": 3, "shipdate": "1993-10-31" }
+{ "partkey": 153, "pid": 1, "shipdate": "1992-02-22" }
+{ "partkey": 153, "pid": 2, "shipdate": "1992-06-02" }
+{ "partkey": 153, "pid": 3, "shipdate": "1992-06-29" }
+{ "partkey": 154, "pid": 1, "shipdate": "1992-02-18" }
+{ "partkey": 154, "pid": 2, "shipdate": "1992-02-20" }
+{ "partkey": 154, "pid": 3, "shipdate": "1992-05-14" }
+{ "partkey": 155, "pid": 1, "shipdate": "1992-09-28" }
+{ "partkey": 155, "pid": 2, "shipdate": "1992-11-25" }
+{ "partkey": 155, "pid": 3, "shipdate": "1993-05-14" }
+{ "partkey": 156, "pid": 1, "shipdate": "1992-04-24" }
+{ "partkey": 156, "pid": 2, "shipdate": "1992-06-17" }
+{ "partkey": 156, "pid": 3, "shipdate": "1992-07-01" }
+{ "partkey": 157, "pid": 1, "shipdate": "1992-07-26" }
+{ "partkey": 157, "pid": 2, "shipdate": "1992-08-11" }
+{ "partkey": 157, "pid": 3, "shipdate": "1992-08-25" }
+{ "partkey": 158, "pid": 1, "shipdate": "1992-08-01" }
+{ "partkey": 158, "pid": 2, "shipdate": "1992-08-29" }
+{ "partkey": 158, "pid": 3, "shipdate": "1992-09-18" }
+{ "partkey": 159, "pid": 1, "shipdate": "1992-05-07" }
+{ "partkey": 159, "pid": 2, "shipdate": "1992-06-03" }
+{ "partkey": 159, "pid": 3, "shipdate": "1992-07-10" }
+{ "partkey": 160, "pid": 1, "shipdate": "1992-05-07" }
+{ "partkey": 160, "pid": 2, "shipdate": "1992-07-04" }
+{ "partkey": 160, "pid": 3, "shipdate": "1992-08-18" }
+{ "partkey": 161, "pid": 1, "shipdate": "1992-03-29" }
+{ "partkey": 161, "pid": 2, "shipdate": "1992-06-18" }
+{ "partkey": 161, "pid": 3, "shipdate": "1992-08-28" }
+{ "partkey": 162, "pid": 1, "shipdate": "1992-04-10" }
+{ "partkey": 162, "pid": 2, "shipdate": "1992-05-03" }
+{ "partkey": 162, "pid": 3, "shipdate": "1992-06-11" }
+{ "partkey": 163, "pid": 1, "shipdate": "1992-02-09" }
+{ "partkey": 163, "pid": 2, "shipdate": "1992-04-27" }
+{ "partkey": 163, "pid": 3, "shipdate": "1992-06-01" }
+{ "partkey": 164, "pid": 1, "shipdate": "1992-03-25" }
+{ "partkey": 164, "pid": 2, "shipdate": "1992-04-17" }
+{ "partkey": 164, "pid": 3, "shipdate": "1992-06-06" }
+{ "partkey": 165, "pid": 1, "shipdate": "1992-03-21" }
+{ "partkey": 165, "pid": 2, "shipdate": "1992-04-01" }
+{ "partkey": 165, "pid": 3, "shipdate": "1992-04-12" }
+{ "partkey": 166, "pid": 1, "shipdate": "1992-08-11" }
+{ "partkey": 166, "pid": 2, "shipdate": "1992-08-14" }
+{ "partkey": 166, "pid": 3, "shipdate": "1993-04-22" }
+{ "partkey": 167, "pid": 1, "shipdate": "1992-06-02" }
+{ "partkey": 167, "pid": 2, "shipdate": "1993-01-31" }
+{ "partkey": 167, "pid": 3, "shipdate": "1993-02-15" }
+{ "partkey": 168, "pid": 1, "shipdate": "1992-05-06" }
+{ "partkey": 168, "pid": 2, "shipdate": "1992-07-20" }
+{ "partkey": 168, "pid": 3, "shipdate": "1992-10-07" }
+{ "partkey": 169, "pid": 1, "shipdate": "1992-03-31" }
+{ "partkey": 169, "pid": 2, "shipdate": "1992-06-05" }
+{ "partkey": 169, "pid": 3, "shipdate": "1992-06-07" }
+{ "partkey": 170, "pid": 1, "shipdate": "1992-08-07" }
+{ "partkey": 170, "pid": 2, "shipdate": "1993-03-17" }
+{ "partkey": 170, "pid": 3, "shipdate": "1993-06-19" }
+{ "partkey": 171, "pid": 1, "shipdate": "1992-11-09" }
+{ "partkey": 171, "pid": 2, "shipdate": "1994-01-22" }
+{ "partkey": 171, "pid": 3, "shipdate": "1995-01-02" }
+{ "partkey": 172, "pid": 1, "shipdate": "1992-09-06" }
+{ "partkey": 172, "pid": 2, "shipdate": "1993-05-01" }
+{ "partkey": 172, "pid": 3, "shipdate": "1993-06-16" }
+{ "partkey": 173, "pid": 1, "shipdate": "1992-06-17" }
+{ "partkey": 173, "pid": 2, "shipdate": "1992-09-15" }
+{ "partkey": 173, "pid": 3, "shipdate": "1992-09-30" }
+{ "partkey": 174, "pid": 1, "shipdate": "1992-06-25" }
+{ "partkey": 174, "pid": 2, "shipdate": "1992-11-02" }
+{ "partkey": 174, "pid": 3, "shipdate": "1992-12-02" }
+{ "partkey": 175, "pid": 1, "shipdate": "1992-10-09" }
+{ "partkey": 175, "pid": 2, "shipdate": "1992-11-09" }
+{ "partkey": 175, "pid": 3, "shipdate": "1992-11-10" }
+{ "partkey": 176, "pid": 1, "shipdate": "1992-02-01" }
+{ "partkey": 176, "pid": 2, "shipdate": "1992-04-28" }
+{ "partkey": 176, "pid": 3, "shipdate": "1992-09-24" }
+{ "partkey": 177, "pid": 1, "shipdate": "1992-04-05" }
+{ "partkey": 177, "pid": 2, "shipdate": "1992-12-25" }
+{ "partkey": 177, "pid": 3, "shipdate": "1993-01-16" }
+{ "partkey": 178, "pid": 1, "shipdate": "1992-05-23" }
+{ "partkey": 178, "pid": 2, "shipdate": "1992-08-18" }
+{ "partkey": 178, "pid": 3, "shipdate": "1992-11-02" }
+{ "partkey": 179, "pid": 1, "shipdate": "1992-05-30" }
+{ "partkey": 179, "pid": 2, "shipdate": "1992-06-02" }
+{ "partkey": 179, "pid": 3, "shipdate": "1992-09-20" }
+{ "partkey": 180, "pid": 1, "shipdate": "1992-03-07" }
+{ "partkey": 180, "pid": 2, "shipdate": "1992-05-23" }
+{ "partkey": 180, "pid": 3, "shipdate": "1992-06-21" }
+{ "partkey": 181, "pid": 1, "shipdate": "1992-07-01" }
+{ "partkey": 181, "pid": 2, "shipdate": "1992-11-04" }
+{ "partkey": 181, "pid": 3, "shipdate": "1992-12-14" }
+{ "partkey": 182, "pid": 1, "shipdate": "1992-03-02" }
+{ "partkey": 182, "pid": 2, "shipdate": "1992-04-02" }
+{ "partkey": 182, "pid": 3, "shipdate": "1992-04-28" }
+{ "partkey": 183, "pid": 1, "shipdate": "1992-04-24" }
+{ "partkey": 183, "pid": 2, "shipdate": "1992-10-24" }
+{ "partkey": 183, "pid": 3, "shipdate": "1993-01-08" }
+{ "partkey": 184, "pid": 1, "shipdate": "1992-04-12" }
+{ "partkey": 184, "pid": 2, "shipdate": "1992-04-12" }
+{ "partkey": 184, "pid": 3, "shipdate": "1992-04-30" }
+{ "partkey": 185, "pid": 1, "shipdate": "1992-04-30" }
+{ "partkey": 185, "pid": 2, "shipdate": "1992-06-20" }
+{ "partkey": 185, "pid": 3, "shipdate": "1992-07-23" }
+{ "partkey": 186, "pid": 1, "shipdate": "1992-07-26" }
+{ "partkey": 186, "pid": 2, "shipdate": "1992-11-25" }
+{ "partkey": 186, "pid": 3, "shipdate": "1992-11-27" }
+{ "partkey": 187, "pid": 1, "shipdate": "1992-04-01" }
+{ "partkey": 187, "pid": 2, "shipdate": "1992-05-30" }
+{ "partkey": 187, "pid": 3, "shipdate": "1992-06-01" }
+{ "partkey": 188, "pid": 1, "shipdate": "1992-09-15" }
+{ "partkey": 188, "pid": 2, "shipdate": "1993-04-08" }
+{ "partkey": 188, "pid": 3, "shipdate": "1993-05-03" }
+{ "partkey": 189, "pid": 1, "shipdate": "1992-06-16" }
+{ "partkey": 189, "pid": 2, "shipdate": "1992-06-20" }
+{ "partkey": 189, "pid": 3, "shipdate": "1992-07-20" }
+{ "partkey": 190, "pid": 1, "shipdate": "1992-04-14" }
+{ "partkey": 190, "pid": 2, "shipdate": "1992-07-17" }
+{ "partkey": 190, "pid": 3, "shipdate": "1992-10-12" }
+{ "partkey": 191, "pid": 1, "shipdate": "1992-07-31" }
+{ "partkey": 191, "pid": 2, "shipdate": "1992-08-29" }
+{ "partkey": 191, "pid": 3, "shipdate": "1992-09-22" }
+{ "partkey": 192, "pid": 1, "shipdate": "1992-02-19" }
+{ "partkey": 192, "pid": 2, "shipdate": "1992-08-10" }
+{ "partkey": 192, "pid": 3, "shipdate": "1992-09-02" }
+{ "partkey": 193, "pid": 1, "shipdate": "1992-05-05" }
+{ "partkey": 193, "pid": 2, "shipdate": "1992-08-21" }
+{ "partkey": 193, "pid": 3, "shipdate": "1993-02-12" }
+{ "partkey": 194, "pid": 1, "shipdate": "1992-02-14" }
+{ "partkey": 194, "pid": 2, "shipdate": "1992-06-20" }
+{ "partkey": 194, "pid": 3, "shipdate": "1992-12-15" }
+{ "partkey": 195, "pid": 1, "shipdate": "1992-04-10" }
+{ "partkey": 195, "pid": 2, "shipdate": "1992-05-07" }
+{ "partkey": 195, "pid": 3, "shipdate": "1992-05-28" }
+{ "partkey": 196, "pid": 1, "shipdate": "1992-03-02" }
+{ "partkey": 196, "pid": 2, "shipdate": "1992-03-04" }
+{ "partkey": 196, "pid": 3, "shipdate": "1992-06-11" }
+{ "partkey": 197, "pid": 1, "shipdate": "1993-08-22" }
+{ "partkey": 197, "pid": 2, "shipdate": "1994-02-24" }
+{ "partkey": 197, "pid": 3, "shipdate": "1994-03-03" }
+{ "partkey": 198, "pid": 1, "shipdate": "1992-04-21" }
+{ "partkey": 198, "pid": 2, "shipdate": "1992-09-12" }
+{ "partkey": 198, "pid": 3, "shipdate": "1992-12-27" }
+{ "partkey": 199, "pid": 1, "shipdate": "1992-03-14" }
+{ "partkey": 199, "pid": 2, "shipdate": "1992-08-02" }
+{ "partkey": 199, "pid": 3, "shipdate": "1992-11-20" }
+{ "partkey": 200, "pid": 1, "shipdate": "1992-04-19" }
+{ "partkey": 200, "pid": 2, "shipdate": "1993-01-06" }
+{ "partkey": 200, "pid": 3, "shipdate": "1993-10-17" }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.1.ast
deleted file mode 100644
index 17dc8b5..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.1.ast
+++ /dev/null
@@ -1,22 +0,0 @@
-DataverseUse test
-TypeDecl LineItemType [
-  closed RecordType {
-    l_orderkey : bigint,
-    l_partkey : bigint,
-    l_suppkey : bigint,
-    l_linenumber : bigint,
-    l_quantity : double,
-    l_extendedprice : double,
-    l_discount : double,
-    l_tax : double,
-    l_returnflag : string,
-    l_linestatus : string,
-    l_shipdate : string,
-    l_commitdate : string,
-    l_receiptdate : string,
-    l_shipinstruct : string,
-    l_shipmode : string,
-    l_comment : string
-  }
-]
-DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.2.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.2.ast
deleted file mode 100644
index 916a59e..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.2.ast
+++ /dev/null
@@ -1 +0,0 @@
-DataverseUse test

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
deleted file mode 100644
index cd20331..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
+++ /dev/null
@@ -1,111 +0,0 @@
-DataverseUse test
-Query:
-SELECT ELEMENT [
-RecordConstructor [
-  (
-    LiteralExpr [STRING] [partkey]
-    :
-    FieldAccessor [
-      Variable [ Name=$gen0 ]
-      Field=partkey
-    ]
-  )
-  (
-    LiteralExpr [STRING] [pid]
-    :
-    Variable [ Name=$p ]
-  )
-  (
-    LiteralExpr [STRING] [shipdate]
-    :
-    FieldAccessor [
-      Variable [ Name=$j ]
-      Field=l_shipdate
-    ]
-  )
-]
-]
-FROM [  (
-    SELECT ELEMENT [
-    RecordConstructor [
-      (
-        LiteralExpr [STRING] [partkey]
-        :
-        FieldAccessor [
-          Variable [ Name=$i ]
-          Field=l_partkey
-        ]
-      )
-      (
-        LiteralExpr [STRING] [i]
-        :
-        (
-          SELECT ELEMENT [
-          FieldAccessor [
-            Variable [ Name=$x ]
-            Field=i
-          ]
-          ]
-          FROM [            Variable [ Name=$g ]
-            AS Variable [ Name=$x ]
-          ]
-          Orderby
-            FieldAccessor [
-              FieldAccessor [
-                Variable [ Name=$x ]
-                Field=i
-              ]
-              Field=l_shipdate
-            ]
-            ASC
-
-        )
-      )
-    ]
-    ]
-    FROM [      FunctionCall Metadata.dataset@1[
-        LiteralExpr [STRING] [LineItem]
-      ]
-      AS Variable [ Name=$i ]
-    ]
-    Groupby
-      Variable [ Name=$l_partkey ]
-      :=
-      FieldAccessor [
-        Variable [ Name=$i ]
-        Field=l_partkey
-      ]
-      GROUP AS Variable [ Name=$g ]
-      (
-        i:=Variable [ Name=$i ]
-      )
-
-  )
-  AS Variable [ Name=$gen0 ]
-,
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=i
-  ]
-  AS Variable [ Name=$j ]
- AT 
-Variable [ Name=$p ]
-]
-Where
-  OperatorExpr [
-    Variable [ Name=$p ]
-    <
-    LiteralExpr [LONG] [4]
-  ]
-Orderby
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=partkey
-  ]
-  ASC
-  FieldAccessor [
-    Variable [ Name=$j ]
-    Field=l_shipdate
-  ]
-  ASC
-

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
deleted file mode 100644
index cd20331..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
+++ /dev/null
@@ -1,111 +0,0 @@
-DataverseUse test
-Query:
-SELECT ELEMENT [
-RecordConstructor [
-  (
-    LiteralExpr [STRING] [partkey]
-    :
-    FieldAccessor [
-      Variable [ Name=$gen0 ]
-      Field=partkey
-    ]
-  )
-  (
-    LiteralExpr [STRING] [pid]
-    :
-    Variable [ Name=$p ]
-  )
-  (
-    LiteralExpr [STRING] [shipdate]
-    :
-    FieldAccessor [
-      Variable [ Name=$j ]
-      Field=l_shipdate
-    ]
-  )
-]
-]
-FROM [  (
-    SELECT ELEMENT [
-    RecordConstructor [
-      (
-        LiteralExpr [STRING] [partkey]
-        :
-        FieldAccessor [
-          Variable [ Name=$i ]
-          Field=l_partkey
-        ]
-      )
-      (
-        LiteralExpr [STRING] [i]
-        :
-        (
-          SELECT ELEMENT [
-          FieldAccessor [
-            Variable [ Name=$x ]
-            Field=i
-          ]
-          ]
-          FROM [            Variable [ Name=$g ]
-            AS Variable [ Name=$x ]
-          ]
-          Orderby
-            FieldAccessor [
-              FieldAccessor [
-                Variable [ Name=$x ]
-                Field=i
-              ]
-              Field=l_shipdate
-            ]
-            ASC
-
-        )
-      )
-    ]
-    ]
-    FROM [      FunctionCall Metadata.dataset@1[
-        LiteralExpr [STRING] [LineItem]
-      ]
-      AS Variable [ Name=$i ]
-    ]
-    Groupby
-      Variable [ Name=$l_partkey ]
-      :=
-      FieldAccessor [
-        Variable [ Name=$i ]
-        Field=l_partkey
-      ]
-      GROUP AS Variable [ Name=$g ]
-      (
-        i:=Variable [ Name=$i ]
-      )
-
-  )
-  AS Variable [ Name=$gen0 ]
-,
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=i
-  ]
-  AS Variable [ Name=$j ]
- AT 
-Variable [ Name=$p ]
-]
-Where
-  OperatorExpr [
-    Variable [ Name=$p ]
-    <
-    LiteralExpr [LONG] [4]
-  ]
-Orderby
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=partkey
-  ]
-  ASC
-  FieldAccessor [
-    Variable [ Name=$j ]
-    Field=l_shipdate
-  ]
-  ASC
-

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
deleted file mode 100644
index cd20331..0000000
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
+++ /dev/null
@@ -1,111 +0,0 @@
-DataverseUse test
-Query:
-SELECT ELEMENT [
-RecordConstructor [
-  (
-    LiteralExpr [STRING] [partkey]
-    :
-    FieldAccessor [
-      Variable [ Name=$gen0 ]
-      Field=partkey
-    ]
-  )
-  (
-    LiteralExpr [STRING] [pid]
-    :
-    Variable [ Name=$p ]
-  )
-  (
-    LiteralExpr [STRING] [shipdate]
-    :
-    FieldAccessor [
-      Variable [ Name=$j ]
-      Field=l_shipdate
-    ]
-  )
-]
-]
-FROM [  (
-    SELECT ELEMENT [
-    RecordConstructor [
-      (
-        LiteralExpr [STRING] [partkey]
-        :
-        FieldAccessor [
-          Variable [ Name=$i ]
-          Field=l_partkey
-        ]
-      )
-      (
-        LiteralExpr [STRING] [i]
-        :
-        (
-          SELECT ELEMENT [
-          FieldAccessor [
-            Variable [ Name=$x ]
-            Field=i
-          ]
-          ]
-          FROM [            Variable [ Name=$g ]
-            AS Variable [ Name=$x ]
-          ]
-          Orderby
-            FieldAccessor [
-              FieldAccessor [
-                Variable [ Name=$x ]
-                Field=i
-              ]
-              Field=l_shipdate
-            ]
-            ASC
-
-        )
-      )
-    ]
-    ]
-    FROM [      FunctionCall Metadata.dataset@1[
-        LiteralExpr [STRING] [LineItem]
-      ]
-      AS Variable [ Name=$i ]
-    ]
-    Groupby
-      Variable [ Name=$l_partkey ]
-      :=
-      FieldAccessor [
-        Variable [ Name=$i ]
-        Field=l_partkey
-      ]
-      GROUP AS Variable [ Name=$g ]
-      (
-        i:=Variable [ Name=$i ]
-      )
-
-  )
-  AS Variable [ Name=$gen0 ]
-,
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=i
-  ]
-  AS Variable [ Name=$j ]
- AT 
-Variable [ Name=$p ]
-]
-Where
-  OperatorExpr [
-    Variable [ Name=$p ]
-    <
-    LiteralExpr [LONG] [4]
-  ]
-Orderby
-  FieldAccessor [
-    Variable [ Name=$gen0 ]
-    Field=partkey
-  ]
-  ASC
-  FieldAccessor [
-    Variable [ Name=$j ]
-    Field=l_shipdate
-  ]
-  ASC
-

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
index a76ecbc..0d8da65 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
@@ -21,6 +21,29 @@
 
 ]>
 <test-suite xmlns="urn:xml.testframework.asterix.apache.org" ResultOffsetPath="results" QueryOffsetPath="queries_sqlpp" QueryFileExtension=".sqlpp">
+  <test-group name="async-deferred">
+    <test-case FilePath="async-deferred">
+      <compilation-unit name="async-failed">
+        <output-dir compare="Text">async-failed</output-dir>
+        <expected-error>Error in processing tuple 0</expected-error>
+      </compilation-unit>
+    </test-case>
+    <test-case FilePath="async-deferred">
+      <compilation-unit name="deferred">
+        <output-dir compare="Text">deferred</output-dir>
+      </compilation-unit>
+    </test-case>
+    <test-case FilePath="async-deferred">
+      <compilation-unit name="async">
+        <output-dir compare="Text">async</output-dir>
+      </compilation-unit>
+    </test-case>
+    <test-case FilePath="async-deferred">
+      <compilation-unit name="async-running">
+        <output-dir compare="Text">async-running</output-dir>
+      </compilation-unit>
+    </test-case>
+  </test-group>
   <test-group name="flwor">
     <test-case FilePath="flwor">
       <compilation-unit name="at00">

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp_parser.xml
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp_parser.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp_parser.xml
index df7e5a0..fcd1a70 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp_parser.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp_parser.xml
@@ -28,11 +28,6 @@
              QueryFileExtension=".sqlpp">
   <test-group name="flwor">
     <test-case FilePath="flwor">
-      <compilation-unit name="at00">
-        <output-dir compare="AST">at00</output-dir>
-      </compilation-unit>
-    </test-case>
-    <test-case FilePath="flwor">
       <compilation-unit name="at01">
         <output-dir compare="AST">at01</output-dir>
       </compilation-unit>

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/392bbbc0/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/utils/JobUtils.java
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/utils/JobUtils.java b/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/utils/JobUtils.java
index 9fb6a31..41f9e67 100644
--- a/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/utils/JobUtils.java
+++ b/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/utils/JobUtils.java
@@ -32,23 +32,11 @@ public class JobUtils {
 
     public static JobId runJob(IHyracksClientConnection hcc, JobSpecification spec, boolean waitForCompletion)
             throws Exception {
-        JobId[] jobIds = executeJobArray(hcc, new Job[] { new Job(spec) }, waitForCompletion);
-        return jobIds[0];
-    }
-
-    public static JobId[] executeJobArray(IHyracksClientConnection hcc, Job[] jobs, boolean waitForCompletion)
-            throws Exception {
-        JobId[] startedJobIds = new JobId[jobs.length];
-        for (int i = 0; i < jobs.length; i++) {
-            JobSpecification spec = jobs[i].getJobSpec();
-            spec.setMaxReattempts(0);
-            JobId jobId = hcc.startJob(spec);
-            startedJobIds[i] = jobId;
-            if (waitForCompletion) {
-                hcc.waitForCompletion(jobId);
-            }
+        spec.setMaxReattempts(0);
+        final JobId jobId = hcc.startJob(spec);
+        if (waitForCompletion) {
+            hcc.waitForCompletion(jobId);
         }
-        return startedJobIds;
+        return jobId;
     }
-
 }


Mime
View raw message