Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-12 Thread via GitHub


starocean999 merged PR #50589:
URL: https://github.com/apache/doris/pull/50589


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


github-actions[bot] commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2964690967

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


github-actions[bot] commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2964690937

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961996901

   
   
   TPC-DS: Total hot run time: 192196 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit d7434d238dd4a8362c794e81b234710ac1c478a8, 
data reload: false
   
   query1   1414109010421042
   query2   6333180718081807
   query3   10977   462544424442
   query4   54006   25582   23069   23069
   query5   5052533 447 447
   query6   341 213 198 198
   query7   4894518 298 298
   query8   294 238 212 212
   query9   5572264126492641
   query10  453 324 286 286
   query11  15036   15064   14798   14798
   query12  158 107 101 101
   query13  1038544 405 405
   query14  10088   633861706170
   query15  205 201 176 176
   query16  7105641 498 498
   query17  1065735 582 582
   query18  1585430 315 315
   query19  206 191 173 173
   query20  126 142 120 120
   query21  210 124 108 108
   query22  4543455342934293
   query23  34232   33669   33593   33593
   query24  6573247924312431
   query25  465 479 405 405
   query26  682 275 158 158
   query27  2237530 347 347
   query28  3069214521372137
   query29  565 567 422 422
   query30  274 221 192 192
   query31  846 874 782 782
   query32  72  63  66  63
   query33  469 361 314 314
   query34  769 891 545 545
   query35  799 839 737 737
   query36  976 992 895 895
   query37  110 105 76  76
   query38  4302422342634223
   query39  1511145914671459
   query40  221 120 116 116
   query41  65  61  61  61
   query42  128 112 114 112
   query43  499 515 486 486
   query44  1362831 831 831
   query45  181 182 171 171
   query46  852 1033673 673
   query47  1899191218121812
   query48  395 419 330 330
   query49  657 502 390 390
   query50  661 709 404 404
   query51  4251435942544254
   query52  119 109 98  98
   query53  226 253 203 203
   query54  599 585 520 520
   query55  87  88  81  81
   query56  314 325 294 294
   query57  1269125711731173
   query58  283 256 265 256
   query59  2673264626482646
   query60  336 338 319 319
   query61  166 148 160 148
   query62  743 772 667 667
   query63  237 202 190 190
   query64  16041130667 667
   query65  4338415641654156
   query66  730 407 307 307
   query67  15843   15734   15628   15628
   query68  7283879 507 507
   query69  546 313 263 263
   query70  1141112110481048
   query71  489 311 330 311
   query72  5909487449744874
   query73  1490722 351 351
   query74  9085898686828682
   query75  3871320827132713
   query76  42461190770 770
   query77  637 354 283 283
   query78  996610121   94289428
   query79  3013788 580 580
   query80  627 527 447 447
   query81  470 253 217 217
   query82  451 125 97  97
   query83  346 251 236 236
   query84  288 103 88  88
   query85  800 346 375 346
   query86  370 308 285 285
   query87  4404446943074307
   query88  3489227822182218
   query89  416 312 281 281
   query90  1926211 209 209
   query91  145 144 113 113
   query92  76  63  54  54
   query93  1587935 563 563
   query94  666 416 304 304
   query95  362 295 290 290
   query96  504 565 278 278
   query97  2767278426482648
   query98  236 217 201 201
   query99  1395143812511251
   Total cold run time: 298391 ms
   Total hot run time: 192196 ms
   ```
   
   


-- 
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 t

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2962013509

   
   
   ClickBench: Total hot run time: 29.51 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d7434d238dd4a8362c794e81b234710ac1c478a8, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.100.11
   query3   0.250.200.20
   query4   1.590.200.20
   query5   0.460.440.45
   query6   1.180.670.66
   query7   0.020.020.02
   query8   0.050.040.03
   query9   0.600.520.52
   query10  0.570.590.57
   query11  0.160.110.12
   query12  0.150.120.12
   query13  0.610.600.59
   query14  0.780.810.80
   query15  0.870.860.86
   query16  0.390.390.39
   query17  1.041.061.03
   query18  0.220.210.21
   query19  1.981.881.90
   query20  0.010.010.01
   query21  15.40   0.900.55
   query22  0.771.160.70
   query23  14.88   1.350.67
   query24  7.011.520.83
   query25  0.450.140.13
   query26  0.540.170.14
   query27  0.060.060.06
   query28  9.540.920.46
   query29  12.53   4.053.35
   query30  0.260.090.07
   query31  2.820.580.38
   query32  3.250.540.46
   query33  2.993.123.10
   query34  15.85   5.124.52
   query35  4.524.544.52
   query36  0.680.510.50
   query37  0.090.060.07
   query38  0.050.040.03
   query39  0.030.020.03
   query40  0.160.140.12
   query41  0.080.020.03
   query42  0.030.020.03
   query43  0.040.040.03
   Total cold run time: 103.12 s
   Total hot run time: 29.51 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961943632

   
   
   TPC-H: Total hot run time: 34346 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d7434d238dd4a8362c794e81b234710ac1c478a8, 
data reload: false
   
   -- Round 1 --
   q1   26508   508450685068
   q2   1961281 183 183
   q3   12138   1235717 717
   q4   10229   1025554 554
   q5   7556240123542354
   q6   181 166 132 132
   q7   905 745 625 625
   q8   9435135811551155
   q9   7305544253035303
   q10  7145236219431943
   q11  483 293 270 270
   q12  361 354 218 218
   q13  19267   380931833183
   q14  250 234 224 224
   q15  576 480 490 480
   q16  436 445 379 379
   q17  618 880 367 367
   q18  7485713370587058
   q19  1687946 551 551
   q20  350 338 224 224
   q21  3823317523862386
   q22  10331008972 972
   Total cold run time: 119732 ms
   Total hot run time: 34346 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5135508750295029
   q2   241 319 228 228
   q3   2193262523032303
   q4   1478187314261426
   q5   4495440243864386
   q6   210 170 129 129
   q7   1982195317771777
   q8   2596264025072507
   q9   7225698772596987
   q10  2947314927522752
   q11  589 526 501 501
   q12  679 752 629 629
   q13  3506399334083408
   q14  293 296 278 278
   q15  539 483 467 467
   q16  444 503 447 447
   q17  1197154913861386
   q18  7806757474707470
   q19  889 839 867 839
   q20  1958198018631863
   q21  4938455443604360
   q22  1134104310061006
   Total cold run time: 52474 ms
   Total hot run time: 50178 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961799847

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


starocean999 commented on code in PR #50589:
URL: https://github.com/apache/doris/pull/50589#discussion_r2139553210


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/BackupCommand.java:
##
@@ -0,0 +1,267 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.BackupStmt;
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.Config;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.datasource.InternalCatalog;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.info.LabelNameInfo;
+import org.apache.doris.nereids.trees.plans.commands.info.TableRefInfo;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.GlobalVariable;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.base.Joiner;
+import com.google.common.base.Strings;
+import com.google.common.collect.Maps;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+
+/**
+ * BackupCommand
+ */
+public class BackupCommand extends Command {
+private static final Logger LOG = 
LogManager.getLogger(BackupCommand.class);
+private static final String PROP_TIMEOUT = "timeout";
+private static final long MIN_TIMEOUT_MS = 600 * 1000L;
+private static final String PROP_TYPE = "type";
+private static final String PROP_CONTENT = "content";
+
+/**
+ * BackupType
+ */
+public enum BackupType {
+INCREMENTAL, FULL
+}
+
+/**
+ * BackupContent
+ */
+public enum BackupContent {
+METADATA_ONLY, ALL
+}
+
+private BackupType type = BackupType.FULL;
+private BackupContent content = BackupContent.ALL;
+
+private final LabelNameInfo labelNameInfo;
+private final String repoName;
+private final List tableRefInfos;
+private final Map properties;
+private final boolean isExclude;
+
+private long timeoutMs;
+
+/**
+ * BackupCommand
+ */
+public BackupCommand(LabelNameInfo labelNameInfo,
+ String repoName,
+ List tableRefInfos,
+ Map properties,
+ boolean isExclude) {
+super(PlanType.BACKUP_COMMAND);
+Objects.requireNonNull(labelNameInfo, "labelNameInfo is null");
+Objects.requireNonNull(repoName, "repoName is null");
+Objects.requireNonNull(tableRefInfos, "tableRefInfos is null");
+Objects.requireNonNull(properties, "properties is null");
+this.labelNameInfo = labelNameInfo;
+this.repoName = repoName;
+this.tableRefInfos = tableRefInfos;
+this.properties = properties;
+this.isExclude = isExclude;
+}
+
+@Override
+public void run(ConnectContext ctx, StmtExecutor executor) throws 
Exception {
+validate(ctx);
+ctx.getEnv().getBackupHandler().process(this);
+}
+
+/**
+ * validate
+ */
+public void validate(ConnectContext ctx) throws AnalysisException {
+labelNameInfo.validate(ctx);
+
+// user need database level privilege(not table level),
+if (!Env.getCurrentEnv().getAccessManager()
+.checkDbPriv(ConnectContext.get(), 
InternalCatalog.INTERNAL_CATALOG_NAME,
+labelNameInfo.getDb(), PrivPredicate.LOAD)) {
+
ErrorReport.reportAnalysisException(ErrorCode.ERR_SPECIFIC_ACCESS_DENIED_ERROR, 
"LOAD");
+}
+
+analyzeTableRefInfo();
+analyzeProperties();
+}
+
+private void analyzeTableRefInfo() throws AnalysisException {
+if (tableRefInfos.isEmpty()) {
+return;
+}
+checkTableRefWithoutDatabase();
+updateTableRefInfos();
+// tbl refs can

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


starocean999 commented on code in PR #50589:
URL: https://github.com/apache/doris/pull/50589#discussion_r2139544715


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/BackupCommand.java:
##
@@ -0,0 +1,267 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.BackupStmt;
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.Config;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.datasource.InternalCatalog;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.info.LabelNameInfo;
+import org.apache.doris.nereids.trees.plans.commands.info.TableRefInfo;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.GlobalVariable;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.base.Joiner;
+import com.google.common.base.Strings;
+import com.google.common.collect.Maps;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+
+/**
+ * BackupCommand
+ */
+public class BackupCommand extends Command {

Review Comment:
   ```suggestion
   public class BackupCommand extends Command implements ForwardWithSync {
   ```



-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-11 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961527396

   # FE UT Coverage Report
   Increment line coverage `  26.47% (63/238)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_74f64bc0c12dd10f9bcf50cef689a39aaa310eee/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_74f64bc0c12dd10f9bcf50cef689a39aaa310eee/fe_report/index.html)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961417343

   
   
   ClickBench: Total hot run time: 29.67 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 74f64bc0c12dd10f9bcf50cef689a39aaa310eee, 
