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

[PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   IdToTask has no persistence, so the queried task will be lost once it is restarted.
   
   The cancel task does not update metadata after being removed from the running task.
   
   tvf displays an error when some fields in the query task result are empty
   
   ## Proposed changes
   
   <img width="1340" alt="image" src="https://github.com/apache/doris/assets/16631152/721f83f2-af9b-466a-9e39-83b278397fd8">
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   run buildall


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.62 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 cc7cbc03f6f307b2ef8da67ec3b9eb1ef7d97087, data reload: false
   
   query1	0.06	0.06	0.06
   query2	0.06	0.02	0.03
   query3	0.25	0.11	0.11
   query4	1.79	0.12	0.12
   query5	0.55	0.52	0.53
   query6	1.32	0.66	0.64
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.54	0.52	0.49
   query10	0.56	0.56	0.56
   query11	0.12	0.09	0.09
   query12	0.12	0.09	0.09
   query13	0.60	0.61	0.60
   query14	0.78	0.78	0.79
   query15	0.79	0.79	0.76
   query16	0.39	0.40	0.40
   query17	1.03	1.05	1.04
   query18	0.25	0.26	0.27
   query19	1.86	1.78	1.84
   query20	0.02	0.01	0.01
   query21	15.44	0.59	0.58
   query22	2.97	2.80	1.80
   query23	17.44	0.80	0.82
   query24	2.62	1.16	0.38
   query25	0.33	0.20	0.20
   query26	0.52	0.15	0.14
   query27	0.06	0.06	0.05
   query28	11.92	0.79	0.80
   query29	12.74	3.32	3.12
   query30	0.57	0.54	0.53
   query31	2.78	0.34	0.37
   query32	3.39	0.48	0.49
   query33	3.25	3.26	3.25
   query34	15.86	4.30	4.21
   query35	4.25	4.23	4.28
   query36	1.13	1.08	1.08
   query37	0.06	0.05	0.05
   query38	0.04	0.03	0.04
   query39	0.02	0.02	0.02
   query40	0.15	0.13	0.14
   query41	0.07	0.01	0.02
   query42	0.03	0.01	0.01
   query43	0.03	0.02	0.02
   Total cold run time: 106.82 s
   Total hot run time: 30.62 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 180391 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 cc7cbc03f6f307b2ef8da67ec3b9eb1ef7d97087, data reload: false
   
   query1	947	352	336	336
   query2	6702	1968	1947	1947
   query3	6723	215	207	207
   query4	33175	22557	22182	22182
   query5	6956	617	551	551
   query6	278	193	192	192
   query7	4622	291	278	278
   query8	252	202	201	201
   query9	9146	2774	2880	2774
   query10	478	251	244	244
   query11	17019	15414	15292	15292
   query12	124	76	82	76
   query13	1700	394	396	394
   query14	11398	7455	7620	7455
   query15	211	186	184	184
   query16	4623	255	248	248
   query17	1008	504	493	493
   query18	1810	273	268	268
   query19	195	155	147	147
   query20	83	81	76	76
   query21	197	138	127	127
   query22	4938	4743	4696	4696
   query23	32105	31279	31264	31264
   query24	12589	2878	2848	2848
   query25	573	333	337	333
   query26	1673	163	166	163
   query27	3229	282	285	282
   query28	7372	1854	1846	1846
   query29	1792	726	700	700
   query30	281	148	141	141
   query31	936	769	771	769
   query32	78	64	64	64
   query33	705	257	263	257
   query34	1130	482	484	482
   query35	892	765	798	765
   query36	1465	1177	1324	1177
   query37	100	70	69	69
   query38	3388	3288	3334	3288
   query39	1338	1300	1287	1287
   query40	338	98	95	95
   query41	39	37	36	36
   query42	101	96	101	96
   query43	575	539	525	525
   query44	1087	712	712	712
   query45	212	189	186	186
   query46	1069	672	681	672
   query47	1724	1606	1619	1606
   query48	406	326	327	326
   query49	1204	317	324	317
   query50	704	330	326	326
   query51	5383	5297	5303	5297
   query52	105	92	102	92
   query53	368	284	300	284
   query54	915	474	478	474
   query55	95	91	86	86
   query56	215	206	199	199
   query57	1045	939	941	939
   query58	219	194	200	194
   query59	3007	2928	2829	2829
   query60	245	217	215	215
   query61	88	86	90	86
   query62	701	401	407	401
   query63	313	308	302	302
   query64	6235	1675	1699	1675
   query65	3390	3292	3305	3292
   query66	1254	355	325	325
   query67	15794	15144	15243	15144
   query68	12202	551	552	551
   query69	660	348	348	348
   query70	1737	1584	1553	1553
   query71	546	233	257	233
   query72	4949	2864	2842	2842
   query73	2951	323	311	311
   query74	7192	6478	6581	6478
   query75	5274	2358	2308	2308
   query76	6235	1033	1049	1033
   query77	692	287	271	271
   query78	9440	8797	8750	8750
   query79	1047	522	527	522
   query80	559	336	368	336
   query81	449	212	209	209
   query82	211	96	90	90
   query83	147	131	126	126
   query84	281	74	76	74
   query85	1046	366	334	334
   query86	391	372	381	372
   query87	3593	3372	3350	3350
   query88	3100	2206	2211	2206
   query89	460	400	386	386
   query90	2026	206	202	202
   query91	156	127	125	125
   query92	65	60	55	55
   query93	1419	428	432	428
   query94	1183	192	188	188
   query95	521	486	491	486
   query96	625	322	318	318
   query97	4300	4167	4157	4157
   query98	224	199	190	190
   query99	1082	742	725	725
   Total cold run time: 303825 ms
   Total hot run time: 180391 ms
   ```
   </details>
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40196 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 cc7cbc03f6f307b2ef8da67ec3b9eb1ef7d97087, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17927	5978	5799	5799
   q2	2052	158	138	138
   q3	10883	1161	1188	1161
   q4	10825	798	804	798
   q5	7934	3258	3230	3230
   q6	209	127	129	127
   q7	930	536	502	502
   q8	9719	2039	2027	2027
   q9	7953	6585	6546	6546
   q10	8249	3097	3091	3091
   q11	415	211	218	211
   q12	359	190	194	190
   q13	18116	3472	3408	3408
   q14	249	220	218	218
   q15	553	519	507	507
   q16	439	398	393	393
   q17	948	560	503	503
   q18	7795	7101	6982	6982
   q19	1595	1394	1365	1365
   q20	579	302	314	302
   q21	2920	2471	2382	2382
   q22	382	333	316	316
   Total cold run time: 111031 ms
   Total hot run time: 40196 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5978	5591	5658	5591
   q2	365	235	229	229
   q3	3298	3220	3122	3122
   q4	2243	2022	2143	2022
   q5	6101	5970	5986	5970
   q6	206	123	127	123
   q7	2446	2027	2062	2027
   q8	3664	3719	3719	3719
   q9	9850	23741	9410	9410
   q10	5284	3804	3893	3804
   q11	609	471	454	454
   q12	1164	647	646	646
   q13	17130	3300	3270	3270
   q14	347	262	271	262
   q15	593	509	511	509
   q16	557	492	465	465
   q17	6856	2123	2093	2093
   q18	9457	9481	12244	9481
   q19	12458	1648	1645	1645
   q20	3802	1969	1940	1940
   q21	14842	5737	6037	5737
   q22	1127	615	650	615
   Total cold run time: 108377 ms
   Total hot run time: 63134 ms
   ```
   </details>
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   run buildall


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.26 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 f7b007766c261547ca24a0d34879425398265f82, data reload: false
   
   query1	0.04	0.02	0.02
   query2	0.06	0.02	0.03
   query3	0.23	0.05	0.05
   query4	1.71	0.07	0.07
   query5	0.54	0.51	0.53
   query6	1.31	0.62	0.64
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.54	0.50	0.49
   query10	0.54	0.56	0.55
   query11	0.12	0.09	0.09
   query12	0.11	0.10	0.09
   query13	0.60	0.61	0.61
   query14	0.80	0.79	0.82
   query15	0.79	0.78	0.78
   query16	0.38	0.39	0.36
   query17	1.01	0.99	1.02
   query18	0.24	0.26	0.24
   query19	1.85	1.79	1.81
   query20	0.01	0.01	0.01
   query21	15.40	0.59	0.57
   query22	2.52	2.84	2.20
   query23	17.00	0.79	0.82
   query24	2.58	0.75	1.17
   query25	0.30	0.36	0.20
   query26	0.40	0.15	0.14
   query27	0.05	0.05	0.06
   query28	12.08	0.79	0.76
   query29	12.68	3.24	3.26
   query30	0.55	0.49	0.48
   query31	2.78	0.34	0.35
   query32	3.39	0.49	0.48
   query33	3.21	3.28	3.20
   query34	15.92	4.31	4.31
   query35	4.32	4.31	4.31
   query36	1.10	1.07	1.08
   query37	0.06	0.04	0.04
   query38	0.03	0.03	0.03
   query39	0.02	0.02	0.02
   query40	0.16	0.14	0.13
   query41	0.07	0.02	0.01
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 105.6 s
   Total hot run time: 31.26 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   PR approved by anyone and no changes requested.


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit cc7cbc03f6f307b2ef8da67ec3b9eb1ef7d97087 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:       14.7 seconds inserted 10000000 Rows, about 680K ops/s
   ```
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit f7b007766c261547ca24a0d34879425398265f82 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:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       14.2 seconds inserted 10000000 Rows, about 704K ops/s
   ```
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

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


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176902 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 f7b007766c261547ca24a0d34879425398265f82, data reload: false
   
   query1	921	335	327	327
   query2	6568	1995	1916	1916
   query3	6709	202	203	202
   query4	33603	22181	22252	22181
   query5	4461	381	386	381
   query6	246	166	159	159
   query7	4618	261	264	261
   query8	216	185	168	168
   query9	8358	2575	2578	2575
   query10	421	242	221	221
   query11	16679	15414	15629	15414
   query12	124	76	71	71
   query13	1670	387	374	374
   query14	10537	7036	6923	6923
   query15	212	175	179	175
   query16	5786	258	253	253
   query17	947	495	476	476
   query18	1793	256	260	256
   query19	177	135	134	134
   query20	73	71	72	71
   query21	182	132	145	132
   query22	4893	4894	4587	4587
   query23	31676	30965	30829	30829
   query24	12926	2837	2845	2837
   query25	566	319	307	307
   query26	1832	147	149	147
   query27	3580	290	291	290
   query28	7608	1841	1835	1835
   query29	2170	630	613	613
   query30	288	138	139	138
   query31	934	754	750	750
   query32	76	52	49	49
   query33	711	220	219	219
   query34	1281	457	470	457
   query35	940	807	816	807
   query36	1290	1182	1122	1122
   query37	177	62	60	60
   query38	3332	3276	3242	3242
   query39	1329	1260	1284	1260
   query40	348	88	85	85
   query41	36	37	36	36
   query42	88	85	82	82
   query43	516	464	466	464
   query44	1133	692	693	692
   query45	199	181	180	180
   query46	1081	653	664	653
   query47	1599	1504	1586	1504
   query48	386	315	310	310
   query49	1223	294	293	293
   query50	685	321	325	321
   query51	5392	5199	5222	5199
   query52	99	71	87	71
   query53	326	253	269	253
   query54	248	175	181	175
   query55	87	82	74	74
   query56	188	163	164	163
   query57	1053	928	945	928
   query58	191	172	166	166
   query59	3018	2809	2784	2784
   query60	213	186	190	186
   query61	86	93	88	88
   query62	578	363	348	348
   query63	281	257	272	257
   query64	6125	1772	1800	1772
   query65	3327	3285	3263	3263
   query66	1438	318	324	318
   query67	15157	15049	15215	15049
   query68	10443	529	513	513
   query69	606	321	313	313
   query70	1629	1509	1461	1461
   query71	556	215	257	215
   query72	4618	2833	2862	2833
   query73	1774	320	318	318
   query74	6981	6419	6390	6390
   query75	4867	2336	2360	2336
   query76	6772	1054	1019	1019
   query77	894	234	241	234
   query78	9444	8887	8786	8786
   query79	1007	492	506	492
   query80	687	326	331	326
   query81	443	206	207	206
   query82	234	86	83	83
   query83	172	122	125	122
   query84	277	70	72	70
   query85	1091	343	330	330
   query86	381	376	372	372
   query87	3480	3387	3292	3292
   query88	2920	2211	2199	2199
   query89	425	357	352	352
   query90	2138	189	185	185
   query91	160	131	125	125
   query92	55	45	45	45
   query93	946	452	431	431
   query94	1209	164	161	161
   query95	502	464	460	460
   query96	615	314	325	314
   query97	4284	4134	4167	4134
   query98	220	209	187	187
   query99	992	665	688	665
   Total cold run time: 295833 ms
   Total hot run time: 176902 ms
   ```
   </details>
   


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

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

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


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


Re: [PR] [Fix](Job)Incorrect task query result of insert type [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39273 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 f7b007766c261547ca24a0d34879425398265f82, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18016	5265	5429	5265
   q2	2440	148	138	138
   q3	11751	1198	1198	1198
   q4	10905	826	797	797
   q5	8005	3253	3246	3246
   q6	205	126	127	126
   q7	889	528	496	496
   q8	9507	1954	1958	1954
   q9	7249	6403	6365	6365
   q10	8246	3060	3064	3060
   q11	417	202	209	202
   q12	356	190	189	189
   q13	17993	3363	3325	3325
   q14	251	215	217	215
   q15	547	509	524	509
   q16	436	393	376	376
   q17	953	555	595	555
   q18	7557	6993	6863	6863
   q19	1570	1436	1397	1397
   q20	612	325	294	294
   q21	2856	2437	2399	2399
   q22	377	313	304	304
   Total cold run time: 111138 ms
   Total hot run time: 39273 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5565	5327	5282	5282
   q2	326	220	205	205
   q3	3291	3151	3268	3151
   q4	2127	2047	2076	2047
   q5	6067	5841	5912	5841
   q6	196	117	121	117
   q7	2284	1869	1955	1869
   q8	3257	3387	3411	3387
   q9	8963	8822	8766	8766
   q10	3787	3861	3831	3831
   q11	572	472	447	447
   q12	791	618	631	618
   q13	16958	3147	3149	3147
   q14	300	259	269	259
   q15	563	501	510	501
   q16	510	480	481	480
   q17	1890	1797	1837	1797
   q18	9441	19982	9645	9645
   q19	23971	1562	1529	1529
   q20	4556	1929	1919	1919
   q21	14536	5425	5443	5425
   q22	967	560	577	560
   Total cold run time: 110918 ms
   Total hot run time: 60823 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