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

[PR] [nereids] downgrade bucket shuffle when tablet num is smaller than instance num [doris]

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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--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] [nereids] downgrade bucket shuffle when tablet num is smaller than instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41268 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 b8f198aa38ddc9649b3af2fe1480bc5250d0d976, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17692	4955	4878	4878
   q2	2031	144	135	135
   q3	10572	1047	1001	1001
   q4	4652	966	965	965
   q5	7675	3191	3251	3191
   q6	192	132	130	130
   q7	1266	779	756	756
   q8	9250	2061	2077	2061
   q9	7596	6693	6676	6676
   q10	8289	2638	2628	2628
   q11	416	223	203	203
   q12	771	324	332	324
   q13	17994	3676	3667	3667
   q14	294	260	260	260
   q15	587	519	498	498
   q16	474	418	410	410
   q17	928	888	846	846
   q18	7334	6709	6581	6581
   q19	1524	1487	1480	1480
   q20	630	357	334	334
   q21	6727	3908	3955	3908
   q22	864	341	336	336
   Total cold run time: 107758 ms
   Total hot run time: 41268 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4869	4868	4882	4868
   q2	293	180	182	180
   q3	3590	3591	3585	3585
   q4	2591	2568	2559	2559
   q5	5755	5758	5757	5757
   q6	208	128	130	128
   q7	2240	1635	1665	1635
   q8	3032	3135	3125	3125
   q9	8721	8713	8726	8713
   q10	6842	4243	4236	4236
   q11	530	373	383	373
   q12	759	538	544	538
   q13	4406	3413	3421	3413
   q14	261	248	256	248
   q15	581	493	507	493
   q16	478	452	428	428
   q17	1704	1631	1627	1627
   q18	8252	7647	7644	7644
   q19	1621	1623	1621	1621
   q20	2112	1841	1834	1834
   q21	6592	6203	6204	6203
   q22	601	504	498	498
   Total cold run time: 66038 ms
   Total hot run time: 59706 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e1b50beaec0b8c82e3c8b436b49aafd62e939cf1 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
   Stream load orc:          60 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   run performance
   
   


