Visitar URL original
[fix](fe) Expose Paimon FileIO access failures during catalog creation by suxiaogang223 · Pull Request #68766 · apache/doris · GitHub
Skip to content

[fix](fe) Expose Paimon FileIO access failures during catalog creation - #68766

Open
suxiaogang223 wants to merge 1 commit into
apache:masterfrom
suxiaogang223:codex/paimon-fileio-error-details
Open

suxiaogang223 wants to merge 1 commit into
apache:masterfrom
suxiaogang223:codex/paimon-fileio-error-details

Conversation

@suxiaogang223

@suxiaogang223 suxiaogang223 commented Oct 8, 2026 •

Copy link
Copy Markdown
Member

What problem does this PR solve?

Issue Number: None

Related PR: None

Problem Summary:

An OBS access timeout during Paimon catalog initialization can be reported as
Could not find a file io implementation for scheme 'obs'. Paimon's FileIO.get
stores the failed access probes as suppressed exceptions on an
UnsupportedSchemeException, while Doris previously displayed only its message.

Expose the underlying access failures in the catalog-creation error and use the
first failed probe as the cause so root-cause consumers, including SHOW CATALOGS,
can report the actual error. Retain the original aggregate as a suppressed
exception, preserving every attempted FileIO failure in the diagnostic stack.
Other catalog errors retain their existing wrapping.

Add six offline tests covering the real Paimon/Hadoop fallback with a simulated
OBS timeout, nested wrappers, multiple failures, errors without messages,
missing filesystem implementations, and unrelated suppressed exceptions.

Release note

Paimon catalog initialization reports underlying filesystem access failures
instead of only a misleading missing-FileIO message.

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test
    • No need to test or manual test.

    Offline Paimon connector unit tests, Checkstyle, and plugin packaging passed.
    No live OBS regression was run.

  • Behavior changed:

    • No.
    • Yes. Catalog error messages and their cause chains expose FileIO access failures; storage access and retry behavior are unchanged.
  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@hello-stephen

Copy link
Copy Markdown
Contributor

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR.

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@suxiaogang223

Copy link
Copy Markdown
Member Author

run buildall

2 similar comments
@suxiaogang223

Copy link
Copy Markdown
Member Author

run buildall

@hello-stephen

Copy link
Copy Markdown
Contributor

run buildall

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-H: Total hot run time: 29079 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit df19b59fee21b679e4d6ebf553b59c09497fc81b, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17600	5674	5551	5551
q2	2122	316	256	256
q3	10241	1394	839	839
q4	4675	472	344	344
q5	7430	797	544	544
q6	188	188	160	160
q7	775	803	611	611
q8	9256	1303	1064	1064
q9	5717	4444	4444	4444
q10	6820	1299	1004	1004
q11	422	261	238	238
q12	617	409	299	299
q13	18062	3057	2388	2388
q14	276	274	252	252
q15	q16	738	735	664	664
q17	1162	727	581	581
q18	7082	6241	6169	6169
q19	1104	958	646	646
q20	384	334	228	228
q21	5044	2514	2583	2514
q22	397	343	283	283
Total cold run time: 100112 ms
Total hot run time: 29079 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	6525	6478	6468	6468
q2	725	590	587	587
q3	5488	5730	5314	5314
q4	2108	2184	1604	1604
q5	5902	5784	5721	5721
q6	258	192	150	150
q7	2278	1995	1859	1859
q8	3133	2816	2807	2807
q9	8271	7729	7651	7651
q10	3653	3601	3235	3235
q11	599	431	377	377
q12	666	701	496	496
q13	2741	3079	2427	2427
q14	283	299	252	252
q15	q16	684	682	652	652
q17	7791	7004	6844	6844
q18	13136	12241	13046	12241
q19	932	853	847	847
q20	2202	2164	1945	1945
q21	5900	4781	4909	4781
q22	478	465	397	397
Total cold run time: 73753 ms
Total hot run time: 66655 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 151741 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit df19b59fee21b679e4d6ebf553b59c09497fc81b, data reload: false