data reload: false
   
   query1   0.030.040.03
   query2   0.120.110.11
   query3   0.240.200.20
   query4   1.800.200.19
   query5   0.480.460.46
   query6   1.330.680.67
   query7   0.020.020.02
   query8   0.050.030.03
   query9   0.580.520.50
   query10  0.560.580.57
   query11  0.160.110.10
   query12  0.140.120.12
   query13  0.620.600.61
   query14  0.800.820.80
   query15  0.890.850.85
   query16  0.390.380.39
   query17  1.051.041.05
   query18  0.220.210.21
   query19  1.921.741.77
   query20  0.010.020.01
   query21  15.39   0.920.54
   query22  0.761.250.96
   query23  14.71   1.380.68
   query24  7.280.971.18
   query25  0.500.140.07
   query26  0.560.160.14
   query27  0.060.050.04
   query28  9.900.920.45
   query29  12.57   4.073.40
   query30  0.250.090.06
   query31  2.820.610.39
   query32  3.230.560.46
   query33  3.033.063.03
   query34  15.89   5.214.55
   query35  4.594.524.55
   query36  0.650.500.47
   query37  0.080.060.06
   query38  0.050.040.03
   query39  0.030.030.03
   query40  0.160.140.12
   query41  0.080.020.02
   query42  0.040.030.02
   query43  0.040.040.03
   Total cold run time: 104.08 s
   Total hot run time: 29.67 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961319990

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961407250

   
   
   TPC-DS: Total hot run time: 192575 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 74f64bc0c12dd10f9bcf50cef689a39aaa310eee, 
