You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "liugddx (via GitHub)" <gi...@apache.org> on 2024/01/28 15:22:51 UTC

[PR] [regression test](schema change) add some case for agg col [doris]

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

   ## 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] [regression test](schema change) add some case for agg col [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 08cfccec847408a409aa57bc0c94c10c2353c9a8 with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 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] [regression test](schema change) add some case for agg col [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 117933327aa892ae1737f57a852c14bb03f0194c with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37580 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 117933327aa892ae1737f57a852c14bb03f0194c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17708	4816	5081	4816
   q2	2057	142	128	128
   q3	10716	975	907	907
   q4	4741	734	761	734
   q5	7678	2886	2878	2878
   q6	186	118	118	118
   q7	1136	734	711	711
   q8	9338	2016	2012	2012
   q9	7218	6333	6326	6326
   q10	8104	2443	2407	2407
   q11	418	197	203	197
   q12	812	274	285	274
   q13	18023	3315	3285	3285
   q14	275	243	252	243
   q15	531	500	492	492
   q16	455	403	416	403
   q17	926	550	517	517
   q18	6856	6035	6131	6035
   q19	3957	1420	1392	1392
   q20	571	334	335	334
   q21	7135	3130	3085	3085
   q22	798	286	292	286
   Total cold run time: 109639 ms
   Total hot run time: 37580 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4998	4930	4928	4928
   q2	330	238	237	237
   q3	3005	2734	2609	2609
   q4	1810	1596	1473	1473
   q5	5220	5094	5250	5094
   q6	202	116	115	115
   q7	2169	1809	1760	1760
   q8	3074	3202	3229	3202
   q9	8671	8466	15721	8466
   q10	5708	3439	3483	3439
   q11	553	469	443	443
   q12	787	600	601	600
   q13	16965	3075	3050	3050
   q14	278	238	260	238
   q15	556	486	490	486
   q16	522	440	464	440
   q17	1889	1754	1685	1685
   q18	8892	8452	8279	8279
   q19	24116	1570	1553	1553
   q20	4608	1905	1890	1890
   q21	15023	4778	4810	4778
   q22	1038	476	489	476
   Total cold run time: 110414 ms
   Total hot run time: 55241 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] [regression test](schema change) add some case for agg col [doris]

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

   run external


-- 
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] [regression test](schema change) add some case for agg col [doris]

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

   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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.75 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 117933327aa892ae1737f57a852c14bb03f0194c, data reload: false
   
   query1	0.05	0.03	0.03
   query2	0.06	0.02	0.02
   query3	0.23	0.06	0.07
   query4	1.68	0.10	0.09
   query5	0.52	0.51	0.51
   query6	1.19	0.63	0.65
   query7	0.02	0.01	0.02
   query8	0.04	0.02	0.03
   query9	0.54	0.50	0.50
   query10	0.56	0.54	0.55
   query11	0.12	0.09	0.08
   query12	0.11	0.09	0.09
   query13	0.61	0.60	0.60
   query14	0.80	0.79	0.80
   query15	0.80	0.79	0.77
   query16	0.36	0.38	0.39
   query17	1.02	1.01	1.00
   query18	0.22	0.26	0.22
   query19	1.80	1.76	1.79
   query20	0.01	0.00	0.01
   query21	15.40	0.58	0.56
   query22	2.59	2.85	1.87
   query23	17.26	0.71	0.72
   query24	2.77	1.21	0.71
   query25	0.55	0.16	0.20
   query26	0.40	0.14	0.14
   query27	0.05	0.04	0.04
   query28	11.00	0.85	0.84
   query29	12.49	3.20	3.22
   query30	0.65	0.53	0.58
   query31	2.79	0.35	0.34
   query32	3.36	0.47	0.48
   query33	3.17	3.20	3.23
   query34	15.71	4.39	4.25
   query35	4.23	4.34	4.34
   query36	1.08	1.04	1.07
   query37	0.06	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.02	0.01
   query40	0.16	0.13	0.12
   query41	0.07	0.02	0.01
   query42	0.02	0.01	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 104.63 s
   Total hot run time: 30.75 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] [regression test](schema change) add some case for agg col [doris]

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

   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] [regression test](schema change) add some case for agg col [doris]

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

   run pipelinex_p0


