http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d76a0c0f/asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/gby_inline/gby_inline.1.adm
----------------------------------------------------------------------
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/gby_inline/gby_inline.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/gby_inline/gby_inline.1.adm
index 9ad1ffa..2459704 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/gby_inline/gby_inline.1.adm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/gby_inline/gby_inline.1.adm
@@ -1,150 +1,150 @@
-{ "customer_name": 1i32, "orders": [ ] }
-{ "customer_name": 2i32, "orders": [ ] }
-{ "customer_name": 3i32, "orders": [ ] }
-{ "customer_name": 4i32, "orders": [ ] }
-{ "customer_name": 5i32, "orders": [ ] }
-{ "customer_name": 6i32, "orders": [ ] }
-{ "customer_name": 7i32, "orders": [ ] }
-{ "customer_name": 8i32, "orders": [ ] }
-{ "customer_name": 9i32, "orders": [ ] }
-{ "customer_name": 10i32, "orders": [ { "o_orderkey": 227i32, "o_custkey":
10i32, "o_orderstatus": "O", "o_totalprice": 46076.46d, "o_orderdate":
"1995-11-10", "o_orderpriority": "5-LOW", "o_clerk": "Clerk#000000919",
"o_shippriority": 0i32, "o_comment": " express instructions. slyly regul" }, {
"o_orderkey": 517i32, "o_custkey": 10i32, "o_orderstatus": "O", "o_totalprice":
82197.79d, "o_orderdate": "1997-04-07", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000359", "o_shippriority": 0i32, "o_comment": "slyly pending deposits
cajole quickly packages. furiou" }, { "o_orderkey": 902i32, "o_custkey": 10i32,
"o_orderstatus": "F", "o_totalprice": 37348.62d, "o_orderdate": "1994-07-27",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000811",
"o_shippriority": 0i32, "o_comment": "yly final requests over the furiously
regula" }, { "o_orderkey": 1218i32, "o_custkey": 10i32, "o_orderstatus": "F",
"o_totalprice": 99834.47d, "o_orderdate": "1994-06-20", "o_orderpriority":
"4-NOT
SPECIFIED", "o_clerk": "Clerk#000000994", "o_shippriority": 0i32,
"o_comment": "s cajole. special, silent deposits about the theo" }, {
"o_orderkey": 1222i32, "o_custkey": 10i32, "o_orderstatus": "F",
"o_totalprice": 47623.94d, "o_orderdate": "1993-02-05", "o_orderpriority":
"3-MEDIUM", "o_clerk": "Clerk#000000811", "o_shippriority": 0i32, "o_comment":
"theodolites use quickly even accounts. carefully final asympto" }, {
"o_orderkey": 1223i32, "o_custkey": 10i32, "o_orderstatus": "O",
"o_totalprice": 26714.67d, "o_orderdate": "1996-05-25", "o_orderpriority":
"4-NOT SPECIFIED", "o_clerk": "Clerk#000000238", "o_shippriority": 0i32,
"o_comment": "posits was blithely fr" }, { "o_orderkey": 1860i32, "o_custkey":
10i32, "o_orderstatus": "O", "o_totalprice": 9103.4d, "o_orderdate":
"1996-04-04", "o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000556",
"o_shippriority": 0i32, "o_comment": "osits. quickly bold deposits according to
" }, { "o_orderkey": 1890i32, "o_custkey": 10i32, "o_or
derstatus": "O", "o_totalprice": 202364.58d, "o_orderdate": "1996-12-18",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000627",
"o_shippriority": 0i32, "o_comment": "romise final, regular deposits. regular
fox" }, { "o_orderkey": 2562i32, "o_custkey": 10i32, "o_orderstatus": "F",
"o_totalprice": 136360.37d, "o_orderdate": "1992-08-01", "o_orderpriority":
"1-URGENT", "o_clerk": "Clerk#000000467", "o_shippriority": 0i32, "o_comment":
"elets. pending dolphins promise slyly. bo" }, { "o_orderkey": 3204i32,
"o_custkey": 10i32, "o_orderstatus": "F", "o_totalprice": 41573.42d,
"o_orderdate": "1992-12-26", "o_orderpriority": "1-URGENT", "o_clerk":
"Clerk#000000693", "o_shippriority": 0i32, "o_comment": "ess somas cajole
slyly. pending accounts cajole" }, { "o_orderkey": 3428i32, "o_custkey": 10i32,
"o_orderstatus": "O", "o_totalprice": 88047.04d, "o_orderdate": "1996-04-07",
"o_orderpriority": "5-LOW", "o_clerk": "Clerk#000000953", "o_shippriority":
0i32, "o_comment": "lar exc
uses. slyly pending ideas detect p" }, { "o_orderkey": 3618i32, "o_custkey":
10i32, "o_orderstatus": "O", "o_totalprice": 136954.81d, "o_orderdate":
"1997-12-13", "o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000894",
"o_shippriority": 0i32, "o_comment": ". ideas run carefully. thin, pending " },
{ "o_orderkey": 3751i32, "o_custkey": 10i32, "o_orderstatus": "F",
"o_totalprice": 202917.72d, "o_orderdate": "1994-04-27", "o_orderpriority":
"4-NOT SPECIFIED", "o_clerk": "Clerk#000000925", "o_shippriority": 0i32,
"o_comment": "sheaves. express, unusual t" }, { "o_orderkey": 3843i32,
"o_custkey": 10i32, "o_orderstatus": "O", "o_totalprice": 34035.17d,
"o_orderdate": "1997-01-04", "o_orderpriority": "4-NOT SPECIFIED", "o_clerk":
"Clerk#000000693", "o_shippriority": 0i32, "o_comment": "eodolites; slyly
unusual accounts nag boldly " }, { "o_orderkey": 3911i32, "o_custkey": 10i32,
"o_orderstatus": "P", "o_totalprice": 35019.95d, "o_orderdate": "1995-03-17",
"o_orderpriority": "4-NOT SPE
CIFIED", "o_clerk": "Clerk#000000818", "o_shippriority": 0i32, "o_comment":
"he fluffily final forges haggle slyly according to the blithely" }, {
"o_orderkey": 4032i32, "o_custkey": 10i32, "o_orderstatus": "O",
"o_totalprice": 62497.51d, "o_orderdate": "1998-02-26", "o_orderpriority":
"3-MEDIUM", "o_clerk": "Clerk#000000686", "o_shippriority": 0i32, "o_comment":
"iresias sleep slyly regular ideas. quickly unusual" }, { "o_orderkey":
4097i32, "o_custkey": 10i32, "o_orderstatus": "O", "o_totalprice": 134308.04d,
"o_orderdate": "1996-05-24", "o_orderpriority": "1-URGENT", "o_clerk":
"Clerk#000000475", "o_shippriority": 0i32, "o_comment": "ickly under the even
accounts. even packages after the furiously express" }, { "o_orderkey":
4388i32, "o_custkey": 10i32, "o_orderstatus": "O", "o_totalprice": 69668.22d,
"o_orderdate": "1996-03-28", "o_orderpriority": "2-HIGH", "o_clerk":
"Clerk#000000715", "o_shippriority": 0i32, "o_comment": "ts wake against the
carefully final accounts. sly" }, {
"o_orderkey": 4421i32, "o_custkey": 10i32, "o_orderstatus": "O",
"o_totalprice": 258779.02d, "o_orderdate": "1997-04-04", "o_orderpriority":
"3-MEDIUM", "o_clerk": "Clerk#000000246", "o_shippriority": 0i32, "o_comment":
"t the pending warhorses. express waters a" }, { "o_orderkey": 4449i32,
"o_custkey": 10i32, "o_orderstatus": "O", "o_totalprice": 48206.14d,
"o_orderdate": "1998-02-08", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000035", "o_shippriority": 0i32, "o_comment": "ourts are carefully
even deposits. pending " }, { "o_orderkey": 4867i32, "o_custkey": 10i32,
"o_orderstatus": "F", "o_totalprice": 9741.03d, "o_orderdate": "1992-05-21",
"o_orderpriority": "1-URGENT", "o_clerk": "Clerk#000000891", "o_shippriority":
0i32, "o_comment": "ss the slyly regular dependencies. fluffily regular
deposits within the car" }, { "o_orderkey": 5123i32, "o_custkey": 10i32,
"o_orderstatus": "O", "o_totalprice": 11850.45d, "o_orderdate": "1998-02-10",
"o_orderpriority": "1-URGENT", "o_cler
k": "Clerk#000000776", "o_shippriority": 0i32, "o_comment": "ic requests.
furiously ironic packages grow above the express, ironic inst" }, {
"o_orderkey": 5220i32, "o_custkey": 10i32, "o_orderstatus": "F",
"o_totalprice": 24844.39d, "o_orderdate": "1992-07-30", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000051", "o_shippriority": 0i32, "o_comment": "
final packages. ideas detect slyly around" } ] }
-{ "customer_name": 11i32, "orders": [ ] }
-{ "customer_name": 12i32, "orders": [ ] }
-{ "customer_name": 13i32, "orders": [ ] }
-{ "customer_name": 14i32, "orders": [ ] }
-{ "customer_name": 15i32, "orders": [ ] }
-{ "customer_name": 16i32, "orders": [ ] }
-{ "customer_name": 17i32, "orders": [ ] }
-{ "customer_name": 18i32, "orders": [ ] }
-{ "customer_name": 19i32, "orders": [ ] }
-{ "customer_name": 20i32, "orders": [ ] }
-{ "customer_name": 21i32, "orders": [ ] }
-{ "customer_name": 22i32, "orders": [ ] }
-{ "customer_name": 23i32, "orders": [ ] }
-{ "customer_name": 24i32, "orders": [ ] }
-{ "customer_name": 25i32, "orders": [ ] }
-{ "customer_name": 26i32, "orders": [ ] }
-{ "customer_name": 27i32, "orders": [ ] }
-{ "customer_name": 28i32, "orders": [ ] }
-{ "customer_name": 29i32, "orders": [ ] }
-{ "customer_name": 30i32, "orders": [ ] }
-{ "customer_name": 31i32, "orders": [ ] }
-{ "customer_name": 32i32, "orders": [ ] }
-{ "customer_name": 33i32, "orders": [ ] }
-{ "customer_name": 34i32, "orders": [ ] }
-{ "customer_name": 35i32, "orders": [ ] }
-{ "customer_name": 36i32, "orders": [ ] }
-{ "customer_name": 37i32, "orders": [ ] }
-{ "customer_name": 38i32, "orders": [ ] }
-{ "customer_name": 39i32, "orders": [ ] }
-{ "customer_name": 40i32, "orders": [ ] }
-{ "customer_name": 41i32, "orders": [ ] }
-{ "customer_name": 42i32, "orders": [ ] }
-{ "customer_name": 43i32, "orders": [ ] }
-{ "customer_name": 44i32, "orders": [ ] }
-{ "customer_name": 45i32, "orders": [ ] }
-{ "customer_name": 46i32, "orders": [ ] }
-{ "customer_name": 47i32, "orders": [ ] }
-{ "customer_name": 48i32, "orders": [ ] }
-{ "customer_name": 49i32, "orders": [ ] }
-{ "customer_name": 50i32, "orders": [ ] }
-{ "customer_name": 51i32, "orders": [ ] }
-{ "customer_name": 52i32, "orders": [ ] }
-{ "customer_name": 53i32, "orders": [ ] }
-{ "customer_name": 54i32, "orders": [ ] }
-{ "customer_name": 55i32, "orders": [ ] }
-{ "customer_name": 56i32, "orders": [ ] }
-{ "customer_name": 57i32, "orders": [ ] }
-{ "customer_name": 58i32, "orders": [ ] }
-{ "customer_name": 59i32, "orders": [ ] }
-{ "customer_name": 60i32, "orders": [ ] }
-{ "customer_name": 61i32, "orders": [ ] }
-{ "customer_name": 62i32, "orders": [ ] }
-{ "customer_name": 63i32, "orders": [ ] }
-{ "customer_name": 64i32, "orders": [ ] }
-{ "customer_name": 65i32, "orders": [ ] }
-{ "customer_name": 66i32, "orders": [ ] }
-{ "customer_name": 67i32, "orders": [ ] }
-{ "customer_name": 68i32, "orders": [ ] }
-{ "customer_name": 69i32, "orders": [ ] }
-{ "customer_name": 70i32, "orders": [ ] }
-{ "customer_name": 71i32, "orders": [ ] }
-{ "customer_name": 72i32, "orders": [ ] }
-{ "customer_name": 73i32, "orders": [ ] }
-{ "customer_name": 74i32, "orders": [ ] }
-{ "customer_name": 75i32, "orders": [ ] }
-{ "customer_name": 76i32, "orders": [ ] }
-{ "customer_name": 77i32, "orders": [ ] }
-{ "customer_name": 78i32, "orders": [ ] }
-{ "customer_name": 79i32, "orders": [ ] }
-{ "customer_name": 80i32, "orders": [ ] }
-{ "customer_name": 81i32, "orders": [ ] }
-{ "customer_name": 82i32, "orders": [ ] }
-{ "customer_name": 83i32, "orders": [ ] }
-{ "customer_name": 84i32, "orders": [ ] }
-{ "customer_name": 85i32, "orders": [ { "o_orderkey": 69i32, "o_custkey":
85i32, "o_orderstatus": "F", "o_totalprice": 162176.23d, "o_orderdate":
"1994-06-04", "o_orderpriority": "4-NOT SPECIFIED", "o_clerk":
"Clerk#000000330", "o_shippriority": 0i32, "o_comment": " depths atop the slyly
thin deposits detect among the furiously silent accou" }, { "o_orderkey":
704i32, "o_custkey": 85i32, "o_orderstatus": "O", "o_totalprice": 56210.26d,
"o_orderdate": "1996-11-21", "o_orderpriority": "3-MEDIUM", "o_clerk":
"Clerk#000000682", "o_shippriority": 0i32, "o_comment": "blithely pending
platelets wake alongside of the final, iron" }, { "o_orderkey": 1699i32,
"o_custkey": 85i32, "o_orderstatus": "F", "o_totalprice": 66408.29d,
"o_orderdate": "1993-12-30", "o_orderpriority": "1-URGENT", "o_clerk":
"Clerk#000000125", "o_shippriority": 0i32, "o_comment": "jole blithely.
furiously un" }, { "o_orderkey": 2437i32, "o_custkey": 85i32, "o_orderstatus":
"F", "o_totalprice": 143411.69d, "o_orderdate":
"1993-04-21", "o_orderpriority": "4-NOT SPECIFIED", "o_clerk":
"Clerk#000000578", "o_shippriority": 0i32, "o_comment": ". theodolites wake
slyly-- ironic, pending platelets above the carefully exp" }, { "o_orderkey":
2630i32, "o_custkey": 85i32, "o_orderstatus": "F", "o_totalprice": 127132.51d,
"o_orderdate": "1992-10-24", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000712", "o_shippriority": 0i32, "o_comment": "inal theodolites.
ironic instructions s" }, { "o_orderkey": 2982i32, "o_custkey": 85i32,
"o_orderstatus": "F", "o_totalprice": 55582.94d, "o_orderdate": "1995-03-19",
"o_orderpriority": "2-HIGH", "o_clerk": "Clerk#000000402", "o_shippriority":
0i32, "o_comment": "lyly. express theodolites affix slyly after the slyly
speci" }, { "o_orderkey": 3108i32, "o_custkey": 85i32, "o_orderstatus": "F",
"o_totalprice": 63278.0d, "o_orderdate": "1993-08-05", "o_orderpriority":
"1-URGENT", "o_clerk": "Clerk#000000574", "o_shippriority": 0i32, "o_comment":
"s packages haggle furiously
am" }, { "o_orderkey": 3776i32, "o_custkey": 85i32, "o_orderstatus": "F",
"o_totalprice": 150349.92d, "o_orderdate": "1992-11-20", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000698", "o_shippriority": 0i32, "o_comment":
"efully even platelets slee" }, { "o_orderkey": 4480i32, "o_custkey": 85i32,
"o_orderstatus": "F", "o_totalprice": 28658.26d, "o_orderdate": "1994-03-31",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000534",
"o_shippriority": 0i32, "o_comment": "press, bold deposits boost blit" }, {
"o_orderkey": 4513i32, "o_custkey": 85i32, "o_orderstatus": "O",
"o_totalprice": 119820.38d, "o_orderdate": "1996-03-15", "o_orderpriority":
"5-LOW", "o_clerk": "Clerk#000000154", "o_shippriority": 0i32, "o_comment":
"ests. final, final ideas" }, { "o_orderkey": 4708i32, "o_custkey": 85i32,
"o_orderstatus": "F", "o_totalprice": 56998.36d, "o_orderdate": "1994-10-01",
"o_orderpriority": "1-URGENT", "o_clerk": "Clerk#000000383", "o_shippriority":
0i32, "o_comment": "l
y thinly even accounts. unusu" }, { "o_orderkey": 4865i32, "o_custkey": 85i32,
"o_orderstatus": "O", "o_totalprice": 162113.46d, "o_orderdate": "1997-06-07",
"o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000418", "o_shippriority":
0i32, "o_comment": "sits boost stealthily above the bl" }, { "o_orderkey":
4896i32, "o_custkey": 85i32, "o_orderstatus": "F", "o_totalprice": 93206.35d,
"o_orderdate": "1992-08-22", "o_orderpriority": "1-URGENT", "o_clerk":
"Clerk#000000622", "o_shippriority": 0i32, "o_comment": "sly pending deposits.
final accounts boost above the sly, even" }, { "o_orderkey": 4999i32,
"o_custkey": 85i32, "o_orderstatus": "F", "o_totalprice": 98643.17d,
"o_orderdate": "1993-06-26", "o_orderpriority": "2-HIGH", "o_clerk":
"Clerk#000000504", "o_shippriority": 0i32, "o_comment": " dolphins cajole
blithely above the sly " }, { "o_orderkey": 5184i32, "o_custkey": 85i32,
"o_orderstatus": "O", "o_totalprice": 209155.48d, "o_orderdate": "1998-07-20",
"o_orderpriority": "5-L
OW", "o_clerk": "Clerk#000000250", "o_shippriority": 0i32, "o_comment": "nding
accounts detect final, even" }, { "o_orderkey": 5830i32, "o_custkey": 85i32,
"o_orderstatus": "F", "o_totalprice": 28223.57d, "o_orderdate": "1993-03-25",
"o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000233", "o_shippriority":
0i32, "o_comment": "lites haggle. ironic, ironic instructions maintain blit" }
] }
-{ "customer_name": 86i32, "orders": [ ] }
-{ "customer_name": 87i32, "orders": [ ] }
-{ "customer_name": 88i32, "orders": [ ] }
-{ "customer_name": 89i32, "orders": [ ] }
-{ "customer_name": 90i32, "orders": [ ] }
-{ "customer_name": 91i32, "orders": [ ] }
-{ "customer_name": 92i32, "orders": [ ] }
-{ "customer_name": 93i32, "orders": [ ] }
-{ "customer_name": 94i32, "orders": [ ] }
-{ "customer_name": 95i32, "orders": [ ] }
-{ "customer_name": 96i32, "orders": [ ] }
-{ "customer_name": 97i32, "orders": [ ] }
-{ "customer_name": 98i32, "orders": [ ] }
-{ "customer_name": 99i32, "orders": [ ] }
-{ "customer_name": 100i32, "orders": [ ] }
-{ "customer_name": 101i32, "orders": [ ] }
-{ "customer_name": 102i32, "orders": [ ] }
-{ "customer_name": 103i32, "orders": [ ] }
-{ "customer_name": 104i32, "orders": [ ] }
-{ "customer_name": 105i32, "orders": [ ] }
-{ "customer_name": 106i32, "orders": [ ] }
-{ "customer_name": 107i32, "orders": [ ] }
-{ "customer_name": 108i32, "orders": [ ] }
-{ "customer_name": 109i32, "orders": [ ] }
-{ "customer_name": 110i32, "orders": [ ] }
-{ "customer_name": 111i32, "orders": [ ] }
-{ "customer_name": 112i32, "orders": [ ] }
-{ "customer_name": 113i32, "orders": [ ] }
-{ "customer_name": 114i32, "orders": [ ] }
-{ "customer_name": 115i32, "orders": [ ] }
-{ "customer_name": 116i32, "orders": [ ] }
-{ "customer_name": 117i32, "orders": [ ] }
-{ "customer_name": 118i32, "orders": [ ] }
-{ "customer_name": 119i32, "orders": [ ] }
-{ "customer_name": 120i32, "orders": [ ] }
-{ "customer_name": 121i32, "orders": [ ] }
-{ "customer_name": 122i32, "orders": [ ] }
-{ "customer_name": 123i32, "orders": [ ] }
-{ "customer_name": 124i32, "orders": [ ] }
-{ "customer_name": 125i32, "orders": [ ] }
-{ "customer_name": 126i32, "orders": [ ] }
-{ "customer_name": 127i32, "orders": [ ] }
-{ "customer_name": 128i32, "orders": [ ] }
-{ "customer_name": 129i32, "orders": [ ] }
-{ "customer_name": 130i32, "orders": [ ] }
-{ "customer_name": 131i32, "orders": [ ] }
-{ "customer_name": 132i32, "orders": [ ] }
-{ "customer_name": 133i32, "orders": [ ] }
-{ "customer_name": 134i32, "orders": [ ] }
-{ "customer_name": 135i32, "orders": [ ] }
-{ "customer_name": 136i32, "orders": [ ] }
-{ "customer_name": 137i32, "orders": [ ] }
-{ "customer_name": 138i32, "orders": [ ] }
-{ "customer_name": 139i32, "orders": [ ] }
-{ "customer_name": 140i32, "orders": [ ] }
-{ "customer_name": 141i32, "orders": [ ] }
-{ "customer_name": 142i32, "orders": [ ] }
-{ "customer_name": 143i32, "orders": [ ] }
-{ "customer_name": 144i32, "orders": [ ] }
-{ "customer_name": 145i32, "orders": [ ] }
-{ "customer_name": 146i32, "orders": [ ] }
-{ "customer_name": 147i32, "orders": [ ] }
-{ "customer_name": 148i32, "orders": [ ] }
-{ "customer_name": 149i32, "orders": [ ] }
-{ "customer_name": 150i32, "orders": [ ] }
+{ "customer_name": 1, "orders": [ ] }
+{ "customer_name": 2, "orders": [ ] }
+{ "customer_name": 3, "orders": [ ] }
+{ "customer_name": 4, "orders": [ ] }
+{ "customer_name": 5, "orders": [ ] }
+{ "customer_name": 6, "orders": [ ] }
+{ "customer_name": 7, "orders": [ ] }
+{ "customer_name": 8, "orders": [ ] }
+{ "customer_name": 9, "orders": [ ] }
+{ "customer_name": 10, "orders": [ { "o_orderkey": 227, "o_custkey": 10,
"o_orderstatus": "O", "o_totalprice": 46076.46, "o_orderdate": "1995-11-10",
"o_orderpriority": "5-LOW", "o_clerk": "Clerk#000000919", "o_shippriority": 0,
"o_comment": " express instructions. slyly regul" }, { "o_orderkey": 517,
"o_custkey": 10, "o_orderstatus": "O", "o_totalprice": 82197.79, "o_orderdate":
"1997-04-07", "o_orderpriority": "5-LOW", "o_clerk": "Clerk#000000359",
"o_shippriority": 0, "o_comment": "slyly pending deposits cajole quickly
packages. furiou" }, { "o_orderkey": 902, "o_custkey": 10, "o_orderstatus":
"F", "o_totalprice": 37348.62, "o_orderdate": "1994-07-27", "o_orderpriority":
"4-NOT SPECIFIED", "o_clerk": "Clerk#000000811", "o_shippriority": 0,
"o_comment": "yly final requests over the furiously regula" }, { "o_orderkey":
1218, "o_custkey": 10, "o_orderstatus": "F", "o_totalprice": 99834.47,
"o_orderdate": "1994-06-20", "o_orderpriority": "4-NOT SPECIFIED", "o_clerk":
"Clerk#000000994
", "o_shippriority": 0, "o_comment": "s cajole. special, silent deposits about
the theo" }, { "o_orderkey": 1222, "o_custkey": 10, "o_orderstatus": "F",
"o_totalprice": 47623.94, "o_orderdate": "1993-02-05", "o_orderpriority":
"3-MEDIUM", "o_clerk": "Clerk#000000811", "o_shippriority": 0, "o_comment":
"theodolites use quickly even accounts. carefully final asympto" }, {
"o_orderkey": 1223, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice":
26714.67, "o_orderdate": "1996-05-25", "o_orderpriority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000238", "o_shippriority": 0, "o_comment": "posits was
blithely fr" }, { "o_orderkey": 1860, "o_custkey": 10, "o_orderstatus": "O",
"o_totalprice": 9103.4, "o_orderdate": "1996-04-04", "o_orderpriority":
"3-MEDIUM", "o_clerk": "Clerk#000000556", "o_shippriority": 0, "o_comment":
"osits. quickly bold deposits according to " }, { "o_orderkey": 1890,
"o_custkey": 10, "o_orderstatus": "O", "o_totalprice": 202364.58,
"o_orderdate": "1996-12-18", "o_ord
erpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000627",
"o_shippriority": 0, "o_comment": "romise final, regular deposits. regular fox"
}, { "o_orderkey": 2562, "o_custkey": 10, "o_orderstatus": "F", "o_totalprice":
136360.37, "o_orderdate": "1992-08-01", "o_orderpriority": "1-URGENT",
"o_clerk": "Clerk#000000467", "o_shippriority": 0, "o_comment": "elets. pending
dolphins promise slyly. bo" }, { "o_orderkey": 3204, "o_custkey": 10,
"o_orderstatus": "F", "o_totalprice": 41573.42, "o_orderdate": "1992-12-26",
"o_orderpriority": "1-URGENT", "o_clerk": "Clerk#000000693", "o_shippriority":
0, "o_comment": "ess somas cajole slyly. pending accounts cajole" }, {
"o_orderkey": 3428, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice":
88047.04, "o_orderdate": "1996-04-07", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000953", "o_shippriority": 0, "o_comment": "lar excuses. slyly
pending ideas detect p" }, { "o_orderkey": 3618, "o_custkey": 10,
"o_orderstatus": "O", "o_totalprice
": 136954.81, "o_orderdate": "1997-12-13", "o_orderpriority": "3-MEDIUM",
"o_clerk": "Clerk#000000894", "o_shippriority": 0, "o_comment": ". ideas run
carefully. thin, pending " }, { "o_orderkey": 3751, "o_custkey": 10,
"o_orderstatus": "F", "o_totalprice": 202917.72, "o_orderdate": "1994-04-27",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000925",
"o_shippriority": 0, "o_comment": "sheaves. express, unusual t" }, {
"o_orderkey": 3843, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice":
34035.17, "o_orderdate": "1997-01-04", "o_orderpriority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000693", "o_shippriority": 0, "o_comment": "eodolites;
slyly unusual accounts nag boldly " }, { "o_orderkey": 3911, "o_custkey": 10,
"o_orderstatus": "P", "o_totalprice": 35019.95, "o_orderdate": "1995-03-17",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000818",
"o_shippriority": 0, "o_comment": "he fluffily final forges haggle slyly
according to the blithely" }, { "o_ord
erkey": 4032, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice": 62497.51,
"o_orderdate": "1998-02-26", "o_orderpriority": "3-MEDIUM", "o_clerk":
"Clerk#000000686", "o_shippriority": 0, "o_comment": "iresias sleep slyly
regular ideas. quickly unusual" }, { "o_orderkey": 4097, "o_custkey": 10,
"o_orderstatus": "O", "o_totalprice": 134308.04, "o_orderdate": "1996-05-24",
"o_orderpriority": "1-URGENT", "o_clerk": "Clerk#000000475", "o_shippriority":
0, "o_comment": "ickly under the even accounts. even packages after the
furiously express" }, { "o_orderkey": 4388, "o_custkey": 10, "o_orderstatus":
"O", "o_totalprice": 69668.22, "o_orderdate": "1996-03-28", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000715", "o_shippriority": 0, "o_comment": "ts
wake against the carefully final accounts. sly" }, { "o_orderkey": 4421,
"o_custkey": 10, "o_orderstatus": "O", "o_totalprice": 258779.02,
"o_orderdate": "1997-04-04", "o_orderpriority": "3-MEDIUM", "o_clerk":
"Clerk#000000246", "o_shi
ppriority": 0, "o_comment": "t the pending warhorses. express waters a" }, {
"o_orderkey": 4449, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice":
48206.14, "o_orderdate": "1998-02-08", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000035", "o_shippriority": 0, "o_comment": "ourts are carefully even
deposits. pending " }, { "o_orderkey": 4867, "o_custkey": 10, "o_orderstatus":
"F", "o_totalprice": 9741.03, "o_orderdate": "1992-05-21", "o_orderpriority":
"1-URGENT", "o_clerk": "Clerk#000000891", "o_shippriority": 0, "o_comment": "ss
the slyly regular dependencies. fluffily regular deposits within the car" }, {
"o_orderkey": 5123, "o_custkey": 10, "o_orderstatus": "O", "o_totalprice":
11850.45, "o_orderdate": "1998-02-10", "o_orderpriority": "1-URGENT",
"o_clerk": "Clerk#000000776", "o_shippriority": 0, "o_comment": "ic requests.
furiously ironic packages grow above the express, ironic inst" }, {
"o_orderkey": 5220, "o_custkey": 10, "o_orderstatus": "F", "o_totalprice":
24844.
39, "o_orderdate": "1992-07-30", "o_orderpriority": "2-HIGH", "o_clerk":
"Clerk#000000051", "o_shippriority": 0, "o_comment": " final packages. ideas
detect slyly around" } ] }
+{ "customer_name": 11, "orders": [ ] }
+{ "customer_name": 12, "orders": [ ] }
+{ "customer_name": 13, "orders": [ ] }
+{ "customer_name": 14, "orders": [ ] }
+{ "customer_name": 15, "orders": [ ] }
+{ "customer_name": 16, "orders": [ ] }
+{ "customer_name": 17, "orders": [ ] }
+{ "customer_name": 18, "orders": [ ] }
+{ "customer_name": 19, "orders": [ ] }
+{ "customer_name": 20, "orders": [ ] }
+{ "customer_name": 21, "orders": [ ] }
+{ "customer_name": 22, "orders": [ ] }
+{ "customer_name": 23, "orders": [ ] }
+{ "customer_name": 24, "orders": [ ] }
+{ "customer_name": 25, "orders": [ ] }
+{ "customer_name": 26, "orders": [ ] }
+{ "customer_name": 27, "orders": [ ] }
+{ "customer_name": 28, "orders": [ ] }
+{ "customer_name": 29, "orders": [ ] }
+{ "customer_name": 30, "orders": [ ] }
+{ "customer_name": 31, "orders": [ ] }
+{ "customer_name": 32, "orders": [ ] }
+{ "customer_name": 33, "orders": [ ] }
+{ "customer_name": 34, "orders": [ ] }
+{ "customer_name": 35, "orders": [ ] }
+{ "customer_name": 36, "orders": [ ] }
+{ "customer_name": 37, "orders": [ ] }
+{ "customer_name": 38, "orders": [ ] }
+{ "customer_name": 39, "orders": [ ] }
+{ "customer_name": 40, "orders": [ ] }
+{ "customer_name": 41, "orders": [ ] }
+{ "customer_name": 42, "orders": [ ] }
+{ "customer_name": 43, "orders": [ ] }
+{ "customer_name": 44, "orders": [ ] }
+{ "customer_name": 45, "orders": [ ] }
+{ "customer_name": 46, "orders": [ ] }
+{ "customer_name": 47, "orders": [ ] }
+{ "customer_name": 48, "orders": [ ] }
+{ "customer_name": 49, "orders": [ ] }
+{ "customer_name": 50, "orders": [ ] }
+{ "customer_name": 51, "orders": [ ] }
+{ "customer_name": 52, "orders": [ ] }
+{ "customer_name": 53, "orders": [ ] }
+{ "customer_name": 54, "orders": [ ] }
+{ "customer_name": 55, "orders": [ ] }
+{ "customer_name": 56, "orders": [ ] }
+{ "customer_name": 57, "orders": [ ] }
+{ "customer_name": 58, "orders": [ ] }
+{ "customer_name": 59, "orders": [ ] }
+{ "customer_name": 60, "orders": [ ] }
+{ "customer_name": 61, "orders": [ ] }
+{ "customer_name": 62, "orders": [ ] }
+{ "customer_name": 63, "orders": [ ] }
+{ "customer_name": 64, "orders": [ ] }
+{ "customer_name": 65, "orders": [ ] }
+{ "customer_name": 66, "orders": [ ] }
+{ "customer_name": 67, "orders": [ ] }
+{ "customer_name": 68, "orders": [ ] }
+{ "customer_name": 69, "orders": [ ] }
+{ "customer_name": 70, "orders": [ ] }
+{ "customer_name": 71, "orders": [ ] }
+{ "customer_name": 72, "orders": [ ] }
+{ "customer_name": 73, "orders": [ ] }
+{ "customer_name": 74, "orders": [ ] }
+{ "customer_name": 75, "orders": [ ] }
+{ "customer_name": 76, "orders": [ ] }
+{ "customer_name": 77, "orders": [ ] }
+{ "customer_name": 78, "orders": [ ] }
+{ "customer_name": 79, "orders": [ ] }
+{ "customer_name": 80, "orders": [ ] }
+{ "customer_name": 81, "orders": [ ] }
+{ "customer_name": 82, "orders": [ ] }
+{ "customer_name": 83, "orders": [ ] }
+{ "customer_name": 84, "orders": [ ] }
+{ "customer_name": 85, "orders": [ { "o_orderkey": 69, "o_custkey": 85,
"o_orderstatus": "F", "o_totalprice": 162176.23, "o_orderdate": "1994-06-04",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000330",
"o_shippriority": 0, "o_comment": " depths atop the slyly thin deposits detect
among the furiously silent accou" }, { "o_orderkey": 704, "o_custkey": 85,
"o_orderstatus": "O", "o_totalprice": 56210.26, "o_orderdate": "1996-11-21",
"o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000682", "o_shippriority":
0, "o_comment": "blithely pending platelets wake alongside of the final, iron"
}, { "o_orderkey": 1699, "o_custkey": 85, "o_orderstatus": "F", "o_totalprice":
66408.29, "o_orderdate": "1993-12-30", "o_orderpriority": "1-URGENT",
"o_clerk": "Clerk#000000125", "o_shippriority": 0, "o_comment": "jole blithely.
furiously un" }, { "o_orderkey": 2437, "o_custkey": 85, "o_orderstatus": "F",
"o_totalprice": 143411.69, "o_orderdate": "1993-04-21", "o_orderpriority":
"4-NOT
SPECIFIED", "o_clerk": "Clerk#000000578", "o_shippriority": 0, "o_comment": ".
theodolites wake slyly-- ironic, pending platelets above the carefully exp" },
{ "o_orderkey": 2630, "o_custkey": 85, "o_orderstatus": "F", "o_totalprice":
127132.51, "o_orderdate": "1992-10-24", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000712", "o_shippriority": 0, "o_comment": "inal theodolites. ironic
instructions s" }, { "o_orderkey": 2982, "o_custkey": 85, "o_orderstatus": "F",
"o_totalprice": 55582.94, "o_orderdate": "1995-03-19", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000402", "o_shippriority": 0, "o_comment":
"lyly. express theodolites affix slyly after the slyly speci" }, {
"o_orderkey": 3108, "o_custkey": 85, "o_orderstatus": "F", "o_totalprice":
63278.0, "o_orderdate": "1993-08-05", "o_orderpriority": "1-URGENT", "o_clerk":
"Clerk#000000574", "o_shippriority": 0, "o_comment": "s packages haggle
furiously am" }, { "o_orderkey": 3776, "o_custkey": 85, "o_orderstatus": "F",
"o_t
otalprice": 150349.92, "o_orderdate": "1992-11-20", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000698", "o_shippriority": 0, "o_comment":
"efully even platelets slee" }, { "o_orderkey": 4480, "o_custkey": 85,
"o_orderstatus": "F", "o_totalprice": 28658.26, "o_orderdate": "1994-03-31",
"o_orderpriority": "4-NOT SPECIFIED", "o_clerk": "Clerk#000000534",
"o_shippriority": 0, "o_comment": "press, bold deposits boost blit" }, {
"o_orderkey": 4513, "o_custkey": 85, "o_orderstatus": "O", "o_totalprice":
119820.38, "o_orderdate": "1996-03-15", "o_orderpriority": "5-LOW", "o_clerk":
"Clerk#000000154", "o_shippriority": 0, "o_comment": "ests. final, final ideas"
}, { "o_orderkey": 4708, "o_custkey": 85, "o_orderstatus": "F", "o_totalprice":
56998.36, "o_orderdate": "1994-10-01", "o_orderpriority": "1-URGENT",
"o_clerk": "Clerk#000000383", "o_shippriority": 0, "o_comment": "ly thinly even
accounts. unusu" }, { "o_orderkey": 4865, "o_custkey": 85, "o_orderstatus":
"O", "o_totalprice": 16
2113.46, "o_orderdate": "1997-06-07", "o_orderpriority": "3-MEDIUM",
"o_clerk": "Clerk#000000418", "o_shippriority": 0, "o_comment": "sits boost
stealthily above the bl" }, { "o_orderkey": 4896, "o_custkey": 85,
"o_orderstatus": "F", "o_totalprice": 93206.35, "o_orderdate": "1992-08-22",
"o_orderpriority": "1-URGENT", "o_clerk": "Clerk#000000622", "o_shippriority":
0, "o_comment": "sly pending deposits. final accounts boost above the sly,
even" }, { "o_orderkey": 4999, "o_custkey": 85, "o_orderstatus": "F",
"o_totalprice": 98643.17, "o_orderdate": "1993-06-26", "o_orderpriority":
"2-HIGH", "o_clerk": "Clerk#000000504", "o_shippriority": 0, "o_comment": "
dolphins cajole blithely above the sly " }, { "o_orderkey": 5184, "o_custkey":
85, "o_orderstatus": "O", "o_totalprice": 209155.48, "o_orderdate":
"1998-07-20", "o_orderpriority": "5-LOW", "o_clerk": "Clerk#000000250",
"o_shippriority": 0, "o_comment": "nding accounts detect final, even" }, {
"o_orderkey": 5830, "o_custkey": 85, "o_
orderstatus": "F", "o_totalprice": 28223.57, "o_orderdate": "1993-03-25",
"o_orderpriority": "3-MEDIUM", "o_clerk": "Clerk#000000233", "o_shippriority":
0, "o_comment": "lites haggle. ironic, ironic instructions maintain blit" } ] }
+{ "customer_name": 86, "orders": [ ] }
+{ "customer_name": 87, "orders": [ ] }
+{ "customer_name": 88, "orders": [ ] }
+{ "customer_name": 89, "orders": [ ] }
+{ "customer_name": 90, "orders": [ ] }
+{ "customer_name": 91, "orders": [ ] }
+{ "customer_name": 92, "orders": [ ] }
+{ "customer_name": 93, "orders": [ ] }
+{ "customer_name": 94, "orders": [ ] }
+{ "customer_name": 95, "orders": [ ] }
+{ "customer_name": 96, "orders": [ ] }
+{ "customer_name": 97, "orders": [ ] }
+{ "customer_name": 98, "orders": [ ] }
+{ "customer_name": 99, "orders": [ ] }
+{ "customer_name": 100, "orders": [ ] }
+{ "customer_name": 101, "orders": [ ] }
+{ "customer_name": 102, "orders": [ ] }
+{ "customer_name": 103, "orders": [ ] }
+{ "customer_name": 104, "orders": [ ] }
+{ "customer_name": 105, "orders": [ ] }
+{ "customer_name": 106, "orders": [ ] }
+{ "customer_name": 107, "orders": [ ] }
+{ "customer_name": 108, "orders": [ ] }
+{ "customer_name": 109, "orders": [ ] }
+{ "customer_name": 110, "orders": [ ] }
+{ "customer_name": 111, "orders": [ ] }
+{ "customer_name": 112, "orders": [ ] }
+{ "customer_name": 113, "orders": [ ] }
+{ "customer_name": 114, "orders": [ ] }
+{ "customer_name": 115, "orders": [ ] }
+{ "customer_name": 116, "orders": [ ] }
+{ "customer_name": 117, "orders": [ ] }
+{ "customer_name": 118, "orders": [ ] }
+{ "customer_name": 119, "orders": [ ] }
+{ "customer_name": 120, "orders": [ ] }
+{ "customer_name": 121, "orders": [ ] }
+{ "customer_name": 122, "orders": [ ] }
+{ "customer_name": 123, "orders": [ ] }
+{ "customer_name": 124, "orders": [ ] }
+{ "customer_name": 125, "orders": [ ] }
+{ "customer_name": 126, "orders": [ ] }
+{ "customer_name": 127, "orders": [ ] }
+{ "customer_name": 128, "orders": [ ] }
+{ "customer_name": 129, "orders": [ ] }
+{ "customer_name": 130, "orders": [ ] }
+{ "customer_name": 131, "orders": [ ] }
+{ "customer_name": 132, "orders": [ ] }
+{ "customer_name": 133, "orders": [ ] }
+{ "customer_name": 134, "orders": [ ] }
+{ "customer_name": 135, "orders": [ ] }
+{ "customer_name": 136, "orders": [ ] }
+{ "customer_name": 137, "orders": [ ] }
+{ "customer_name": 138, "orders": [ ] }
+{ "customer_name": 139, "orders": [ ] }
+{ "customer_name": 140, "orders": [ ] }
+{ "customer_name": 141, "orders": [ ] }
+{ "customer_name": 142, "orders": [ ] }
+{ "customer_name": 143, "orders": [ ] }
+{ "customer_name": 144, "orders": [ ] }
+{ "customer_name": 145, "orders": [ ] }
+{ "customer_name": 146, "orders": [ ] }
+{ "customer_name": 147, "orders": [ ] }
+{ "customer_name": 148, "orders": [ ] }
+{ "customer_name": 149, "orders": [ ] }
+{ "customer_name": 150, "orders": [ ] }
