You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HHoflittlefish777 (via GitHub)" <gi...@apache.org> on 2024/06/05 06:03:58 UTC

[PR] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   ## Proposed changes
   
   use label 125 load data
   ```
   {
       "TxnId": 163088604293120,
       "Label": "125",
       "Comment": "",
       "TwoPhaseCommit": "false",
       "Status": "Success",
       "Message": "OK",
       "NumberTotalRows": 1,
       "NumberLoadedRows": 1,
       "NumberFilteredRows": 0,
       "NumberUnselectedRows": 0,
       "LoadBytes": 4,
       "LoadTimeMs": 441,
       "BeginTxnTimeMs": 60,
       "StreamLoadPutTimeMs": 246,
       "ReadDataTimeMs": 0,
       "WriteDataTimeMs": 126,
       "CommitAndPublishTimeMs": 6
   }
   ```
   
   curl --location-trusted -u root:"" http://127.0.0.1:8239/api/db/get_load_state?label=125
   ```
   {
       "msg": "success",
       "code": 0,
       "data": "VISIBLE",
       "count": 0
   }
   ```
   
   curl --location-trusted -u root:"" http://127.0.0.1:8239/api/db/get_load_state?label=126
   ```
   {
       "msg": "success",
       "code": 0,
       "data": "UNKNOWN",
       "count": 0
   }
   ```
   


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39597 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 6a020e0c050d94760183c2607d642e23843e8b22, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17643	4307	4314	4307
   q2	2031	202	197	197
   q3	10423	1142	1028	1028
   q4	10185	785	768	768
   q5	7459	2656	2618	2618
   q6	219	133	136	133
   q7	946	634	606	606
   q8	9229	2057	2076	2057
   q9	8962	6524	6484	6484
   q10	8954	3727	3726	3726
   q11	453	246	249	246
   q12	445	234	224	224
   q13	17770	2954	2949	2949
   q14	275	224	209	209
   q15	516	474	480	474
   q16	542	384	384	384
   q17	966	634	621	621
   q18	8038	7420	7415	7415
   q19	7372	1396	1455	1396
   q20	650	328	314	314
   q21	4810	3107	3854	3107
   q22	390	337	334	334
   Total cold run time: 118278 ms
   Total hot run time: 39597 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4395	4236	4235	4235
   q2	366	268	267	267
   q3	2972	2970	2882	2882
   q4	2001	1730	1703	1703
   q5	5553	5523	5450	5450
   q6	226	134	135	134
   q7	2227	1960	1833	1833
   q8	3273	3411	3415	3411
   q9	8681	8603	8823	8603
   q10	4119	3927	3757	3757
   q11	581	486	519	486
   q12	795	643	656	643
   q13	16383	3199	3141	3141
   q14	301	283	272	272
   q15	525	486	507	486
   q16	514	427	416	416
   q17	1816	1503	1495	1495
   q18	8285	7932	7832	7832
   q19	5424	1634	1624	1624
   q20	2145	1904	1842	1842
   q21	5016	4929	4954	4929
   q22	614	527	529	527
   Total cold run time: 76212 ms
   Total hot run time: 55968 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 172080 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 0225744204aad3dc98a0735368d3b3be8dc25bdf, data reload: false
   
   query1	916	382	367	367
   query2	6452	2473	2265	2265
   query3	6635	205	209	205
   query4	19359	17135	17300	17135
   query5	3610	460	459	459
   query6	242	155	155	155
   query7	4575	295	288	288
   query8	318	302	279	279
   query9	8602	2373	2369	2369
   query10	592	298	292	292
   query11	10503	9985	9902	9902
   query12	118	81	84	81
   query13	1630	360	355	355
   query14	9338	6149	6715	6149
   query15	223	190	202	190
   query16	7128	261	256	256
   query17	1362	554	505	505
   query18	1897	263	259	259
   query19	186	146	142	142
   query20	85	82	79	79
   query21	229	124	122	122
   query22	4256	4047	4035	4035
   query23	33792	33830	33642	33642
   query24	10878	2959	2826	2826
   query25	595	375	355	355
   query26	723	151	151	151
   query27	2338	327	331	327
   query28	6032	2115	2124	2115
   query29	895	611	625	611
   query30	253	158	160	158
   query31	972	774	748	748
   query32	93	54	54	54
   query33	679	290	292	290
   query34	888	471	481	471
   query35	761	639	639	639
   query36	1146	981	989	981
   query37	139	99	69	69
   query38	2937	2852	2845	2845
   query39	886	804	802	802
   query40	217	130	131	130
   query41	56	56	53	53
   query42	111	101	104	101
   query43	602	554	568	554
   query44	1048	722	725	722
   query45	189	163	166	163
   query46	1088	719	676	676
   query47	1828	1763	1785	1763
   query48	371	291	292	291
   query49	846	389	393	389
   query50	767	386	381	381
   query51	6836	6729	6697	6697
   query52	100	89	93	89
   query53	358	282	286	282
   query54	883	428	456	428
   query55	72	73	72	72
   query56	295	248	247	247
   query57	1132	1065	1060	1060
   query58	239	222	240	222
   query59	3347	3179	3195	3179
   query60	278	257	267	257
   query61	87	90	88	88
   query62	616	444	450	444
   query63	319	281	285	281
   query64	8469	2185	1710	1710
   query65	3173	3080	3078	3078
   query66	804	325	318	318
   query67	15431	15018	14814	14814
   query68	4504	519	543	519
   query69	534	410	351	351
   query70	1184	1089	1160	1089
   query71	366	269	265	265
   query72	7092	5703	5585	5585
   query73	737	322	320	320
   query74	5877	5462	5509	5462
   query75	3375	2627	2642	2627
   query76	2058	986	979	979
   query77	441	291	286	286
   query78	10301	9720	9677	9677
   query79	2835	506	504	504
   query80	2169	469	445	445
   query81	547	218	219	218
   query82	897	103	97	97
   query83	295	164	156	156
   query84	262	82	86	82
   query85	1302	385	264	264
   query86	438	336	324	324
   query87	3254	3116	3046	3046
   query88	4480	2339	2342	2339
   query89	471	370	375	370
   query90	1652	193	190	190
   query91	120	97	92	92
   query92	58	49	47	47
   query93	2217	493	493	493
   query94	1057	179	179	179
   query95	400	312	312	312
   query96	586	271	263	263
   query97	3173	3012	3028	3012
   query98	212	196	196	196
   query99	1322	831	829	829
   Total cold run time: 266041 ms
   Total hot run time: 172080 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39978 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 0225744204aad3dc98a0735368d3b3be8dc25bdf, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17972	4450	4320	4320
   q2	2022	196	200	196
   q3	10441	1083	1115	1083
   q4	10431	762	751	751
   q5	7467	2708	2601	2601
   q6	221	137	138	137
   q7	933	635	592	592
   q8	9214	2055	2096	2055
   q9	8822	6628	7035	6628
   q10	9193	3940	3881	3881
   q11	450	255	251	251
   q12	466	253	230	230
   q13	18064	2947	2988	2947
   q14	262	234	239	234
   q15	531	484	487	484
   q16	733	404	378	378
   q17	1341	674	628	628
   q18	8210	7641	7319	7319
   q19	6819	1481	1563	1481
   q20	659	321	324	321
   q21	4847	3135	3162	3135
   q22	374	326	326	326
   Total cold run time: 119472 ms
   Total hot run time: 39978 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4347	4277	4257	4257
   q2	368	266	254	254
   q3	3145	2952	2860	2860
   q4	1911	1746	1693	1693
   q5	5473	5472	5430	5430
   q6	223	137	132	132
   q7	2269	1826	1828	1826
   q8	3288	3446	3386	3386
   q9	8701	8739	8753	8739
   q10	4170	3756	3808	3756
   q11	579	496	491	491
   q12	816	662	628	628
   q13	17129	3109	3123	3109
   q14	313	283	289	283
   q15	546	491	497	491
   q16	480	421	438	421
   q17	1777	1510	1488	1488
   q18	8176	7945	7737	7737
   q19	1851	1542	1734	1542
   q20	3057	1859	1847	1847
   q21	10076	4878	4818	4818
   q22	635	520	547	520
   Total cold run time: 79330 ms
   Total hot run time: 55708 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 172191 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 6a020e0c050d94760183c2607d642e23843e8b22, data reload: false
   
   query1	920	377	382	377
   query2	6465	2378	2241	2241
   query3	6629	207	215	207
   query4	18956	17414	17444	17414
   query5	3591	486	461	461
   query6	242	164	160	160
   query7	4586	305	293	293
   query8	319	326	288	288
   query9	8755	2387	2383	2383
   query10	573	305	285	285
   query11	10415	10083	9981	9981
   query12	121	89	85	85
   query13	1643	372	376	372
   query14	10247	7800	7627	7627
   query15	269	194	195	194
   query16	7967	269	269	269
   query17	1909	580	542	542
   query18	2067	278	283	278
   query19	189	162	161	161
   query20	92	86	83	83
   query21	204	132	131	131
   query22	4291	4107	4137	4107
   query23	33956	33661	33565	33565
   query24	10981	2902	2875	2875
   query25	601	383	394	383
   query26	729	166	158	158
   query27	2335	325	327	325
   query28	5973	2113	2129	2113
   query29	884	639	646	639
   query30	255	157	153	153
   query31	929	761	761	761
   query32	92	55	56	55
   query33	702	287	299	287
   query34	890	501	487	487
   query35	731	653	643	643
   query36	1108	1000	992	992
   query37	137	73	71	71
   query38	2890	2851	2825	2825
   query39	884	815	826	815
   query40	211	138	129	129
   query41	56	51	54	51
   query42	112	107	105	105
   query43	648	532	551	532
   query44	1128	735	739	735
   query45	196	167	169	167
   query46	1087	736	703	703
   query47	1888	1800	1766	1766
   query48	374	306	304	304
   query49	844	403	399	399
   query50	775	412	398	398
   query51	6786	6699	6652	6652
   query52	119	90	99	90
   query53	360	291	293	291
   query54	887	447	450	447
   query55	74	76	73	73
   query56	283	250	262	250
   query57	1141	1066	1056	1056
   query58	258	238	260	238
   query59	3340	3141	3311	3141
   query60	302	276	274	274
   query61	93	86	105	86
   query62	633	430	454	430
   query63	314	300	300	300
   query64	8497	2204	1739	1739
   query65	3191	3100	3126	3100
   query66	743	328	320	320
   query67	15415	15211	15082	15082
   query68	4690	540	537	537
   query69	646	429	401	401
   query70	1226	1205	1158	1158
   query71	458	272	281	272
   query72	8362	5384	2740	2740
   query73	749	319	323	319
   query74	5909	5531	5475	5475
   query75	4027	2684	2678	2678
   query76	3185	968	974	968
   query77	713	298	296	296
   query78	10196	9840	9742	9742
   query79	3674	517	518	517
   query80	1049	478	461	461
   query81	549	225	220	220
   query82	771	110	100	100
   query83	399	180	219	180
   query84	269	86	92	86
   query85	1298	279	264	264
   query86	455	329	330	329
   query87	3275	3130	3139	3130
   query88	4307	2341	2336	2336
   query89	497	403	385	385
   query90	1894	196	189	189
   query91	125	101	100	100
   query92	58	51	50	50
   query93	4598	510	508	508
   query94	1192	189	187	187
   query95	398	310	308	308
   query96	601	261	260	260
   query97	3157	3017	3026	3017
   query98	217	205	205	205
   query99	1177	840	829	829
   Total cold run time: 274403 ms
   Total hot run time: 172191 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41701 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 6d69bd6b07fb71370abaf0b3e5b0027e92996a49, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17621	4367	4288	4288
   q2	2017	198	189	189
   q3	10471	1221	1150	1150
   q4	10187	845	828	828
   q5	7481	2682	2706	2682
   q6	222	140	141	140
   q7	970	601	642	601
   q8	9232	2125	2115	2115
   q9	9342	6731	6764	6731
   q10	9286	3889	3836	3836
   q11	461	240	247	240
   q12	469	231	237	231
   q13	17418	3242	3243	3242
   q14	254	223	214	214
   q15	504	468	470	468
   q16	496	386	398	386
   q17	988	611	649	611
   q18	8318	7837	7771	7771
   q19	2621	1392	1311	1311
   q20	640	336	332	332
   q21	5158	4034	3991	3991
   q22	392	344	345	344
   Total cold run time: 114548 ms
   Total hot run time: 41701 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4637	4426	4395	4395
   q2	375	259	272	259
   q3	3181	2987	2721	2721
   q4	1902	1611	1665	1611
   q5	5456	5514	5495	5495
   q6	222	126	132	126
   q7	2213	1854	1821	1821
   q8	3200	3384	3377	3377
   q9	8572	8648	8733	8648
   q10	4123	3719	3690	3690
   q11	583	502	491	491
   q12	821	631	632	631
   q13	17173	3111	3128	3111
   q14	298	280	270	270
   q15	529	487	492	487
   q16	522	453	454	453
   q17	1814	1478	1508	1478
   q18	7884	7604	7365	7365
   q19	1692	1699	1613	1613
   q20	2072	1768	1778	1768
   q21	4897	4745	4822	4745
   q22	622	546	499	499
   Total cold run time: 72788 ms
   Total hot run time: 55054 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.25 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 6a020e0c050d94760183c2607d642e23843e8b22, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.03	0.04
   query3	0.23	0.05	0.05
   query4	1.67	0.07	0.07
   query5	0.50	0.48	0.48
   query6	1.13	0.72	0.74
   query7	0.02	0.01	0.02
   query8	0.05	0.05	0.04
   query9	0.54	0.50	0.48
   query10	0.56	0.55	0.55
   query11	0.16	0.12	0.11
   query12	0.14	0.11	0.11
   query13	0.60	0.59	0.60
   query14	0.79	0.78	0.79
   query15	0.85	0.81	0.82
   query16	0.36	0.37	0.36
   query17	0.95	1.03	1.01
   query18	0.23	0.24	0.26
   query19	1.78	1.70	1.70
   query20	0.01	0.01	0.01
   query21	15.41	0.67	0.66
   query22	4.21	7.44	1.50
   query23	18.30	1.42	1.32
   query24	2.14	0.22	0.23
   query25	0.16	0.10	0.09
   query26	0.28	0.17	0.17
   query27	0.07	0.08	0.07
   query28	13.23	1.03	1.01
   query29	12.59	3.31	3.27
   query30	0.26	0.06	0.06
   query31	2.87	0.40	0.40
   query32	3.25	0.48	0.47
   query33	2.86	2.92	2.89
   query34	17.12	4.40	4.49
   query35	4.47	4.48	4.50
   query36	0.65	0.46	0.46
   query37	0.18	0.16	0.16
   query38	0.15	0.14	0.16
   query39	0.05	0.04	0.04
   query40	0.18	0.14	0.15
   query41	0.09	0.05	0.05
   query42	0.05	0.04	0.04
   query43	0.03	0.04	0.03
   Total cold run time: 109.29 s
   Total hot run time: 30.25 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 168814 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 6d69bd6b07fb71370abaf0b3e5b0027e92996a49, data reload: false
   
   query1	916	378	376	376
   query2	6471	2409	2282	2282
   query3	6642	207	207	207
   query4	19551	17193	17336	17193
   query5	4118	441	440	440
   query6	255	158	155	155
   query7	4593	296	282	282
   query8	326	274	282	274
   query9	8478	2436	2396	2396
   query10	435	298	278	278
   query11	10435	10080	9951	9951
   query12	144	90	85	85
   query13	1630	357	358	357
   query14	9376	6870	6726	6726
   query15	228	186	185	185
   query16	7156	273	259	259
   query17	1020	516	517	516
   query18	1939	270	267	267
   query19	199	153	151	151
   query20	88	85	82	82
   query21	198	128	127	127
   query22	4318	4091	4115	4091
   query23	33497	33004	32907	32907
   query24	11398	2903	2819	2819
   query25	640	348	361	348
   query26	1526	151	152	151
   query27	3031	312	311	311
   query28	7515	2047	2026	2026
   query29	1059	615	606	606
   query30	283	154	172	154
   query31	939	754	737	737
   query32	96	53	52	52
   query33	769	272	273	272
   query34	985	475	453	453
   query35	722	600	587	587
   query36	1118	922	888	888
   query37	152	71	67	67
   query38	2854	2707	2737	2707
   query39	843	812	788	788
   query40	223	126	120	120
   query41	56	53	53	53
   query42	114	94	100	94
   query43	585	561	552	552
   query44	1158	735	747	735
   query45	204	163	170	163
   query46	1076	725	733	725
   query47	1848	1771	1842	1771
   query48	372	324	296	296
   query49	1152	401	398	398
   query50	777	387	383	383
   query51	6865	6661	6690	6661
   query52	97	92	88	88
   query53	368	282	282	282
   query54	987	448	444	444
   query55	74	73	71	71
   query56	270	262	253	253
   query57	1135	1087	1029	1029
   query58	262	264	237	237
   query59	3558	3401	3235	3235
   query60	303	280	310	280
   query61	105	85	88	85
   query62	644	451	442	442
   query63	310	280	286	280
   query64	10019	2186	1781	1781
   query65	3192	3065	3133	3065
   query66	1440	342	381	342
   query67	15475	15361	14834	14834
   query68	4546	527	531	527
   query69	524	415	352	352
   query70	1123	1110	1151	1110
   query71	425	276	282	276
   query72	7012	2779	2518	2518
   query73	753	317	315	315
   query74	5897	5478	5509	5478
   query75	3332	2661	2614	2614
   query76	2590	915	900	900
   query77	448	286	286	286
   query78	10211	9862	9704	9704
   query79	1467	517	504	504
   query80	1253	472	455	455
   query81	549	226	230	226
   query82	414	99	97	97
   query83	272	175	169	169
   query84	272	84	88	84
   query85	1476	369	263	263
   query86	452	303	298	298
   query87	3284	3115	3073	3073
   query88	3964	2325	2356	2325
   query89	459	387	366	366
   query90	1798	184	189	184
   query91	124	95	97	95
   query92	62	48	48	48
   query93	2195	512	494	494
   query94	1232	186	184	184
   query95	411	303	304	303
   query96	586	269	266	266
   query97	3176	2995	2986	2986
   query98	243	218	211	211
   query99	1146	851	853	851
   Total cold run time: 270308 ms
   Total hot run time: 168814 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.84 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 6d69bd6b07fb71370abaf0b3e5b0027e92996a49, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.08	0.04	0.04
   query3	0.23	0.05	0.05
   query4	1.68	0.08	0.07
   query5	0.50	0.46	0.50
   query6	1.13	0.73	0.73
   query7	0.02	0.02	0.01
   query8	0.05	0.05	0.05
   query9	0.55	0.50	0.48
   query10	0.54	0.56	0.54
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.61	0.59	0.58
   query14	0.79	0.78	0.78
   query15	0.83	0.82	0.81
   query16	0.37	0.35	0.37
   query17	0.98	1.01	0.99
   query18	0.24	0.24	0.23
   query19	1.80	1.68	1.75
   query20	0.02	0.01	0.01
   query21	15.45	0.72	0.70
   query22	4.98	6.47	2.04
   query23	18.26	1.44	1.23
   query24	1.87	0.21	0.20
   query25	0.16	0.08	0.08
   query26	0.26	0.17	0.18
   query27	0.07	0.08	0.07
   query28	13.30	1.10	1.07
   query29	13.35	3.34	3.29
   query30	0.23	0.06	0.06
   query31	2.90	0.40	0.40
   query32	3.22	0.49	0.48
   query33	2.92	2.89	2.93
   query34	17.29	4.45	4.42
   query35	4.53	4.58	4.69
   query36	0.64	0.47	0.46
   query37	0.17	0.15	0.16
   query38	0.15	0.13	0.13
   query39	0.04	0.04	0.03
   query40	0.17	0.14	0.15
   query41	0.08	0.04	0.04
   query42	0.06	0.04	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 110.9 s
   Total hot run time: 30.84 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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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