data reload: false
   
   query1   1398109510671067
   query2   6225182318531823
   query3   11200   468245804580
   query4   25465   23726   23007   23007
   query5   3885601 455 455
   query6   299 205 205 205
   query7   3991498 293 293
   query8   286 243 225 225
   query9   8494264226632642
   query10  477 333 272 272
   query11  15440   15092   14801   14801
   query12  174 108 107 107
   query13  1557544 401 401
   query14  9238625062156215
   query15  202 202 172 172
   query16  7640621 456 456
   query17  1183696 570 570
   query18  2024421 311 311
   query19  194 213 175 175
   query20  123 135 120 120
   query21  219 127 113 113
   query22  4394449042524252
   query23  34472   33859   33585   33585
   query24  8660240024452400
   query25  509 487 399 399
   query26  1244274 151 151
   query27  2701529 351 351
   query28  4635219921522152
   query29  713 583 454 454
   query30  271 220 193 193
   query31  910 852 797 797
   query32  77  64  61  61
   query33  537 373 334 334
   query34  822 859 544 544
   query35  807 848 731 731
   query36  992 976 881 881
   query37  120 110 80  80
   query38  4322433844664338
   query39  1499147715141477
   query40  218 120 114 114
   query41  60  56  53  53
   query42  125 116 117 116
   query43  532 513 472 472
   query44  1329842 842 842
   query45  191 177 187 177
   query46  874 1030654 654
   query47  1860187317781778
   query48  396 436 332 332
   query49  722 464 384 384
   query50  656 711 419 419
   query51  4247431042354235
   query52  111 113 106 106
   query53  227 264 182 182
   query54  592 583 523 523
   query55  93  86  83  83
   query56  316 327 292 292
   query57  1200124011601160
   query58  269 263 269 263
   query59  2816286827112711
   query60  338 325 309 309
   query61  132 130 138 130
   query62  800 783 693 693
   query63  233 195 198 195
   query64  41721047787 787
   query65  4322427242474247
   query66  949 418 317 317
   query67  15833   15794   15413   15413
   query68  8552900 517 517
   query69  471 310 276 276
   query70  1214113711041104
   query71  482 333 292 292
   query72  5686483849484838
   query73  684 652 360 360
   query74  9149916286608660
   query75  3796321827222722
   query76  33431189769 769
   query77  764 375 301 301
   query78  10083   10212   94489448
   query79  2302790 570 570
   query80  599 519 473 473
   query81  473 261 217 217
   query82  462 132 96  96
   query83  259 254 233 233
   query84  244 107 83  83
   query85  816 385 318 318
   query86  385 304 282 282
   query87  4451444643434343
   query88  3725228823102288
   query89  399 312 289 289
   query90  1870212 202 202
   query91  140 144 112 112
   query92  75  57  61  57
   query93  1974963 572 572
   query94  654 405 302 302
   query95  365 297 283 283
   query96  485 576 281 281
   query97  2764280026432643
   query98  226 213 201 201
   query99  1398138512661266
   Total cold run time: 279302 ms
   Total hot run time: 192575 ms
   ```
   
   


-- 
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 

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961384292

   
   
   TPC-H: Total hot run time: 33787 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 74f64bc0c12dd10f9bcf50cef689a39aaa310eee, 
data reload: false
   
   -- Round 1 --
   q1   25750   501949864986
   q2   1955269 184 184
   q3   10301   1217687 687
   q4   10224   1006506 506
   q5   7510236023622360
   q6   183 164 133 133
   q7   907 728 606 606
   q8   9312127610771077
   q9   6875518650985098
   q10  6865229219001900
   q11  522 288 298 288
   q12  336 345 211 211
   q13  17784   372530463046
   q14  227 225 218 218
   q15  557 501 513 501
   q16  415 425 373 373
   q17  577 858 355 355
   q18  7596721671577157
   q19  1780955 546 546
   q20  315 336 220 220
   q21  3596339123562356
   q22  10551028979 979
   Total cold run time: 114642 ms
   Total hot run time: 33787 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5122509250705070
   q2   232 315 216 216
   q3   2144262923152315
   q4   1405177613521352
   q5   4422438644584386
   q6   215 170 131 131
   q7   1990192917681768
   q8   2578252926892529
   q9   7207718470187018
   q10  3048317927462746
   q11  587 516 488 488
   q12  712 797 591 591
   q13  3503395233013301
   q14  289 297 280 280
   q15  529 501 484 484
   q16  454 492 429 429
   q17  1152145614051405
   q18  7938759075617561
   q19  807 832 981 832
   q20  1979204719151915
   q21  4809443944804439
   q22  1130109310511051
   Total cold run time: 52252 ms
   Total hot run time: 50307 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961200193

   # FE UT Coverage Report
   Increment line coverage `  27.27% (63/231)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_a2d99f4c8f606c76015570b9cebd95c0582c9ddb/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_a2d99f4c8f606c76015570b9cebd95c0582c9ddb/fe_report/index.html)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961132161

   
   
   ClickBench: Total hot run time: 29.46 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a2d99f4c8f606c76015570b9cebd95c0582c9ddb, 