query5	4304	591	447	447
query6	418	206	206	206
query7	4798	438	229	229
query8	313	175	164	164
query9	8736	3938	3934	3934
query10	491	309	244	244
query11	5936	3412	3187	3187
query12	147	90	85	85
query13	1244	436	305	305
query14	6516	4798	4461	4461
query14_1	4310	4244	4241	4241
query15	209	209	190	190
query16	946	454	433	433
query17	866	647	544	544
query18	2423	420	317	317
query19	193	170	141	141
query20	82	80	77	77
query21	209	140	111	111
query22	12938	13081	12860	12860
query23	13170	12485	12024	12024
query23_1	12147	12084	12145	12084
query24	7109	825	475	475
query24_1	465	466	470	466
query25	554	426	365	365
query26	1265	256	140	140
query27	2747	436	269	269
query28	4587	1901	1935	1901
query29	1522	595	460	460
query30	296	215	184	184
query31	871	760	651	651
query32	137	89	95	89
query33	501	319	248	248
query34	907	865	503	503
query35	756	747	646	646
query36	848	818	745	745
query37	126	106	92	92
query38	1781	1770	1666	1666
query39	690	708	668	668
query39_1	663	685	682	682
query40	220	117	101	101
query41	74	73	68	68
query42	84	82	82	82
query43	364	372	336	336
query44	1281	691	692	691
query45	185	179	164	164
query46	864	964	570	570
query47	2729	2768	2873	2768
query48	315	307	257	257
query49	564	384	286	286
query50	670	266	216	216
query51	10601	10653	10463	10463
query52	77	78	70	70
query53	189	201	146	146
query54	226	184	205	184
query55	74	73	66	66
query56	226	224	211	211
query57	1599	1567	1566	1566
query58	278	236	249	236
query59	2350	2361	2097	2097
query60	283	235	216	216
query61	146	148	144	144
query62	386	341	285	285
query63	192	161	178	161
query64	2564	940	773	773
query65	3419	3365	3361	3361
query66	1741	430	323	323
query67	20141	20158	20332	20158
query68	2989	1023	615	615
query69	390	297	245	245
query70	906	837	841	837
query71	302	226	214	214
query72	2742	2523	2263	2263
query73	523	522	292	292
query74	4585	4508	4333	4333
query75	2333	2309	1949	1949
query76	2280	1026	607	607
query77	354	394	303	303
query78	8922	8941	8498	8498
query79	1480	841	506	506
query80	1229	427	354	354
query81	604	326	273	273
query82	576	135	107	107
query83	301	203	178	178
query84	316	120	102	102
query85	831	428	367	367
query86	397	243	225	225
query87	2009	1959	1820	1820
query88	3628	2688	2694	2688
query89	330	304	257	257
query90	1851	183	181	181
query91	156	149	123	123
query92	98	89	94	89
query93	1126	982	551	551
query94	651	304	251	251
query95	582	338	317	317
query96	667	519	233	233
query97	2493	2434	2302	2302
query98	158	150	139	139
query99	778	765	656	656
Total cold run time: 234386 ms
Total hot run time: 151741 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 24.43 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit df19b59fee21b679e4d6ebf553b59c09497fc81b, data reload: false

query1	0.01	0.01	0.01
query2	0.11	0.05	0.05
query3	0.26	0.12	0.11
query4	1.61	0.11	0.11
query5	0.24	0.25	0.25
query6	1.17	0.70	0.68
query7	0.04	0.01	0.01
query8	0.05	0.04	0.03
query9	0.42	0.36	0.35
query10	0.61	0.58	0.57
query11	0.21	0.15	0.14
query12	0.19	0.15	0.15
query13	0.49	0.51	0.50
query14	0.96	0.97	0.95
query15	0.64	0.60	0.61
query16	0.36	0.36	0.36
query17	1.13	1.16	1.16
query18	0.24	0.21	0.20
query19	2.02	1.93	1.94
query20	0.02	0.01	0.01
query21	15.43	0.27	0.14
query22	4.40	0.05	0.05
query23	16.22	0.32	0.12
query24	3.29	0.55	0.35
query25	0.10	0.05	0.04
query26	1.04	0.26	0.15
query27	0.05	0.04	0.03
query28	1.69	0.61	0.39
query29	12.54	4.09	3.25
query30	0.30	0.15	0.14
query31	2.78	0.58	0.34
query32	3.23	0.62	0.52
query33	3.16	3.21	3.33
query34	15.48	4.01	3.40
query35	3.32	3.36	3.34
query36	0.54	0.49	0.44
query37	0.10	0.06	0.06
query38	0.05	0.04	0.04
query39	0.04	0.03	0.03
query40	0.16	0.14	0.15
query41	0.10	0.03	0.02
query42	0.03	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 94.87 s
Total hot run time: 24.43 s