-- 
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] [nereids] downgrade bucket shuffle when tablet num is smaller than instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e1b50beaec0b8c82e3c8b436b49aafd62e939cf1 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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.6 seconds inserted 10000000 Rows, about 735K 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176780 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   query1	1049	344	352	344
   query2	6658	1817	1710	1710
   query3	6697	207	198	198
   query4	23161	21349	21263	21263
   query5	4334	385	401	385
   query6	762	213	190	190
   query7	6457	303	289	289
   query8	254	190	207	190
   query9	8441	2851	2861	2851
   query10	422	227	220	220
   query11	15294	14986	14927	14927
   query12	156	87	94	87
   query13	1746	453	455	453
   query14	12430	7713	7835	7713
   query15	231	187	197	187
   query16	9680	274	260	260
   query17	2884	583	521	521
   query18	2360	259	262	259
   query19	191	139	147	139
   query20	84	84	83	83
   query21	196	121	125	121
   query22	4850	4628	4606	4606
   query23	32435	31410	31482	31410
   query24	10951	3405	3424	3405
   query25	610	357	355	355
   query26	1684	147	160	147
   query27	3050	324	312	312
   query28	6630	1870	1842	1842
   query29	1069	605	622	605
   query30	273	137	146	137
   query31	937	745	763	745
   query32	97	61	54	54
   query33	725	228	224	224
   query34	1074	489	495	489
   query35	927	833	825	825
   query36	979	879	879	879
   query37	141	62	60	60
   query38	3312	3149	3163	3149
   query39	1370	1318	1326	1318
   query40	279	106	105	105
   query41	36	35	36	35
   query42	107	104	95	95
   query43	480	447	451	447
   query44	1062	677	687	677
   query45	197	187	177	177
   query46	1034	774	756	756
   query47	1653	1504	1563	1504
   query48	415	357	360	357
   query49	1171	308	308	308
   query50	765	363	364	363
   query51	4366	4302	4291	4291
   query52	107	97	92	92
   query53	410	302	304	302
   query54	302	213	227	213
   query55	84	79	76	76
   query56	219	214	199	199
   query57	1058	958	997	958
   query58	217	198	195	195
   query59	2268	2146	2171	2146
   query60	237	225	211	211
   query61	86	85	89	85
   query62	598	388	387	387
   query63	335	278	288	278
   query64	6279	3038	3123	3038
   query65	3280	3282	3226	3226
   query66	1341	326	324	324
   query67	14568	14324	13974	13974
   query68	5140	571	551	551
   query69	522	358	358	358
   query70	1273	1200	1193	1193
   query71	452	259	257	257
   query72	6306	2750	2619	2619
   query73	687	308	306	306
   query74	6803	6464	6467	6464
   query75	3223	2590	2557	2557
   query76	3275	1087	1209	1087
   query77	390	242	229	229
   query78	9407	8764	8815	8764
   query79	955	512	508	508
   query80	507	360	346	346
   query81	435	207	207	207
   query82	161	86	85	85
   query83	141	121	116	116
   query84	226	76	77	76
   query85	1011	342	337	337
   query86	300	313	300	300
   query87	3455	3271	3260	3260
   query88	2656	2283	2272	2272
   query89	429	361	348	348
   query90	1916	167	164	164
   query91	154	119	124	119
   query92	52	45	49	45
   query93	1020	517	503	503
   query94	1209	178	176	176
   query95	425	331	340	331
   query96	570	259	262	259
   query97	4448	4249	4266	4249
   query98	226	207	197	197
   query99	1085	750	726	726
   Total cold run time: 276414 ms
   Total hot run time: 176780 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit b8f198aa38ddc9649b3af2fe1480bc5250d0d976 with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 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:       14.4 seconds inserted 10000000 Rows, about 694K 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.81 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   query1	0.03	0.03	0.02
   query2	0.06	0.03	0.03
   query3	0.23	0.08	0.07
   query4	1.66	0.08	0.08
   query5	0.48	0.48	0.48
   query6	1.36	0.62	0.62
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.54	0.44	0.44
   query10	0.50	0.48	0.49
   query11	0.13	0.10	0.09
   query12	0.12	0.10	0.10
   query13	0.59	0.59	0.59
   query14	0.75	0.78	0.78
   query15	0.82	0.80	0.79
   query16	0.32	0.34	0.33
   query17	0.87	0.89	0.92
   query18	0.20	0.17	0.18
   query19	1.79	1.70	1.64
   query20	0.02	0.01	0.01
   query21	15.40	0.66	0.60
   query22	3.47	3.91	2.37
   query23	17.55	1.09	0.96
   query24	2.10	0.94	0.18
   query25	0.56	0.06	0.05
   query26	0.15	0.13	0.13
   query27	0.06	0.04	0.04
   query28	11.85	0.83	0.82
   query29	12.52	3.34	3.44
   query30	0.55	0.50	0.47
   query31	2.77	0.36	0.36
   query32	3.36	0.48	0.48
   query33	3.14	3.16	3.17
   query34	15.36	4.52	4.50
   query35	4.50	4.47	4.49
   query36	1.07	0.95	0.95
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.04
   query39	0.02	0.01	0.02
   query40	0.16	0.14	0.15
   query41	0.08	0.01	0.01
   query42	0.02	0.02	0.02
   query43	0.03	0.02	0.02
   Total cold run time: 105.36 s
   Total hot run time: 30.81 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 49b226d7d0ca7f9c76f73b6d31329ddfc42205e0 with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
   Stream load orc:          60 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.2 seconds inserted 10000000 Rows, about 757K 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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