data reload: false
   
   query1   0.030.030.03
   query2   0.110.110.11
   query3   0.250.190.19
   query4   1.590.200.18
   query5   0.470.430.46
   query6   1.590.670.67
   query7   0.030.020.02
   query8   0.040.030.03
   query9   0.570.530.51
   query10  0.590.580.58
   query11  0.150.110.11
   query12  0.140.110.11
   query13  0.620.600.61
   query14  0.790.820.80
   query15  0.860.840.87
   query16  0.380.370.38
   query17  1.011.021.04
   query18  0.230.210.21
   query19  1.891.801.77
   query20  0.010.010.02
   query21  15.40   0.890.57
   query22  0.751.250.78
   query23  14.74   1.370.63
   query24  7.220.981.16
   query25  0.470.190.06
   query26  0.540.160.13
   query27  0.050.050.05
   query28  9.460.890.46
   query29  12.56   4.123.41
   query30  0.260.090.06
   query31  2.820.580.40
   query32  3.250.540.46
   query33  3.093.043.06
   query34  15.71   5.154.51
   query35  4.524.544.54
   query36  0.700.490.47
   query37  0.080.060.06
   query38  0.040.040.04
   query39  0.040.020.02
   query40  0.170.140.13
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.040.040.03
   Total cold run time: 103.38 s
   Total hot run time: 29.46 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961126507

   
   
   TPC-DS: Total hot run time: 192408 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a2d99f4c8f606c76015570b9cebd95c0582c9ddb, 
data reload: false
   
   query1   1411108110981081
   query2   6168183718261826
   query3   11158   459445844584
   query4   54491   24755   23517   23517
   query5   5194496 461 461
   query6   361 194 185 185
   query7   4876498 287 287
   query8   288 227 211 211
   query9   5682262726182618
   query10  442 319 266 266
   query11  15448   15018   14858   14858
   query12  157 109 110 109
   query13  1034531 405 405
   query14  10122   629863506298
   query15  206 212 190 190
   query16  7111653 502 502
   query17  1102779 612 612
   query18  1588425 317 317
   query19  211 194 172 172
   query20  131 141 118 118
   query21  211 124 114 114
   query22  4402434043134313
   query23  34144   33448   33365   33365
   query24  7001240724542407
   query25  470 479 407 407
   query26  732 271 150 150
   query27  2310506 348 348
   query28  2936217221832172
   query29  579 564 440 440
   query30  270 212 188 188
   query31  896 886 792 792
   query32  76  62  58  58
   query33  446 345 306 306
   query34  780 889 525 525
   query35  794 804 738 738
   query36  955 1023891 891
   query37  111 106 74  74
   query38  4286428842824282
   query39  1491146114681461
   query40  206 120 112 112
   query41  60  56  55  55
   query42  115 108 116 108
   query43  513 540 481 481
   query44  1356850 836 836
   query45  179 175 164 164
   query46  861 1046647 647
   query47  1821183817941794
   query48  411 422 324 324
   query49  671 496 405 405
   query50  657 696 438 438
   query51  4284429041764176
   query52  111 115 105 105
   query53  232 254 186 186
   query54  578 577 513 513
   query55  84  84  83  83
   query56  309 316 306 306
   query57  1200123111441144
   query58  283 269 278 269
   query59  2735285327332733
   query60  349 336 326 326
   query61  134 128 122 122
   query62  762 731 715 715
   query63  226 191 185 185
   query64  17961021682 682
   query65  4222416341544154
   query66  719 396 301 301
   query67  15914   15470   15282   15282
   query68  7314927 520 520
   query69  558 319 266 266
   query70  1220111511391115
   query71  511 324 291 291
   query72  5755473348534733
   query73  1381648 353 353
   query74  8976904488408840
   query75  3749320326902690
   query76  42811190746 746
   query77  644 356 275 275
   query78  10178   10232   92389238
   query79  2123812 589 589
   query80  588 514 441 441
   query81  488 255 219 219
   query82  518 125 96  96
   query83  252 249 232 232
   query84  297 108 82  82
   query85  809 358 325 325
   query86  408 297 288 288
   query87  4457450943024302
   query88  3674229522612261
   query89  413 307 286 286
   query90  1823204 217 204
   query91  138 143 112 112
   query92  74  58  57  57
   query93  1708942 583 583
   query94  757 407 309 309
   query95  372 302 280 280
   query96  486 622 283 283
   query97  2741275126462646
   query98  247 207 209 207
   query99  1663141712451245
   Total cold run time: 299462 ms
   Total hot run time: 192408 ms
   ```
   
   


-- 
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 

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961113143

   
   
   TPC-H: Total hot run time: 33600 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a2d99f4c8f606c76015570b9cebd95c0582c9ddb, 
data reload: false
   
   -- Round 1 --
   q1   25840   504049934993
   q2   1946280 180 180
   q3   10276   1224712 712
   q4   10231   992 507 507
   q5   7526231223002300
   q6   188 163 129 129
   q7   903 744 601 601
   q8   9308129111021102
   q9   6888504950835049
   q10  6814229218801880
   q11  474 279 264 264
   q12  339 348 213 213
   q13  17753   365330663066
   q14  217 225 206 206
   q15  575 485 493 485
   q16  424 428 373 373
   q17  571 845 348 348
   q18  7443708271187082
   q19  1297966 544 544
   q20  330 336 222 222
   q21  3715315823942394
   q22  10651010950 950
   Total cold run time: 114123 ms
   Total hot run time: 33600 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5085503250465032
   q2   248 312 216 216
   q3   2160259723002300
   q4   1354178113531353
   q5   4376436644824366
   q6   209 172 133 133
   q7   1971191618521852
   q8   2579258425462546
   q9   7119717269976997
   q10  2952326927692769
   q11  561 508 477 477
   q12  651 751 601 601
   q13  3526386932663266
   q14  273 295 273 273
   q15  514 489 486 486
   q16  450 479 449 449
   q17  1148154513911391
   q18  7711751073787378
   q19  812 810 951 810
   q20  1977205119071907
   q21  4661447344284428
   q22  1128105310071007
   Total cold run time: 51465 ms
   Total hot run time: 50037 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2961039035

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2960983563

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959908960

   # FE UT Coverage Report
   Increment line coverage `  27.27% (63/231)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_8c19c8ff15e5d13810e5385d67a121cd8f6260f1/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_8c19c8ff15e5d13810e5385d67a121cd8f6260f1/fe_report/index.html)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959626946

   
   
   ClickBench: Total hot run time: 28.88 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8c19c8ff15e5d13810e5385d67a121cd8f6260f1, 
