You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yx-keith (via GitHub)" <gi...@apache.org> on 2025/04/11 06:31:59 UTC

[PR] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

yx-keith opened a new pull request, #49985:
URL: https://github.com/apache/doris/pull/49985

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33234 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 9dd3700cd6960b5b622977d86f5d37551a88a428, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17572	5165	5054	5054
   q2	1923	267	184	184
   q3	10433	1283	732	732
   q4	10295	988	514	514
   q5	8148	2309	2322	2309
   q6	187	160	128	128
   q7	890	764	598	598
   q8	9311	1302	1069	1069
   q9	6858	5050	5048	5048
   q10	6897	2379	1949	1949
   q11	477	286	275	275
   q12	349	355	210	210
   q13	17761	3684	3090	3090
   q14	221	218	207	207
   q15	522	475	473	473
   q16	431	420	365	365
   q17	592	878	385	385
   q18	7521	7160	7196	7160
   q19	1210	936	554	554
   q20	349	336	233	233
   q21	4046	3198	2401	2401
   q22	352	320	296	296
   Total cold run time: 106345 ms
   Total hot run time: 33234 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5139	5149	5134	5134
   q2	238	324	224	224
   q3	2201	2702	2312	2312
   q4	1382	1787	1363	1363
   q5	4222	4255	4518	4255
   q6	213	173	127	127
   q7	2103	1958	1774	1774
   q8	2686	2774	2587	2587
   q9	7251	7236	7192	7192
   q10	3116	3327	2847	2847
   q11	587	553	517	517
   q12	719	782	643	643
   q13	3645	3947	3363	3363
   q14	285	314	288	288
   q15	509	476	484	476
   q16	424	498	442	442
   q17	1160	1571	1356	1356
   q18	7977	7618	7870	7618
   q19	847	835	990	835
   q20	1958	1941	1826	1826
   q21	4867	4405	4222	4222
   q22	611	560	532	532
   Total cold run time: 52140 ms
   Total hot run time: 49933 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 187269 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 9dd3700cd6960b5b622977d86f5d37551a88a428, data reload: false
   
   query1	982	391	410	391
   query2	6491	1592	1628	1592
   query3	6747	208	206	206
   query4	27283	23736	23399	23399
   query5	4358	590	443	443
   query6	316	221	198	198
   query7	4631	504	290	290
   query8	266	211	214	211
   query9	8653	2600	2610	2600
   query10	462	329	289	289
   query11	15523	15103	14891	14891
   query12	153	101	102	101
   query13	1635	523	386	386
   query14	8495	6078	5959	5959
   query15	214	199	166	166
   query16	7186	425	247	247
   query17	1359	714	563	563
   query18	1980	392	301	301
   query19	187	183	162	162
   query20	136	118	111	111
   query21	217	128	100	100
   query22	4164	4257	4042	4042
   query23	34269	33050	33057	33050
   query24	8412	2347	2342	2342
   query25	522	499	389	389
   query26	1234	271	149	149
   query27	2763	501	347	347
   query28	4328	2101	2094	2094
   query29	762	558	437	437
   query30	293	226	198	198
   query31	902	860	770	770
   query32	77	63	65	63
   query33	554	341	281	281
   query34	804	825	522	522
   query35	604	654	570	570
   query36	964	1015	914	914
   query37	119	133	78	78
   query38	4174	4217	4083	4083
   query39	1484	1420	1419	1419
   query40	211	117	102	102
   query41	56	52	51	51
   query42	122	117	114	114
   query43	482	487	462	462
   query44	1329	816	823	816
   query45	178	178	169	169
   query46	832	1043	625	625
   query47	1762	1808	1778	1778
   query48	380	406	307	307
   query49	724	461	389	389
   query50	665	686	433	433
   query51	5555	5466	5352	5352
   query52	115	107	96	96
   query53	224	258	181	181
   query54	569	562	527	527
   query55	122	80	83	80
   query56	296	312	297	297
   query57	1174	1201	1124	1124
   query58	261	256	256	256
   query59	2501	2668	2522	2522
   query60	342	318	297	297
   query61	126	120	121	120
   query62	792	717	663	663
   query63	230	191	185	185
   query64	4474	1169	804	804
   query65	4280	4173	4171	4171
   query66	1146	410	325	325
   query67	15659	15628	15485	15485
   query68	4383	912	544	544
   query69	520	319	275	275
   query70	1233	1142	1125	1125
   query71	415	329	312	312
   query72	5783	4689	4816	4689
   query73	678	658	362	362
   query74	9178	8991	8757	8757
   query75	3189	3215	2721	2721
   query76	3158	1149	736	736
   query77	493	383	280	280
   query78	11002	11055	10317	10317
   query79	1053	822	579	579
   query80	613	509	444	444
   query81	470	254	216	216
   query82	409	126	105	105
   query83	264	257	289	257
   query84	253	99	90	90
   query85	752	362	316	316
   query86	345	299	297	297
   query87	4443	4525	4293	4293
   query88	2951	2328	2325	2325
   query89	392	326	305	305
   query90	1694	219	219	219
   query91	137	145	111	111
   query92	68	59	57	57
   query93	1127	970	598	598
   query94	647	315	195	195
   query95	370	290	282	282
   query96	503	564	284	284
   query97	2627	2743	2605	2605
   query98	234	208	200	200
   query99	1303	1398	1288	1288
   Total cold run time: 268997 ms
   Total hot run time: 187269 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.3 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 9dd3700cd6960b5b622977d86f5d37551a88a428, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.08	0.04	0.04
   query3	0.24	0.07	0.07
   query4	1.64	0.11	0.11
   query5	0.43	0.42	0.41
   query6	1.17	0.67	0.68
   query7	0.02	0.01	0.02
   query8	0.04	0.04	0.03
   query9	0.60	0.51	0.51
   query10	0.57	0.58	0.57
   query11	0.16	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.64	0.61	0.62
   query14	0.83	0.82	0.82
   query15	0.91	0.86	0.89
   query16	0.38	0.38	0.40
   query17	1.12	1.05	1.07
   query18	0.22	0.22	0.21
   query19	1.93	1.85	1.80
   query20	0.01	0.01	0.02
   query21	15.37	0.89	0.53
   query22	0.74	1.35	0.62
   query23	14.86	1.37	0.66
   query24	7.38	1.79	0.53
   query25	0.51	0.13	0.10
   query26	0.56	0.17	0.15
   query27	0.06	0.05	0.04
   query28	9.62	0.94	0.46
   query29	12.51	3.99	3.37
   query30	3.06	3.03	2.99
   query31	2.82	0.61	0.40
   query32	3.23	0.54	0.49
   query33	3.06	3.11	3.07
   query34	16.04	5.38	4.80
   query35	4.81	4.86	4.85
   query36	0.70	0.50	0.53
   query37	0.08	0.06	0.07
   query38	0.05	0.04	0.03
   query39	0.03	0.03	0.02
   query40	0.18	0.14	0.13
   query41	0.08	0.02	0.03
   query42	0.03	0.03	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 107 s
   Total hot run time: 32.3 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

