完成 TPCH 测试

完成 TPCH 测试

TPC Benchmark™H（TPC-H）是决策支持基准。它由一套面向业务的即时查询（ad-hoc）和并发数据修改组成。选择查询和填充数据库的数据具有广泛的行业相关性。该基准测试解释说明了决策支持系统，该系统可检查大量数据，执行高度复杂的查询并为关键业务问题提供答案。TPC-H 是 OLAP 数据库广泛使用的基准测试。

通过阅读本教程，您将学习如何使用 MatrixOne 完成 TPC-H 测试。

开始前准备

确保你已经完成了单机部署 MatrixOne。

1. 编译 dbgen

默认情况下，TPCH dbgen 实用程序是用来生成测试数据集表格的工具，它根据比例因子 Scale Factor（SF) 的大小确定数据集的大小，并生成一组平面文件（Flat File)，这些文件适合加载到 tpch 模式中。

当使用 -s 1 时 dbgen 命令会产生 1GB 的完整数据集，当使用 -s 10 时会产生大约 10GB 的数据集，以此类推。

1. git clone https://github.com/electrum/tpch-dbgen.git
2. cd tpch-dbgen
3. make

2. 生成数据

运行 dbgen，获得适当的数据库大小因子 (在示例中为 1GB)。

1. ./dbgen -s 1

生成完整数据集可能需要一段时间。完成后，您可以看到结果文件。

1. total 2150000
2. -rw-r--r--  1 deister  staff   24346144 13 may 12:05 customer.tbl
3. -rw-r--r--  1 deister  staff  759863287 13 may 12:05 lineitem.tbl
4. -rw-r--r--  1 deister  staff       2224 13 may 12:05 nation.tbl
5. -rw-r--r--  1 deister  staff  171952161 13 may 12:05 orders.tbl
6. -rw-r--r--  1 deister  staff   24135125 13 may 12:05 part.tbl
7. -rw-r--r--  1 deister  staff  118984616 13 may 12:05 partsupp.tbl
8. -rw-r--r--  1 deister  staff        389 13 may 12:05 region.tbl
9. -rw-r--r--  1 deister  staff    1409184 13 may 12:05 supplier.tbl

我们同时也准备了 1GB 的数据集供您下载。您可以在以下链接中直接获取数据文件：

1. https://community-shared-data-1308875761.cos.ap-beijing.myqcloud.com/tpch/tpch-1g.zip

3. 在 MatrixOne 中建表

MatrixOne 暂不支持分区加速，LINEITEM 表的创建代码有以下修改：

移除了 LINEITEM 表的 PARTITION BY KEY()。

1. drop database if exists TPCH;
2. create database if not exists TPCH;
3. use tpch;
4. CREATE TABLE NATION(
5. N_NATIONKEY  INTEGER NOT NULL,
6. N_NAME       CHAR(25) NOT NULL,
7. N_REGIONKEY  INTEGER NOT NULL,
8. N_COMMENT    VARCHAR(152),
9. PRIMARY KEY (N_NATIONKEY)
10. );

12. CREATE TABLE REGION(
13. R_REGIONKEY  INTEGER NOT NULL,
14. R_NAME       CHAR(25) NOT NULL,
15. R_COMMENT    VARCHAR(152),
16. PRIMARY KEY (R_REGIONKEY)
17. );

19. CREATE TABLE PART(
20. P_PARTKEY     INTEGER NOT NULL,
21. P_NAME        VARCHAR(55) NOT NULL,
22. P_MFGR        CHAR(25) NOT NULL,
23. P_BRAND       CHAR(10) NOT NULL,
24. P_TYPE        VARCHAR(25) NOT NULL,
25. P_SIZE        INTEGER NOT NULL,
26. P_CONTAINER   CHAR(10) NOT NULL,
27. P_RETAILPRICE DECIMAL(15,2) NOT NULL,
28. P_COMMENT     VARCHAR(23) NOT NULL,
29. PRIMARY KEY (P_PARTKEY)
30. );

32. CREATE TABLE SUPPLIER(
33. S_SUPPKEY     INTEGER NOT NULL,
34. S_NAME        CHAR(25) NOT NULL,
35. S_ADDRESS     VARCHAR(40) NOT NULL,
36. S_NATIONKEY   INTEGER NOT NULL,
37. S_PHONE       CHAR(15) NOT NULL,
38. S_ACCTBAL     DECIMAL(15,2) NOT NULL,
39. S_COMMENT     VARCHAR(101) NOT NULL,
40. PRIMARY KEY (S_SUPPKEY)
41. );

43. CREATE TABLE PARTSUPP (
44. PS_PARTKEY INTEGER NOT NULL,
45. PS_SUPPKEY INTEGER NOT NULL,
46. PS_AVAILQTY INTEGER NOT NULL,
47. PS_SUPPLYCOST DECIMAL(15,2) NOT NULL,
48. PS_COMMENT VARCHAR(199) NOT NULL,
49. PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY)
50. );

52. CREATE TABLE CUSTOMER(
53. C_CUSTKEY     INTEGER NOT NULL,
54. C_NAME        VARCHAR(25) NOT NULL,
55. C_ADDRESS     VARCHAR(40) NOT NULL,
56. C_NATIONKEY   INTEGER NOT NULL,
57. C_PHONE       CHAR(15) NOT NULL,
58. C_ACCTBAL     DECIMAL(15,2)   NOT NULL,
59. C_MKTSEGMENT  CHAR(10) NOT NULL,
60. C_COMMENT     VARCHAR(117) NOT NULL,
61. PRIMARY KEY (C_CUSTKEY)
62. );

64. CREATE TABLE ORDERS(
65. O_ORDERKEY       BIGINT NOT NULL,
66. O_CUSTKEY        INTEGER NOT NULL,
67. O_ORDERSTATUS    CHAR(1) NOT NULL,
68. O_TOTALPRICE     DECIMAL(15,2) NOT NULL,
69. O_ORDERDATE      DATE NOT NULL,
70. O_ORDERPRIORITY  CHAR(15) NOT NULL,
71. O_CLERK          CHAR(15) NOT NULL,
72. O_SHIPPRIORITY   INTEGER NOT NULL,
73. O_COMMENT        VARCHAR(79) NOT NULL,
74. PRIMARY KEY (O_ORDERKEY)
75. );