@hello-stephen

Copy link
Copy Markdown
Contributor

FE UT Coverage Report

Increment line coverage `` 🎉
Increment coverage report
Complete coverage report

@suxiaogang223
suxiaogang223 force-pushed the codex/paimon-fileio-error-details branch from df19b59 to bf64853 Compare October 10, 2026 09:50
@suxiaogang223

Copy link
Copy Markdown
Member Author

run buildall

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-H: Total hot run time: 29112 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit bf6485324db27a2983f87b7dafde3c84134eb47b, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17570	5602	5536	5536
q2	2103	313	257	257
q3	10251	1393	845	845
q4	4680	478	357	357
q5	7442	798	558	558
q6	194	187	160	160
q7	773	794	611	611
q8	9252	1348	1131	1131
q9	5844	4473	4412	4412
q10	6823	1316	1014	1014
q11	440	266	243	243
q12	631	394	290	290
q13	18055	3046	2372	2372
q14	274	268	246	246
q15	q16	735	727	674	674
q17	1182	741	576	576
q18	7172	6250	6209	6209
q19	1101	972	599	599
q20	384	336	223	223
q21	5089	2504	2603	2504
q22	393	368	295	295
Total cold run time: 100388 ms
Total hot run time: 29112 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	6766	6415	6486	6415
q2	736	627	552	552
q3	5625	5656	5434	5434
q4	2096	2174	1625	1625
q5	5783	5793	5800	5793
q6	260	194	156	156
q7	2243	1968	1867	1867
q8	3147	2886	2794	2794
q9	8304	8118	7784	7784
q10	3657	3620	3266	3266
q11	607	414	396	396
q12	666	691	501	501
q13	2751	3083	2389	2389
q14	298	281	262	262
q15	q16	673	694	629	629
q17	7936	7154	6968	6968
q18	13156	12316	13113	12316
q19	930	795	796	795
q20	2193	2199	1955	1955
q21	6060	4980	4993	4980
q22	502	479	424	424
Total cold run time: 74389 ms
Total hot run time: 67301 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-H: Total hot run time: 28636 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit bf6485324db27a2983f87b7dafde3c84134eb47b, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17618	5585	5512	5512
q2	2138	305	260	260
q3	10229	1356	841	841
q4	4674	468	352	352
q5	7405	801	531	531
q6	186	181	155	155
q7	750	794	602	602
q8	9240	1318	1053	1053
q9	5650	4413	4388	4388
q10	6798	1275	1022	1022
q11	424	245	231	231
q12	635	405	287	287
q13	18032	3030	2370	2370
q14	272	266	246	246
q15	q16	740	730	676	676
q17	1171	738	576	576
q18	6995	6223	6181	6181
q19	1097	938	597	597
q20	369	334	222	222
q21	5395	2264	2362	2264
q22	360	313	270	270
Total cold run time: 100178 ms
Total hot run time: 28636 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	6157	6111	6145	6111
q2	650	583	542	542
q3	5169	5390	4917	4917
q4	2012	2150	1557	1557
q5	5239	5153	5768	5153
q6	260	199	153	153
q7	2236	2022	1847	1847
q8	3135	2778	2782	2778
q9	8313	8244	8217	8217
q10	3727	3919	3327	3327
q11	632	479	399	399
q12	690	726	549	549
q13	2866	3249	2528	2528
q14	318	314	302	302
q15	q16	729	729	670	670
q17	8305	7487	7578	7487
q18	13237	12241	13091	12241
q19	920	784	786	784
q20	2201	2177	1976	1976
q21	5952	4768	4910	4768
q22	511	456	418	418
Total cold run time: 73259 ms
Total hot run time: 66724 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 151954 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit bf6485324db27a2983f87b7dafde3c84134eb47b, data reload: false