Posted by "yx-keith (via GitHub)" <gi...@apache.org>.
yx-keith closed pull request #49985: [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids
URL: https://github.com/apache/doris/pull/49985


-- 
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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 187542 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 df1b950aa84e49587a74197614467cb3dd26fbfd, data reload: false
   
   query1	1015	372	376	372
   query2	6508	1702	1638	1638
   query3	6736	210	212	210
   query4	26318	23738	23481	23481
   query5	4995	594	436	436
   query6	309	220	195	195
   query7	4628	495	284	284
   query8	272	214	211	211
   query9	8657	2605	2633	2605
   query10	501	321	270	270
   query11	15281	15161	14895	14895
   query12	159	111	101	101
   query13	1641	534	389	389
   query14	9083	5702	5762	5702
   query15	200	201	163	163
   query16	7346	641	463	463
   query17	1133	720	575	575
   query18	1993	417	288	288
   query19	191	191	161	161
   query20	122	118	122	118
   query21	214	122	103	103
   query22	4211	4441	4702	4441
   query23	34992	34108	33310	33310
   query24	8471	2334	2372	2334
   query25	537	445	386	386
   query26	1232	269	144	144
   query27	2756	505	358	358
   query28	4326	2130	2104	2104
   query29	765	598	497	497
   query30	279	216	185	185
   query31	906	827	735	735
   query32	70	61	62	61
   query33	556	368	318	318
   query34	798	841	510	510
   query35	771	844	717	717
   query36	974	995	902	902
   query37	107	96	75	75
   query38	4128	4121	4106	4106
   query39	1535	1436	1453	1436
   query40	206	150	105	105
   query41	54	50	49	49
   query42	118	108	103	103
   query43	521	499	467	467
   query44	1351	836	833	833
   query45	180	166	161	161
   query46	854	1000	620	620
   query47	1770	1798	1758	1758
   query48	385	423	304	304
   query49	738	446	392	392
   query50	630	680	410	410
   query51	5421	5574	5456	5456
   query52	112	98	97	97
   query53	218	244	185	185
   query54	560	568	492	492
   query55	81	77	84	77
   query56	303	304	290	290
   query57	1193	1201	1111	1111
   query58	274	265	268	265
   query59	2554	2670	2537	2537
   query60	343	339	336	336
   query61	169	145	122	122
   query62	807	738	636	636
   query63	217	187	180	180
   query64	4262	998	683	683
   query65	4301	4145	4212	4145
   query66	1110	402	315	315
   query67	16224	15723	15535	15535
   query68	6497	914	531	531
   query69	469	301	285	285
   query70	1255	1136	1145	1136
   query71	405	317	311	311
   query72	5704	4853	4955	4853
   query73	671	651	347	347
   query74	9080	9059	8845	8845
   query75	3200	3163	2670	2670
   query76	3212	1155	713	713
   query77	470	394	395	394
   query78	9884	9949	9228	9228
   query79	2283	827	598	598
   query80	588	514	462	462
   query81	512	256	220	220
   query82	467	131	97	97
   query83	268	254	237	237
   query84	252	112	90	90
   query85	796	363	379	363
   query86	384	314	308	308
   query87	4369	4342	4318	4318
   query88	3953	2290	2280	2280
   query89	383	310	280	280
   query90	1935	204	206	204
   query91	141	152	114	114
   query92	76	58	56	56
   query93	1809	938	594	594
   query94	717	404	310	310
   query95	376	294	279	279
   query96	506	579	277	277
   query97	2674	2748	2706	2706
   query98	233	210	206	206
   query99	1380	1409	1287	1287
   Total cold run time: 274621 ms
   Total hot run time: 187542 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33332 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 df1b950aa84e49587a74197614467cb3dd26fbfd, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17551	5207	5097	5097
   q2	1930	278	184	184
   q3	10317	1270	743	743
   q4	10222	1022	535	535
   q5	7544	2421	2300	2300
   q6	178	159	126	126
   q7	900	759	602	602
   q8	9327	1299	1119	1119
   q9	6792	5128	5072	5072
   q10	6903	2369	1965	1965
   q11	470	290	279	279
   q12	344	351	209	209
   q13	17744	3691	3108	3108
   q14	230	237	228	228
   q15	538	472	475	472
   q16	426	419	368	368
   q17	601	867	381	381
   q18	7426	7309	7165	7165
   q19	930	945	529	529
   q20	357	343	226	226
   q21	3661	3129	2328	2328
   q22	357	326	296	296
   Total cold run time: 104748 ms
   Total hot run time: 33332 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5172	5147	5102	5102
   q2	236	322	219	219
   q3	2144	2702	2272	2272
   q4	1374	1787	1320	1320
   q5	4279	4168	4604	4168
   q6	214	171	121	121
   q7	2026	1966	1815	1815
   q8	2708	2641	2612	2612
   q9	7448	7300	7300	7300
   q10	3103	3287	3061	3061
   q11	647	517	500	500
   q12	680	773	614	614
   q13	3578	3946	3390	3390
   q14	303	279	254	254
   q15	569	465	497	465
   q16	454	520	445	445
   q17	1226	1559	1380	1380
   q18	7941	7744	7618	7618
   q19	797	837	879	837
   q20	2050	2104	1925	1925
   q21	5090	4661	4512	4512
   q22	620	589	541	541
   Total cold run time: 52659 ms
   Total hot run time: 50471 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