-- 
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] [regression test](schema change) add some case for agg col [doris]

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

   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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173381 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 08cfccec847408a409aa57bc0c94c10c2353c9a8, data reload: false
   
   query1	930	328	330	328
   query2	6563	2050	1929	1929
   query3	6698	199	196	196
   query4	34757	22144	22144	22144
   query5	4458	435	359	359
   query6	273	161	157	157
   query7	4596	263	264	263
   query8	256	172	173	172
   query9	8500	2274	2286	2274
   query10	411	208	212	208
   query11	18228	15393	15354	15354
   query12	116	66	67	66
   query13	1671	362	377	362
   query14	9231	6468	6440	6440
   query15	206	171	190	171
   query16	5701	265	251	251
   query17	941	486	485	485
   query18	1807	256	247	247
   query19	174	131	140	131
   query20	71	74	68	68
   query21	196	134	134	134
   query22	4940	4793	4672	4672
   query23	31146	30267	30335	30267
   query24	11609	2786	2749	2749
   query25	596	309	302	302
   query26	1792	134	134	134
   query27	3187	273	285	273
   query28	7775	1823	1810	1810
   query29	1828	607	607	607
   query30	284	136	139	136
   query31	923	714	719	714
   query32	76	53	54	53
   query33	687	217	213	213
   query34	1143	466	466	466
   query35	922	785	753	753
   query36	1359	1230	1281	1230
   query37	91	60	55	55
   query38	3227	3141	3155	3141
   query39	1317	1251	1249	1249
   query40	201	85	82	82
   query41	40	34	34	34
   query42	93	79	85	79
   query43	523	472	488	472
   query44	1091	678	684	678
   query45	194	174	175	174
   query46	1043	628	665	628
   query47	1539	1568	1507	1507
   query48	397	296	295	295
   query49	1133	287	282	282
   query50	666	311	312	311
   query51	5262	5231	5214	5214
   query52	106	73	73	73
   query53	347	279	263	263
   query54	245	181	188	181
   query55	76	78	72	72
   query56	169	167	152	152
   query57	982	909	921	909
   query58	186	165	158	158
   query59	2799	2504	2596	2504
   query60	196	167	170	167
   query61	85	85	82	82
   query62	662	376	360	360
   query63	270	267	274	267
   query64	4942	1771	1739	1739
   query65	3292	3225	3219	3219
   query66	1289	314	327	314
   query67	14295	14345	14194	14194
   query68	3784	495	472	472
   query69	446	292	299	292
   query70	1589	1520	1581	1520
   query71	260	213	216	213
   query72	3783	2866	2864	2864
   query73	687	312	311	311
   query74	6620	6150	6344	6150
   query75	2786	2295	2305	2295
   query76	2632	1046	1029	1029
   query77	371	239	231	231
   query78	9080	8879	8604	8604
   query79	2717	488	501	488
   query80	1944	319	313	313
   query81	532	194	201	194
   query82	700	83	74	74
   query83	236	127	119	119
   query84	284	77	72	72
   query85	2263	340	322	322
   query86	513	411	404	404
   query87	3519	3246	3272	3246
   query88	3785	2158	2166	2158
   query89	438	374	370	370
   query90	1874	184	182	182
   query91	148	120	135	120
   query92	52	44	44	44
   query93	2587	448	446	446
   query94	1310	160	155	155
   query95	512	462	454	454
   query96	613	309	306	306
   query97	4249	4125	4107	4107
   query98	209	193	190	190
   query99	1096	666	663	663
   Total cold run time: 282428 ms
   Total hot run time: 173381 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] [regression test](schema change) add some case for agg col [doris]

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

   run p0


-- 
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] [regression test](schema change) add some case for agg col [doris]

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

   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] [regression test](schema change) add some case for agg col [doris]

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

   LGTM


-- 
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] [regression test](schema change) add some case for agg col [doris]

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


