You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XieJiann (via GitHub)" <gi...@apache.org> on 2024/02/06 02:09:50 UTC

[PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

XieJiann opened a new pull request, #30884:
URL: https://github.com/apache/doris/pull/30884

   ## Proposed changes
   fix name of rule EliminateJoinByFK
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929133997

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a8b141460308f17fcf43521eac4ea2eb780b334b with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.7 seconds inserted 10000000 Rows, about 729K ops/s
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928715967

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a20c3bcb3d081b756f84ec0b80b402ef149bd716 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       13.9 seconds inserted 10000000 Rows, about 719K ops/s
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #30884:
URL: https://github.com/apache/doris/pull/30884


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929119065

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174242 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
   
   query1	938	342	331	331
   query2	6542	1944	1953	1944
   query3	6695	215	208	208
   query4	31833	21971	21940	21940
   query5	4282	426	359	359
   query6	266	174	167	167
   query7	4601	284	281	281
   query8	245	188	178	178
   query9	8897	2287	2251	2251
   query10	413	213	213	213
   query11	17301	15546	15264	15264
   query12	129	75	79	75
   query13	1625	418	422	418
   query14	8946	7282	6766	6766
   query15	243	181	183	181
   query16	8081	253	250	250
   query17	1876	532	493	493
   query18	2114	264	268	264
   query19	368	149	136	136
   query20	82	77	80	77
   query21	194	119	122	119
   query22	5157	4847	4881	4847
   query23	30674	29994	30099	29994
   query24	6916	2738	2748	2738
   query25	518	363	357	357
   query26	707	151	147	147
   query27	1965	305	304	304
   query28	3545	1856	1849	1849
   query29	848	594	610	594
   query30	258	133	143	133
   query31	930	682	729	682
   query32	92	57	53	53
   query33	441	226	218	218
   query34	812	452	469	452
   query35	833	780	771	771
   query36	1012	951	872	872
   query37	97	58	58	58
   query38	3298	3145	3094	3094
   query39	1313	1273	1236	1236
   query40	186	96	95	95
   query41	40	35	36	35
   query42	103	96	92	92
   query43	535	471	455	455
   query44	1031	686	707	686
   query45	190	180	174	174
   query46	1024	646	655	646
   query47	1501	1508	1441	1441
   query48	441	361	346	346
   query49	844	295	289	289
   query50	769	374	376	374
   query51	5285	5141	5125	5125
   query52	103	85	94	85
   query53	337	281	269	269
   query54	248	217	214	214
   query55	80	79	76	76
   query56	225	198	198	198
   query57	967	897	913	897
   query58	203	180	179	179
   query59	2446	2465	2351	2351
   query60	238	213	210	210
   query61	87	88	84	84
   query62	537	325	346	325
   query63	293	276	269	269
   query64	4480	3649	3443	3443
   query65	3259	3265	3243	3243
   query66	795	310	307	307
   query67	14458	14162	14232	14162
   query68	4104	529	548	529
   query69	457	326	338	326
   query70	1223	1257	1156	1156
   query71	330	253	243	243
   query72	5863	2876	2661	2661
   query73	696	325	333	325
   query74	6515	6323	6228	6228
   query75	3036	2319	2343	2319
   query76	2558	963	921	921
   query77	346	232	234	232
   query78	9282	8973	8610	8610
   query79	2949	488	497	488
   query80	2087	343	349	343
   query81	514	195	199	195
   query82	772	80	80	80
   query83	243	126	123	123
   query84	288	80	77	77
   query85	1906	361	331	331
   query86	501	309	266	266
   query87	3336	3170	3222	3170
   query88	4209	2308	2325	2308
   query89	436	359	337	337
   query90	1970	163	162	162
   query91	158	127	121	121
   query92	55	47	43	43
   query93	4647	476	459	459
   query94	1243	178	172	172
   query95	8036	360	348	348
   query96	594	272	279	272
   query97	4217	4119	4127	4119
   query98	220	189	195	189
   query99	1131	705	705	705
   Total cold run time: 279714 ms
   Total hot run time: 174242 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928699174

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37395 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17628	4518	4511	4511
   q2	2059	152	142	142
   q3	10573	938	925	925
   q4	4651	770	791	770
   q5	7702	2887	2843	2843
   q6	184	125	125	125
   q7	1186	745	735	735
   q8	9277	2027	2066	2027
   q9	7350	6408	6386	6386
   q10	8119	2486	2417	2417
   q11	413	203	199	199
   q12	795	264	294	264
   q13	18058	3318	3322	3318
   q14	285	248	251	248
   q15	536	522	492	492
   q16	477	403	413	403
   q17	954	609	516	516
   q18	6946	6043	6016	6016
   q19	1569	1360	1404	1360
   q20	595	354	348	348
   q21	6918	3065	3061	3061
   q22	814	289	310	289
   Total cold run time: 107089 ms
   Total hot run time: 37395 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4437	4484	4380	4380
   q2	323	238	245	238
   q3	3048	2851	2866	2851
   q4	1849	1628	1628	1628
   q5	5222	5269	5265	5265
   q6	195	116	118	116
   q7	2175	1760	1796	1760
   q8	3138	3280	3281	3280
   q9	8414	8323	8374	8323
   q10	5884	3579	3599	3579
   q11	548	472	484	472
   q12	738	599	562	562
   q13	16890	3134	3083	3083
   q14	288	253	264	253
   q15	526	490	485	485
   q16	497	476	477	476
   q17	1858	1732	1767	1732
   q18	7894	7866	7684	7684
   q19	6947	1535	1559	1535
   q20	2160	1946	1912	1912
   q21	4784	4665	4617	4617
   q22	532	452	475	452
   Total cold run time: 78347 ms
   Total hot run time: 54683 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928672957

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929099065

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37079 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	6500	4526	4451	4451
   q2	1154	151	139	139
   q3	4955	942	944	942
   q4	1008	746	730	730
   q5	2797	2789	2781	2781
   q6	203	130	133	130
   q7	1256	756	729	729
   q8	1899	1985	2021	1985
   q9	6397	6363	6320	6320
   q10	7247	2420	2411	2411
   q11	342	201	212	201
   q12	830	284	287	284
   q13	17754	3337	3337	3337
   q14	288	257	249	249
   q15	528	502	490	490
   q16	468	402	410	402
   q17	931	579	484	484
   q18	6500	6023	6004	6004
   q19	1551	1300	1345	1300
   q20	596	360	330	330
   q21	6710	3094	3078	3078
   q22	807	302	304	302
   Total cold run time: 70721 ms
   Total hot run time: 37079 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4370	4504	4439	4439
   q2	336	233	230	230
   q3	2968	2871	2783	2783
   q4	1891	1686	1655	1655
   q5	5185	5278	5182	5182
   q6	191	113	115	113
   q7	2126	1741	1776	1741
   q8	3123	3199	3227	3199
   q9	8309	8231	8248	8231
   q10	6023	3590	3619	3590
   q11	552	450	463	450
   q12	735	567	585	567
   q13	3783	3119	3136	3119
   q14	280	267	256	256
   q15	532	494	499	494
   q16	528	458	473	458
   q17	1825	1706	1741	1706
   q18	7974	7666	7533	7533
   q19	10643	1543	1552	1543
   q20	2523	1927	1891	1891
   q21	4771	4700	4580	4580
   q22	628	484	475	475
   Total cold run time: 69296 ms
   Total hot run time: 54235 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929028796

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929041264

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928653403

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928709355

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 175007 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
   
   query1	919	364	334	334
   query2	6518	1895	1873	1873
   query3	6709	218	218	218
   query4	31684	22200	22222	22200
   query5	4315	437	359	359
   query6	259	168	165	165
   query7	4603	293	287	287
   query8	239	172	178	172
   query9	8969	2289	2274	2274
   query10	412	215	222	215
   query11	19001	15663	15421	15421
   query12	132	79	77	77
   query13	1638	420	418	418
   query14	9333	7093	6980	6980
   query15	238	179	184	179
   query16	8122	268	257	257
   query17	1856	538	505	505
   query18	2102	267	268	267
   query19	345	144	139	139
   query20	82	74	78	74
   query21	198	132	126	126
   query22	4979	4669	4603	4603
   query23	30656	30130	30079	30079
   query24	10601	2744	2750	2744
   query25	544	352	345	345
   query26	709	153	151	151
   query27	2175	301	300	300
   query28	5767	1853	1856	1853
   query29	868	628	612	612
   query30	285	131	141	131
   query31	895	698	694	694
   query32	94	53	52	52
   query33	631	225	220	220
   query34	822	463	455	455
   query35	867	776	773	773
   query36	1029	898	930	898
   query37	97	54	57	54
   query38	3220	3133	3080	3080
   query39	1316	1271	1248	1248
   query40	186	100	92	92
   query41	38	35	34	34
   query42	105	87	95	87
   query43	497	500	457	457
   query44	1101	694	712	694
   query45	193	179	170	170
   query46	1036	660	662	660
   query47	1528	1520	1533	1520
   query48	444	345	356	345
   query49	1045	290	286	286
   query50	775	374	381	374
   query51	5194	5144	5176	5144
   query52	103	84	96	84
   query53	345	264	263	263
   query54	292	222	223	222
   query55	86	72	86	72
   query56	224	201	200	200
   query57	975	957	893	893
   query58	196	183	187	183
   query59	2423	2325	2310	2310
   query60	233	217	217	217
   query61	83	89	86	86
   query62	634	376	362	362
   query63	290	269	272	269
   query64	4735	3756	3755	3755
   query65	3234	3234	3231	3231
   query66	805	316	303	303
   query67	14296	13988	14094	13988
   query68	3925	548	527	527
   query69	467	322	332	322
   query70	1239	1235	1207	1207
   query71	321	253	254	253
   query72	6274	2894	2688	2688
   query73	719	320	328	320
   query74	6463	6271	6260	6260
   query75	3057	2369	2348	2348
   query76	2557	983	902	902
   query77	365	234	231	231
   query78	9132	8762	8451	8451
   query79	2527	487	486	486
   query80	1849	364	351	351
   query81	541	198	201	198
   query82	759	87	77	77
   query83	242	126	123	123
   query84	284	82	80	80
   query85	2131	367	343	343
   query86	490	318	297	297
   query87	3325	3201	3229	3201
   query88	3710	2335	2323	2323
   query89	462	366	339	339
   query90	1879	169	167	167
   query91	154	131	124	124
   query92	59	52	47	47
   query93	2570	511	462	462
   query94	1283	177	174	174
   query95	477	8001	362	362
   query96	585	267	274	267
   query97	4232	4098	4106	4098
   query98	218	203	190	190
   query99	1163	689	656	656
   Total cold run time: 277784 ms
   Total hot run time: 175007 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929041177

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929066312

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929128689

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.13 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.06	0.02	0.02
   query3	0.23	0.06	0.06
   query4	1.65	0.10	0.10
   query5	0.54	0.52	0.52
   query6	1.19	0.64	0.63
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.56	0.51	0.52
   query10	0.57	0.55	0.55
   query11	0.12	0.08	0.09
   query12	0.11	0.08	0.09
   query13	0.60	0.61	0.59
   query14	0.76	0.81	0.80
   query15	0.80	0.78	0.78
   query16	0.37	0.41	0.38
   query17	1.02	1.03	1.05
   query18	0.24	0.26	0.24
   query19	1.88	1.82	1.72
   query20	0.02	0.01	0.01
   query21	15.42	0.58	0.55
   query22	2.34	3.24	1.71
   query23	16.93	0.85	0.80
   query24	2.80	1.04	0.25
   query25	0.25	0.10	0.16
   query26	0.47	0.15	0.14
   query27	0.06	0.05	0.05
   query28	12.33	0.84	0.82
   query29	12.52	3.13	3.26
   query30	0.59	0.54	0.52
   query31	2.79	0.34	0.36
   query32	3.33	0.49	0.49
   query33	3.18	3.24	3.20
   query34	15.73	4.30	4.28
   query35	4.29	4.27	4.31
   query36	1.10	1.07	1.06
   query37	0.07	0.04	0.06
   query38	0.04	0.03	0.03
   query39	0.02	0.02	0.02
   query40	0.17	0.12	0.13
   query41	0.08	0.01	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 105.37 s
   Total hot run time: 30.13 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928713507

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.71 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
   
   query1	0.03	0.03	0.02
   query2	0.06	0.03	0.02
   query3	0.22	0.06	0.06
   query4	1.68	0.10	0.10
   query5	0.54	0.51	0.51
   query6	1.18	0.64	0.64
   query7	0.02	0.01	0.02
   query8	0.04	0.02	0.02
   query9	0.56	0.51	0.52
   query10	0.57	0.56	0.55
   query11	0.12	0.09	0.08
   query12	0.11	0.09	0.10
   query13	0.60	0.61	0.60
   query14	0.80	0.80	0.79
   query15	0.79	0.79	0.79
   query16	0.38	0.37	0.40
   query17	1.03	1.03	1.01
   query18	0.24	0.25	0.23
   query19	1.84	1.72	1.72
   query20	0.01	0.01	0.01
   query21	15.40	0.56	0.60
   query22	2.50	2.71	1.52
   query23	17.03	0.80	0.69
   query24	2.69	1.19	0.93
   query25	0.35	0.26	0.17
   query26	0.51	0.14	0.14
   query27	0.06	0.04	0.05
   query28	11.12	0.85	0.84
   query29	12.55	3.18	3.19
   query30	0.64	0.55	0.53
   query31	2.79	0.35	0.35
   query32	3.35	0.48	0.49
   query33	3.29	3.22	3.24
   query34	15.92	4.31	4.33
   query35	4.35	4.31	4.32
   query36	1.13	1.06	1.05
   query37	0.06	0.06	0.05
   query38	0.03	0.03	0.02
   query39	0.02	0.02	0.01
   query40	0.17	0.13	0.13
   query41	0.06	0.01	0.02
   query42	0.03	0.02	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 104.89 s
   Total hot run time: 30.71 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org