-- 
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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.23 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 b8f198aa38ddc9649b3af2fe1480bc5250d0d976, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.07	0.02	0.02
   query3	0.23	0.08	0.07
   query4	1.62	0.08	0.08
   query5	0.49	0.49	0.48
   query6	1.39	0.61	0.61
   query7	0.02	0.01	0.02
   query8	0.04	0.03	0.03
   query9	0.52	0.46	0.45
   query10	0.51	0.53	0.52
   query11	0.14	0.10	0.10
   query12	0.12	0.10	0.10
   query13	0.59	0.60	0.59
   query14	0.79	0.76	0.80
   query15	0.82	0.80	0.80
   query16	0.33	0.34	0.34
   query17	0.88	0.91	0.94
   query18	0.18	0.18	0.16
   query19	1.74	1.62	1.71
   query20	0.01	0.00	0.01
   query21	15.40	0.60	0.60
   query22	2.90	3.63	2.50
   query23	17.51	1.24	0.97
   query24	2.19	0.47	0.56
   query25	0.60	0.07	0.06
   query26	0.17	0.14	0.15
   query27	0.06	0.05	0.05
   query28	11.68	0.86	0.79
   query29	12.54	3.33	3.36
   query30	0.54	0.49	0.49
   query31	2.78	0.36	0.37
   query32	3.30	0.47	0.49
   query33	3.15	3.10	3.15
   query34	15.36	4.53	4.50
   query35	4.53	4.48	4.53
   query36	1.09	0.99	0.97
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.01	0.01
   query40	0.17	0.14	0.16
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 104.75 s
   Total hot run time: 31.23 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176288 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 49b226d7d0ca7f9c76f73b6d31329ddfc42205e0, data reload: false
   
   query1	921	349	345	345
   query2	6531	1705	1685	1685
   query3	6691	203	206	203
   query4	23288	21076	21170	21076
   query5	4292	375	374	374
   query6	259	168	172	168
   query7	4611	296	289	289
   query8	257	197	198	197
   query9	8417	2840	2821	2821
   query10	418	225	217	217
   query11	15061	14521	14489	14489
   query12	152	85	82	82
   query13	1719	406	410	406
   query14	9118	7581	7640	7581
   query15	209	182	185	182
   query16	7552	253	247	247
   query17	1417	562	540	540
   query18	1938	257	251	251
   query19	197	152	151	151
   query20	84	82	82	82
   query21	192	112	116	112
   query22	4932	4741	4687	4687
   query23	32501	31550	31608	31550
   query24	12700	3415	3408	3408
   query25	644	358	354	354
   query26	1879	151	149	149
   query27	3066	324	318	318
   query28	6621	1842	1849	1842
   query29	1091	616	603	603
   query30	280	136	146	136
   query31	948	743	768	743
   query32	96	62	59	59
   query33	750	227	233	227
   query34	1069	487	483	483
   query35	944	810	809	809
   query36	975	909	933	909
   query37	151	63	60	60
   query38	3322	3174	3184	3174
   query39	1368	1340	1317	1317
   query40	284	104	107	104
   query41	40	35	34	34
   query42	102	95	103	95
   query43	463	432	441	432
   query44	1060	697	697	697
   query45	189	183	181	181
   query46	1033	750	757	750
   query47	1663	1589	1538	1538
   query48	415	362	335	335
   query49	1209	305	296	296
   query50	771	365	368	365
   query51	4405	4317	4337	4317
   query52	99	95	92	92
   query53	435	301	304	301
   query54	297	225	225	225
   query55	85	83	77	77
   query56	217	197	198	197
   query57	1075	966	953	953
   query58	223	195	187	187
   query59	2249	2109	2073	2073
   query60	251	212	218	212
   query61	87	84	91	84
   query62	604	412	369	369
   query63	324	291	278	278
   query64	6424	3080	3143	3080
   query65	3287	3271	3241	3241
   query66	1348	329	327	327
   query67	14505	14388	14032	14032
   query68	5094	567	562	562
   query69	517	357	357	357
   query70	1221	1201	1296	1201
   query71	388	249	248	248
   query72	6345	2826	2627	2627
   query73	694	304	308	304
   query74	6857	6498	6451	6451
   query75	3228	2552	2567	2552
   query76	3289	1127	1203	1127
   query77	360	234	233	233
   query78	9401	8900	8796	8796
   query79	947	536	518	518
   query80	513	351	345	345
   query81	440	205	205	205
   query82	162	84	88	84
   query83	148	128	127	127
   query84	230	84	79	79
   query85	1029	348	345	345
   query86	295	315	302	302
   query87	3412	3276	3249	3249
   query88	2711	2278	2277	2277
   query89	435	345	361	345
   query90	1933	167	163	163
   query91	156	122	130	122
   query92	51	47	47	47
   query93	988	507	493	493
   query94	1117	170	176	170
   query95	426	330	328	328
   query96	565	259	264	259
   query97	4408	4307	4267	4267
   query98	223	200	194	194
   query99	1088	717	713	713
   Total cold run time: 268476 ms
   Total hot run time: 176288 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.15 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 49b226d7d0ca7f9c76f73b6d31329ddfc42205e0, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.06	0.03	0.03
   query3	0.23	0.07	0.06
   query4	1.67	0.09	0.08
   query5	0.48	0.49	0.50
   query6	1.39	0.61	0.64
   query7	0.01	0.01	0.02
   query8	0.04	0.02	0.02
   query9	0.54	0.48	0.45
   query10	0.49	0.50	0.50
   query11	0.12	0.10	0.10
   query12	0.12	0.10	0.10
   query13	0.60	0.59	0.59
   query14	0.77	0.79	0.80
   query15	0.83	0.81	0.80
   query16	0.33	0.34	0.34
   query17	0.95	0.92	0.93
   query18	0.18	0.18	0.18
   query19	1.70	1.69	1.70
   query20	0.01	0.02	0.02
   query21	15.40	0.63	0.57
   query22	2.68	3.31	3.56
   query23	17.84	0.91	0.94
   query24	2.30	0.55	0.38
   query25	0.62	0.07	0.05
   query26	0.16	0.14	0.15
   query27	0.05	0.06	0.05
   query28	12.00	0.87	0.85
   query29	12.52	3.41	3.53
   query30	0.57	0.49	0.48
   query31	2.78	0.35	0.36
   query32	3.35	0.49	0.48
   query33	3.12	3.15	3.16
   query34	15.35	4.50	4.49
   query35	4.50	4.46	4.48
   query36	1.08	0.98	0.98
   query37	0.07	0.05	0.05
   query38	0.03	0.03	0.04
   query39	0.02	0.01	0.02
   query40	0.17	0.15	0.15
   query41	0.07	0.02	0.02
   query42	0.03	0.02	0.01
   query43	0.03	0.02	0.02
   Total cold run time: 105.29 s
   Total hot run time: 32.15 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40872 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17700	5004	4867	4867
   q2	2030	139	132	132
   q3	10577	988	979	979
   q4	4652	968	966	966
   q5	7607	3137	3178	3137
   q6	197	135	131	131
   q7	1247	764	765	764
   q8	9234	2061	2048	2048
   q9	7434	6555	6551	6551
   q10	8309	2630	2625	2625
   q11	420	212	218	212
   q12	792	322	334	322
   q13	17929	3578	3586	3578
   q14	301	259	258	258
   q15	584	510	504	504
   q16	477	413	416	413
   q17	922	852	848	848
   q18	7352	6599	6517	6517
   q19	1520	1488	1492	1488
   q20	552	261	271	261
   q21	6827	3957	3950	3950
   q22	871	338	321	321
   Total cold run time: 107534 ms
   Total hot run time: 40872 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4881	4868	4856	4856
   q2	291	183	183	183
   q3	3590	3579	3580	3579
   q4	2530	2514	2529	2514
   q5	5765	5763	5767	5763
   q6	209	122	127	122
   q7	2232	1635	1667	1635
   q8	3023	3125	3124	3124
   q9	8707	8679	8703	8679
   q10	6856	4238	4237	4237
   q11	513	380	377	377
   q12	774	533	528	528
   q13	4268	3401	3402	3401
   q14	256	226	245	226
   q15	606	508	518	508
   q16	487	425	424	424
   q17	1683	1634	1622	1622
   q18	8263	7800	7500	7500
   q19	1629	1636	1621	1621
   q20	2121	1845	1821	1821
   q21	6630	6195	6181	6181
   q22	550	497	497	497
   Total cold run time: 65864 ms
   Total hot run time: 59398 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176736 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   query1	920	345	354	345
   query2	6509	1721	1721	1721
   query3	6690	204	198	198
   query4	23243	21130	21240	21130
   query5	4367	382	383	382
   query6	270	184	168	168
   query7	4611	302	300	300
   query8	249	198	204	198
   query9	8460	2854	2838	2838
   query10	413	227	234	227
   query11	15136	14692	14419	14419
   query12	145	84	81	81
   query13	1707	428	429	428
   query14	9478	7785	7750	7750
   query15	210	184	188	184
   query16	7535	256	243	243
   query17	1524	572	532	532
   query18	1953	282	269	269
   query19	192	145	150	145
   query20	86	84	90	84
   query21	185	121	126	121
   query22	4895	4654	4743	4654
   query23	32599	31423	31377	31377
   query24	12689	3389	3472	3389
   query25	635	364	358	358
   query26	1888	158	168	158
   query27	3033	317	324	317
   query28	6510	1875	1870	1870
   query29	1140	641	642	641
   query30	284	136	147	136
   query31	951	745	739	739
   query32	94	59	58	58
   query33	736	238	243	238
   query34	1068	491	505	491
   query35	937	831	846	831
   query36	997	907	919	907
   query37	185	64	61	61
   query38	3241	3162	3143	3143
   query39	1392	1336	1310	1310
   query40	287	108	109	108
   query41	40	35	35	35
   query42	108	104	102	102
   query43	469	452	439	439
   query44	1081	686	698	686
   query45	199	183	181	181
   query46	1062	785	776	776
   query47	1667	1602	1519	1519
   query48	409	340	344	340
   query49	1216	308	305	305
   query50	767	378	377	377
   query51	4501	4371	4429	4371
   query52	107	94	98	94
   query53	404	313	313	313
   query54	290	228	227	227
   query55	87	83	78	78
   query56	223	207	202	202
   query57	1051	966	947	947
   query58	221	199	205	199
   query59	2308	2142	2115	2115
   query60	238	230	214	214
   query61	85	88	85	85
   query62	589	398	368	368
   query63	335	306	308	306
   query64	6257	3106	3148	3106
   query65	3294	3256	3248	3248
   query66	1328	333	328	328
   query67	14764	14227	14295	14227
   query68	5166	553	573	553
   query69	501	358	362	358
   query70	1290	1217	1182	1182
   query71	361	255	265	255
   query72	6402	2780	2634	2634
   query73	703	308	311	308
   query74	6886	6356	6382	6356
   query75	3182	2560	2545	2545
   query76	3197	1129	1193	1129
   query77	363	244	239	239
   query78	9430	8715	8793	8715
   query79	968	512	519	512
   query80	523	354	351	351
   query81	436	204	202	202
   query82	236	86	87	86
   query83	143	126	123	123
   query84	224	81	77	77
   query85	1020	345	345	345
   query86	298	303	309	303
   query87	3478	3253	3303	3253
   query88	2735	2290	2280	2280
   query89	463	366	373	366
   query90	2021	167	166	166
   query91	156	127	130	127
   query92	57	50	50	50
   query93	1020	516	506	506
   query94	1288	181	180	180
   query95	448	340	351	340
   query96	572	261	267	261
   query97	4450	4350	4286	4286
   query98	233	211	198	198
   query99	1116	739	713	713
   Total cold run time: 269910 ms
   Total hot run time: 176736 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.29 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   query1	0.02	0.02	0.02
   query2	0.06	0.02	0.02
   query3	0.22	0.07	0.07
   query4	1.65	0.10	0.10
   query5	0.52	0.51	0.49
   query6	1.36	0.62	0.63
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.03
   query9	0.55	0.45	0.44
   query10	0.51	0.49	0.48
   query11	0.13	0.10	0.10
   query12	0.12	0.10	0.11
   query13	0.60	0.59	0.60
   query14	0.77	0.79	0.80
   query15	0.85	0.82	0.82
   query16	0.34	0.34	0.34
   query17	0.96	0.95	0.96
   query18	0.19	0.20	0.18
   query19	1.83	1.74	1.75
   query20	0.02	0.01	0.02
   query21	15.42	0.62	0.58
   query22	3.32	4.05	1.35
   query23	17.64	1.03	0.96
   query24	1.99	0.76	0.20
   query25	0.61	0.06	0.06
   query26	0.16	0.14	0.13
   query27	0.06	0.06	0.05
   query28	12.01	0.84	0.84
   query29	12.72	3.38	3.36
   query30	0.52	0.50	0.48
   query31	2.76	0.38	0.39
   query32	3.30	0.49	0.50
   query33	3.23	3.25	3.22
   query34	15.36	4.59	4.54
   query35	4.56	4.51	4.51
   query36	1.11	0.99	1.00
   query37	0.08	0.05	0.05
   query38	0.04	0.03	0.02
   query39	0.02	0.01	0.01
   query40	0.17	0.14	0.15
   query41	0.07	0.02	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 105.95 s
   Total hot run time: 30.29 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41161 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 49b226d7d0ca7f9c76f73b6d31329ddfc42205e0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17642	5022	4917	4917
   q2	2046	138	137	137
   q3	10581	994	995	994
   q4	4650	974	987	974
   q5	7634	3161	3215	3161
   q6	199	142	140	140
   q7	1263	794	775	775
   q8	9242	2072	2086	2072
   q9	7513	6583	6585	6583
   q10	8323	2662	2626	2626
   q11	419	220	222	220
   q12	770	332	324	324
   q13	17935	3611	3602	3602
   q14	296	253	261	253
   q15	606	514	530	514
   q16	479	415	413	413
   q17	938	879	884	879
   q18	7534	6580	6505	6505
   q19	1563	1503	1502	1502
   q20	542	272	274	272
   q21	6424	3961	3983	3961
   q22	869	348	337	337
   Total cold run time: 107468 ms
   Total hot run time: 41161 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4867	4877	4892	4877
   q2	297	188	189	188
   q3	3589	3602	3610	3602
   q4	2524	2549	2526	2526
   q5	5756	5765	5754	5754
   q6	210	132	136	132
   q7	2280	1749	1710	1710
   q8	3051	3117	3141	3117
   q9	8678	8695	8706	8695
   q10	6821	4247	4259	4247
   q11	529	390	388	388
   q12	776	552	543	543
   q13	4422	3437	3434	3434
   q14	267	239	249	239
   q15	630	535	535	535
   q16	508	474	464	464
   q17	2041	1636	1615	1615
   q18	8391	7724	7676	7676
   q19	1639	1643	1642	1642
   q20	2127	1837	1850	1837
   q21	6690	6220	6233	6220
   q22	564	519	508	508
   Total cold run time: 66657 ms
   Total hot run time: 59949 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   run performance


