You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org> on 2024/02/27 12:23:24 UTC

[PR] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

zhiqiang-hhhh opened a new pull request, #31490:
URL: https://github.com/apache/doris/pull/31490

   pick #31228 


-- 
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 226294 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
   
   query1	923	391	384	384
   query2	6527	2289	2113	2113
   query3	6921	206	211	206
   query4	20889	18018	17970	17970
   query5	19728	6547	6550	6547
   query6	295	218	226	218
   query7	4164	297	290	290
   query8	246	273	231	231
   query9	3127	2722	2651	2651
   query10	408	280	307	280
   query11	11269	10667	10707	10667
   query12	115	72	73	72
   query13	5583	663	623	623
   query14	18154	13613	13670	13613
   query15	386	230	226	226
   query16	6454	273	262	262
   query17	1754	1444	864	864
   query18	2323	405	407	405
   query19	196	146	145	145
   query20	80	82	76	76
   query21	186	99	91	91
   query22	5455	5823	6552	5823
   query23	40821	36996	36197	36197
   query24	7415	7196	7093	7093
   query25	636	498	500	498
   query26	540	180	183	180
   query27	1839	329	331	329
   query28	6080	2376	2355	2355
   query29	3112	3026	3009	3009
   query30	276	182	193	182
   query31	1015	824	903	824
   query32	78	68	69	68
   query33	426	286	288	286
   query34	950	505	548	505
   query35	1415	1188	1281	1188
   query36	1754	1910	1833	1833
   query37	112	84	73	73
   query38	3616	3461	3407	3407
   query39	1536	1455	1518	1455
   query40	223	112	120	112
   query41	50	41	40	40
   query42	105	95	101	95
   query43	653	569	626	569
   query44	1230	990	842	842
   query45	284	281	286	281
   query46	1440	1079	1104	1079
   query47	2556	2178	2108	2108
   query48	1099	750	763	750
   query49	666	402	421	402
   query50	1030	667	685	667
   query51	5543	5225	5350	5225
   query52	110	92	90	90
   query53	494	359	348	348
   query54	3022	2655	2586	2586
   query55	104	97	97	97
   query56	267	235	240	235
   query57	1317	1287	1254	1254
   query58	246	239	213	213
   query59	4038	3410	3825	3410
   query60	232	238	239	238
   query61	94	99	95	95
   query62	787	598	505	505
   query63	512	368	360	360
   query64	4225	1822	1644	1644
   query65	4165	4362	4526	4362
   query66	990	457	417	417
   query67	22742	19801	21550	19801
   query68	8011	733	717	717
   query69	644	421	401	401
   query70	2197	1979	1820	1820
   query71	446	334	326	326
   query72	6804	5544	4270	4270
   query73	827	353	346	346
   query74	7714	7170	7438	7170
   query75	5216	4461	4237	4237
   query76	4637	1138	1280	1138
   query77	568	289	276	276
   query78	15175	15109	14100	14100
   query79	7008	709	720	709
   query80	2368	488	439	439
   query81	565	265	273	265
   query82	1253	114	109	109
   query83	172	150	139	139
   query84	231	75	79	75
   query85	1443	318	313	313
   query86	443	484	408	408
   query87	3814	4725	3629	3629
   query88	5402	2572	2557	2557
   query89	391	335	301	301
   query90	1686	222	234	222
   query91	177	124	133	124
   query92	64	62	53	53
   query93	2278	614	628	614
   query94	796	235	233	233
   query95	1342	1220	1244	1220
   query96	697	350	355	350
   query97	7541	7440	8092	7440
   query98	230	210	210	210
   query99	2251	1063	1019	1019
   Total cold run time: 337419 ms
   Total hot run time: 226294 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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


-- 
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 49835 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18168	4360	4334	4334
   q2	2037	149	143	143
   q3	10283	1910	1914	1910
   q4	10367	1233	1311	1233
   q5	8502	3888	3972	3888
   q6	230	122	123	122
   q7	2043	1557	1586	1557
   q8	9264	2683	2704	2683
   q9	11137	10751	10590	10590
   q10	8592	3542	3490	3490
   q11	425	237	237	237
   q12	456	288	299	288
   q13	18339	3960	4020	3960
   q14	358	327	323	323
   q15	493	458	454	454
   q16	702	591	585	585
   q17	1110	968	963	963
   q18	7137	6945	6796	6796
   q19	1655	1557	1517	1517
   q20	525	294	321	294
   q21	4405	4120	4062	4062
   q22	500	407	406	406
   Total cold run time: 116728 ms
   Total hot run time: 49835 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4327	4287	4342	4287
   q2	312	217	233	217
   q3	4141	4109	4111	4109
   q4	2739	2760	2751	2751
   q5	7316	7229	7214	7214
   q6	231	116	114	114
   q7	3240	2815	2895	2815
   q8	4361	4450	4471	4450
   q9	17630	17129	17191	17129
   q10	4204	4292	4300	4292
   q11	790	681	675	675
   q12	1017	839	867	839
   q13	7496	3739	3717	3717
   q14	448	417	411	411
   q15	500	446	457	446
   q16	761	701	696	696
   q17	3783	3803	3836	3803
   q18	8706	8681	8829	8681
   q19	1678	1696	1616	1616
   q20	2409	2121	2128	2121
   q21	8545	8480	8462	8462
   q22	1069	979	960	960
   Total cold run time: 85703 ms
   Total hot run time: 79805 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.01 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
   
   query1	0.02	0.02	0.02
   query2	0.06	0.02	0.03
   query3	0.24	0.04	0.05
   query4	1.84	0.07	0.06
   query5	0.53	0.53	0.52
   query6	1.33	0.66	0.62
   query7	0.01	0.01	0.01
   query8	0.03	0.03	0.03
   query9	0.52	0.48	0.48
   query10	0.54	0.54	0.53
   query11	0.11	0.09	0.09
   query12	0.12	0.09	0.09
   query13	0.62	0.61	0.62
   query14	0.77	0.79	0.80
   query15	0.79	0.77	0.77
   query16	0.37	0.39	0.37
   query17	1.01	1.00	1.02
   query18	0.24	0.26	0.25
   query19	1.92	1.88	1.82
   query20	0.01	0.01	0.01
   query21	15.50	0.59	0.55
   query22	2.06	2.59	1.17
   query23	17.07	1.01	1.03
   query24	4.87	1.57	1.45
   query25	1.58	0.11	0.10
   query26	0.31	0.16	0.14
   query27	0.10	0.11	0.11
   query28	7.14	0.73	0.71
   query29	12.66	2.32	2.27
   query30	0.51	0.51	0.51
   query31	2.81	0.39	0.39
   query32	3.44	0.49	0.49
   query33	3.06	3.06	3.08
   query34	15.27	4.84	4.80
   query35	4.89	4.86	4.88
   query36	1.04	1.02	1.01
   query37	0.05	0.05	0.04
   query38	0.03	0.03	0.02
   query39	0.02	0.02	0.02
   query40	0.16	0.14	0.14
   query41	0.06	0.02	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.01
   Total cold run time: 103.75 s
   Total hot run time: 31.01 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 6dfac79655b158672bda55c36750d28c7cdf6b2f with default session variables
   Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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:       21.2 seconds inserted 10000000 Rows, about 471K 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