Posted by "yx-keith (via GitHub)" <gi...@apache.org>.
yx-keith closed pull request #49985: [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids
URL: https://github.com/apache/doris/pull/49985


-- 
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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   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).
   
   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?
       


-- 
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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.87 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 df1b950aa84e49587a74197614467cb3dd26fbfd, data reload: false
   
   query1	0.05	0.03	0.03
   query2	0.08	0.04	0.05
   query3	0.24	0.07	0.07
   query4	1.63	0.11	0.11
   query5	0.44	0.40	0.44
   query6	1.16	0.66	0.65
   query7	0.02	0.02	0.02
   query8	0.04	0.04	0.03
   query9	0.59	0.51	0.52
   query10	0.58	0.57	0.57
   query11	0.16	0.12	0.11
   query12	0.14	0.11	0.12
   query13	0.62	0.61	0.61
   query14	0.78	0.84	0.79
   query15	0.89	0.89	0.85
   query16	0.39	0.39	0.40
   query17	1.08	1.06	1.06
   query18	0.22	0.20	0.21
   query19	1.94	1.90	1.84
   query20	0.02	0.01	0.01
   query21	15.40	0.89	0.52
   query22	0.76	1.22	0.64
   query23	14.94	1.37	0.62
   query24	6.91	1.95	0.42
   query25	0.50	0.22	0.14
   query26	0.57	0.16	0.15
   query27	0.06	0.06	0.05
   query28	9.98	0.88	0.44
   query29	12.53	3.96	3.25
   query30	3.03	2.97	2.90
   query31	2.82	0.58	0.40
   query32	3.23	0.56	0.47
   query33	3.05	3.05	3.19
   query34	15.98	5.35	4.73
   query35	4.83	4.87	4.85
   query36	0.68	0.52	0.49
   query37	0.09	0.06	0.07
   query38	0.05	0.05	0.04
   query39	0.04	0.03	0.03
   query40	0.16	0.14	0.14
   query41	0.07	0.03	0.02
   query42	0.03	0.03	0.03
   query43	0.04	0.03	0.03
   Total cold run time: 106.82 s
   Total hot run time: 31.87 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] [Enhancement] (nereids) optimize CreateRoutineLoadCommand in nereids [doris]

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


-- 
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