data reload: false
   
   query1   0.030.040.03
   query2   0.120.100.11
   query3   0.250.200.19
   query4   1.590.200.10
   query5   0.420.420.44
   query6   1.160.660.66
   query7   0.030.010.02
   query8   0.040.040.04
   query9   0.580.530.52
   query10  0.560.600.56
   query11  0.150.110.12
   query12  0.150.120.11
   query13  0.620.620.59
   query14  0.790.840.79
   query15  0.880.850.85
   query16  0.380.390.37
   query17  1.071.031.01
   query18  0.220.210.20
   query19  1.951.851.77
   query20  0.020.010.01
   query21  15.41   0.880.55
   query22  0.751.190.78
   query23  14.79   1.350.58
   query24  6.801.150.71
   query25  0.520.190.06
   query26  0.700.160.15
   query27  0.050.050.05
   query28  9.550.940.43
   query29  12.56   4.093.39
   query30  0.250.090.07
   query31  2.840.610.39
   query32  3.240.560.47
   query33  3.003.033.03
   query34  15.65   5.124.48
   query35  4.504.524.51
   query36  0.660.490.48
   query37  0.090.060.06
   query38  0.060.040.03
   query39  0.030.020.02
   query40  0.170.140.13
   query41  0.080.020.02
   query42  0.030.020.02
   query43  0.040.040.03
   Total cold run time: 102.78 s
   Total hot run time: 28.88 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959608834

   
   
   TPC-DS: Total hot run time: 185776 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 8c19c8ff15e5d13810e5385d67a121cd8f6260f1, 