-- 
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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37203 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 08cfccec847408a409aa57bc0c94c10c2353c9a8, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17648	4902	4756	4756
   q2	2068	142	137	137
   q3	10694	910	922	910
   q4	4701	684	690	684
   q5	7681	2845	2788	2788
   q6	185	122	123	122
   q7	1129	716	705	705
   q8	9393	1976	1989	1976
   q9	7185	6302	6259	6259
   q10	8105	2391	2381	2381
   q11	419	198	214	198
   q12	808	265	289	265
   q13	18012	3291	3292	3291
   q14	285	263	241	241
   q15	532	497	479	479
   q16	454	408	407	407
   q17	931	570	533	533
   q18	6903	6148	6068	6068
   q19	1573	1370	1383	1370
   q20	614	340	329	329
   q21	7108	3122	3016	3016
   q22	795	302	288	288
   Total cold run time: 107223 ms
   Total hot run time: 37203 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5180	4952	5059	4952
   q2	326	244	233	233
   q3	2989	2778	2684	2684
   q4	1762	1588	1546	1546
   q5	5173	5154	5081	5081
   q6	203	118	116	116
   q7	2171	1762	1804	1762
   q8	3097	3177	3212	3177
   q9	8533	8607	10836	8607
   q10	5463	3429	3413	3413
   q11	572	461	451	451
   q12	750	557	568	557
   q13	16933	3081	3114	3081
   q14	276	246	280	246
   q15	522	487	488	487
   q16	494	478	470	470
   q17	1980	1574	1659	1574
   q18	8794	12023	8607	8607
   q19	26654	1704	1559	1559
   q20	4607	1897	1904	1897
   q21	18090	4732	4732	4732
   q22	1564	451	462	451
   Total cold run time: 116133 ms
   Total hot run time: 55683 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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.34 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 08cfccec847408a409aa57bc0c94c10c2353c9a8, data reload: false
   
   query1	0.04	0.03	0.04
   query2	0.05	0.02	0.02
   query3	0.23	0.07	0.06
   query4	1.68	0.09	0.10
   query5	0.53	0.52	0.51
   query6	1.23	0.63	0.62
   query7	0.01	0.01	0.02
   query8	0.03	0.02	0.02
   query9	0.54	0.51	0.49
   query10	0.55	0.56	0.55
   query11	0.12	0.08	0.09
   query12	0.11	0.09	0.10
   query13	0.60	0.60	0.60
   query14	0.78	0.79	0.79
   query15	0.79	0.78	0.79
   query16	0.39	0.37	0.38
   query17	1.03	1.04	0.99
   query18	0.24	0.26	0.22
   query19	1.88	1.77	1.77
   query20	0.01	0.01	0.02
   query21	15.40	0.56	0.56
   query22	2.27	2.48	1.95
   query23	17.54	0.80	0.78
   query24	2.51	1.57	0.13
   query25	0.22	0.17	0.19
   query26	0.52	0.13	0.14
   query27	0.05	0.04	0.05
   query28	12.11	0.85	0.83
   query29	12.57	3.23	3.12
   query30	0.63	0.54	0.47
   query31	2.78	0.34	0.35
   query32	3.37	0.48	0.49
   query33	3.20	3.26	3.20
   query34	15.77	4.39	4.41
   query35	4.33	4.34	4.33
   query36	1.08	1.07	1.06
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.01	0.02
   query40	0.16	0.12	0.12
   query41	0.07	0.02	0.02
   query42	0.03	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 105.6 s
   Total hot run time: 30.34 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] [regression test](schema change) add some case for agg col [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173301 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 117933327aa892ae1737f57a852c14bb03f0194c, data reload: false
   
   query1	942	334	321	321
   query2	6562	1975	1827	1827
   query3	6700	205	195	195
   query4	32999	22018	21914	21914
   query5	4454	424	415	415
   query6	246	160	154	154
   query7	4602	260	271	260
   query8	238	173	168	168
   query9	8537	2274	2261	2261
   query10	408	215	200	200
   query11	17374	15410	15414	15410
   query12	120	67	66	66
   query13	1685	367	366	366
   query14	9188	6488	6431	6431
   query15	201	171	172	171
   query16	5706	254	249	249
   query17	952	485	472	472
   query18	1802	269	253	253
   query19	168	130	132	130
   query20	72	71	66	66
   query21	193	135	129	129
   query22	4920	4757	4758	4757
   query23	31062	30450	30349	30349
   query24	7491	2762	2759	2759
   query25	459	316	311	311
   query26	818	140	135	135
   query27	2803	279	285	279
   query28	3969	1837	1827	1827
   query29	915	613	599	599
   query30	203	136	141	136
   query31	920	705	736	705
   query32	80	52	49	49
   query33	421	209	211	209
   query34	813	452	471	452
   query35	855	780	743	743
   query36	1292	1230	1225	1225
   query37	91	55	58	55
   query38	3294	3141	3185	3141
   query39	1312	1234	1237	1234
   query40	194	86	83	83
   query41	37	38	36	36
   query42	85	82	79	79
   query43	522	484	471	471
   query44	1033	679	678	678
   query45	191	177	173	173
   query46	1020	638	645	638
   query47	1566	1482	1509	1482
   query48	379	309	316	309
   query49	610	289	286	286
   query50	668	304	305	304
   query51	5270	5175	5280	5175
   query52	87	80	74	74
   query53	307	261	254	254
   query54	232	184	187	184
   query55	80	73	73	73
   query56	179	161	168	161
   query57	950	923	927	923
   query58	184	156	148	148
   query59	2669	2477	2531	2477
   query60	218	181	178	178
   query61	88	91	94	91
   query62	445	367	351	351
   query63	281	264	261	261
   query64	3413	1803	1774	1774
   query65	3287	3216	3223	3216
   query66	1166	330	315	315
   query67	14657	14449	14316	14316
   query68	3717	479	470	470
   query69	438	298	293	293
   query70	1548	1565	1591	1565
   query71	262	208	215	208
   query72	3743	2863	2850	2850
   query73	687	309	315	309
   query74	6576	6389	6313	6313
   query75	2783	2305	2297	2297
   query76	2635	1040	1048	1040
   query77	378	230	226	226
   query78	9049	8898	8475	8475
   query79	3034	507	493	493
   query80	1915	320	317	317
   query81	509	201	206	201
   query82	700	83	78	78
   query83	238	114	108	108
   query84	277	77	77	77
   query85	1965	362	323	323
   query86	512	398	364	364
   query87	3462	3235	3282	3235
   query88	4132	2175	2154	2154
   query89	408	349	356	349
   query90	2043	184	180	180
   query91	153	137	122	122
   query92	54	44	41	41
   query93	5649	418	422	418
   query94	1371	160	155	155
   query95	498	452	452	452
   query96	627	311	316	311
   query97	4226	4111	4149	4111
   query98	205	194	196	194
   query99	1096	639	675	639
   Total cold run time: 269575 ms
   Total hot run time: 173301 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