-- 
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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   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] [feature](cloud) support get load state by HTTP API in cloud mode [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.63 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 0225744204aad3dc98a0735368d3b3be8dc25bdf, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.03	0.03
   query3	0.22	0.05	0.05
   query4	1.68	0.07	0.07
   query5	0.51	0.50	0.50
   query6	1.13	0.72	0.72
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.04
   query9	0.53	0.50	0.49
   query10	0.54	0.54	0.53
   query11	0.16	0.12	0.12
   query12	0.15	0.11	0.12
   query13	0.60	0.58	0.60
   query14	0.77	0.76	0.77
   query15	0.84	0.82	0.80
   query16	0.39	0.36	0.37
   query17	1.01	0.95	0.95
   query18	0.21	0.24	0.27
   query19	1.79	1.67	1.72
   query20	0.02	0.01	0.01
   query21	15.41	0.67	0.66
   query22	4.30	7.19	2.12
   query23	18.30	1.39	1.27
   query24	2.11	0.21	0.21
   query25	0.16	0.08	0.07
   query26	0.27	0.17	0.17
   query27	0.08	0.08	0.07
   query28	13.21	1.02	1.01
   query29	12.66	3.29	3.29
   query30	0.25	0.06	0.05
   query31	2.87	0.37	0.39
   query32	3.30	0.48	0.47
   query33	2.85	2.89	2.86
   query34	17.18	4.42	4.45
   query35	4.48	4.56	4.47
   query36	0.66	0.46	0.48
   query37	0.18	0.15	0.15
   query38	0.15	0.14	0.15
   query39	0.04	0.04	0.04
   query40	0.17	0.16	0.14
   query41	0.09	0.05	0.04
   query42	0.05	0.04	0.04
   query43	0.04	0.04	0.04
   Total cold run time: 109.55 s
   Total hot run time: 30.63 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