query5	4298	587	450	450
query6	425	208	194	194
query7	4825	446	213	213
query8	319	177	165	165
query9	8726	4009	3979	3979
query10	469	302	253	253
query11	5973	3425	3204	3204
query12	138	85	83	83
query13	1247	443	318	318
query14	6509	4778	4405	4405
query14_1	4267	4213	4195	4195
query15	206	206	185	185
query16	960	450	452	450
query17	842	654	539	539
query18	2404	414	293	293
query19	204	163	132	132
query20	78	75	74	74
query21	203	128	108	108
query22	13063	12939	12755	12755
query23	13113	12402	12075	12075
query23_1	12267	12247	12152	12152
query24	7100	825	450	450
query24_1	459	468	456	456
query25	510	389	330	330
query26	1254	251	130	130
query27	2786	427	264	264
query28	4638	1895	1921	1895
query29	1554	577	425	425
query30	296	211	180	180
query31	875	756	638	638
query32	142	85	87	85
query33	504	291	228	228
query34	921	850	502	502
query35	740	767	659	659
query36	847	806	714	714
query37	133	102	90	90
query38	1793	1784	1681	1681
query39	696	708	671	671
query39_1	658	691	681	681
query40	222	153	94	94
query41	67	64	63	63
query42	87	88	83	83
query43	364	379	322	322
query44	1290	683	685	683
query45	174	174	160	160
query46	829	945	555	555
query47	3005	3009	2923	2923
query48	286	299	217	217
query49	567	418	293	293
query50	688	266	207	207
query51	10451	10485	10370	10370
query52	75	79	69	69
query53	182	207	148	148
query54	252	198	171	171
query55	69	62	61	61
query56	218	216	204	204
query57	1668	1585	1580	1580
query58	270	255	251	251
query59	2347	2409	2121	2121
query60	279	233	218	218
query61	148	141	142	141
query62	394	343	287	287
query63	192	157	167	157
query64	2765	954	875	875
query65	3448	3378	3398	3378
query66	1802	470	327	327
query67	20030	20457	20418	20418
query68	2939	1009	607	607
query69	390	307	257	257
query70	924	838	811	811
query71	319	220	215	215
query72	2829	2718	2429	2429
query73	515	529	298	298
query74	4599	4490	4317	4317
query75	2349	2360	1931	1931
query76	2285	1033	595	595
query77	343	382	290	290
query78	9144	8881	8428	8428
query79	963	881	498	498
query80	774	421	330	330
query81	564	327	273	273
query82	576	134	108	108
query83	299	193	173	173
query84	321	123	98	98
query85	965	427	377	377
query86	342	241	231	231
query87	2045	1942	1830	1830
query88	3599	2704	2675	2675
query89	345	312	258	258
query90	1728	183	179	179
query91	165	147	125	125
query92	97	86	87	86
query93	997	982	546	546
query94	488	303	288	288
query95	583	337	325	325
query96	675	510	227	227
query97	2536	2408	2337	2337
query98	157	149	147	147
query99	781	755	636	636
Total cold run time: 233978 ms
Total hot run time: 151954 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 24.38 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit bf6485324db27a2983f87b7dafde3c84134eb47b, data reload: false

