You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yukang-Lian (via GitHub)" <gi...@apache.org> on 2026/05/29 09:53:09 UTC

[PR] [improvement](compaction) split time series compaction score metric [doris]

Yukang-Lian opened a new pull request, #63900:
URL: https://github.com/apache/doris/pull/63900

   ### What problem does this PR solve?
   
   Time series cumulative compaction and size-based cumulative compaction shared the same max compaction score metric.
   
   This PR:
   - adds `tablet_time_series_max_compaction_score`
   - keeps `tablet_cumulative_max_compaction_score` for size-based cumulative compaction
   - keeps BE report compatibility by reporting the max of base, size-based, and time-series scores
   
   ### Release note
   
   None
   
   ### Check List
   
   - [x] `git diff --check`
   - [x] `DORIS_HOME=/data/data14/lianyukang/doris ninja -C be/build_Release src/common/CMakeFiles/Common.dir/metrics/doris_metrics.cpp.o src/storage/CMakeFiles/Storage.dir/olap_server.cpp.o src/storage/CMakeFiles/Storage.dir/tablet/tablet_manager.cpp.o src/cloud/CMakeFiles/Cloud.dir/cloud_storage_engine.cpp.o src/cloud/CMakeFiles/Cloud.dir/cloud_tablet_mgr.cpp.o src/agent/CMakeFiles/Agent.dir/task_worker_pool.cpp.o`


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   run performance


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

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

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


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