77. CREATE TABLE LINEITEM (
78. L_ORDERKEY BIGINT NOT NULL,
79. L_PARTKEY INTEGER NOT NULL,
80. L_SUPPKEY INTEGER NOT NULL,
81. L_LINENUMBER INTEGER NOT NULL,
82. L_QUANTITY DECIMAL(15,2) NOT NULL,
83. L_EXTENDEDPRICE DECIMAL(15,2) NOT NULL,
84. L_DISCOUNT DECIMAL(15,2) NOT NULL,
85. L_TAX DECIMAL(15,2) NOT NULL,
86. L_RETURNFLAG CHAR(1) NOT NULL,
87. L_LINESTATUS CHAR(1) NOT NULL,
88. L_SHIPDATE DATE NOT NULL,
89. L_COMMITDATE DATE NOT NULL,
90. L_RECEIPTDATE DATE NOT NULL,
91. L_SHIPINSTRUCT CHAR(25) NOT NULL,
92. L_SHIPMODE CHAR(10) NOT NULL,
93. L_COMMENT VARCHAR(44) NOT NULL,
94. PRIMARY KEY (L_ORDERKEY, L_LINENUMBER)
95. );

4. 导入数据

在 MatrixOne 中使用以下命令将数据加载到相关的表中。

1. load data infile '/YOUR_TPCH_DATA_PATH/nation.tbl' into table NATION FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

3. load data infile '/YOUR_TPCH_DATA_PATH/region.tbl' into table REGION FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

5. load data infile '/YOUR_TPCH_DATA_PATH/part.tbl' into table PART FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

7. load data infile '/YOUR_TPCH_DATA_PATH/supplier.tbl' into table SUPPLIER FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

9. load data infile '/YOUR_TPCH_DATA_PATH/partsupp.tbl' into table PARTSUPP FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

11. load data infile '/YOUR_TPCH_DATA_PATH/orders.tbl' into table ORDERS FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

13. load data infile '/YOUR_TPCH_DATA_PATH/customer.tbl' into table CUSTOMER FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

15. load data infile '/YOUR_TPCH_DATA_PATH/lineitem.tbl' into table LINEITEM FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

加载完成后，可以使用创建的表查询 MatrixOne 中的数据。

5. 运行 TPCH 测试命令

1. -- Q1
2. select
3. l_returnflag,
4. l_linestatus,
5. sum(l_quantity) as sum_qty,
6. sum(l_extendedprice) as sum_base_price,
7. sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
8. sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
9. avg(l_quantity) as avg_qty,
10. avg(l_extendedprice) as avg_price,
11. avg(l_discount) as avg_disc,
12. count(*) as count_order
13. from
14. lineitem
15. where
16. l_shipdate <= date '1998-12-01' - interval '112' day
17. group by
18. l_returnflag,
19. l_linestatus
20. order by
21. l_returnflag,
22. l_linestatus
23. ;

25. -- Q2
26. select
27. s_acctbal,
28. s_name,
29. n_name,
30. p_partkey,
31. p_mfgr,
32. s_address,
33. s_phone,
34. s_comment
35. from
36. part,
37. supplier,
38. partsupp,
39. nation,
40. region
41. where
42. p_partkey = ps_partkey
43. and s_suppkey = ps_suppkey
44. and p_size = 48
45. and p_type like '%TIN'
46. and s_nationkey = n_nationkey
47. and n_regionkey = r_regionkey
48. and r_name = 'MIDDLE EAST'
49. and ps_supplycost = (
50. select
51. min(ps_supplycost)
52. from
53. partsupp,
54. supplier,
55. nation,
56. region
57. where
58. p_partkey = ps_partkey
59. and s_suppkey = ps_suppkey
60. and s_nationkey = n_nationkey
61. and n_regionkey = r_regionkey
62. and r_name = 'MIDDLE EAST'
63. )
64. order by
65. s_acctbal desc,
66. n_name,
67. s_name,
68. p_partkey
69. limit 100
70. ;

73. -- Q3
74. select
75. l_orderkey,
76. sum(l_extendedprice * (1 - l_discount)) as revenue,
77. o_orderdate,
78. o_shippriority
79. from
80. customer,
81. orders,
82. lineitem
83. where
84. c_mktsegment = 'HOUSEHOLD'
85. and c_custkey = o_custkey
86. and l_orderkey = o_orderkey
87. and o_orderdate < date '1995-03-29'
88. and l_shipdate > date '1995-03-29'
89. group by
90. l_orderkey,
91. o_orderdate,
92. o_shippriority
93. order by
94. revenue desc,
95. o_orderdate
96. limit 10
97. ;

99. -- Q4
100. select
101. o_orderpriority,
102. count(*) as order_count
103. from
104. orders
105. where
106. o_orderdate >= date '1997-07-01'
107. and o_orderdate < date '1997-07-01' + interval '3' month
108. and exists (
109. select
110. *
111. from
112. lineitem
113. where
114. l_orderkey = o_orderkey
115. and l_commitdate < l_receiptdate
116. )
117. group by
118. o_orderpriority
119. order by
120. o_orderpriority
121. ;

124. -- Q5
125. select
126. n_name,
127. sum(l_extendedprice * (1 - l_discount)) as revenue
128. from
129. customer,
130. orders,
131. lineitem,
132. supplier,
133. nation,
134. region
135. where
136. c_custkey = o_custkey
137. and l_orderkey = o_orderkey
138. and l_suppkey = s_suppkey
139. and c_nationkey = s_nationkey
140. and s_nationkey = n_nationkey
141. and n_regionkey = r_regionkey
142. and r_name = 'AMERICA'
143. and o_orderdate >= date '1994-01-01'
144. and o_orderdate < date '1994-01-01' + interval '1' year
145. group by
146. n_name
147. order by
148. revenue desc
149. ;