data reload: false
   
   query1   1004477 498 477
   query2   6563184018341834
   query3   6753224 217 217
   query4   26261   24036   23001   23001
   query5   4737636 471 471
   query6   294 217 200 200
   query7   4634485 302 302
   query8   279 232 218 218
   query9   8632263726562637
   query10  470 338 281 281
   query11  15283   15015   14879   14879
   query12  162 113 114 113
   query13  1649530 409 409
   query14  8716613963006139
   query15  207 195 163 163
   query16  7195628 479 479
   query17  1167697 587 587
   query18  1968398 299 299
   query19  190 182 165 165
   query20  119 119 117 117
   query21  217 122 103 103
   query22  3975399640163996
   query23  34136   32981   33239   32981
   query24  8468239723842384
   query25  549 459 389 389
   query26  1247266 161 161
   query27  2758503 350 350
   query28  4344217421182118
   query29  760 540 431 431
   query30  283 221 186 186
   query31  905 837 759 759
   query32  72  68  65  65
   query33  561 377 329 329
   query34  801 858 540 540
   query35  776 790 744 744
   query36  929 989 888 888
   query37  108 99  88  88
   query38  4128412540814081
   query39  1486142014111411
   query40  215 123 109 109
   query41  65  59  59  59
   query42  121 109 112 109
   query43  508 510 472 472
   query44  1305838 821 821
   query45  182 181 167 167
   query46  847 1026633 633
   query47  1758175917381738
   query48  402 423 302 302
   query49  753 494 397 397
   query50  633 702 410 410
   query51  4144424240634063
   query52  112 110 101 101
   query53  220 247 185 185
   query54  581 577 519 519
   query55  88  82  88  82
   query56  330 320 297 297
   query57  1189120311221122
   query58  279 267 271 267
   query59  2647268125102510
   query60  344 343 316 316
   query61  152 149 160 149
   query62  839 742 653 653
   query63  224 193 187 187
   query64  43941017686 686
   query65  4218415941724159
   query66  1148424 328 328
   query67  15729   15483   15355   15355
   query68  7773897 520 520
   query69  471 312 267 267
   query70  1178110911211109
   query71  418 319 313 313
   query72  5608480548074805
   query73  652 614 350 350
   query74  8914923288178817
   query75  3586323527492749
   query76  33741199767 767
   query77  791 384 288 288
   query78  9927998593369336
   query79  2379820 576 576
   query80  564 498 448 448
   query81  498 265 219 219
   query82  450 128 98  98
   query83  256 253 234 234
   query84  244 117 94  94
   query85  798 347 309 309
   query86  379 306 305 305
   query87  4333447543274327
   query88  3857234423202320
   query89  399 318 356 318
   query90  1862217 216 216
   query91  149 156 119 119
   query92  84  60  60  60
   query93  1893919 578 578
   query94  686 402 312 312
   query95  377 293 285 285
   query96  486 577 284 284
   query97  2711276527062706
   query98  257 221 207 207
   query99  1452143312521252
   Total cold run time: 273019 ms
   Total hot run time: 185776 ms
   ```
   
   


-- 
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

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959563960

   
   
   TPC-H: Total hot run time: 33610 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8c19c8ff15e5d13810e5385d67a121cd8f6260f1, 
data reload: false
   
   -- Round 1 --
   q1   26060   506150275027
   q2   1938269 179 179
   q3   10321   1252687 687
   q4   10219   976 507 507
   q5   7511241423182318
   q6   184 159 129 129
   q7   868 749 612 612
   q8   9301128510751075
   q9   6828518151125112
   q10  6828228918921892
   q11  465 288 271 271
   q12  339 351 207 207
   q13  17765   362930623062
   q14  239 222 219 219
   q15  554 499 480 480
   q16  422 436 377 377
   q17  557 867 352 352
   q18  7710717370987098
   q19  1221973 535 535
   q20  344 333 224 224
   q21  3749255222822282
   q22  10911011965 965
   Total cold run time: 114514 ms
   Total hot run time: 33610 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5027501950675019
   q2   242 316 225 225
   q3   2206262423302330
   q4   1368182414061406
   q5   4374446844344434
   q6   224 187 131 131
   q7   1994193118611861
   q8   2540248824672467
   q9   7128715470897089
   q10  2991320427652765
   q11  581 511 482 482
   q12  667 787 620 620
   q13  3452383233363336
   q14  297 303 265 265
   q15  513 475 476 475
   q16  465 488 441 441
   q17  1137155413791379
   q18  7752756073087308
   q19  780 750 816 750
   q20  2012202918661866
   q21  5062435543114311
   q22  1054102710251025
   Total cold run time: 51866 ms
   Total hot run time: 49985 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959484150

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2959030216

   # FE UT Coverage Report
   Increment line coverage `  27.27% (63/231)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_c9f6f4fce38405706c322329851c41d629f27100/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_c9f6f4fce38405706c322329851c41d629f27100/fe_report/index.html)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958878168

   
   
   ClickBench: Total hot run time: 29.27 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit c9f6f4fce38405706c322329851c41d629f27100, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.110.10
   query3   0.270.190.19
   query4   1.590.190.20
   query5   0.450.450.44
   query6   1.170.670.66
   query7   0.020.020.01
   query8   0.050.040.03
   query9   0.580.510.53
   query10  0.580.570.58
   query11  0.150.110.10
   query12  0.150.110.12
   query13  0.610.600.60
   query14  0.790.820.82
   query15  0.880.840.86
   query16  0.400.400.40
   query17  1.031.051.04
   query18  0.230.210.21
   query19  1.941.851.81
   query20  0.010.010.02
   query21  15.40   0.880.53
   query22  0.741.320.63
   query23  14.88   1.360.58
   query24  7.450.981.04
   query25  0.520.200.14
   query26  0.560.160.13
   query27  0.060.050.05
   query28  9.550.910.43
   query29  12.54   4.013.34
   query30  0.240.090.06
   query31  2.820.580.39
   query32  3.240.540.47
   query33  3.013.073.08
   query34  15.75   5.134.47
   query35  4.464.544.51
   query36  0.670.490.49
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.020.02
   query40  0.160.140.13
   query41  0.080.030.03
   query42  0.030.030.02
   query43  0.030.030.03
   Total cold run time: 103.43 s
   Total hot run time: 29.27 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958856990

   
   
   TPC-DS: Total hot run time: 192681 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit c9f6f4fce38405706c322329851c41d629f27100, 