Re: [PR] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 158255 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 9e37d18a4604e78180cb7aa3da637d6ff7c14472, data reload: false
   
   query5	4306	579	444	444
   query6	466	230	204	204
   query7	5006	565	343	343
   query8	318	169	161	161
   query9	8765	4011	3966	3966
   query10	491	353	306	306
   query11	5849	2182	2008	2008
   query12	156	100	95	95
   query13	1250	635	418	418
   query14	6079	4269	3940	3940
   query14_1	3781	3776	3787	3776
   query15	202	201	179	179
   query16	972	515	472	472
   query17	934	734	571	571
   query18	2429	490	352	352
   query19	209	192	151	151
   query20	113	105	108	105
   query21	232	156	134	134
   query22	13099	12998	12832	12832
   query23	15856	14909	14632	14632
   query23_1	14634	14557	14648	14557
   query24	7655	1723	1239	1239
   query24_1	1225	1240	1236	1236
   query25	567	501	380	380
   query26	1321	359	217	217
   query27	2580	608	398	398
   query28	4563	2030	2028	2028
   query29	1065	638	514	514
   query30	346	269	219	219
   query31	1179	1117	1050	1050
   query32	108	63	66	63
   query33	525	304	239	239
   query34	1177	1101	663	663
   query35	738	761	614	614
   query36	775	786	702	702
   query37	155	108	90	90
   query38	1829	1766	1680	1680
   query39	825	829	807	807
   query39_1	796	776	787	776
   query40	256	164	143	143
   query41	65	64	63	63
   query42	98	95	97	95
   query43	324	317	279	279
   query44	1398	775	772	772
   query45	192	174	173	173
   query46	1055	1169	715	715
   query47	1520	1566	1465	1465
   query48	400	414	297	297
   query49	577	423	320	320
   query50	1062	458	321	321
   query51	10412	10600	10505	10505
   query52	94	84	77	77
   query53	269	272	194	194
   query54	297	224	225	224
   query55	73	70	66	66
   query56	305	300	320	300
   query57	1015	1006	978	978
   query58	286	255	248	248
   query59	1570	1612	1391	1391
   query60	313	289	252	252
   query61	185	145	149	145
   query62	392	317	267	267
   query63	226	198	201	198
   query64	2850	1119	877	877
   query65	3884	3845	3812	3812
   query66	1818	474	366	366
   query67	19868	20190	19939	19939
   query68	3187	1524	1066	1066
   query69	413	288	276	276
   query70	854	771	819	771
   query71	364	345	315	315
   query72	3016	2688	2388	2388
   query73	871	780	455	455
   query74	4622	4480	4283	4283
   query75	2362	2345	1988	1988
   query76	2336	1094	742	742
   query77	328	370	272	272
   query78	11117	10993	10466	10466
   query79	1373	1149	744	744
   query80	1053	551	448	448
   query81	504	335	281	281
   query82	632	188	140	140
   query83	410	318	297	297
   query84	322	159	135	135
   query85	988	629	521	521
   query86	369	230	219	219
   query87	1992	1984	1843	1843
   query88	3721	2786	2758	2758
   query89	398	323	276	276
   query90	1787	205	195	195
   query91	201	189	164	164
   query92	62	59	55	55
   query93	1666	1684	928	928
   query94	619	344	331	331
   query95	822	519	459	459
   query96	1110	808	379	379
   query97	2472	2471	2352	2352
   query98	198	187	185	185
   query99	745	750	608	608
   Total cold run time: 244558 ms
   Total hot run time: 158255 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] [improvement](compaction) split time series compaction score metric [doris]

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

   # BE Regression && UT Coverage Report
   Increment line coverage `96.52% (111/115)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/63900_c45fe72d7898e11f553a077fa29f33b9f3382ba4_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/63900_c45fe72d7898e11f553a077fa29f33b9f3382ba4_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 63.73% (24407/38300) |
   | Line Coverage     | 47.61% (253237/531944) |
   | Region Coverage   | 44.31% (208917/471438) |
   | Branch Coverage   | 45.48% (90736/199493) |


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 29083 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 d9faa0fad7a0160c67f206ce45fa99a6f21bb095, data reload: false
   
   ------ Round 1 ----------------------------------
   ============================================
   q1	17898	4033	3924	3924
   q2	2010	334	202	202
   q3	10300	1432	810	810
   q4	4679	477	345	345
   q5	7549	843	554	554
   q6	184	166	139	139
   q7	769	800	602	602
   q8	9337	1506	1632	1506
   q9	5391	4127	4082	4082
   q10	6729	1632	1376	1376
   q11	508	350	322	322
   q12	732	570	446	446
   q13	18112	3301	2746	2746
   q14	271	257	239	239
   q15	q16	732	732	664	664
   q17	967	1000	928	928
   q18	6662	5608	5579	5579
   q19	1178	1276	1058	1058
   q20	804	688	571	571
   q21	6226	2893	2670	2670
   q22	463	388	320	320
   Total cold run time: 101501 ms
   Total hot run time: 29083 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   ============================================
   q1	5012	4696	4664	4664
   q2	289	334	217	217
   q3	5019	5816	4651	4651
   q4	2192	2275	1438	1438
   q5	4728	4444	4421	4421
   q6	238	179	136	136
   q7	1843	1718	1521	1521
   q8	2369	2059	2008	2008
   q9	7045	6757	6741	6741
   q10	4282	4197	3805	3805
   q11	520	375	344	344
   q12	699	714	493	493
   q13	2947	3307	2724	2724
   q14	266	279	250	250
   q15	q16	661	683	596	596
   q17	1246	1219	1210	1210
   q18	12142	10986	11775	10986
   q19	1094	1060	1068	1060
   q20	2187	2204	1893	1893
   q21	5301	4551	4527	4527
   q22	537	453	390	390
   Total cold run time: 60617 ms
   Total hot run time: 54075 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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   run nonConcurrent


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   # BE UT Coverage Report
   Increment line coverage `97.08% (133/137)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/d9faa0fad7a0160c67f206ce45fa99a6f21bb095_d9faa0fad7a0160c67f206ce45fa99a6f21bb095/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/d9faa0fad7a0160c67f206ce45fa99a6f21bb095_d9faa0fad7a0160c67f206ce45fa99a6f21bb095/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 59.81% (26093/43627) |
   | Line Coverage     | 44.14% (264737/599741) |
   | Region Coverage   | 39.88% (210813/528582) |
   | Branch Coverage   | 41.31% (96550/233748) |


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   # BE Regression && UT Coverage Report
   Increment line coverage `97.46% (115/118)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/63900_d9faa0fad7a0160c67f206ce45fa99a6f21bb095_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/63900_d9faa0fad7a0160c67f206ce45fa99a6f21bb095_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 75.96% (32287/42508) |
   | Line Coverage     | 60.73% (361398/595136) |
   | Region Coverage   | 57.36% (303916/529836) |
   | Branch Coverage   | 58.81% (137295/233443) |


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 29207 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 c45fe72d7898e11f553a077fa29f33b9f3382ba4, data reload: false
   
   ------ Round 1 ----------------------------------
   orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
   ============================================
   q1	17735	4099	4021	4021
   q2	q3	10791	1470	854	854
   q4	4686	482	345	345
   q5	7628	910	589	589
   q6	193	182	142	142
   q7	804	864	650	650
   q8	9374	1699	1604	1604
   q9	5811	4556	4473	4473
   q10	6758	1826	1530	1530
   q11	446	282	257	257
   q12	634	421	300	300
   q13	18152	3432	2808	2808
   q14	273	266	251	251
   q15	q16	834	781	712	712
   q17	949	892	935	892
   q18	6917	5926	5663	5663
   q19	1365	1271	1081	1081
   q20	547	409	253	253
   q21	5838	2639	2470	2470
   q22	431	366	312	312
   Total cold run time: 100166 ms
   Total hot run time: 29207 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
   ============================================
   q1	4380	4352	4349	4349
   q2	q3	4544	4971	4348	4348
   q4	2090	2194	1405	1405
   q5	4504	4356	4385	4356
   q6	233	177	133	133
   q7	1743	1869	1910	1869
   q8	2658	2230	2230	2230
   q9	8167	8377	7989	7989
   q10	4837	4739	4279	4279
   q11	572	430	384	384
   q12	766	799	549	549
   q13	3374	3663	2968	2968
   q14	295	314	262	262
   q15	q16	741	750	659	659
   q17	1394	1348	1369	1348
   q18	8114	7388	7178	7178
   q19	1186	1178	1135	1135
   q20	2215	2228	1969	1969
   q21	5319	4624	4509	4509
   q22	537	465	409	409
   Total cold run time: 57669 ms
   Total hot run time: 52328 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] [improvement](compaction) split time series compaction score metric [doris]

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


##########
be/src/storage/olap_server.cpp:
##########
@@ -915,38 +920,59 @@ std::vector<TabletCompactionContext> StorageEngine::_generate_compaction_tasks(
 
         // Even if need_pick_tablet is false, we still need to call find_best_tablet_to_compaction(),
         // So that we can update the max_compaction_score metric.
-        if (!data_dir->reach_capacity_limit(0)) {
-            uint32_t disk_max_score = 0;
-            auto tablet_contexts = compaction_registry_snapshot.pick_topn_tablets_for_compaction(
-                    _tablet_manager.get(), data_dir, compaction_type,
-                    cumulative_compaction_policies, &disk_max_score);
-            int concurrent_num = get_concurrent_per_disk(
-                    disk_max_score, disk_compaction_slot_num(*data_dir, compaction_type));
-            need_pick_tablet = need_generate_compaction_tasks(
-                    executing_task_num, concurrent_num, compaction_type,
-                    !compaction_registry_snapshot.has_compaction_task(
-                            data_dir, CompactionType::CUMULATIVE_COMPACTION));
-            for (const auto& context : tablet_contexts) {
-                if (context.tablet != nullptr) {
-                    if (need_pick_tablet) {
-                        tablet_compaction_contexts.emplace_back(context);
-                    }
-                    max_compaction_score = std::max(max_compaction_score, disk_max_score);
+        if (data_dir->reach_capacity_limit(0)) {
+            skipped_capacity_limited_dir = true;
+            continue;
+        }
+
+        CompactionScoreStats disk_score_stats;
+        auto tablet_contexts = compaction_registry_snapshot.pick_topn_tablets_for_compaction(
+                _tablet_manager.get(), data_dir, compaction_type, cumulative_compaction_policies,
+                &disk_score_stats);
+        max_score_stats.scanned = max_score_stats.scanned || disk_score_stats.scanned;
+        max_score_stats.max_score = std::max(max_score_stats.max_score, disk_score_stats.max_score);
+        max_score_stats.size_based_max_score = std::max(max_score_stats.size_based_max_score,
+                                                        disk_score_stats.size_based_max_score);
+        max_score_stats.time_series_max_score = std::max(max_score_stats.time_series_max_score,
+                                                         disk_score_stats.time_series_max_score);
+        int concurrent_num = get_concurrent_per_disk(
+                disk_score_stats.max_score, disk_compaction_slot_num(*data_dir, compaction_type));
+        need_pick_tablet = need_generate_compaction_tasks(
+                executing_task_num, concurrent_num, compaction_type,
+                !compaction_registry_snapshot.has_compaction_task(
+                        data_dir, CompactionType::CUMULATIVE_COMPACTION));
+        for (const auto& context : tablet_contexts) {
+            if (context.tablet != nullptr) {
+                if (need_pick_tablet) {
+                    tablet_compaction_contexts.emplace_back(context);
                 }
             }
         }
     }
 
-    if (max_compaction_score > 0) {
-        if (compaction_type == CompactionType::BASE_COMPACTION) {
+    if (max_score_stats.scanned) {
+        if (compaction_type == CompactionType::BASE_COMPACTION && max_score_stats.max_score > 0) {
             DorisMetrics::instance()->tablet_base_max_compaction_score->set_value(
-                    max_compaction_score);
+                    max_score_stats.max_score);
         } else if (compaction_type == CompactionType::CUMULATIVE_COMPACTION) {
-            DorisMetrics::instance()->tablet_cumulative_max_compaction_score->set_value(
-                    max_compaction_score);
-        } else if (compaction_type == CompactionType::BINLOG_COMPACTION) {
+            auto update_policy_score = [skipped_capacity_limited_dir, check_score](IntGauge* metric,
+                                                                                   int64_t score) {
+                if (skipped_capacity_limited_dir) {
+                    if (score > metric->value()) {
+                        metric->set_value(score);
+                    }
+                } else if (check_score || score > 0) {
+                    metric->set_value(score);

Review Comment:
   `tablet_cumulative_max_compaction_score` is an existing exported BE metric, but after this change it no longer means "max cumulative compaction score"; it only tracks size-based cumulative scores while time-series backlog moves to `tablet_time_series_max_compaction_score`. In the base code this same metric was fed from the single aggregate cumulative `max_compaction_score`, so existing dashboards/alerts will silently miss time-series tablets after upgrade unless they know to query both metrics. Please either keep the old metric as the aggregate for compatibility and add a new size-based-specific metric, or document/release-note this as a metric semantic break.



-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   run beut


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 24 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 d9faa0fad7a0160c67f206ce45fa99a6f21bb095, data reload: false
   
   query1	0.00	0.00	0.01
   query2	0.09	0.04	0.05
   query3	0.25	0.13	0.13
   query4	1.60	0.13	0.14
   query5	0.23	0.22	0.22
   query6	1.16	0.80	0.81
   query7	0.03	0.01	0.01
   query8	0.06	0.03	0.04
   query9	0.38	0.33	0.31
   query10	0.54	0.58	0.57
   query11	0.19	0.14	0.13
   query12	0.19	0.14	0.14
   query13	0.45	0.46	0.47
   query14	0.99	0.99	0.98
   query15	0.61	0.58	0.61
   query16	0.31	0.32	0.32
   query17	1.12	1.10	1.10
   query18	0.21	0.20	0.20
   query19	2.05	2.00	1.96
   query20	0.02	0.01	0.01
   query21	15.44	0.19	0.13
   query22	4.96	0.05	0.06
   query23	16.10	0.30	0.12
   query24	2.98	0.43	0.36
   query25	0.11	0.05	0.03
   query26	0.77	0.20	0.15
   query27	0.03	0.04	0.04
   query28	3.58	0.77	0.34
   query29	12.50	3.99	3.17
   query30	0.28	0.15	0.15
   query31	2.77	0.55	0.31
   query32	3.22	0.58	0.50
   query33	3.28	3.21	3.21
   query34	15.50	4.00	3.33
   query35	3.23	3.20	3.21
   query36	0.56	0.41	0.43
   query37	0.09	0.07	0.07
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.04
   query40	0.17	0.17	0.15
   query41	0.09	0.03	0.03
   query42	0.04	0.03	0.03
   query43	0.04	0.03	0.04
   Total cold run time: 96.32 s
   Total hot run time: 24 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] [improvement](compaction) split time series compaction score metric [doris]

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

   run cloud_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] [improvement](compaction) split time series compaction score metric [doris]

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

   skip check_coverage


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   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] [improvement](compaction) split time series compaction score metric [doris]

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

   # BE Regression && UT Coverage Report
   Increment line coverage `96.52% (111/115)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/63900_c45fe72d7898e11f553a077fa29f33b9f3382ba4_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/63900_c45fe72d7898e11f553a077fa29f33b9f3382ba4_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 63.73% (24407/38300) |
   | Line Coverage     | 47.61% (253237/531944) |
   | Region Coverage   | 44.31% (208917/471438) |
   | Branch Coverage   | 45.48% (90736/199493) |


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   # BE UT Coverage Report
   Increment line coverage `93.28% (125/134)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/c45fe72d7898e11f553a077fa29f33b9f3382ba4_c45fe72d7898e11f553a077fa29f33b9f3382ba4/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/c45fe72d7898e11f553a077fa29f33b9f3382ba4_c45fe72d7898e11f553a077fa29f33b9f3382ba4/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 53.96% (21156/39209) |
   | Line Coverage     | 37.67% (201533/535009) |
   | Region Coverage   | 33.68% (158017/469239) |
   | Branch Coverage   | 34.73% (69189/199212) |


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 166284 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 d9faa0fad7a0160c67f206ce45fa99a6f21bb095, data reload: false
   
   query5	4328	592	451	451
   query6	464	226	209	209
   query7	4864	605	354	354
   query8	323	164	147	147
   query9	8769	4071	4039	4039
   query10	465	359	295	295
   query11	5815	2153	2011	2011
   query12	151	96	99	96
   query13	1260	611	456	456
   query14	6163	4290	3953	3953
   query14_1	3767	3779	3791	3779
   query15	201	200	181	181
   query16	955	455	437	437
   query17	908	699	541	541
   query18	2476	464	323	323
   query19	202	179	141	141
   query20	101	101	99	99
   query21	228	158	135	135
   query22	13104	12980	12806	12806
   query23	15846	15073	14547	14547
   query23_1	14727	14806	14726	14726
   query24	7539	1734	1224	1224
   query24_1	1265	1216	1251	1216
   query25	541	411	348	348
   query26	1327	365	222	222
   query27	2610	596	380	380
   query28	4613	2069	2049	2049
   query29	1065	597	470	470
   query30	344	262	222	222
   query31	1185	1121	1057	1057
   query32	105	60	58	58
   query33	513	300	237	237
   query34	1175	1162	636	636
   query35	711	745	626	626
   query36	773	774	704	704
   query37	155	107	90	90
   query38	1827	1770	1719	1719
   query39	823	819	805	805
   query39_1	810	786	781	781
   query40	252	162	146	146
   query41	66	65	65	65
   query42	102	95	91	91
   query43	317	325	278	278
   query44	1452	779	784	779
   query45	195	177	170	170
   query46	1100	1181	704	704
   query47	1590	1566	1494	1494
   query48	412	420	315	315
   query49	591	422	308	308
   query50	1104	425	334	334
   query51	10637	10562	10772	10562
   query52	90	89	87	87
   query53	265	287	208	208
   query54	301	257	233	233
   query55	79	80	72	72
   query56	308	325	302	302
   query57	1029	1049	931	931
   query58	318	275	272	272
   query59	1555	1648	1385	1385
   query60	315	312	262	262
   query61	171	174	176	174
   query62	405	323	274	274
   query63	235	200	210	200
   query64	3042	1165	984	984
   query65	3917	3836	3799	3799
   query66	1838	505	375	375
   query67	28207	28091	28009	28009
   query68	3226	1663	956	956
   query69	415	309	270	270
   query70	913	738	777	738
   query71	363	338	319	319
   query72	3019	2592	2305	2305
   query73	873	802	437	437
   query74	4615	4502	4282	4282
   query75	2363	2360	1987	1987
   query76	2326	1195	745	745
   query77	357	364	273	273
   query78	11312	11225	10506	10506
   query79	1484	1174	695	695
   query80	1240	551	461	461
   query81	538	326	281	281
   query82	639	173	142	142
   query83	374	319	293	293
   query84	334	159	134	134
   query85	981	603	517	517
   query86	406	238	212	212
   query87	1963	1963	1841	1841
   query88	3772	2847	2803	2803
   query89	386	325	283	283
   query90	1991	198	191	191
   query91	207	195	158	158
   query92	63	61	56	56
   query93	1660	1537	937	937
   query94	722	367	317	317
   query95	787	573	472	472
   query96	1080	785	365	365
   query97	2468	2442	2375	2375
   query98	200	190	184	184
   query99	752	734	608	608
   Total cold run time: 254291 ms
   Total hot run time: 166284 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] [improvement](compaction) split time series compaction score metric [doris]

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

   /review


-- 
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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169015 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 c45fe72d7898e11f553a077fa29f33b9f3382ba4, data reload: false
   
   query5	4316	637	484	484
   query6	468	198	179	179
   query7	4846	555	302	302
   query8	377	222	207	207
   query9	8780	4061	4043	4043
   query10	449	315	254	254
   query11	5844	2357	2221	2221
   query12	159	104	100	100
   query13	1272	622	436	436
   query14	6367	5385	5066	5066
   query14_1	4388	4431	4419	4419
   query15	205	201	183	183
   query16	1026	463	437	437
   query17	958	708	588	588
   query18	2466	477	355	355
   query19	206	197	164	164
   query20	116	110	106	106
   query21	225	140	120	120
   query22	13685	13662	13380	13380
   query23	17280	16614	16186	16186
   query23_1	16381	16273	16229	16229
   query24	7501	1756	1287	1287
   query24_1	1308	1311	1327	1311
   query25	551	459	384	384
   query26	1349	307	161	161
   query27	2740	543	309	309
   query28	4477	2010	1994	1994
   query29	1095	611	512	512
   query30	315	249	200	200
   query31	1110	1077	955	955
   query32	163	68	60	60
   query33	516	321	258	258
   query34	1161	1098	663	663
   query35	762	783	679	679
   query36	1358	1424	1228	1228
   query37	158	117	85	85
   query38	3213	3149	3032	3032
   query39	938	919	905	905
   query39_1	866	906	897	897
   query40	215	124	108	108
   query41	67	67	62	62
   query42	102	94	95	94
   query43	322	319	279	279
   query44	
   query45	196	182	181	181
   query46	1099	1212	743	743
   query47	2362	2393	2252	2252
   query48	354	406	299	299
   query49	636	469	364	364
   query50	1032	343	255	255
   query51	4376	4272	4262	4262
   query52	87	87	77	77
   query53	242	270	196	196
   query54	275	219	201	201
   query55	76	77	69	69
   query56	234	234	211	211
   query57	1419	1415	1330	1330
   query58	276	211	196	196
   query59	1578	1619	1464	1464
   query60	287	259	233	233
   query61	161	160	161	160
   query62	706	642	591	591
   query63	224	192	183	183
   query64	2614	793	623	623
   query65	
   query66	1831	498	345	345
   query67	29711	29581	29563	29563
   query68	
   query69	423	306	268	268
   query70	958	946	919	919
   query71	293	226	213	213
   query72	3062	2703	2407	2407
   query73	836	762	415	415
   query74	5107	4969	4772	4772
   query75	2675	2588	2272	2272
   query76	2344	1136	761	761
   query77	364	369	289	289
   query78	12382	12297	11798	11798
   query79	1318	1043	760	760
   query80	595	478	396	396
   query81	448	280	247	247
   query82	643	157	120	120
   query83	362	279	252	252
   query84	
   query85	900	542	448	448
   query86	367	292	298	292
   query87	3423	3358	3192	3192
   query88	3631	2731	2702	2702
   query89	418	389	329	329
   query90	1937	177	182	177
   query91	175	161	141	141
   query92	59	61	60	60
   query93	1396	1421	946	946
   query94	570	345	325	325
   query95	675	373	436	373
   query96	1026	762	355	355
   query97	2702	2699	2575	2575
   query98	214	215	204	204
   query99	1147	1179	1023	1023
   Total cold run time: 250614 ms
   Total hot run time: 169015 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] [improvement](compaction) split time series compaction score metric [doris]

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

   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] [improvement](compaction) split time series compaction score metric [doris]

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

   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] [improvement](compaction) split time series compaction score metric [doris]

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

   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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 29282 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 9e37d18a4604e78180cb7aa3da637d6ff7c14472, data reload: false
   
   ------ Round 1 ----------------------------------
   ============================================
   q1	17592	4056	3957	3957
   q2	2048	321	210	210
   q3	10281	1385	821	821
   q4	4682	465	336	336
   q5	7490	828	562	562
   q6	175	166	135	135
   q7	737	813	590	590
   q8	9328	1649	1673	1649
   q9	5392	4114	4117	4114
   q10	6714	1643	1371	1371
   q11	504	348	331	331
   q12	708	567	449	449
   q13	18141	3353	2777	2777
   q14	258	263	246	246
   q15	q16	728	733	657	657
   q17	987	921	994	921
   q18	6571	5607	5570	5570
   q19	1160	1210	1053	1053
   q20	767	677	569	569
   q21	5935	2820	2640	2640
   q22	440	380	324	324
   Total cold run time: 100638 ms
   Total hot run time: 29282 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   ============================================
   q1	4936	4651	4532	4532
   q2	285	346	211	211
   q3	4924	5319	4610	4610
   q4	2213	2266	1448	1448
   q5	4519	4657	4395	4395
   q6	232	176	125	125
   q7	1813	1714	1527	1527
   q8	2306	2008	2053	2008
   q9	7176	6805	6689	6689
   q10	4258	4232	3830	3830
   q11	511	371	338	338
   q12	698	717	485	485
   q13	2932	3202	2742	2742
   q14	281	275	248	248
   q15	q16	655	680	600	600
   q17	1231	1205	1219	1205
   q18	12025	10993	11839	10993
   q19	1087	1087	1052	1052
   q20	2189	2175	1908	1908
   q21	5269	4462	4563	4462
   q22	506	463	393	393
   Total cold run time: 60046 ms
   Total hot run time: 53801 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] [improvement](compaction) split time series compaction score metric [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 23.79 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 9e37d18a4604e78180cb7aa3da637d6ff7c14472, data reload: false
   
   query1	0.01	0.01	0.00
   query2	0.10	0.05	0.05
   query3	0.25	0.14	0.14
   query4	1.61	0.14	0.14
   query5	0.24	0.22	0.21
   query6	1.16	0.80	0.83
   query7	0.04	0.01	0.00
   query8	0.06	0.04	0.03
   query9	0.38	0.30	0.31
   query10	0.59	0.56	0.54
   query11	0.19	0.14	0.13
   query12	0.18	0.15	0.14
   query13	0.45	0.45	0.48
   query14	1.01	0.98	1.00
   query15	0.61	0.58	0.58
   query16	0.31	0.33	0.34
   query17	1.07	1.18	1.08
   query18	0.21	0.20	0.19
   query19	2.05	1.94	1.97
   query20	0.02	0.01	0.01
   query21	15.47	0.20	0.13
   query22	4.90	0.06	0.05
   query23	16.15	0.30	0.12
   query24	2.97	0.42	0.32
   query25	0.11	0.05	0.04
   query26	0.74	0.20	0.14
   query27	0.04	0.03	0.04
   query28	3.57	0.74	0.33
   query29	12.47	4.08	3.22
   query30	0.27	0.15	0.15
   query31	2.76	0.55	0.32
   query32	3.21	0.58	0.48
   query33	3.18	3.19	3.15
   query34	15.49	3.98	3.25
   query35	3.23	3.23	3.25
   query36	0.57	0.44	0.43
   query37	0.09	0.07	0.07
   query38	0.05	0.04	0.03
   query39	0.03	0.04	0.03
   query40	0.17	0.15	0.15
   query41	0.08	0.03	0.03
   query42	0.04	0.02	0.02
   query43	0.04	0.03	0.04
   Total cold run time: 96.17 s
   Total hot run time: 23.79 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