| ==== |
| ---- QUERY |
| set EXPAND_COMPLEX_TYPES=true; |
| select c_name, c_address, c_comment, o.* from customer c, c.c_orders o where c_name = 'Customer#000000001'; |
| ---- RESULTS |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',579908,'O',54048.26,'1996-12-09','5-LOW','Clerk#000000783',0,' asymptotes. regular requests boost blithely. pending gifts according to the','[{"l_partkey":104617,"l_suppkey":7128,"l_linenumber":1,"l_quantity":33.00,"l_extendedprice":53513.13,"l_discount":0.00,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-30","l_commitdate":"1997-01-11","l_receiptdate":"1997-04-25","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"uickly special ideas alongside"}]' |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',3868359,'F',123076.84,'1992-08-22','5-LOW','Clerk#000000536',0,'. furiously bold asymptotes are instructions. quickly ironic dep','[{"l_partkey":68383,"l_suppkey":8384,"l_linenumber":1,"l_quantity":36.00,"l_extendedprice":48649.68,"l_discount":0.04,"l_tax":0.05,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-10-29","l_commitdate":"1992-10-18","l_receiptdate":"1992-10-30","l_shipinstruct":"NONE","l_shipmode":"RAIL","l_comment":"ts. carefully express ideas run quickly c"},{"l_partkey":105649,"l_suppkey":3180,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":14891.76,"l_discount":0.05,"l_tax":0.03,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-10-27","l_commitdate":"1992-09-27","l_receiptdate":"1992-11-26","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":"s wake furiously. platele"},{"l_partkey":39769,"l_suppkey":2273,"l_linenumber":3,"l_quantity":32.00,"l_extendedprice":54680.32,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-11-29","l_commitdate":"1992-10-13","l_receiptdate":"1992-12-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"c ideas are quickly ironic "},{"l_partkey":194361,"l_suppkey":9400,"l_linenumber":4,"l_quantity":6.00,"l_extendedprice":8732.16,"l_discount":0.09,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-11-03","l_commitdate":"1992-10-05","l_receiptdate":"1992-11-21","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"s are. furiously final foxes are spec"}]' |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',4273923,'O',95911.01,'1997-03-23','3-MEDIUM','Clerk#000000381',0,'ep fluffily along the carefull','[{"l_partkey":127174,"l_suppkey":9687,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":33632.76,"l_discount":0.09,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-07-04","l_commitdate":"1997-06-10","l_receiptdate":"1997-07-25","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"asymptotes try to nag fluffily acros"},{"l_partkey":12564,"l_suppkey":5066,"l_linenumber":2,"l_quantity":42.00,"l_extendedprice":62015.52,"l_discount":0.03,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-06","l_commitdate":"1997-06-16","l_receiptdate":"1997-06-13","l_shipinstruct":"COLLECT COD","l_shipmode":"AIR","l_comment":"ly even packages: ironic as"}]' |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',4808192,'O',65478.05,'1996-06-29','2-HIGH','Clerk#000000473',0,'eposits use against the express accounts. carefully regular ideas sleep blithe','[{"l_partkey":118792,"l_suppkey":8793,"l_linenumber":1,"l_quantity":26.00,"l_extendedprice":47080.54,"l_discount":0.05,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-26","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-03","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"inal deposits haggle b"},{"l_partkey":121572,"l_suppkey":9109,"l_linenumber":2,"l_quantity":11.00,"l_extendedprice":17529.27,"l_discount":0.03,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-15","l_commitdate":"1996-09-04","l_receiptdate":"1996-09-25","l_shipinstruct":"COLLECT COD","l_shipmode":"MAIL","l_comment":"g, final requests sleep quickly fluffi"}]' |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 'Customer#000000001','IVhzIApeRb ot,c,E','to the even, regular platelets. regular, ironic epitaphs nag e',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| ---- TYPES |
| STRING, STRING, STRING, BIGINT, STRING, DECIMAL, STRING, STRING, STRING, INT, STRING, STRING |
| ==== |
| ---- QUERY |
| set EXPAND_COMPLEX_TYPES=true; |
| select c_name, c_address, c_comment, o.* from customer c, c.c_orders o where c_name = 'Customer#000000002'; |
| ---- RESULTS |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',2992930,'F',103297.68,'1994-05-21','4-NOT SPECIFIED','Clerk#000000913',0,'owly slyly final platelets. ironic instructions wake carefully unusual plate','[{"l_partkey":84928,"l_suppkey":7437,"l_linenumber":1,"l_quantity":50.00,"l_extendedprice":95646.00,"l_discount":0.00,"l_tax":0.08,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-09-12","l_commitdate":"1994-08-18","l_receiptdate":"1994-10-03","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":" slyly final instr"}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',430243,'F',33082.83,'1994-12-24','4-NOT SPECIFIED','Clerk#000000121',0,'n braids among the final packages cajole pendin','[{"l_partkey":155290,"l_suppkey":5291,"l_linenumber":1,"l_quantity":23.00,"l_extendedprice":30941.67,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1995-03-28","l_commitdate":"1995-03-10","l_receiptdate":"1995-04-06","l_shipinstruct":"COLLECT COD","l_shipmode":"SHIP","l_comment":"ter the fluffily even instructions. furi"}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',1071617,'P',221397.35,'1995-03-10','2-HIGH','Clerk#000000408',0,'al, unusual packages. furiously final requests use quickly. f','[{"l_partkey":36850,"l_suppkey":1857,"l_linenumber":1,"l_quantity":27.00,"l_extendedprice":48244.95,"l_discount":0.00,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-09","l_commitdate":"1995-05-15","l_receiptdate":"1995-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":"ic packages are. spe"},{"l_partkey":137384,"l_suppkey":2411,"l_linenumber":2,"l_quantity":11.00,"l_extendedprice":15635.18,"l_discount":0.10,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-04-08","l_commitdate":"1995-04-16","l_receiptdate":"1995-04-13","l_shipinstruct":"COLLECT COD","l_shipmode":"MAIL","l_comment":"ke furiously furiously regular "},{"l_partkey":3374,"l_suppkey":8375,"l_linenumber":3,"l_quantity":36.00,"l_extendedprice":45985.32,"l_discount":0.02,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-03","l_commitdate":"1995-04-26","l_receiptdate":"1995-07-17","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"express requests. even patterns "},{"l_partkey":90308,"l_suppkey":309,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":38949.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"F","l_shipdate":"1995-06-12","l_commitdate":"1995-05-28","l_receiptdate":"1995-06-26","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"l ideas. blithely ironic instructions are "},{"l_partkey":194723,"l_suppkey":2281,"l_linenumber":5,"l_quantity":39.00,"l_extendedprice":70891.08,"l_discount":0.07,"l_tax":0.05,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1995-06-08","l_commitdate":"1995-06-03","l_receiptdate":"1995-06-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"AIR","l_comment":"blithely express hockey"}]' |
| 'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak','l accounts. blithely ironic theodolites integrate boldly: caref',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| ---- TYPES |
| STRING, STRING, STRING, BIGINT, STRING, DECIMAL, STRING, STRING, STRING, INT, STRING, STRING |
| ==== |
| ---- QUERY |
| select r_name, r_comment, r_nations from region; |
| ---- RESULTS |
| 'AFRICA','lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ','[{"n_nationkey":0,"n_name":"ALGERIA","n_comment":" haggle. carefully final deposits detect slyly agai"},{"n_nationkey":5,"n_name":"ETHIOPIA","n_comment":"ven packages wake quickly. regu"},{"n_nationkey":14,"n_name":"KENYA","n_comment":" pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t"},{"n_nationkey":15,"n_name":"MOROCCO","n_comment":"rns. blithely bold courts among the closely regular packages use furiously bold platelets?"},{"n_nationkey":16,"n_name":"MOZAMBIQUE","n_comment":"s. ironic, unusual asymptotes wake blithely r"}]' |
| 'MIDDLE EAST','uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl','[{"n_nationkey":4,"n_name":"EGYPT","n_comment":"y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d"},{"n_nationkey":10,"n_name":"IRAN","n_comment":"efully alongside of the slyly final dependencies. "},{"n_nationkey":11,"n_name":"IRAQ","n_comment":"nic deposits boost atop the quickly final requests? quickly regula"},{"n_nationkey":13,"n_name":"JORDAN","n_comment":"ic deposits are blithely about the carefully regular pa"},{"n_nationkey":20,"n_name":"SAUDI ARABIA","n_comment":"ts. silent requests haggle. closely express packages sleep across the blithely"}]' |
| 'ASIA','ges. thinly even pinto beans ca','[{"n_nationkey":8,"n_name":"INDIA","n_comment":"ss excuses cajole slyly across the packages. deposits print aroun"},{"n_nationkey":9,"n_name":"INDONESIA","n_comment":" slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull"},{"n_nationkey":12,"n_name":"JAPAN","n_comment":"ously. final, express gifts cajole a"},{"n_nationkey":18,"n_name":"CHINA","n_comment":"c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos"},{"n_nationkey":21,"n_name":"VIETNAM","n_comment":"hely enticingly express accounts. even, final "}]' |
| 'EUROPE','ly final courts cajole furiously final excuse','[{"n_nationkey":6,"n_name":"FRANCE","n_comment":"refully final requests. regular, ironi"},{"n_nationkey":7,"n_name":"GERMANY","n_comment":"l platelets. regular accounts x-ray: unusual, regular acco"},{"n_nationkey":19,"n_name":"ROMANIA","n_comment":"ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account"},{"n_nationkey":22,"n_name":"RUSSIA","n_comment":" requests against the platelets use never according to the quickly regular pint"},{"n_nationkey":23,"n_name":"UNITED KINGDOM","n_comment":"eans boost carefully special requests. accounts are. carefull"}]' |
| 'AMERICA','hs use ironic, even requests. s','[{"n_nationkey":1,"n_name":"ARGENTINA","n_comment":"al foxes promise slyly according to the regular accounts. bold requests alon"},{"n_nationkey":2,"n_name":"BRAZIL","n_comment":"y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special "},{"n_nationkey":3,"n_name":"CANADA","n_comment":"eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold"},{"n_nationkey":17,"n_name":"PERU","n_comment":"platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun"},{"n_nationkey":24,"n_name":"UNITED STATES","n_comment":"y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be"}]' |
| ---- TYPES |
| STRING, STRING, STRING |
| ==== |
| ---- QUERY |
| # Complex query where we broadcast complex types to a join and |
| # have deeply nested small/long strings. |
| set EXPAND_COMPLEX_TYPES=true; |
| select straight_join c_custkey, r_name, o.* |
| from region join customer c, c.c_orders o |
| where o_orderpriority = '1-URGENT' and |
| c.c_name < 'Customer#000000005' and |
| c.c_nationkey in (select n_nationkey from region.r_nations); |
| ---- RESULTS |
| 1,'AFRICA',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 1,'AFRICA',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| 4,'AFRICA',1192231,'O',143971.54,'1996-06-03','1-URGENT','Clerk#000000978',0,'osits haggle carefully. carefully final grouches are. blithely si','[{"l_partkey":103367,"l_suppkey":3368,"l_linenumber":1,"l_quantity":29.00,"l_extendedprice":39740.44,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-06","l_commitdate":"1996-08-24","l_receiptdate":"1996-06-15","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"across the blithe"},{"l_partkey":86763,"l_suppkey":1780,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":15747.84,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-22","l_receiptdate":"1996-10-09","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"careful accounts. even ideas haggle aga"},{"l_partkey":10325,"l_suppkey":326,"l_linenumber":3,"l_quantity":15.00,"l_extendedprice":18529.80,"l_discount":0.04,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-31","l_receiptdate":"1996-09-30","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" the furiously furious deposits wake fur"},{"l_partkey":117347,"l_suppkey":4881,"l_linenumber":4,"l_quantity":2.00,"l_extendedprice":2728.68,"l_discount":0.08,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-10","l_commitdate":"1996-07-24","l_receiptdate":"1996-07-12","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"osits. fluffily regular courts sle"},{"l_partkey":43478,"l_suppkey":8487,"l_linenumber":5,"l_quantity":26.00,"l_extendedprice":36958.22,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-19","l_commitdate":"1996-08-18","l_receiptdate":"1996-06-23","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"fully regular instructions"},{"l_partkey":120368,"l_suppkey":369,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":26378.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-14","l_commitdate":"1996-08-12","l_receiptdate":"1996-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"bold packages haggle furiously against th"}]' |
| 4,'AFRICA',1944711,'P',104934.65,'1995-05-06','1-URGENT','Clerk#000000580',0,'deas wake. slyly silent packa','[{"l_partkey":66583,"l_suppkey":4102,"l_linenumber":1,"l_quantity":37.00,"l_extendedprice":57334.46,"l_discount":0.03,"l_tax":0.00,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-05-15","l_commitdate":"1995-07-29","l_receiptdate":"1995-05-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"ular forges. slyly ev"},{"l_partkey":48820,"l_suppkey":3829,"l_linenumber":2,"l_quantity":15.00,"l_extendedprice":26532.30,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-08-06","l_commitdate":"1995-06-20","l_receiptdate":"1995-09-04","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"into beans according to the slyl"},{"l_partkey":103892,"l_suppkey":8913,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":24646.57,"l_discount":0.10,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-16","l_commitdate":"1995-06-28","l_receiptdate":"1995-07-31","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":", final instructions."}]' |
| 4,'AFRICA',1226497,'F',88317.19,'1993-10-04','1-URGENT','Clerk#000000154',0,'al theodolites. quickly ruthless accounts lose blithely furiously re','[{"l_partkey":101559,"l_suppkey":4070,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":49937.60,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-11-02","l_commitdate":"1993-12-04","l_receiptdate":"1993-11-22","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":". final, unusual deposits cajole slowly. i"},{"l_partkey":98547,"l_suppkey":6075,"l_linenumber":2,"l_quantity":27.00,"l_extendedprice":41729.58,"l_discount":0.06,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-01-09","l_commitdate":"1993-12-10","l_receiptdate":"1994-01-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"e quickly along th"}]' |
| 2,'AFRICA',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 2,'AFRICA',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 2,'AFRICA',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 2,'AFRICA',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| 1,'MIDDLE EAST',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 1,'MIDDLE EAST',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| 4,'MIDDLE EAST',1192231,'O',143971.54,'1996-06-03','1-URGENT','Clerk#000000978',0,'osits haggle carefully. carefully final grouches are. blithely si','[{"l_partkey":103367,"l_suppkey":3368,"l_linenumber":1,"l_quantity":29.00,"l_extendedprice":39740.44,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-06","l_commitdate":"1996-08-24","l_receiptdate":"1996-06-15","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"across the blithe"},{"l_partkey":86763,"l_suppkey":1780,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":15747.84,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-22","l_receiptdate":"1996-10-09","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"careful accounts. even ideas haggle aga"},{"l_partkey":10325,"l_suppkey":326,"l_linenumber":3,"l_quantity":15.00,"l_extendedprice":18529.80,"l_discount":0.04,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-31","l_receiptdate":"1996-09-30","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" the furiously furious deposits wake fur"},{"l_partkey":117347,"l_suppkey":4881,"l_linenumber":4,"l_quantity":2.00,"l_extendedprice":2728.68,"l_discount":0.08,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-10","l_commitdate":"1996-07-24","l_receiptdate":"1996-07-12","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"osits. fluffily regular courts sle"},{"l_partkey":43478,"l_suppkey":8487,"l_linenumber":5,"l_quantity":26.00,"l_extendedprice":36958.22,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-19","l_commitdate":"1996-08-18","l_receiptdate":"1996-06-23","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"fully regular instructions"},{"l_partkey":120368,"l_suppkey":369,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":26378.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-14","l_commitdate":"1996-08-12","l_receiptdate":"1996-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"bold packages haggle furiously against th"}]' |
| 4,'MIDDLE EAST',1944711,'P',104934.65,'1995-05-06','1-URGENT','Clerk#000000580',0,'deas wake. slyly silent packa','[{"l_partkey":66583,"l_suppkey":4102,"l_linenumber":1,"l_quantity":37.00,"l_extendedprice":57334.46,"l_discount":0.03,"l_tax":0.00,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-05-15","l_commitdate":"1995-07-29","l_receiptdate":"1995-05-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"ular forges. slyly ev"},{"l_partkey":48820,"l_suppkey":3829,"l_linenumber":2,"l_quantity":15.00,"l_extendedprice":26532.30,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-08-06","l_commitdate":"1995-06-20","l_receiptdate":"1995-09-04","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"into beans according to the slyl"},{"l_partkey":103892,"l_suppkey":8913,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":24646.57,"l_discount":0.10,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-16","l_commitdate":"1995-06-28","l_receiptdate":"1995-07-31","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":", final instructions."}]' |
| 4,'MIDDLE EAST',1226497,'F',88317.19,'1993-10-04','1-URGENT','Clerk#000000154',0,'al theodolites. quickly ruthless accounts lose blithely furiously re','[{"l_partkey":101559,"l_suppkey":4070,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":49937.60,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-11-02","l_commitdate":"1993-12-04","l_receiptdate":"1993-11-22","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":". final, unusual deposits cajole slowly. i"},{"l_partkey":98547,"l_suppkey":6075,"l_linenumber":2,"l_quantity":27.00,"l_extendedprice":41729.58,"l_discount":0.06,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-01-09","l_commitdate":"1993-12-10","l_receiptdate":"1994-01-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"e quickly along th"}]' |
| 2,'MIDDLE EAST',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 2,'MIDDLE EAST',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 2,'MIDDLE EAST',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 2,'MIDDLE EAST',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| 1,'ASIA',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 1,'ASIA',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| 4,'ASIA',1192231,'O',143971.54,'1996-06-03','1-URGENT','Clerk#000000978',0,'osits haggle carefully. carefully final grouches are. blithely si','[{"l_partkey":103367,"l_suppkey":3368,"l_linenumber":1,"l_quantity":29.00,"l_extendedprice":39740.44,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-06","l_commitdate":"1996-08-24","l_receiptdate":"1996-06-15","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"across the blithe"},{"l_partkey":86763,"l_suppkey":1780,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":15747.84,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-22","l_receiptdate":"1996-10-09","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"careful accounts. even ideas haggle aga"},{"l_partkey":10325,"l_suppkey":326,"l_linenumber":3,"l_quantity":15.00,"l_extendedprice":18529.80,"l_discount":0.04,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-31","l_receiptdate":"1996-09-30","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" the furiously furious deposits wake fur"},{"l_partkey":117347,"l_suppkey":4881,"l_linenumber":4,"l_quantity":2.00,"l_extendedprice":2728.68,"l_discount":0.08,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-10","l_commitdate":"1996-07-24","l_receiptdate":"1996-07-12","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"osits. fluffily regular courts sle"},{"l_partkey":43478,"l_suppkey":8487,"l_linenumber":5,"l_quantity":26.00,"l_extendedprice":36958.22,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-19","l_commitdate":"1996-08-18","l_receiptdate":"1996-06-23","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"fully regular instructions"},{"l_partkey":120368,"l_suppkey":369,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":26378.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-14","l_commitdate":"1996-08-12","l_receiptdate":"1996-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"bold packages haggle furiously against th"}]' |
| 4,'ASIA',1944711,'P',104934.65,'1995-05-06','1-URGENT','Clerk#000000580',0,'deas wake. slyly silent packa','[{"l_partkey":66583,"l_suppkey":4102,"l_linenumber":1,"l_quantity":37.00,"l_extendedprice":57334.46,"l_discount":0.03,"l_tax":0.00,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-05-15","l_commitdate":"1995-07-29","l_receiptdate":"1995-05-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"ular forges. slyly ev"},{"l_partkey":48820,"l_suppkey":3829,"l_linenumber":2,"l_quantity":15.00,"l_extendedprice":26532.30,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-08-06","l_commitdate":"1995-06-20","l_receiptdate":"1995-09-04","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"into beans according to the slyl"},{"l_partkey":103892,"l_suppkey":8913,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":24646.57,"l_discount":0.10,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-16","l_commitdate":"1995-06-28","l_receiptdate":"1995-07-31","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":", final instructions."}]' |
| 4,'ASIA',1226497,'F',88317.19,'1993-10-04','1-URGENT','Clerk#000000154',0,'al theodolites. quickly ruthless accounts lose blithely furiously re','[{"l_partkey":101559,"l_suppkey":4070,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":49937.60,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-11-02","l_commitdate":"1993-12-04","l_receiptdate":"1993-11-22","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":". final, unusual deposits cajole slowly. i"},{"l_partkey":98547,"l_suppkey":6075,"l_linenumber":2,"l_quantity":27.00,"l_extendedprice":41729.58,"l_discount":0.06,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-01-09","l_commitdate":"1993-12-10","l_receiptdate":"1994-01-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"e quickly along th"}]' |
| 2,'ASIA',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 2,'ASIA',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 2,'ASIA',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 2,'ASIA',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| 1,'EUROPE',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 1,'EUROPE',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| 4,'EUROPE',1192231,'O',143971.54,'1996-06-03','1-URGENT','Clerk#000000978',0,'osits haggle carefully. carefully final grouches are. blithely si','[{"l_partkey":103367,"l_suppkey":3368,"l_linenumber":1,"l_quantity":29.00,"l_extendedprice":39740.44,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-06","l_commitdate":"1996-08-24","l_receiptdate":"1996-06-15","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"across the blithe"},{"l_partkey":86763,"l_suppkey":1780,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":15747.84,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-22","l_receiptdate":"1996-10-09","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"careful accounts. even ideas haggle aga"},{"l_partkey":10325,"l_suppkey":326,"l_linenumber":3,"l_quantity":15.00,"l_extendedprice":18529.80,"l_discount":0.04,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-31","l_receiptdate":"1996-09-30","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" the furiously furious deposits wake fur"},{"l_partkey":117347,"l_suppkey":4881,"l_linenumber":4,"l_quantity":2.00,"l_extendedprice":2728.68,"l_discount":0.08,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-10","l_commitdate":"1996-07-24","l_receiptdate":"1996-07-12","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"osits. fluffily regular courts sle"},{"l_partkey":43478,"l_suppkey":8487,"l_linenumber":5,"l_quantity":26.00,"l_extendedprice":36958.22,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-19","l_commitdate":"1996-08-18","l_receiptdate":"1996-06-23","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"fully regular instructions"},{"l_partkey":120368,"l_suppkey":369,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":26378.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-14","l_commitdate":"1996-08-12","l_receiptdate":"1996-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"bold packages haggle furiously against th"}]' |
| 4,'EUROPE',1944711,'P',104934.65,'1995-05-06','1-URGENT','Clerk#000000580',0,'deas wake. slyly silent packa','[{"l_partkey":66583,"l_suppkey":4102,"l_linenumber":1,"l_quantity":37.00,"l_extendedprice":57334.46,"l_discount":0.03,"l_tax":0.00,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-05-15","l_commitdate":"1995-07-29","l_receiptdate":"1995-05-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"ular forges. slyly ev"},{"l_partkey":48820,"l_suppkey":3829,"l_linenumber":2,"l_quantity":15.00,"l_extendedprice":26532.30,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-08-06","l_commitdate":"1995-06-20","l_receiptdate":"1995-09-04","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"into beans according to the slyl"},{"l_partkey":103892,"l_suppkey":8913,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":24646.57,"l_discount":0.10,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-16","l_commitdate":"1995-06-28","l_receiptdate":"1995-07-31","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":", final instructions."}]' |
| 4,'EUROPE',1226497,'F',88317.19,'1993-10-04','1-URGENT','Clerk#000000154',0,'al theodolites. quickly ruthless accounts lose blithely furiously re','[{"l_partkey":101559,"l_suppkey":4070,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":49937.60,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-11-02","l_commitdate":"1993-12-04","l_receiptdate":"1993-11-22","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":". final, unusual deposits cajole slowly. i"},{"l_partkey":98547,"l_suppkey":6075,"l_linenumber":2,"l_quantity":27.00,"l_extendedprice":41729.58,"l_discount":0.06,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-01-09","l_commitdate":"1993-12-10","l_receiptdate":"1994-01-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"e quickly along th"}]' |
| 2,'EUROPE',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 2,'EUROPE',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 2,'EUROPE',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 2,'EUROPE',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| 1,'AMERICA',454791,'F',74602.81,'1992-04-19','1-URGENT','Clerk#000000815',0,'uriously ironic deposits wake across the s','[{"l_partkey":98296,"l_suppkey":5824,"l_linenumber":1,"l_quantity":40.00,"l_extendedprice":51771.60,"l_discount":0.05,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-06-24","l_commitdate":"1992-06-20","l_receiptdate":"1992-07-11","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" busy theodol"},{"l_partkey":52971,"l_suppkey":487,"l_linenumber":2,"l_quantity":13.00,"l_extendedprice":25011.61,"l_discount":0.10,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-02","l_commitdate":"1992-05-19","l_receiptdate":"1992-05-10","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ily silent id"}]' |
| 1,'AMERICA',5133509,'O',174645.94,'1996-07-01','1-URGENT','Clerk#000000463',0,'al accounts could have to cajole furiously even','[{"l_partkey":196216,"l_suppkey":6217,"l_linenumber":1,"l_quantity":28.00,"l_extendedprice":36741.88,"l_discount":0.02,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-19","l_commitdate":"1996-09-07","l_receiptdate":"1996-09-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"encies nag quickly regular, special de"},{"l_partkey":198707,"l_suppkey":6265,"l_linenumber":2,"l_quantity":35.00,"l_extendedprice":63199.50,"l_discount":0.06,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-12","l_commitdate":"1996-09-24","l_receiptdate":"1996-08-28","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" haggle furiously acr"},{"l_partkey":60989,"l_suppkey":6002,"l_linenumber":3,"l_quantity":12.00,"l_extendedprice":23399.76,"l_discount":0.05,"l_tax":0.00,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-28","l_commitdate":"1996-08-07","l_receiptdate":"1996-10-24","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"the, final dependencies sleep. f"},{"l_partkey":31696,"l_suppkey":1697,"l_linenumber":4,"l_quantity":33.00,"l_extendedprice":53713.77,"l_discount":0.07,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-16","l_commitdate":"1996-09-16","l_receiptdate":"1996-08-30","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"ites use across the fluffily regula"}]' |
| 4,'AMERICA',1192231,'O',143971.54,'1996-06-03','1-URGENT','Clerk#000000978',0,'osits haggle carefully. carefully final grouches are. blithely si','[{"l_partkey":103367,"l_suppkey":3368,"l_linenumber":1,"l_quantity":29.00,"l_extendedprice":39740.44,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-06","l_commitdate":"1996-08-24","l_receiptdate":"1996-06-15","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"across the blithe"},{"l_partkey":86763,"l_suppkey":1780,"l_linenumber":2,"l_quantity":9.00,"l_extendedprice":15747.84,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-22","l_receiptdate":"1996-10-09","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"careful accounts. even ideas haggle aga"},{"l_partkey":10325,"l_suppkey":326,"l_linenumber":3,"l_quantity":15.00,"l_extendedprice":18529.80,"l_discount":0.04,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-25","l_commitdate":"1996-07-31","l_receiptdate":"1996-09-30","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":" the furiously furious deposits wake fur"},{"l_partkey":117347,"l_suppkey":4881,"l_linenumber":4,"l_quantity":2.00,"l_extendedprice":2728.68,"l_discount":0.08,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-10","l_commitdate":"1996-07-24","l_receiptdate":"1996-07-12","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"osits. fluffily regular courts sle"},{"l_partkey":43478,"l_suppkey":8487,"l_linenumber":5,"l_quantity":26.00,"l_extendedprice":36958.22,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-19","l_commitdate":"1996-08-18","l_receiptdate":"1996-06-23","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"fully regular instructions"},{"l_partkey":120368,"l_suppkey":369,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":26378.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-14","l_commitdate":"1996-08-12","l_receiptdate":"1996-07-16","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"bold packages haggle furiously against th"}]' |
| 4,'AMERICA',1944711,'P',104934.65,'1995-05-06','1-URGENT','Clerk#000000580',0,'deas wake. slyly silent packa','[{"l_partkey":66583,"l_suppkey":4102,"l_linenumber":1,"l_quantity":37.00,"l_extendedprice":57334.46,"l_discount":0.03,"l_tax":0.00,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1995-05-15","l_commitdate":"1995-07-29","l_receiptdate":"1995-05-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"ular forges. slyly ev"},{"l_partkey":48820,"l_suppkey":3829,"l_linenumber":2,"l_quantity":15.00,"l_extendedprice":26532.30,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-08-06","l_commitdate":"1995-06-20","l_receiptdate":"1995-09-04","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"into beans according to the slyl"},{"l_partkey":103892,"l_suppkey":8913,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":24646.57,"l_discount":0.10,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1995-07-16","l_commitdate":"1995-06-28","l_receiptdate":"1995-07-31","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":", final instructions."}]' |
| 4,'AMERICA',1226497,'F',88317.19,'1993-10-04','1-URGENT','Clerk#000000154',0,'al theodolites. quickly ruthless accounts lose blithely furiously re','[{"l_partkey":101559,"l_suppkey":4070,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":49937.60,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-11-02","l_commitdate":"1993-12-04","l_receiptdate":"1993-11-22","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":". final, unusual deposits cajole slowly. i"},{"l_partkey":98547,"l_suppkey":6075,"l_linenumber":2,"l_quantity":27.00,"l_extendedprice":41729.58,"l_discount":0.06,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-01-09","l_commitdate":"1993-12-10","l_receiptdate":"1994-01-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"e quickly along th"}]' |
| 2,'AMERICA',1763205,'F',16495.33,'1994-08-28','1-URGENT','Clerk#000000450',0,'ven requests. blithely express excuses nag or','[{"l_partkey":12629,"l_suppkey":5131,"l_linenumber":1,"l_quantity":10.00,"l_extendedprice":15416.20,"l_discount":0.00,"l_tax":0.07,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-10-30","l_commitdate":"1994-10-24","l_receiptdate":"1994-11-23","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":". fluffily regular packages "}]' |
| 2,'AMERICA',1374019,'F',167016.61,'1992-04-05','1-URGENT','Clerk#000000440',0,'lithe packages. acco','[{"l_partkey":45052,"l_suppkey":7557,"l_linenumber":1,"l_quantity":39.00,"l_extendedprice":38884.95,"l_discount":0.07,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-01","l_commitdate":"1992-05-20","l_receiptdate":"1992-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"special, special deposits among the f"},{"l_partkey":178552,"l_suppkey":1070,"l_linenumber":2,"l_quantity":1.00,"l_extendedprice":1630.55,"l_discount":0.10,"l_tax":0.00,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-06-21","l_commitdate":"1992-05-26","l_receiptdate":"1992-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"en theodolites. furiously unus"},{"l_partkey":111572,"l_suppkey":6595,"l_linenumber":3,"l_quantity":13.00,"l_extendedprice":20586.41,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1992-05-10","l_commitdate":"1992-06-25","l_receiptdate":"1992-05-30","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"furiously ac"},{"l_partkey":182631,"l_suppkey":7668,"l_linenumber":4,"l_quantity":42.00,"l_extendedprice":71972.46,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-07-06","l_commitdate":"1992-06-28","l_receiptdate":"1992-08-05","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"deposits sleep across the ironic deposits"},{"l_partkey":62432,"l_suppkey":9951,"l_linenumber":5,"l_quantity":33.00,"l_extendedprice":46016.19,"l_discount":0.10,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1992-05-20","l_commitdate":"1992-06-03","l_receiptdate":"1992-05-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"e slyly even instructions. furiously i"}]' |
| 2,'AMERICA',1842406,'O',174291.41,'1996-08-05','1-URGENT','Clerk#000000521',0,'s. excuses lose. pen','[{"l_partkey":84138,"l_suppkey":6647,"l_linenumber":1,"l_quantity":13.00,"l_extendedprice":14587.69,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-11-30","l_commitdate":"1996-10-15","l_receiptdate":"1996-12-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"idle, bold requests wake fluff"},{"l_partkey":105207,"l_suppkey":2738,"l_linenumber":2,"l_quantity":6.00,"l_extendedprice":7273.20,"l_discount":0.00,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-05","l_commitdate":"1996-09-24","l_receiptdate":"1996-09-11","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"le blithely: express, bold accounts sl"},{"l_partkey":10233,"l_suppkey":7737,"l_linenumber":3,"l_quantity":7.00,"l_extendedprice":8002.61,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-23","l_commitdate":"1996-11-01","l_receiptdate":"1996-11-14","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":"lyly. regular ideas a"},{"l_partkey":177150,"l_suppkey":2185,"l_linenumber":4,"l_quantity":48.00,"l_extendedprice":58903.20,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-08-17","l_commitdate":"1996-09-07","l_receiptdate":"1996-08-28","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"TRUCK","l_comment":"ms haggle according to the un"},{"l_partkey":159230,"l_suppkey":1746,"l_linenumber":5,"l_quantity":40.00,"l_extendedprice":51569.20,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-13","l_commitdate":"1996-10-20","l_receiptdate":"1996-10-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s haggle. express, regular packages amon"},{"l_partkey":166502,"l_suppkey":1535,"l_linenumber":6,"l_quantity":19.00,"l_extendedprice":29801.50,"l_discount":0.05,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-10-17","l_commitdate":"1996-10-08","l_receiptdate":"1996-11-09","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":"onic theodolites integrate among the furio"}]' |
| 2,'AMERICA',3986496,'O',312692.22,'1997-02-22','1-URGENT','Clerk#000000768',0,'. theodolites nag fluffily above the blithely iron','[{"l_partkey":14260,"l_suppkey":4261,"l_linenumber":1,"l_quantity":32.00,"l_extendedprice":37576.32,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-04","l_commitdate":"1997-04-01","l_receiptdate":"1997-06-12","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"olites. packages bel"},{"l_partkey":57360,"l_suppkey":2371,"l_linenumber":2,"l_quantity":21.00,"l_extendedprice":27664.56,"l_discount":0.03,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-10","l_commitdate":"1997-05-14","l_receiptdate":"1997-04-18","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"lar dependencies"},{"l_partkey":36515,"l_suppkey":4025,"l_linenumber":3,"l_quantity":49.00,"l_extendedprice":71123.99,"l_discount":0.01,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-06","l_commitdate":"1997-04-13","l_receiptdate":"1997-03-09","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"y regular foxes. furiously e"},{"l_partkey":94207,"l_suppkey":6717,"l_linenumber":4,"l_quantity":30.00,"l_extendedprice":36036.00,"l_discount":0.03,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-03","l_commitdate":"1997-04-04","l_receiptdate":"1997-04-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"slyly ironic foxes "},{"l_partkey":128461,"l_suppkey":8462,"l_linenumber":5,"l_quantity":28.00,"l_extendedprice":41704.88,"l_discount":0.04,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-09","l_commitdate":"1997-05-09","l_receiptdate":"1997-06-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"y special t"},{"l_partkey":41797,"l_suppkey":6806,"l_linenumber":6,"l_quantity":14.00,"l_extendedprice":24343.06,"l_discount":0.10,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-28","l_commitdate":"1997-04-01","l_receiptdate":"1997-04-02","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"ly according to the carefull"},{"l_partkey":76510,"l_suppkey":9018,"l_linenumber":7,"l_quantity":44.00,"l_extendedprice":65406.44,"l_discount":0.04,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-08","l_commitdate":"1997-03-31","l_receiptdate":"1997-04-02","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ress requests solve b"}]' |
| ---- TYPES |
| BIGINT, STRING, BIGINT, STRING, DECIMAL, STRING, STRING, STRING, INT, STRING, STRING |
| ==== |