query1	0.00	0.00	0.01
query2	0.09	0.05	0.05
query3	0.27	0.12	0.11
query4	1.62	0.13	0.12
query5	0.24	0.24	0.25
query6	1.18	0.68	0.67
query7	0.03	0.00	0.00
query8	0.06	0.04	0.04
query9	0.41	0.36	0.35
query10	0.59	0.60	0.58
query11	0.22	0.14	0.14
query12	0.18	0.15	0.15
query13	0.48	0.49	0.48
query14	0.97	0.96	0.97
query15	0.63	0.61	0.61
query16	0.35	0.36	0.35
query17	1.14	1.15	1.08
query18	0.23	0.20	0.20
query19	2.07	1.97	1.93
query20	0.02	0.01	0.01
query21	15.48	0.29	0.14
query22	4.40	0.05	0.05
query23	16.29	0.32	0.11
query24	3.22	0.62	0.40
query25	0.12	0.06	0.07
query26	1.08	0.25	0.14
query27	0.05	0.03	0.04
query28	1.84	0.69	0.42
query29	12.51	4.06	3.26
query30	0.28	0.14	0.13
query31	2.77	0.58	0.34
query32	3.23	0.61	0.51
query33	3.18	3.24	3.22
query34	15.57	4.04	3.39
query35	3.34	3.36	3.34
query36	0.55	0.42	0.42
query37	0.10	0.07	0.06
query38	0.06	0.04	0.04
query39	0.04	0.03	0.03
query40	0.19	0.14	0.15
query41	0.08	0.03	0.03
query42	0.04	0.02	0.03
query43	0.04	0.04	0.03
Total cold run time: 95.24 s
Total hot run time: 24.38 s

@hello-stephen

Copy link
Copy Markdown
Contributor

FE Regression Coverage Report

Increment line coverage 0.00% (0/430) 🎉
Increment coverage report
Complete coverage report

### What problem does this PR solve?

Issue Number: None

Related PR: None

Problem Summary: Paimon FileIO.get reports failed filesystem access probes as
UnsupportedSchemeException and attaches the actual failures as suppressed
exceptions. Doris previously displayed only the scheme-resolution message, so an
OBS timeout looked like a missing FileIO implementation. Include all failed
access attempts in the catalog-creation error and use the first access failure
as its cause, allowing root-cause consumers such as SHOW CATALOGS to expose the
actual error. Preserve the original aggregate as a suppressed exception for
complete diagnostics. Errors without failed FileIO probes retain their existing
wrapping. Add offline tests exercising the real Hadoop fallback and covering
nested errors, multiple attempts, missing implementations, and unrelated errors.

### Release note

Paimon catalog initialization now reports the underlying filesystem access
failures instead of only a misleading missing-FileIO message.

### Check List (For Author)

- Test: Paimon connector module package with 657 unit tests (656 passed, one live-connectivity test skipped); six new tests passed; Checkstyle and connector import gate passed. Used Thrift compiler 0.24.0 through doris.thrift.executable. No live OBS regression run.
- Behavior changed: Yes, catalog error messages and their diagnostic cause chains expose FileIO access failures. Storage access and retry behavior are unchanged.
- Does this need documentation: No
@suxiaogang223
suxiaogang223 force-pushed the codex/paimon-fileio-error-details branch from bf64853 to e9fae44 Compare October 12, 2026 02:19
@suxiaogang223

Copy link
Copy Markdown
Member Author

run buildall

@suxiaogang223

Copy link
Copy Markdown
Member Author

/review

@github-actions github-actions Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Review conclusion: no substantiated new inline finding for PR #68766 at e9fae44. No existing inline P0/P1 thread applies. This review is complete and static only; I did not build, run tests, or modify source.