-- 
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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41296 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 e1b50beaec0b8c82e3c8b436b49aafd62e939cf1, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17906	5278	5141	5141
   q2	2365	146	142	142
   q3	11479	1025	1030	1025
   q4	5284	969	981	969
   q5	7607	3148	3207	3148
   q6	201	140	136	136
   q7	1284	779	748	748
   q8	9254	2081	2036	2036
   q9	7480	6623	6577	6577
   q10	8301	2653	2648	2648
   q11	421	221	207	207
   q12	803	332	336	332
   q13	17932	3615	3650	3615
   q14	288	259	263	259
   q15	575	508	504	504
   q16	481	405	428	405
   q17	917	846	819	819
   q18	7404	6760	6554	6554
   q19	1548	1489	1490	1489
   q20	502	269	271	269
   q21	6030	3938	3952	3938
   q22	840	342	335	335
   Total cold run time: 108902 ms
   Total hot run time: 41296 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4876	4839	4856	4839
   q2	305	196	189	189
   q3	3627	3619	3598	3598
   q4	2559	2546	2546	2546
   q5	5751	5761	5734	5734
   q6	213	130	132	130
   q7	2239	1644	1663	1644
   q8	3048	3103	3103	3103
   q9	8706	8692	8701	8692
   q10	6599	4245	4232	4232
   q11	518	388	377	377
   q12	781	546	548	546
   q13	4208	3393	3436	3393
   q14	267	242	241	241
   q15	625	500	494	494
   q16	489	455	447	447
   q17	1751	1636	1644	1636
   q18	8408	7771	7829	7771
   q19	1641	1627	1629	1627
   q20	2104	1852	1834	1834
   q21	6721	6413	6332	6332
   q22	581	512	507	507
   Total cold run time: 66017 ms
   Total hot run time: 59912 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] [nereids] downgrade bucket shuffle if tablet num < instance num [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 177503 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 b8f198aa38ddc9649b3af2fe1480bc5250d0d976, data reload: false
   
   query1	927	349	342	342
   query2	6524	1686	1666	1666
   query3	6693	205	205	205
   query4	23179	21122	21369	21122
   query5	4781	380	372	372
   query6	264	172	178	172
   query7	4604	297	294	294
   query8	260	200	208	200
   query9	8446	2865	2852	2852
   query10	441	228	227	227
   query11	15049	14767	14548	14548
   query12	145	87	82	82
   query13	1694	429	417	417
   query14	9642	7802	8513	7802
   query15	224	193	227	193
   query16	7805	274	279	274
   query17	1995	639	589	589
   query18	3639	283	302	283
   query19	416	180	177	177
   query20	141	96	107	96
   query21	705	132	136	132
   query22	5098	4882	4826	4826
   query23	32733	31630	31681	31630
   query24	12371	3528	3403	3403
   query25	621	370	372	370
   query26	1710	148	152	148
   query27	3052	318	315	315
   query28	6464	1843	1822	1822
   query29	1138	609	610	609
   query30	278	139	148	139
   query31	931	733	767	733
   query32	97	56	58	56
   query33	735	234	238	234
   query34	1085	486	492	486
   query35	944	822	820	820
   query36	986	927	877	877
   query37	136	60	63	60
   query38	3259	3216	3189	3189
   query39	1367	1312	1315	1312
   query40	284	109	109	109
   query41	38	36	35	35
   query42	104	96	101	96
   query43	466	438	435	435
   query44	1064	710	710	710
   query45	192	179	172	172
   query46	1068	779	772	772
   query47	1636	1556	1568	1556
   query48	426	357	349	349
   query49	1162	302	305	302
   query50	771	379	371	371
   query51	4434	4342	4292	4292
   query52	105	88	93	88
   query53	391	294	297	294
   query54	303	228	229	228
   query55	81	81	76	76
   query56	221	197	206	197
   query57	1061	988	936	936
   query58	235	205	207	205
   query59	2205	2101	2020	2020
   query60	240	219	229	219
   query61	91	89	88	88
   query62	602	378	399	378
   query63	328	287	289	287
   query64	6116	3125	3181	3125
   query65	3301	3263	3243	3243
   query66	1362	335	321	321
   query67	14577	14353	14335	14335
   query68	5176	563	571	563
   query69	532	362	352	352
   query70	1245	1232	1193	1193
   query71	445	252	271	252
   query72	6342	2875	2700	2700
   query73	700	317	316	316
   query74	6821	6523	6465	6465
   query75	3288	2567	2542	2542
   query76	3405	1081	1225	1081
   query77	498	236	223	223
   query78	9433	8861	8730	8730
   query79	956	507	492	492
   query80	505	390	355	355
   query81	436	206	205	205
   query82	169	85	82	82
   query83	148	130	129	129
   query84	228	78	78	78
   query85	1042	373	350	350
   query86	299	312	308	308
   query87	3464	3317	3289	3289
   query88	2700	2306	2306	2306
   query89	437	344	347	344
   query90	1990	169	165	165
   query91	165	130	129	129
   query92	58	48	50	48
   query93	1001	517	509	509
   query94	1304	184	184	184
   query95	494	389	378	378
   query96	584	265	260	260
   query97	4437	4285	4263	4263
   query98	222	204	197	197
   query99	1072	702	748	702
   Total cold run time: 273039 ms
   Total hot run time: 177503 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