data reload: false
   
   query1   1425109310961093
   query2   6181185018521850
   query3   11033   457845584558
   query4   56675   25603   23057   23057
   query5   5037487 458 458
   query6   381 214 203 203
   query7   5020509 293 293
   query8   303 236 213 213
   query9   6291266726572657
   query10  460 333 284 284
   query11  15116   15076   14794   14794
   query12  173 111 109 109
   query13  1089527 412 412
   query14  10203   649762876287
   query15  207 201 189 189
   query16  7091668 512 512
   query17  1092791 587 587
   query18  1531401 315 315
   query19  207 198 158 158
   query20  132 127 127 127
   query21  207 121 109 109
   query22  4518450541624162
   query23  34354   33665   33546   33546
   query24  6872246525042465
   query25  477 478 409 409
   query26  672 278 151 151
   query27  2262513 369 369
   query28  2933217121902171
   query29  573 600 452 452
   query30  266 215 195 195
   query31  874 843 793 793
   query32  72  63  68  63
   query33  429 375 325 325
   query34  810 863 537 537
   query35  821 838 754 754
   query36  955 987 883 883
   query37  106 99  78  78
   query38  4139428543314285
   query39  1551145514871455
   query40  219 123 110 110
   query41  63  57  55  55
   query42  132 119 116 116
   query43  524 525 486 486
   query44  1363846 848 846
   query45  188 183 167 167
   query46  847 1029679 679
   query47  1785187917711771
   query48  401 458 324 324
   query49  671 492 404 404
   query50  667 681 408 408
   query51  4306427641914191
   query52  127 112 103 103
   query53  231 253 182 182
   query54  591 606 518 518
   query55  87  91  84  84
   query56  309 289 280 280
   query57  1210123711511151
   query58  294 280 260 260
   query59  2879276527952765
   query60  361 327 326 326
   query61  128 124 134 124
   query62  725 738 658 658
   query63  228 188 197 188
   query64  14631072729 729
   query65  4273417541924175
   query66  707 391 305 305
   query67  15976   15921   15361   15361
   query68  6521838 518 518
   query69  539 313 274 274
   query70  1188110810911091
   query71  492 324 296 296
   query72  5757496249344934
   query73  1092684 358 358
   query74  8947892389448923
   query75  3530322926942694
   query76  38261247755 755
   query77  547 382 287 287
   query78  10239   10257   92569256
   query79  2577825 578 578
   query80  627 525 451 451
   query81  492 252 219 219
   query82  498 128 96  96
   query83  253 245 239 239
   query84  303 118 101 101
   query85  841 361 325 325
   query86  424 290 286 286
   query87  4469449143244324
   query88  3536225322682253
   query89  416 320 283 283
   query90  1880206 202 202
   query91  147 149 131 131
   query92  76  65  62  62
   query93  2479939 574 574
   query94  628 420 305 305
   query95  368 290 287 287
   query96  491 619 284 284
   query97  2712275226972697
   query98  255 215 201 201
   query99  1322143012731273
   Total cold run time: 300765 ms
   Total hot run time: 192681 ms
   ```
   
   


-- 
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

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958810642

   
   
   TPC-H: Total hot run time: 34003 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit c9f6f4fce38405706c322329851c41d629f27100, 
data reload: false
   
   -- Round 1 --
   q1   25836   509150035003
   q2   1953288 184 184
   q3   10274   1228746 746
   q4   10206   1007531 531
   q5   7529235224042352
   q6   188 160 135 135
   q7   898 759 622 622
   q8   9457130011421142
   q9   7012518552655185
   q10  6889232518821882
   q11  489 290 270 270
   q12  354 361 225 225
   q13  17793   368330653065
   q14  238 229 230 229
   q15  588 502 494 494
   q16  412 427 371 371
   q17  600 857 365 365
   q18  7390721371577157
   q19  21061031576 576
   q20  333 337 214 214
   q21  3742318923222322
   q22  1034987 933 933
   Total cold run time: 115321 ms
   Total hot run time: 34003 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5198509951285099
   q2   227 314 218 218
   q3   2154260622832283
   q4   1365178613981398
   q5   4488439844004398
   q6   227 169 133 133
   q7   1995194817691769
   q8   2615263125442544
   q9   7226722868606860
   q10  3053317027492749
   q11  587 514 505 505
   q12  703 800 619 619
   q13  3504386734013401
   q14  282 291 282 282
   q15  535 495 502 495
   q16  450 517 438 438
   q17  1180149714101410
   q18  7618754372737273
   q19  882 808 903 808
   q20  1958205619341934
   q21  4768449544564456
   q22  1080105010311031
   Total cold run time: 52095 ms
   Total hot run time: 50103 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958667980

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958586394

   # FE UT Coverage Report
   Increment line coverage `  10.39% (24/231)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_2d9ede867e8274badc672f0dd908c6f254adcfcc/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50589_2d9ede867e8274badc672f0dd908c6f254adcfcc/fe_report/index.html)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958381630

   
   
   ClickBench: Total hot run time: 29.01 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 2d9ede867e8274badc672f0dd908c6f254adcfcc, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.100.10
   query3   0.240.190.19
   query4   1.600.200.10
   query5   0.430.410.42
   query6   1.160.660.65
   query7   0.030.020.01
   query8   0.050.030.03
   query9   0.570.530.52
   query10  0.580.580.57
   query11  0.160.100.11
   query12  0.160.120.12
   query13  0.610.610.59
   query14  0.820.810.80
   query15  0.860.850.85
   query16  0.380.380.38
   query17  1.001.051.09
   query18  0.230.210.21
   query19  1.901.801.85
   query20  0.020.010.01
   query21  15.41   0.910.56
   query22  0.781.270.69
   query23  15.19   1.410.62
   query24  7.202.250.85
   query25  0.460.200.08
   query26  0.590.180.15
   query27  0.050.050.05
   query28  9.350.830.45
   query29  12.56   4.003.32
   query30  0.260.100.07
   query31  2.830.580.39
   query32  3.240.540.46
   query33  3.072.993.03
   query34  15.67   5.144.47
   query35  4.534.544.55
   query36  0.670.500.48
   query37  0.100.060.06
   query38  0.050.040.04
   query39  0.030.030.02
   query40  0.180.150.13
   query41  0.080.020.03
   query42  0.040.020.03
   query43  0.040.030.03
   Total cold run time: 103.35 s
   Total hot run time: 29.01 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958365781

   
   
   TPC-DS: Total hot run time: 184429 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 2d9ede867e8274badc672f0dd908c6f254adcfcc, 
data reload: false
   
   query1   1024504 492 492
   query2   6579188218641864
   query3   6763239 219 219
   query4   26331   23402   23398   23398
   query5   4376643 465 465
   query6   305 224 205 205
   query7   4634493 309 309
   query8   264 233 223 223
   query9   8618265526452645
   query10  472 336 295 295
   query11  15442   15163   14821   14821
   query12  151 112 110 110
   query13  1670541 438 438
   query14  8748617662336176
   query15  198 200 163 163
   query16  7125647 491 491
   query17  1192719 561 561
   query18  1952404 297 297
   query19  189 188 153 153
   query20  122 130 126 126
   query21  226 127 106 106
   query22  4003400640704006
   query23  33797   33096   33237   33096
   query24  8470236424052364
   query25  527 437 392 392
   query26  1238277 155 155
   query27  2741507 344 344
   query28  4367214321182118
   query29  770 590 444 444
   query30  283 209 186 186
   query31  917 865 786 786
   query32  77  66  65  65
   query33  568 359 318 318
   query34  785 877 536 536
   query35  780 810 734 734
   query36  944 971 883 883
   query37  114 108 78  78
   query38  4120416441404140
   query39  1503139814041398
   query40  208 117 109 109
   query41  61  62  60  60
   query42  129 108 112 108
   query43  523 527 489 489
   query44  1310829 839 829
   query45  180 180 176 176
   query46  838 1023642 642
   query47  1777178917121712
   query48  386 432 314 314
   query49  749 488 420 420
   query50  645 704 399 399
   query51  4160416041664160
   query52  114 111 103 103
   query53  232 259 191 191
   query54  594 601 520 520
   query55  93  85  87  85
   query56  327 314 295 295
   query57  1201118111101110
   query58  280 263 269 263
   query59  2693266426332633
   query60  354 348 331 331
   query61  149 156 178 156
   query62  789 748 673 673
   query63  229 186 191 186
   query64  43031005676 676
   query65  4222412742404127
   query66  1135417 318 318
   query67  15876   15496   15411   15411
   query68  8457910 524 524
   query69  494 317 271 271
   query70  1196110610901090
   query71  469 323 297 297
   query72  5873240451982404
   query73  783 762 351 351
   query74  8991919190309030
   query75  3853324026952695
   query76  36461198769 769
   query77  775 376 291 291
   query78  10005   10094   94089408
   query79  2701847 584 584
   query80  618 523 437 437
   query81  472 257 220 220
   query82  451 129 104 104
   query83  281 254 243 243
   query84  290 117 93  93
   query85  835 357 322 322
   query86  351 299 293 293
   query87  4495450943134313
   query88  3210227223092272
   query89  406 303 281 281
   query90  1947221 214 214
   query91  145 147 111 111
   query92  80  64  61  61
   query93  1590944 575 575
   query94  669 416 309 309
   query95  382 289 291 289
   query96  501 577 281 281
   query97  2737276226982698
   query98  236 212 213 212
   query99  1435140812911291
   Total cold run time: 274316 ms
   Total hot run time: 184429 ms
   ```
   
   


-- 
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 t

Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


doris-robot commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958328172

   
   
   TPC-H: Total hot run time: 34079 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 2d9ede867e8274badc672f0dd908c6f254adcfcc, 
data reload: false
   
   -- Round 1 --
   q1   26127   519150235023
   q2   1956287 181 181
   q3   10278   1219702 702
   q4   10228   1010521 521
   q5   7547242323602360
   q6   185 169 137 137
   q7   906 740 626 626
   q8   9313128411491149
   q9   6954506151165061
   q10  6848231519531953
   q11  487 298 290 290
   q12  362 363 218 218
   q13  1   373030643064
   q14  248 231 214 214
   q15  540 499 494 494
   q16  429 428 374 374
   q17  622 915 355 355
   q18  7569724971937193
   q19  1225994 568 568
   q20  337 338 223 223
   q21  3708327623962396
   q22  10441053977 977
   Total cold run time: 114690 ms
   Total hot run time: 34079 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5528506750885067
   q2   237 321 230 230
   q3   2165267923082308
   q4   1419183814031403
   q5   4532442543864386
   q6   223 173 134 134
   q7   1944195217401740
   q8   2607250225162502
   q9   7234716071337133
   q10  2993318027512751
   q11  598 500 491 491
   q12  675 764 607 607
   q13  3617382533823382
   q14  283 311 269 269
   q15  524 491 493 491
   q16  423 490 433 433
   q17  1163154114181418
   q18  7835748073247324
   q19  817 842 932 842
   q20  2017204919061906
   q21  4901469143924392
   q22  10681068974 974
   Total cold run time: 52803 ms
   Total hot run time: 50183 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958235078

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-06-10 Thread via GitHub


yx-keith commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2958089230

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [Enhancement] (nereids) implement backupCommand in nereids [doris]

2025-05-04 Thread via GitHub


hello-stephen commented on PR #50589:
URL: https://github.com/apache/doris/pull/50589#issuecomment-2849951667

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]