Critical checkpoints:

  • Goal and evidence: the changed catch exposes Paimon FileIO probe failures; the new helper promotes the suppressed access error so FE root-cause consumers, including SHOW CATALOGS, can display it. Six added tests cover a simulated real Hadoop/OBS fallback and synthetic exception shapes. Their source was inspected, not executed in this runner; no live OBS result was verified.
  • Scope: one catch-site change, one small helper, and focused tests. The change matches adjacent RuntimeException wrapping while retaining the original aggregate as a suppressed stack.
  • Concurrency: ensureCatalog still uses volatile publication and synchronized lazy creation. Failed creation leaves the catalog unset for a later retry. No thread, lock, or lock order is added; failure-only formatting is small within the existing initialization lock.
  • Lifecycle: the existing finally block restores the thread context classloader on success and failure; the helper does not alter catalog ownership or close behavior.
  • Configuration: no new item or dynamic setting is introduced.
  • Compatibility: no SPI, FE/BE protocol, persisted format, thrift, or protobuf definition changes. The intended user-visible error message and cause chain change is limited to the matched FileIO exception case.
  • Parallel paths: filesystem, JDBC, HMS, REST, and DLF creation share the catch boundary. FileIO resolution is reached by the applicable filesystem/JDBC/HMS paths; other failures retain ordinary wrapping.
  • Conditional logic: only an UnsupportedSchemeException with suppressed failures is promoted. The no-suppressed and unrelated-exception cases retain the original cause; tests cover both.
  • Tests and results: the six new offline test cases have relevant assertions for message, root cause, preserved aggregate, and classloader restoration. This invocation performed no build or test; the PR author's passing-test claim was not treated as runtime proof.
  • Observability: the top-level message lists attempted failures and resolution context; the full stack retains the aggregate. The FE deferred-error path stores the promoted root cause for SHOW CATALOGS.
  • Transactions, persistence, and writes: no transaction, edit-log, data-write, or crash-recovery path changes.
  • FE/BE variables: none added or forwarded.
  • Performance: work is limited to failed catalog creation and the number of FileIO probes; no successful hot path changes.
  • Other risks: inspected Paimon 1.4.2 loader ordering and Doris packaging. Supported object-store paths have a single Hadoop failure, so the first-suppressed choice does not mask a later timeout. No reachable retry or type classifier needs the original aggregate in the primary cause chain.

User focus: no additional focus was provided. All three required review passes returned NO_NEW_VALUABLE_FINDINGS; the final changed-file and candidate sweep found no remaining issue.

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-H: Total hot run time: 28937 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit e9fae44c33418515806074e43d32aeaa77627f7e, data reload: false

------ Round 1 ----------------------------------
============================================
q1	17598	5604	5550	5550
q2	2099	313	269	269
q3	10225	1420	833	833
q4	4680	478	354	354
q5	7431	804	543	543
q6	191	194	158	158
q7	761	803	622	622
q8	9250	1368	1117	1117
q9	5699	4477	4467	4467
q10	6807	1299	1017	1017
q11	456	261	237	237
q12	639	404	286	286
q13	18040	3101	2399	2399
q14	270	274	250	250
q15	q16	734	719	659	659
q17	1195	742	579	579
q18	7102	6215	6185	6185
q19	1107	964	623	623
q20	392	346	234	234
q21	5485	2284	2442	2284
q22	359	314	271	271
Total cold run time: 100520 ms
Total hot run time: 28937 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	6275	6176	6149	6149
q2	686	584	558	558
q3	5255	5399	4944	4944
q4	2029	2182	1575	1575
q5	5275	5151	6031	5151
q6	263	199	163	163
q7	2334	1968	1851	1851
q8	3264	2793	2795	2793
q9	8292	8257	8199	8199
q10	3915	3779	3369	3369
q11	632	446	417	417
q12	710	715	504	504
q13	2974	3279	2537	2537
q14	327	317	301	301
q15	q16	727	732	646	646
q17	8676	7657	7475	7475
q18	13253	12291	13058	12291
q19	966	825	799	799
q20	2187	2192	1955	1955
q21	5828	4717	4920	4717
q22	499	460	418	418
Total cold run time: 74367 ms
Total hot run time: 66812 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 152265 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit e9fae44c33418515806074e43d32aeaa77627f7e, data reload: false