152. -- Q6
153. select
154. sum(l_extendedprice * l_discount) as revenue
155. from
156. lineitem
157. where
158. l_shipdate >= date '1994-01-01'
159. and l_shipdate < date '1994-01-01' + interval '1' year
160. and l_discount between 0.03 - 0.01 and 0.03 + 0.01
161. and l_quantity < 24;

163. -- Q7
164. select
165. supp_nation,
166. cust_nation,
167. l_year,
168. sum(volume) as revenue
169. from
170. (
171. select
172. n1.n_name as supp_nation,
173. n2.n_name as cust_nation,
174. extract(year from l_shipdate) as l_year,
175. l_extendedprice * (1 - l_discount) as volume
176. from
177. supplier,
178. lineitem,
179. orders,
180. customer,
181. nation n1,
182. nation n2
183. where
184. s_suppkey = l_suppkey
185. and o_orderkey = l_orderkey
186. and c_custkey = o_custkey
187. and s_nationkey = n1.n_nationkey
188. and c_nationkey = n2.n_nationkey
189. and (
190. (n1.n_name = 'FRANCE' and n2.n_name = 'ARGENTINA')
191. or (n1.n_name = 'ARGENTINA' and n2.n_name = 'FRANCE')
192. )
193. and l_shipdate between date '1995-01-01' and date '1996-12-31'
194. ) as shipping
195. group by
196. supp_nation,
197. cust_nation,
198. l_year
199. order by
200. supp_nation,
201. cust_nation,
202. l_year
203. ;

205. -- Q8
206. select
207. o_year,
208. (sum(case
209. when nation = 'ARGENTINA' then volume
210. else 0
211. end) / sum(volume)) as mkt_share
212. from
213. (
214. select
215. extract(year from o_orderdate) as o_year,
216. l_extendedprice * (1 - l_discount) as volume,
217. n2.n_name as nation
218. from
219. part,
220. supplier,
221. lineitem,
222. orders,
223. customer,
224. nation n1,
225. nation n2,
226. region
227. where
228. p_partkey = l_partkey
229. and s_suppkey = l_suppkey
230. and l_orderkey = o_orderkey
231. and o_custkey = c_custkey
232. and c_nationkey = n1.n_nationkey
233. and n1.n_regionkey = r_regionkey
234. and r_name = 'AMERICA'
235. and s_nationkey = n2.n_nationkey
236. and o_orderdate between date '1995-01-01' and date '1996-12-31'
237. and p_type = 'ECONOMY BURNISHED TIN'
238. ) as all_nations
239. group by
240. o_year
241. order by
242. o_year
243. ;

245. -- Q9
246. select
247. nation,
248. o_year,
249. sum(amount) as sum_profit
250. from
251. (
252. select
253. n_name as nation,
254. extract(year from o_orderdate) as o_year,
255. l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
256. from
257. part,
258. supplier,
259. lineitem,
260. partsupp,
261. orders,
262. nation
263. where
264. s_suppkey = l_suppkey
265. and ps_suppkey = l_suppkey
266. and ps_partkey = l_partkey
267. and p_partkey = l_partkey
268. and o_orderkey = l_orderkey
269. and s_nationkey = n_nationkey
270. and p_name like '%pink%'
271. ) as profit
272. group by
273. nation,
274. o_year
275. order by
276. nation,
277. o_year desc
278. ;

281. -- Q10
282. select
283. c_custkey,
284. c_name,
285. sum(l_extendedprice * (1 - l_discount)) as revenue,
286. c_acctbal,
287. n_name,
288. c_address,
289. c_phone,
290. c_comment
291. from
292. customer,
293. orders,
294. lineitem,
295. nation
296. where
297. c_custkey = o_custkey
298. and l_orderkey = o_orderkey
299. and o_orderdate >= date '1993-03-01'
300. and o_orderdate < date '1993-03-01' + interval '3' month
301. and l_returnflag = 'R'
302. and c_nationkey = n_nationkey
303. group by
304. c_custkey,
305. c_name,
306. c_acctbal,
307. c_phone,
308. n_name,
309. c_address,
310. c_comment
311. order by
312. revenue desc
313. limit 20
314. ;

317. -- Q11
318. select
319. ps_partkey,
320. sum(ps_supplycost * ps_availqty) as value
321. from
322. partsupp,
323. supplier,
324. nation
325. where
326. ps_suppkey = s_suppkey
327. and s_nationkey = n_nationkey
328. and n_name = 'JAPAN'
329. group by
330. ps_partkey having
331. sum(ps_supplycost * ps_availqty) > (
332. select
333. sum(ps_supplycost * ps_availqty) * 0.0001000000
334. from
335. partsupp,
336. supplier,nation
337. where
338. ps_suppkey = s_suppkey
339. and s_nationkey = n_nationkey
340. and n_name = 'JAPAN'
341. )
342. order by
343. value desc
344. ;

346. -- Q12
347. select
348. l_shipmode,
349. sum(case
350. when o_orderpriority = '1-URGENT'
351. or o_orderpriority = '2-HIGH'
352. then 1
353. else 0
354. end) as high_line_count,
355. sum(case
356. when o_orderpriority <> '1-URGENT'
357. and o_orderpriority <> '2-HIGH'
358. then 1
359. else 0
360. end) as low_line_count
361. from
362. orders,
363. lineitem
364. where
365. o_orderkey = l_orderkey
366. and l_shipmode in ('FOB', 'TRUCK')
367. and l_commitdate < l_receiptdate
368. and l_shipdate < l_commitdate
369. and l_receiptdate >= date '1996-01-01'
370. and l_receiptdate < date '1996-01-01' + interval '1' year
371. group by
372. l_shipmode
373. order by
374. l_shipmode
375. ;

377. -- Q13
378. select
379. c_count,
380. count(*) as custdist
381. from
382. (
383. select
384. c_custkey,
385. count(o_orderkey)
386. from
387. customer left outer join orders on
388. c_custkey = o_custkey
389. and o_comment not like '%pending%accounts%'
390. group by
391. c_custkey
392. ) as c_orders (c_custkey, c_count)
393. group by
394. c_count
395. order by
396. custdist desc,
397. c_count desc
398. ;

400. -- Q14
401. select
402. 100.00 * sum(case
403. when p_type like 'PROMO%'
404. then l_extendedprice * (1 - l_discount)
405. else 0
406. end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
407. from
408. lineitem,
409. part
410. where
411. l_partkey = p_partkey
412. and l_shipdate >= date '1996-04-01'
413. and l_shipdate < date '1996-04-01' + interval '1' month;

415. -- Q15
416. with q15_revenue0 as (
417. select
418. l_suppkey as supplier_no,
419. sum(l_extendedprice * (1 - l_discount)) as total_revenue
420. from
421. lineitem
422. where
423. l_shipdate >= date '1995-12-01'
424. and l_shipdate < date '1995-12-01' + interval '3' month
425. group by
426. l_suppkey
427. )
428. select
429. s_suppkey,
430. s_name,
431. s_address,
432. s_phone,
433. total_revenue
434. from
435. supplier,
436. q15_revenue0
437. where
438. s_suppkey = supplier_no
439. and total_revenue = (
440. select
441. max(total_revenue)
442. from
443. q15_revenue0
444. )
445. order by
446. s_suppkey
447. ;

449. -- Q16
450. select
451. p_brand,
452. p_type,
453. p_size,
454. count(distinct ps_suppkey) as supplier_cnt
455. from
456. partsupp,
457. part
458. where
459. p_partkey = ps_partkey
460. and p_brand <> 'Brand#35'
461. and p_type not like 'ECONOMY BURNISHED%'
462. and p_size in (14, 7, 21, 24, 35, 33, 2, 20)
463. and ps_suppkey not in (
464. select
465. s_suppkey
466. from
467. supplier
468. where
469. s_comment like '%Customer%Complaints%'
470. )
471. group by
472. p_brand,
473. p_type,
474. p_size
475. order by
476. supplier_cnt desc,
477. p_brand,
478. p_type,
479. p_size
480. ;

482. -- Q17
483. select
484. sum(l_extendedprice) / 7.0 as avg_yearly
485. from
486. lineitem,
487. part
488. where
489. p_partkey = l_partkey
490. and p_brand = 'Brand#54'
491. and p_container = 'LG BAG'
492. and l_quantity < (
493. select
494. 0.2 * avg(l_quantity)
495. from
496. lineitem
497. where
498. l_partkey = p_partkey
499. );

501. -- Q18
502. select
503. c_name,
504. c_custkey,
505. o_orderkey,
506. o_orderdate,
507. o_totalprice,
508. sum(l_quantity)
509. from
510. customer,
511. orders,
512. lineitem
513. where
514. o_orderkey in (
515. select
516. l_orderkey
517. from
518. lineitem
519. group by
520. l_orderkey having
521. sum(l_quantity) > 314
522. )
523. and c_custkey = o_custkey
524. and o_orderkey = l_orderkey
525. group by
526. c_name,
527. c_custkey,
528. o_orderkey,
529. o_orderdate,
530. o_totalprice
531. order by
532. o_totalprice desc,
533. o_orderdate
534. limit 100
535. ;

537. -- Q19
538. select
539. sum(l_extendedprice* (1 - l_discount)) as revenue
540. from
541. lineitem,
542. part
543. where
544. (
545. p_partkey = l_partkey
546. and p_brand = 'Brand#23'
547. and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
548. and l_quantity >= 5 and l_quantity <= 5 + 10
549. and p_size between 1 and 5
550. and l_shipmode in ('AIR', 'AIR REG')
551. and l_shipinstruct = 'DELIVER IN PERSON'
552. )
553. or
554. (
555. p_partkey = l_partkey
556. and p_brand = 'Brand#15'
557. and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
558. and l_quantity >= 14 and l_quantity <= 14 + 10
559. and p_size between 1 and 10
560. and l_shipmode in ('AIR', 'AIR REG')
561. and l_shipinstruct = 'DELIVER IN PERSON'
562. )
563. or
564. (
565. p_partkey = l_partkey
566. and p_brand = 'Brand#44'
567. and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
568. and l_quantity >= 28 and l_quantity <= 28 + 10
569. and p_size between 1 and 15
570. and l_shipmode in ('AIR', 'AIR REG')
571. and l_shipinstruct = 'DELIVER IN PERSON'
572. );

574. -- Q20
575. select
576. s_name,
577. s_address
578. from
579. supplier,
580. nation
581. where
582. s_suppkey in (
583. select
584. ps_suppkey
585. from
586. partsupp
587. where
588. ps_partkey in (
589. select
590. p_partkey
591. from
592. part
593. where
594. p_name like 'lime%'
595. )
596. and ps_availqty > (
597. select
598. 0.5 * sum(l_quantity)
599. from
600. lineitem
601. where
602. l_partkey = ps_partkey
603. and l_suppkey = ps_suppkey
604. and l_shipdate >= date '1993-01-01'
605. and l_shipdate < date '1993-01-01' + interval '1' year
606. )
607. )
608. and s_nationkey = n_nationkey
609. and n_name = 'VIETNAM'
610. order by s_name
611. ;

613. -- Q21
614. select
615. s_name,
616. count(*) as numwait
617. from
618. supplier,
619. lineitem l1,
620. orders,
621. nation
622. where
623. s_suppkey = l1.l_suppkey
624. and o_orderkey = l1.l_orderkey
625. and o_orderstatus = 'F'
626. and l1.l_receiptdate > l1.l_commitdate
627. and exists (
628. select
629. *
630. from
631. lineitem l2
632. where
633. l2.l_orderkey = l1.l_orderkey
634. and l2.l_suppkey <> l1.l_suppkey
635. )
636. and not exists (
637. select
638. *
639. from
640. lineitem l3
641. where
642. l3.l_orderkey = l1.l_orderkey
643. and l3.l_suppkey <> l1.l_suppkey
644. and l3.l_receiptdate > l3.l_commitdate
645. )
646. and s_nationkey = n_nationkey
647. and n_name = 'BRAZIL'
648. group by
649. s_name
650. order by
651. numwait desc,
652. s_name
653. limit 100
654. ;

656. -- Q22
657. select
658. cntrycode,
659. count(*) as numcust,
660. sum(c_acctbal) as totacctbal
661. from
662. (
663. select
664. substring(c_phone from 1 for 2) as cntrycode,
665. c_acctbal
666. from
667. customer
668. where
669. substring(c_phone from 1 for 2) in
670. ('10', '11', '26', '22', '19', '20', '27')
671. and c_acctbal > (
672. select
673. avg(c_acctbal)
674. from
675. customer
676. where
677. c_acctbal > 0.00
678. and substring(c_phone from 1 for 2) in
679. ('10', '11', '26', '22', '19', '20', '27')
680. )
681. and not exists (
682. select
683. *
684. from
685. orders
686. where
687. o_custkey = c_custkey
688. )
689. ) as custsale
690. group by
691. cntrycode
692. order by
693. cntrycode
694. ;

6. 运行预期结果

以下为 22 个 TPCH 查询的预期结果。

说明：由于 Q16 的结果段落过长，无法在下文展示，请参阅此连结的完整结果：Q16 运行预期结果

``` 1. Q1 2. +--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+ 3. | l_returnflag | l_linestatus | sum_qty | sum_base_price | sum_disc_price | sum_charge | avg_qty | avg_price | avg_disc | count_order | 4. +--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+ 5. | A | F | 37734107.00 | 56586554400.73 | 53758257134.8700 | 55909065222.827692 | 25.52200585 | 38273.12973462 | 0.04998530 | 1478493 | 6. | N | F | 991417.00 | 1487504710.38 | 1413082168.0541 | 1469649223.194375 | 25.51647192 | 38284.46776085 | 0.05009343 | 38854 | 7. | N | O | 73295769.00 | 109931611187.71 | 104436646745.0693 | 108617847377.142872 | 25.50176452 | 38248.45691074 | 0.04999662 | 2874145 | 8. | R | F | 37719753.00 | 56568041380.90 | 53741292684.6040 | 55889619119.831932 | 25.50579361 | 38250.85462610 | 0.05000941 | 1478870 | 9. +--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+ 10. 4 rows in set (0.56 sec)

Q2
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------+
| s_acctbal | s_name | n_name | p_partkey | p_mfgr | s_address | s_phone | s_comment |
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------+
| 9973.93 | Supplier#000004194 | JORDAN | 14193 | Manufacturer#1 | A8AoX9AK,qhf,CpEF | 23-944-413-2681 | t fluffily. regular requests about the regular, unusual somas play of the furiously busy |
| 9956.34 | Supplier#000005108 | IRAN | 140079 | Manufacturer#5 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882-7047 | ronic accounts. carefully bold accounts sleep beyond |
| 9836.43 | Supplier#000000489 | IRAN | 190488 | Manufacturer#2 | y9NMoYGxDUPfrB1GwjYhLtCeV7pOt | 20-375-500-2226 | quickly carefully pending accounts. fina |
| 9825.95 | Supplier#000007554 | IRAQ | 40041 | Manufacturer#5 | Huq0k qKET hByp3RcMcr | 21-787-637-9651 | ending, final requests thrash pending, |
| 9806.52 | Supplier#000005276 | IRAQ | 132762 | Manufacturer#2 | inh0KOhRfLM7WRhdRNvJJDQx | 21-834-496-7360 | the slyly unusual theodolites; carefully even accounts use slyly. sl |
| 9796.31 | Supplier#000005847 | IRAQ | 188292 | Manufacturer#1 | obol3bfh0zWi | 21-530-950-2847 | equests. blithely regular deposits should have to impress. final platelets integrate fluffily |
| 9775.37 | Supplier#000007245 | IRAQ | 169696 | Manufacturer#5 | 5VOUnvxlJeOJ | 21-663-724-2985 | ic deposits about the slyly bold requests |
| 9755.43 | Supplier#000002439 | EGYPT | 172438 | Manufacturer#5 | rXxojWV0VefSK7A0dhF | 14-410-168-5354 | p quickly packages. carefully pending pinto beans after the |
| 9714.60 | Supplier#000007317 | EGYPT | 29810 | Manufacturer#4 | nJGsPl2ruoq4Ydtv0fwWG385eOFV6 VUokbCZ | 14-666-351-2592 | ons integrate furiously? slyly ironic requests sl |
| 9557.33 | Supplier#000007367 | EGYPT | 197366 | Manufacturer#3 | bTP8DLvaRAB0n | 14-234-934-5255 | ep slyly regular accounts-- regular, regular excuses dazzle furiously about the reg |
| 9538.15 | Supplier#000000979 | IRAN | 55968 | Manufacturer#1 | cdvHjrKZR7iDlmSWU2a | 20-151-688-1408 | ckages cajole quietly carefully regular in |
| 9513.31 | Supplier#000004163 | SAUDI ARABIA | 109142 | Manufacturer#4 | 2VnQypC7pJPJRu6HzYRg7nAvhzckcYAQFbI | 30-544-852-3772 | he regular requests. blithely final |
| 9450.15 | Supplier#000002067 | EGYPT | 9566 | Manufacturer#3 | 9dO68x0XLMCUDuFk1J6k9hpvLoKx 4qasok4lIb | 14-252-246-5791 | rding to the regular dolphins. quickly ir |
| 9359.59 | Supplier#000005087 | JORDAN | 55086 | Manufacturer#4 | q0c6r9wYVQx31IeGBZKfe | 23-335-392-5204 | osits. quickly regular packages haggle among the quickly silent ins |
| 9343.35 | Supplier#000006337 | IRAN | 173819 | Manufacturer#1 | ilQgNOdCAysclt3SgODb6LeJ7d4RzYD | 20-950-345-8173 | quickly ironic packages affix aft |
| 9318.47 | Supplier#000003834 | SAUDI ARABIA | 11332 | Manufacturer#5 | cxGQnW3nShks59xA5bPoaC bIvcBWUt | 30-823-353-6520 | regular instructions. express packages run slyly pending |
| 9318.47 | Supplier#000003834 | SAUDI ARABIA | 108813 | Manufacturer#2 | cxGQnW3nShks59xA5bPoaC bIvcBWUt | 30-823-353-6520 | regular instructions. express packages run slyly pending |
| 9315.33 | Supplier#000003009 | IRAN | 40504 | Manufacturer#2 | oTbwfQ,Yfdcf3ysgc60NKtTpSIc | 20-306-556-2450 | the carefully special requests. express instructions wake |
| 9296.31 | Supplier#000008213 | JORDAN | 163180 | Manufacturer#2 | YhdN9ESxYvhJp9ngr12Bbeo4t3zLPD, | 23-197-507-9431 | g to the blithely regular accounts! deposit |
| 9284.57 | Supplier#000009781 | EGYPT | 4780 | Manufacturer#4 | 49NAd1iDiY4, | 14-410-636-4312 | its. ironic pinto beans are blithely. express depths use caref |
| 9261.13 | Supplier#000000664 | EGYPT | 125639 | Manufacturer#5 | ln6wISAnC8Bpj q4V | 14-244-772-4913 | ly special foxes cajole slyly ironic reque |
| 9260.78 | Supplier#000001949 | IRAN | 86932 | Manufacturer#2 | W79M2lpYiSY76Ujo6fSRUQiu | 20-531-767-2819 | thinly ironic excuses haggle slyly. f |
| 9227.16 | Supplier#000009461 | EGYPT | 126948 | Manufacturer#2 | Eweba 0sfaF,l4sAxXGTgEjzsJsNWWIGjYhFkRWV | 14-983-137-4957 | lly bold packages. carefully express deposits integrate about the unusual accounts. regular, |
| 9185.89 | Supplier#000007888 | EGYPT | 27887 | Manufacturer#1 | nq06Y48amPfS8YBuduy1RYu | 14-462-704-3828 | ole slyly-- blithely careful foxes wake against the furiously ironic accounts. pending ideas |
| 9185.89 | Supplier#000007888 | EGYPT | 190330 | Manufacturer#4 | nq06Y48amPfS8YBuduy1RYu | 14-462-704-3828 | ole slyly-- blithely careful foxes wake against the furiously ironic accounts. pending ideas |
| 9132.92 | Supplier#000007878 | IRAN | 92859 | Manufacturer#3 | aq6T3tUVq1, | 20-861-274-6282 | waters cajole ironic, ironic requests. furi |
| 9058.94 | Supplier#000002789 | IRAN | 142788 | Manufacturer#4 | 7EkIldjP7M6psSWcJ11tf65GT7ZC7UaiCh | 20-842-716-4307 | s. platelets use carefully. busily regular accounts cajole fluffily above the slowly final pinto be |
| 9026.80 | Supplier#000005436 | SAUDI ARABIA | 92926 | Manufacturer#3 | 3HiusYZGYmHItExgX5VfNCdJwkW8W7R | 30-453-280-6340 | . blithely unusual requests |
| 9007.16 | Supplier#000001747 | EGYPT | 121746 | Manufacturer#3 | UyDlFjVxanP,ifej7L5jtNaubC | 14-141-360-9722 | maintain bravely across the busily express pinto beans. sometimes |
| 8846.35 | Supplier#000005446 | EGYPT | 57930 | Manufacturer#2 | Nusoq0ckv9SwnJZV8Rw2dUqE,V0ylm Bon | 14-468-853-6477 | deposits. ironic, bold ideas wake. fluffily ironic deposits must have to sleep furiously pending |
| 8837.21 | Supplier#000007210 | JORDAN | 144695 | Manufacturer#3 | G7MYkWkkJDVu,rr23aXjQCwNqZ2Vk6 | 23-560-295-1805 | en, express foxes use across the blithely bold |
| 8800.91 | Supplier#000008182 | EGYPT | 143153 | Manufacturer#5 | KGMyipBiAF00tSB99DwH | 14-658-338-3635 | thely even excuses integrate blithel |
| 8788.46 | Supplier#000003437 | IRAN | 118414 | Manufacturer#4 | JfgZDO9fsP4ljfzsi,s7431Ld3A7zXtHfrF74 | 20-547-871-1712 | ickly unusual dependencies. carefully regular dolphins ha |
| 8750.12 | Supplier#000001064 | IRAQ | 31063 | Manufacturer#5 | QgmUIaEs5KpuW ,oREZV2b4wr3HEC1z4F | 21-440-809-7599 | sly even deposits? furiously regular pack |
| 8594.80 | Supplier#000007553 | IRAN | 5052 | Manufacturer#4 | wAU2Lui w9 | 20-663-409-7956 | old, stealthy accounts are blithely. fluffily final |
| 8594.80 | Supplier#000007553 | IRAN | 195033 | Manufacturer#1 | wAU2Lui w9 | 20-663-409-7956 | old, stealthy accounts are blithely. fluffily final |
| 8588.63 | Supplier#000008094 | SAUDI ARABIA | 148093 | Manufacturer#1 | SNS6FCscBNZBFecA | 30-465-665-6735 | ake quickly blithely ironic theodolites. quickly ironic ideas boost. furiously iro |
| 8522.70 | Supplier#000004208 | IRAQ | 166659 | Manufacturer#5 | x3jZYF7ZYN 8a4LY1c1kEsh | 21-468-998-1571 | furiously regular accounts! |
| 8514.86 | Supplier#000006347 | JORDAN | 181310 | Manufacturer#5 | wwR5j4kdIAwLe33uBwo | 23-340-942-3641 | uests breach blithely ironic deposi |
| 8473.01 | Supplier#000003912 | IRAQ | 33911 | Manufacturer#3 | Op7,1zt3MAxs34Qo4O W | 21-474-809-6508 | es. regular, brave instructions wa |
| 8405.28 | Supplier#000007886 | IRAQ | 192847 | Manufacturer#4 | sFTj5nzc5EIVmzjXwenFTXD U | 21-735-778-5786 | ven dependencies boost blithely ironic de |
| 8375.58 | Supplier#000001259 | IRAQ | 38755 | Manufacturer#2 | 32cJBGFFpGEkEjx1sF8JZAy0A72uXL5qU | 21-427-422-4993 | ironic accounts haggle slyly alongside of the carefully ironic deposit |
| 8351.75 | Supplier#000007495 | IRAQ | 114983 | Manufacturer#4 | 3jQQGvfs,5Aryhn0Z | 21-953-463-7239 | requests. carefully final accounts after the qui |
| 8230.12 | Supplier#000001058 | SAUDI ARABIA | 68551 | Manufacturer#2 | fJ8egP,xkLygXGv8bmtc9T1FJ | 30-496-504-3341 | requests haggle? regular, regular pinto beans integrate fluffily. dependenc |
| 8195.44 | Supplier#000009805 | IRAQ | 4804 | Manufacturer#4 | dTTmLRYJNat,JbhlQlxwWp HjMR | 21-838-243-3925 | lets. quickly even theodolites dazzle slyly even a |
| 8175.17 | Supplier#000003172 | IRAN | 55656 | Manufacturer#5 | 8ngbGS7BQoTDmJyMa5WV9XbaM31u5FAayd2vT3 | 20-834-374-7746 | ss deposits use furiously after the quickly final sentiments. fluffily ruthless ideas believe regu |
| 8159.13 | Supplier#000007486 | EGYPT | 17485 | Manufacturer#1 | AjfdzbrrJE1 | 14-970-643-1521 | ld accounts. enticingly furious requests cajole. final packages s |
| 8111.40 | Supplier#000007567 | IRAN | 197566 | Manufacturer#1 | 7W4k2qEVoBkRehprGliXRSYVOQEh | 20-377-181-7435 | gular foxes. silent attainments boost furiousl |
| 8046.55 | Supplier#000001625 | IRAQ | 14121 | Manufacturer#2 | yKlKMbENR6bfmIu7aCFmbs | 21-769-404-7617 | deposits. ideas boost blithely. slyly even Tiresias according to the platelets are q |
| 8040.16 | Supplier#000001925 | SAUDI ARABIA | 4424 | Manufacturer#4 | Cu5Ub AAdXT | 30-969-417-1108 | pending packages across the regular req |
| 8031.68 | Supplier#000002370 | SAUDI ARABIA | 147341 | Manufacturer#5 | xGQB9xSPqRtCuMZaJavOrFuTY7km | 30-373-388-2352 | dependencies. carefully express deposits use slyly among the slyly unusual pearls. dogge |
| 8031.42 | Supplier#000008216 | IRAN | 83199 | Manufacturer#2 | jsqlyr1ViAo | 20-224-305-7298 | to the carefully even excuses haggle blithely against the pending pinto be |
| 8007.83 | Supplier#000006266 | JORDAN | 81249 | Manufacturer#1 | XWBf5Jd2V5SOurbn11Tt1 | 23-363-445-7184 | as cajole carefully against the quickly special ac |
| 7995.78 | Supplier#000006957 | IRAN | 161924 | Manufacturer#1 | 8lvRhU5xtXv | 20-312-173-2216 | ly ironic accounts. stealthily regular foxes about the blithely ironic requests play blithely abo |
| 7913.40 | Supplier#000003148 | JORDAN | 58137 | Manufacturer#1 | CpCJWI4PHeiwYuq0 | 23-767-770-9172 | ove the quickly final packages boost fluffily among the furiously final platelets. carefully s |
| 7910.16 | Supplier#000002102 | IRAQ | 99592 | Manufacturer#2 | 1kuyUn5q6czLOGB60fAVgpv68M2suwchpmp2nK | 21-367-198-9930 | accounts after the blithely |
| 7893.58 | Supplier#000000918 | SAUDI ARABIA | 13414 | Manufacturer#1 | e0sB7xAU3,cWF7pzXrpIbATUNydCUZup | 30-303-831-1662 | ependencies wake carefull |
| 7885.17 | Supplier#000004001 | JORDAN | 38994 | Manufacturer#2 | 3M39sZY1XeQXPDRO | 23-109-632-6806 | efully express packages integrate across the regular pearls. blithely unusual packages mainta |
| 7880.20 | Supplier#000005352 | JORDAN | 351 | Manufacturer#3 | PP9gHTn946hXqUF5E7idIPLkhnN | 23-557-756-7951 | egular frays. final instructions sleep a |
| 7844.31 | Supplier#000006987 | IRAQ | 44482 | Manufacturer#5 | UH1zBxTNjTminnmHRe h YUT1eR | 21-963-444-7397 | nag quickly carefully regular requests. ironic theo |
| 7812.27 | Supplier#000006967 | SAUDI ARABIA | 151936 | Manufacturer#4 | S4i1HfrSM4m3di3R9Cxxp59M1 | 30-193-457-6365 | ely. dependencies cajole quickly. final warhorses across the furiously ironic foxes integr |
| 7767.63 | Supplier#000004306 | IRAN | 31802 | Manufacturer#2 | SkZkJZflW5mDg9wL fJ | 20-911-180-1895 | uickly regular ideas. blithely express accounts along the carefully sile |
| 7741.42 | Supplier#000000899 | IRAQ | 53383 | Manufacturer#5 | oLlkiVghtro IwzcwFuzwMCG94rRpux | 21-980-994-3905 | equests wake quickly special, express accounts. courts promi |
| 7741.42 | Supplier#000000899 | IRAQ | 105878 | Manufacturer#3 | oLlkiVghtro IwzcwFuzwMCG94rRpux | 21-980-994-3905 | equests wake quickly special, express accounts. courts promi |
| 7741.10 | Supplier#000001059 | IRAN | 103528 | Manufacturer#4 | 4tBenOMokWbWVRB8i8HwENeO cQjM9 | 20-620-710-8984 | to the carefully special courts. |
| 7599.20 | Supplier#000006596 | SAUDI ARABIA | 184077 | Manufacturer#2 | k8qeFxfXKIGYdQ82RXAfCwddSrc | 30-804-947-3851 | ously unusual deposits boost carefully after the enticing |
| 7598.31 | Supplier#000008857 | IRAQ | 63844 | Manufacturer#4 | dP2th8vneyOLIUFwNBwqixkFD6 | 21-691-170-4769 | s. quickly ironic frays detect carefully |
| 7591.79 | Supplier#000009723 | JORDAN | 104702 | Manufacturer#2 | Q1CkkpDdlLOpCJiV,zIf,Mv86otWhxj7slGc | 23-710-907-3873 | e fluffily even instructions. packages impress enticingly. |
| 7575.12 | Supplier#000007557 | IRAQ | 77556 | Manufacturer#1 | udLvpjNvIx9qeRNdjL1ZAO0OZNOBo6h | 21-629-935-9941 | ally special accounts nod; f |
| 7496.91 | Supplier#000005828 | IRAN | 103317 | Manufacturer#1 | Xt0EqDCNU6X00sNsIO7nd0ws3H | 20-435-850-8703 | furiously about the fluffily careful idea |
| 7472.88 | Supplier#000004204 | EGYPT | 14203 | Manufacturer#1 | 0rGZJ6VZXdH | 14-520-667-4690 | y pending pinto beans. even, final requests sleep care |
| 7472.88 | Supplier#000004204 | EGYPT | 161687 | Manufacturer#3 | 0rGZJ6VZXdH | 14-520-667-4690 | y pending pinto beans. even, final requests sleep care |
| 7467.63 | Supplier#000003270 | IRAN | 45757 | Manufacturer#2 | 7j4n5FnNEHVJxFhiyz | 20-450-599-9591 | regular, even instructions boost deposits |
| 7465.41 | Supplier#000008686 | EGYPT | 188685 | Manufacturer#4 | 4Onf4yxuNwHCRIC0y | 14-454-946-4151 | ly final ideas. bravely unusual deposits doze carefully. expr |
| 7460.80 | Supplier#000008701 | IRAQ | 83684 | Manufacturer#3 | PLR2QehcW08 | 21-747-984-4244 | ideas use carefully pending, final deposits. ironic, pe |
| 7447.86 | Supplier#000005877 | JORDAN | 120852 | Manufacturer#2 | EyqOHClZZMJkq grnOX9 4alZx6P7B2fq | 23-419-288-6451 | lar pinto beans breach carefully final pinto |
| 7445.03 | Supplier#000009802 | IRAQ | 164769 | Manufacturer#5 | y6wLN KiZuTf5HT9Hbm0BELn1GUTD6yl | 21-116-708-2013 | nic requests. pinto beans across the carefully regular grouches snooze among the final pin |
| 7401.46 | Supplier#000008677 | IRAN | 123652 | Manufacturer#5 | WNa780JZzivxuGBEsDszqoT1Pj | 20-899-256-5288 | onic instructions along the furiously ironic accounts haggle fluffily silently un |
| 7393.50 | Supplier#000007056 | IRAQ | 54550 | Manufacturer#1 | M5cAJQvW9D5zwC7o2qkoe | 21-175-383-4727 | slyly even requests. forges haggle boldly express requests. furio |
| 7376.11 | Supplier#000003982 | IRAQ | 118959 | Manufacturer#1 | jx9EloF33Ez | 21-890-236-4160 | s the furiously special warhorses affix after the car |
| 7264.42 | Supplier#000001565 | IRAQ | 14061 | Manufacturer#4 | bOwKHdBteMkZoZcxdigk4Tnu07w1gDztmV7hvCw | 21-791-273-8592 | to beans. express accounts nag around the |
| 7256.46 | Supplier#000009116 | IRAQ | 4115 | Manufacturer#3 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci |
| 7256.46 | Supplier#000009116 | IRAQ | 99115 | Manufacturer#1 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci |
| 7256.46 | Supplier#000009116 | IRAQ | 131576 | Manufacturer#4 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci |
| 7254.81 | Supplier#000005664 | EGYPT | 35663 | Manufacturer#2 | b8VWuTXRt66wF9bfrgTmNGuxf1PU0x3O9e | 14-214-171-8987 | ts across the quickly pending pin |
| 7186.63 | Supplier#000006958 | IRAN | 71943 | Manufacturer#4 | 0n9BD,gRzUc3B,PsFcxDBGp4BFf4P | 20-185-413-5590 | against the instructions. requests are. speci |
| 7166.36 | Supplier#000003541 | EGYPT | 116007 | Manufacturer#1 | DbwyOxoaMEdhEtIB3y045QrKCi2fQpGRu, | 14-508-763-1850 | ages. carefully unusual requests across the pending instructions aff |
| 7128.81 | Supplier#000000677 | JORDAN | 50676 | Manufacturer#4 | 8mhrffG7D2WJBSQbOGstQ | 23-290-639-3315 | nder blithely. slyly unusual theod |
| 7051.73 | Supplier#000003349 | IRAQ | 125812 | Manufacturer#3 | wtTK9df9kY7mQ5QUM0Xe5bHLMRLgwE | 21-614-525-7451 | ar theodolites cajole fluffily across the pending requests. slyly final requests a |
| 7023.47 | Supplier#000009543 | SAUDI ARABIA | 47038 | Manufacturer#1 | VYKinyOBNXRr Hdqn8kOxfTw | 30-785-782-6088 | sts. furiously pending packages sleep slyly even requests. final excuses print deposits. final pac |
| 6985.93 | Supplier#000006409 | IRAQ | 131382 | Manufacturer#1 | eO8JDNM19HrlQMR | 21-627-356-3992 | sts. slyly final deposits around the regular accounts are along the furiously final pac |
| 6964.75 | Supplier#000009931 | EGYPT | 57425 | Manufacturer#1 | peQYiRFk G0xZKfJ | 14-989-166-5782 | deposits according to the sometimes silent requests wake along the packages-- blithely f |
| 6964.04 | Supplier#000007399 | IRAQ | 77398 | Manufacturer#2 | zdxjENOGR4QiCFP | 21-859-733-1999 | e blithely after the even requests. carefully ironic packages use slyly a |
| 6913.81 | Supplier#000002625 | IRAQ | 22624 | Manufacturer#3 | a4V0rWemgbsT ZMj w7DB8rUbZ4F4lqqW5VKljQF | 21-136-564-3910 | . asymptotes among the express requests cajole furiously after the ca |
|

（本文超出站点单文档体积上限，已截断）