query5	4304	579	441	441
query6	425	208	190	190
query7	4799	447	220	220
query8	321	185	174	174
query9	8766	4011	4017	4011
query10	470	316	255	255
query11	5992	3430	3196	3196
query12	136	88	83	83
query13	1260	431	311	311
query14	6492	4873	4554	4554
query14_1	4275	4294	4261	4261
query15	211	198	181	181
query16	944	460	422	422
query17	861	649	572	572
query18	2446	430	318	318
query19	207	163	137	137
query20	83	79	77	77
query21	216	143	114	114
query22	12983	13179	12780	12780
query23	13159	12535	12068	12068
query23_1	12298	12288	12260	12260
query24	7134	837	473	473
query24_1	502	476	486	476
query25	542	422	365	365
query26	1292	272	142	142
query27	2764	443	284	284
query28	4621	1916	1926	1916
query29	1583	614	459	459
query30	303	213	185	185
query31	888	766	652	652
query32	140	97	92	92
query33	503	308	253	253
query34	988	855	484	484
query35	788	759	645	645
query36	813	790	752	752
query37	125	95	90	90
query38	1793	1716	1704	1704
query39	722	706	663	663
query39_1	661	685	665	665
query40	218	115	94	94
query41	68	62	62	62
query42	84	81	79	79
query43	360	377	331	331
query44	1332	684	693	684
query45	180	179	162	162
query46	856	963	574	574
query47	2997	3038	2922	2922
query48	299	330	215	215
query49	562	386	287	287
query50	702	278	203	203
query51	10283	10533	10453	10453
query52	78	81	66	66
query53	189	205	148	148
query54	236	191	186	186
query55	66	65	68	65
query56	241	210	215	210
query57	1609	1589	1546	1546
query58	287	257	249	249
query59	2344	2377	2256	2256
query60	275	232	223	223
query61	159	151	148	148
query62	393	340	284	284
query63	190	168	165	165
query64	2771	948	799	799
query65	3453	3386	3370	3370
query66	1781	419	294	294
query67	20233	20288	19959	19959
query68	3149	999	610	610
query69	384	293	259	259
query70	961	835	830	830
query71	299	221	210	210
query72	2869	2607	2319	2319
query73	516	530	289	289
query74	4638	4542	4313	4313
query75	2369	2271	1935	1935
query76	2325	1016	640	640
query77	372	389	291	291
query78	9002	9034	8488	8488
query79	930	903	539	539
query80	540	419	334	334
query81	532	323	270	270
query82	579	136	114	114
query83	302	195	177	177
query84	314	131	98	98
query85	878	437	364	364
query86	308	233	232	232
query87	2003	1960	1820	1820
query88	3667	2698	2688	2688
query89	340	296	254	254
query90	1860	179	176	176
query91	171	151	124	124
query92	97	87	85	85
query93	1017	998	560	560
query94	448	322	282	282
query95	602	341	332	332
query96	664	537	239	239
query97	2452	2434	2313	2313
query98	158	148	142	142
query99	792	764	646	646
Total cold run time: 234305 ms
Total hot run time: 152265 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 24.44 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit e9fae44c33418515806074e43d32aeaa77627f7e, data reload: false

query1	0.01	0.01	0.01
query2	0.10	0.05	0.04
query3	0.26	0.12	0.12
query4	1.61	0.12	0.12
query5	0.30	0.24	0.24
query6	1.17	0.68	0.69
query7	0.03	0.01	0.00
query8	0.06	0.04	0.04
query9	0.42	0.36	0.35
query10	0.59	0.60	0.57
query11	0.21	0.14	0.14
query12	0.19	0.15	0.15
query13	0.51	0.51	0.52
query14	0.98	0.97	0.95
query15	0.65	0.61	0.61
query16	0.32	0.31	0.32
query17	1.12	1.16	1.15
query18	0.23	0.22	0.23
query19	2.05	2.04	1.98
query20	0.02	0.01	0.01
query21	15.55	0.27	0.15
query22	4.46	0.06	0.05
query23	16.23	0.32	0.12
query24	3.27	0.61	0.40
query25	0.11	0.06	0.05
query26	1.15	0.26	0.14
query27	0.03	0.04	0.03
query28	1.82	0.60	0.37
query29	12.53	4.25	3.31
query30	0.28	0.16	0.14
query31	2.78	0.58	0.34
query32	3.25	0.63	0.51
query33	3.15	3.20	3.27
query34	15.44	4.00	3.34
query35	3.36	3.32	3.34
query36	0.55	0.45	0.42
query37	0.09	0.07	0.06
query38	0.05	0.03	0.03
query39	0.03	0.03	0.03
query40	0.17	0.14	0.14
query41	0.09	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 95.3 s
Total hot run time: 24.44 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants