Re: [PR] [Enhancement] (nereids) implement mysqlLoadCommand in nereids [doris]
starocean999 merged PR #49109: URL: https://github.com/apache/doris/pull/49109 -- 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 mysqlLoadCommand in nereids [doris]
github-actions[bot] commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043796486 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 mysqlLoadCommand in nereids [doris]
github-actions[bot] commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043796629 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043581305 run external -- 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043486562 run external -- 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043479168 run external -- 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043407582 ClickBench: Total hot run time: 29.61 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit aefae6dab61172e41f64c6fc8abfd98cb385, data reload: false query1 0.040.030.04 query2 0.080.050.04 query3 0.250.080.07 query4 1.620.110.11 query5 0.440.450.42 query6 1.160.660.65 query7 0.020.020.02 query8 0.040.040.04 query9 0.610.520.52 query10 0.570.570.57 query11 0.150.120.11 query12 0.150.120.12 query13 0.630.600.61 query14 0.800.810.81 query15 0.900.870.87 query16 0.380.390.40 query17 1.061.061.10 query18 0.220.220.22 query19 1.961.841.87 query20 0.020.010.02 query21 15.42 0.890.54 query22 0.751.240.78 query23 14.77 1.330.61 query24 6.881.760.67 query25 0.510.190.12 query26 0.650.160.14 query27 0.060.060.06 query28 9.340.860.46 query29 12.55 3.993.30 query30 0.250.090.06 query31 2.830.610.38 query32 3.240.560.49 query33 3.103.063.11 query34 16.10 5.374.75 query35 4.824.854.86 query36 0.700.510.50 query37 0.090.070.07 query38 0.060.040.04 query39 0.030.030.02 query40 0.180.140.14 query41 0.080.030.02 query42 0.030.030.03 query43 0.040.030.02 Total cold run time: 103.58 s Total hot run time: 29.61 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043402069 TPC-DS: Total hot run time: 184823 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 aefae6dab61172e41f64c6fc8abfd98cb385, data reload: false query1 995 412 385 385 query2 6544173016741674 query3 6741213 210 210 query4 26230 23653 23189 23189 query5 4365580 439 439 query6 282 217 202 202 query7 4628488 280 280 query8 269 219 212 212 query9 8615262626342626 query10 494 323 273 273 query11 15314 15057 14756 14756 query12 160 103 119 103 query13 1641517 404 404 query14 8536561156225611 query15 209 180 176 176 query16 7128625 439 439 query17 1183691 600 600 query18 1977393 296 296 query19 200 189 153 153 query20 125 116 111 111 query21 211 121 102 102 query22 4111437740214021 query23 33907 33091 33033 33033 query24 8455234023692340 query25 524 466 395 395 query26 1235265 148 148 query27 2767501 332 332 query28 4317214421272127 query29 766 579 432 432 query30 286 215 201 201 query31 937 817 746 746 query32 70 72 61 61 query33 553 357 311 311 query34 799 852 512 512 query35 791 818 750 750 query36 940 959 890 890 query37 114 101 79 79 query38 4182407340634063 query39 1472144613931393 query40 214 127 110 110 query41 76 60 58 58 query42 124 109 106 106 query43 500 515 464 464 query44 1308819 821 819 query45 183 168 166 166 query46 842 1031621 621 query47 1737180717111711 query48 391 440 316 316 query49 727 491 394 394 query50 624 706 416 416 query51 4144416741374137 query52 118 114 99 99 query53 217 250 190 190 query54 580 600 515 515 query55 84 82 80 80 query56 312 320 304 304 query57 1178123911431143 query58 277 250 252 250 query59 2649275026692669 query60 333 308 294 294 query61 124 120 120 120 query62 825 717 655 655 query63 216 191 186 186 query64 43621010717 717 query65 4321412341574123 query66 1147445 317 317 query67 16127 15556 15338 15338 query68 8541888 528 528 query69 484 306 256 256 query70 1192105110401040 query71 442 324 290 290 query72 5609483451884834 query73 760 660 350 350 query74 8948909989208920 query75 3879318426632663 query76 36411142751 751 query77 807 385 287 287 query78 997810136 94469446 query79 4072856 557 557 query80 639 507 444 444 query81 485 258 225 225 query82 549 125 95 95 query83 283 250 232 232 query84 295 103 79 79 query85 804 352 322 322 query86 340 303 283 283 query87 4402444543864386 query88 2839226322382238 query89 436 312 278 278 query90 1929202 239 202 query91 130 141 115 115 query92 79 58 58 58 query93 2152930 583 583 query94 673 405 268 268 query95 376 287 277 277 query96 487 575 282 282 query97 2758274426172617 query98 232 216 201 201 query99 1422141813231323 Total cold run time: 275476 ms Total hot run time: 184823 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043389726 TPC-H: Total hot run time: 33800 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit aefae6dab61172e41f64c6fc8abfd98cb385, data reload: false -- Round 1 -- q1 17576 513450375037 q2 1933279 182 182 q3 10420 1308711 711 q4 10254 1057515 515 q5 8565241023852385 q6 177 166 128 128 q7 978 724 596 596 q8 9307129210661066 q9 6865508651115086 q10 6875238419441944 q11 497 291 287 287 q12 338 347 222 222 q13 17760 368030813081 q14 226 220 211 211 q15 565 479 473 473 q16 426 423 380 380 q17 588 858 353 353 q18 7483707571337075 q19 1573948 552 552 q20 323 349 213 213 q21 3796323323502350 q22 1063989 953 953 Total cold run time: 107588 ms Total hot run time: 33800 ms - Round 2, with runtime_filter_mode=off - q1 5171507050835070 q2 241 323 220 220 q3 2177272122772277 q4 1357182613631363 q5 4246454846024548 q6 214 174 131 131 q7 2070191418541854 q8 2663255226342552 q9 7201718472957184 q10 3124336329022902 q11 596 536 533 533 q12 675 775 585 585 q13 3730393833613361 q14 277 304 290 290 q15 521 475 481 475 q16 444 487 473 473 q17 1277150014951495 q18 7841778076217621 q19 797 796 864 796 q20 2056209118771877 q21 4721437842704270 q22 1061997 978 978 Total cold run time: 52460 ms Total hot run time: 50855 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3043341170 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 mysqlLoadCommand in nereids [doris]
starocean999 commented on code in PR #49109:
URL: https://github.com/apache/doris/pull/49109#discussion_r2184609834
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/load/MysqlLoadCommand.java:
##
@@ -0,0 +1,332 @@
+// 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.load;
+
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.Config;
+import org.apache.doris.common.DdlException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.UserException;
+import org.apache.doris.common.util.PrintableMap;
+import org.apache.doris.common.util.TimeUtils;
+import org.apache.doris.load.EtlJobType;
+import org.apache.doris.load.LoadJobRowResult;
+import org.apache.doris.load.loadv2.LoadManager;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.Command;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.base.Function;
+import com.google.common.collect.ImmutableMap;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+import org.checkerframework.checker.nullness.qual.Nullable;
+
+import java.io.File;
+import java.io.IOException;
+import java.util.Map;
+import java.util.Objects;
+import java.util.UUID;
+
+// LOAD command, load files into tables.
+//
+// syntax:
+// LOAD mysqlDataDesc
+// [PROPERTIES (key1=value1, )]
+// [commentSpec]
+//
+// mysqlDataDesc:
+//DATA [ LOCAL ]
+//INFILE ""
+//INTO TABLE ""
+//[ PARTITION ( [, ... ]) ]
+//[ COLUMNS TERMINATED BY "" ]
+//[ LINES TERMINATED BY "" ]
+//[ IGNORE {LINES | ROWS} ]
+//[ ( [, ... ] ) ]
+//[ SET (col_name={ | DEFAULT} [, col_name={ | DEFAULT}] ...) ]
+//[ PROPERTIES ("" = "" [ , ... ]) ]
+// commentSpec:
+//COMMENT ...
+
+/**
+ * MysqlLoadCommand
+ */
+public class MysqlLoadCommand extends Command {
+public static final String TIMEOUT_PROPERTY = "timeout";
+public static final String EXEC_MEM_LIMIT_PROPERTY = "exec_mem_limit";
+public static final String MAX_FILTER_RATIO_PROPERTY = "max_filter_ratio";
+public static final String STRICT_MODE_PROPERTY = "strict_mode";
+public static final String TIMEZONE_PROPERTY = "timezone";
+public static final String ENCLOSE_PROPERTY = "enclose";
+public static final String ESCAPE_PROPERTY = "escape";
+public static final String TRIM_DOUBLE_QUOTES_PROPERTY =
"trim_double_quotes";
+public static final String KEY_SKIP_LINES = "skip_lines";
+public static final String KEY_IN_PARAM_COLUMN_SEPARATOR =
"column_separator";
+public static final String KEY_IN_PARAM_LINE_DELIMITER = "line_delimiter";
+public static final String KEY_IN_PARAM_COLUMNS = "columns";
+public static final String KEY_IN_PARAM_TEMP_PARTITIONS =
"temporary_partitions";
+public static final String KEY_IN_PARAM_PARTITIONS = "partitions";
+public static final String KEY_CLOUD_CLUSTER = "cloud_cluster";
+private static final Logger LOG =
LogManager.getLogger(MysqlLoadCommand.class);
+
+private static final ImmutableMap PROPERTIES_MAP = new
ImmutableMap.Builder()
+.put(TIMEOUT_PROPERTY, new Function() {
+@Override
+public @Nullable Long apply(@Nullable String s) {
+return Long.valueOf(s);
+}
+})
+.put(MAX_FILTER_RATIO_PROPERTY, new Function() {
+@Override
+public @Nullable Double apply(@Nullable String s) {
+return Double.valueOf(s);
+}
+})
+.put(EXEC_MEM_LIMIT_PROPERTY, new Function() {
+@Override
+public @Nullable Long apply(@Nullable String s) {
+return Long.valueOf(s);
+}
+})
+.put(STRICT_MODE_PROPERTY, new Function() {
+@Override
+public @Nullable Boolean apply(@Nullable String s)
Re: [PR] [Enhancement] (nereids) implement mysqlLoadCommand in nereids [doris]
starocean999 commented on code in PR #49109:
URL: https://github.com/apache/doris/pull/49109#discussion_r2184606820
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/load/MysqlLoadCommand.java:
##
@@ -0,0 +1,332 @@
+// 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.load;
+
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.Config;
+import org.apache.doris.common.DdlException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.UserException;
+import org.apache.doris.common.util.PrintableMap;
+import org.apache.doris.common.util.TimeUtils;
+import org.apache.doris.load.EtlJobType;
+import org.apache.doris.load.LoadJobRowResult;
+import org.apache.doris.load.loadv2.LoadManager;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.Command;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.base.Function;
+import com.google.common.collect.ImmutableMap;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+import org.checkerframework.checker.nullness.qual.Nullable;
+
+import java.io.File;
+import java.io.IOException;
+import java.util.Map;
+import java.util.Objects;
+import java.util.UUID;
+
+// LOAD command, load files into tables.
+//
+// syntax:
+// LOAD mysqlDataDesc
+// [PROPERTIES (key1=value1, )]
+// [commentSpec]
+//
+// mysqlDataDesc:
+//DATA [ LOCAL ]
+//INFILE ""
+//INTO TABLE ""
+//[ PARTITION ( [, ... ]) ]
+//[ COLUMNS TERMINATED BY "" ]
+//[ LINES TERMINATED BY "" ]
+//[ IGNORE {LINES | ROWS} ]
+//[ ( [, ... ] ) ]
+//[ SET (col_name={ | DEFAULT} [, col_name={ | DEFAULT}] ...) ]
+//[ PROPERTIES ("" = "" [ , ... ]) ]
+// commentSpec:
+//COMMENT ...
+
+/**
+ * MysqlLoadCommand
+ */
+public class MysqlLoadCommand extends Command {
Review Comment:
```suggestion
public class MysqlLoadCommand 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 mysqlLoadCommand in nereids [doris]
starocean999 commented on code in PR #49109:
URL: https://github.com/apache/doris/pull/49109#discussion_r2184597719
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/load/MysqlDataDescription.java:
##
@@ -0,0 +1,282 @@
+// 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.load;
+
+import org.apache.doris.analysis.ImportColumnDesc;
+import org.apache.doris.analysis.Separator;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.cluster.ClusterNamespace;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.UserException;
+import org.apache.doris.datasource.InternalCatalog;
+import org.apache.doris.datasource.property.fileformat.FileFormatProperties;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.expressions.Expression;
+import org.apache.doris.nereids.trees.plans.commands.info.PartitionNamesInfo;
+import org.apache.doris.nereids.trees.plans.commands.info.TableNameInfo;
+import org.apache.doris.qe.ConnectContext;
+
+import com.google.common.base.Function;
+import com.google.common.base.Joiner;
+import com.google.common.base.Strings;
+import com.google.common.collect.Lists;
+import com.google.common.collect.Maps;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+import java.util.Optional;
+import java.util.Set;
+import java.util.TreeSet;
+
+/**
+ * MysqlDataDescription
+ */
+public class MysqlDataDescription {
+private final List filePaths;
+private String dbName;
+private String tableName;
+private final PartitionNamesInfo partitionNamesInfo;
+private final Separator columnSeparator;
+private Separator lineDelimiter;
+private int skipLines = 0;
+private List columns;
+private final List columnMappingList;
+private final Map properties;
+private boolean isAnalyzed = false;
Review Comment:
```suggestion
```
--
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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3031697899 # FE UT Coverage Report Increment line coverage ` 0.24% (1/425)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49109_3f20fcfb55f1a91d60e69f8b0a6545c00ea96dd1/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49109_3f20fcfb55f1a91d60e69f8b0a6545c00ea96dd1/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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3031657767 ClickBench: Total hot run time: 29.66 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3f20fcfb55f1a91d60e69f8b0a6545c00ea96dd1, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.250.080.07 query4 1.620.110.10 query5 0.440.410.44 query6 1.150.660.65 query7 0.030.020.02 query8 0.040.030.04 query9 0.600.500.52 query10 0.560.560.55 query11 0.160.110.11 query12 0.150.120.12 query13 0.620.620.61 query14 0.800.810.82 query15 0.890.870.89 query16 0.370.370.39 query17 1.031.121.06 query18 0.220.210.22 query19 1.901.841.78 query20 0.010.010.02 query21 15.39 0.890.54 query22 0.751.300.70 query23 14.76 1.360.66 query24 6.811.410.84 query25 0.500.280.09 query26 0.570.170.15 query27 0.070.050.05 query28 9.660.940.45 query29 12.57 4.003.41 query30 0.250.080.06 query31 2.880.580.40 query32 3.230.560.47 query33 3.043.093.11 query34 16.02 5.404.77 query35 4.804.824.80 query36 0.700.510.49 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.140.15 query41 0.090.030.02 query42 0.030.030.03 query43 0.040.040.03 Total cold run time: 103.46 s Total hot run time: 29.66 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3031636071 TPC-DS: Total hot run time: 184335 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 3f20fcfb55f1a91d60e69f8b0a6545c00ea96dd1, data reload: false query1 1036379 374 374 query2 6522166717091667 query3 6741213 212 212 query4 25970 23253 23120 23120 query5 4357586 421 421 query6 301 210 200 200 query7 4625509 286 286 query8 274 219 217 217 query9 8633263626562636 query10 480 326 256 256 query11 15426 15426 14791 14791 query12 157 108 105 105 query13 1661525 395 395 query14 9083561456525614 query15 229 191 172 172 query16 7378579 458 458 query17 1183708 553 553 query18 2041392 295 295 query19 193 184 151 151 query20 120 118 115 115 query21 211 119 107 107 query22 4130427840804080 query23 34115 32969 33159 32969 query24 8425235523882355 query25 515 476 389 389 query26 1226258 149 149 query27 2764504 343 343 query28 4357213221142114 query29 733 550 452 452 query30 277 213 184 184 query31 927 799 725 725 query32 74 62 60 60 query33 550 386 326 326 query34 778 837 535 535 query35 761 814 730 730 query36 937 946 885 885 query37 116 96 70 70 query38 4145412939883988 query39 1484140714151407 query40 216 117 107 107 query41 55 58 58 58 query42 121 107 102 102 query43 488 518 478 478 query44 1315809 808 808 query45 176 170 161 161 query46 833 1005621 621 query47 1764178417191719 query48 398 413 309 309 query49 712 485 391 391 query50 663 692 406 406 query51 4152411740664066 query52 108 107 102 102 query53 218 251 178 178 query54 578 585 500 500 query55 82 77 79 77 query56 295 327 292 292 query57 1179118111411141 query58 257 258 258 258 query59 2596272025932593 query60 314 324 300 300 query61 145 118 120 118 query62 790 718 659 659 query63 222 187 185 185 query64 4304991 656 656 query65 4251417741664166 query66 1119410 312 312 query67 15735 15539 15362 15362 query68 6829868 523 523 query69 478 310 335 310 query70 1188109010461046 query71 434 318 294 294 query72 5220484547814781 query73 655 610 352 352 query74 8867904289638963 query75 3145318926872687 query76 31381135701 701 query77 467 368 289 289 query78 10097 10235 93379337 query79 2031847 585 585 query80 767 512 447 447 query81 509 260 216 216 query82 425 128 92 92 query83 254 246 250 246 query84 256 106 91 91 query85 749 367 315 315 query86 401 312 292 292 query87 4348440642534253 query88 2867231122612261 query89 378 313 281 281 query90 1746206 205 205 query91 142 195 111 111 query92 63 61 62 61 query93 1211938 593 593 query94 677 421 300 300 query95 372 303 280 280 query96 502 561 280 280 query97 2703275926602660 query98 225 216 201 201 query99 1343142412511251 Total cold run time: 268508 ms Total hot run time: 184335 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3031600904 TPC-H: Total hot run time: 33471 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3f20fcfb55f1a91d60e69f8b0a6545c00ea96dd1, data reload: false -- Round 1 -- q1 17615 521350555055 q2 1960271 189 189 q3 10319 1533720 720 q4 10207 999 497 497 q5 7513218722602187 q6 180 165 124 124 q7 861 753 603 603 q8 9309125511131113 q9 6726507951365079 q10 6902234319631963 q11 464 292 284 284 q12 328 350 204 204 q13 17780 360730703070 q14 220 223 198 198 q15 567 475 461 461 q16 412 424 383 383 q17 614 852 377 377 q18 7504706069546954 q19 1211980 547 547 q20 337 349 222 222 q21 3676311422922292 q22 10361011949 949 Total cold run time: 105741 ms Total hot run time: 33471 ms - Round 2, with runtime_filter_mode=off - q1 5353517551525152 q2 239 324 216 216 q3 2145265622882288 q4 1387179313401340 q5 4155441945154419 q6 220 171 126 126 q7 2026191018701870 q8 2668253326052533 q9 7299733172667266 q10 3143329128972897 q11 568 535 498 498 q12 714 782 622 622 q13 3551386732973297 q14 305 323 293 293 q15 547 485 480 480 q16 443 486 452 452 q17 1179162215211521 q18 7721771273647364 q19 765 801 992 801 q20 1914199418581858 q21 4635439142474247 q22 1075105710171017 Total cold run time: 52052 ms Total hot run time: 50557 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3031483557 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030787445 ClickBench: Total hot run time: 29.18 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit c83ab647729c1963ba6003ab2e9791a22186c3f9, data reload: false query1 0.040.040.04 query2 0.080.040.04 query3 0.250.070.07 query4 1.610.100.10 query5 0.430.430.42 query6 1.170.660.66 query7 0.020.010.01 query8 0.050.040.03 query9 0.620.510.52 query10 0.580.570.58 query11 0.160.110.11 query12 0.150.110.11 query13 0.630.620.61 query14 0.800.820.82 query15 0.910.870.87 query16 0.410.390.39 query17 1.051.041.04 query18 0.230.210.21 query19 1.971.821.89 query20 0.010.020.01 query21 15.39 0.920.54 query22 0.751.130.65 query23 15.05 1.420.64 query24 7.841.020.48 query25 0.480.230.07 query26 0.560.180.14 query27 0.060.050.06 query28 8.970.920.45 query29 12.57 3.973.33 query30 0.250.090.06 query31 2.840.610.39 query32 3.250.550.46 query33 3.193.123.11 query34 16.08 5.404.74 query35 4.804.874.81 query36 0.700.500.49 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.180.140.15 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 104.46 s Total hot run time: 29.18 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030777589 TPC-DS: Total hot run time: 186324 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 c83ab647729c1963ba6003ab2e9791a22186c3f9, data reload: false query1 1009377 379 377 query2 6543171117441711 query3 6735215 211 211 query4 26927 23762 23199 23199 query5 4352570 445 445 query6 274 212 187 187 query7 4618492 288 288 query8 266 212 199 199 query9 8610264326502643 query10 456 336 264 264 query11 15251 15135 14938 14938 query12 158 105 106 105 query13 1658552 412 412 query14 8561565657115656 query15 212 192 164 164 query16 7156624 448 448 query17 951 718 603 603 query18 1966414 313 313 query19 203 192 160 160 query20 116 115 113 113 query21 210 131 109 109 query22 4060425145544251 query23 35027 34149 34136 34136 query24 8416232523632325 query25 548 475 387 387 query26 1231266 145 145 query27 2748496 342 342 query28 4289219021272127 query29 796 551 434 434 query30 281 215 179 179 query31 877 826 757 757 query32 72 68 60 60 query33 541 356 305 305 query34 792 849 512 512 query35 770 804 747 747 query36 927 948 881 881 query37 120 92 72 72 query38 4108413241204120 query39 1460144614441444 query40 203 109 105 105 query41 53 50 48 48 query42 124 103 110 103 query43 498 507 460 460 query44 1299819 813 813 query45 173 165 168 165 query46 836 999 615 615 query47 1771179817371737 query48 387 426 309 309 query49 718 470 402 402 query50 624 688 409 409 query51 4131415140784078 query52 107 107 97 97 query53 240 251 187 187 query54 574 562 486 486 query55 83 83 78 78 query56 284 294 286 286 query57 1185120511151115 query58 263 247 250 247 query59 2600271526692669 query60 316 310 298 298 query61 122 121 120 120 query62 802 718 705 705 query63 227 186 184 184 query64 4355979 649 649 query65 4229415741814157 query66 1136394 307 307 query67 15990 15376 15541 15376 query68 8134890 518 518 query69 470 300 263 263 query70 1204104010801040 query71 450 332 294 294 query72 5696479847334733 query73 701 618 347 347 query74 8947920189888988 query75 3899320326832683 query76 37601141718 718 query77 781 368 277 277 query78 994610031 93239323 query79 2647828 588 588 query80 617 507 511 507 query81 479 263 223 223 query82 455 128 98 98 query83 278 252 234 234 query84 292 100 82 82 query85 783 352 378 352 query86 336 294 296 294 query87 4435444943104310 query88 3139225022602250 query89 405 324 280 280 query90 1939206 197 197 query91 138 149 110 110 query92 70 59 60 59 query93 1787937 576 576 query94 670 420 301 301 query95 374 282 283 282 query96 501 575 283 283 query97 2708271926522652 query98 227 231 202 202 query99 1413140512861286 Total cold run time: 274306 ms Total hot run time: 186324 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030760668 TPC-H: Total hot run time: 34415 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit c83ab647729c1963ba6003ab2e9791a22186c3f9, data reload: false -- Round 1 -- q1 17607 516250135013 q2 1927279 188 188 q3 10306 1284699 699 q4 10219 1024517 517 q5 7451240423332333 q6 176 160 127 127 q7 895 750 601 601 q8 9312129111151115 q9 6888516651235123 q10 6894236119591959 q11 483 290 270 270 q12 338 352 220 220 q13 1 368431133113 q14 225 230 208 208 q15 528 481 473 473 q16 433 437 373 373 q17 614 875 382 382 q18 7553713470357035 q19 1201932 550 550 q20 338 346 222 222 q21 3837320329512951 q22 10801031943 943 Total cold run time: 106082 ms Total hot run time: 34415 ms - Round 2, with runtime_filter_mode=off - q1 5127503950675039 q2 238 325 217 217 q3 2152264923322332 q4 1336178313301330 q5 4208458245704570 q6 206 169 128 128 q7 1967194218631863 q8 2631253325862533 q9 7214731073757310 q10 3121329128632863 q11 566 495 512 495 q12 902 772 643 643 q13 3482397834743474 q14 301 303 283 283 q15 526 484 473 473 q16 446 502 454 454 q17 1151155013661366 q18 8066776276087608 q19 822 804 973 804 q20 2019213919241924 q21 5033478445044504 q22 1160114110321032 Total cold run time: 52674 ms Total hot run time: 51245 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030690034 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030593913 ClickBench: Total hot run time: 29.85 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ddbe46f64e17926d78283a601b75ee48e8a4de31, data reload: false query1 0.040.030.03 query2 0.070.040.05 query3 0.250.070.08 query4 1.650.100.11 query5 0.420.430.41 query6 1.190.670.65 query7 0.030.020.02 query8 0.040.040.05 query9 0.590.520.50 query10 0.560.570.56 query11 0.160.110.11 query12 0.140.110.11 query13 0.630.610.62 query14 0.800.820.81 query15 0.880.880.86 query16 0.390.380.41 query17 1.071.051.04 query18 0.220.210.21 query19 1.911.831.79 query20 0.010.010.02 query21 15.38 0.890.54 query22 0.741.240.82 query23 14.76 1.380.66 query24 7.201.470.94 query25 0.500.130.09 query26 0.610.170.13 query27 0.070.050.05 query28 8.990.890.44 query29 12.57 3.993.36 query30 0.250.090.07 query31 2.860.570.38 query32 3.230.560.48 query33 3.073.103.21 query34 16.16 5.394.77 query35 4.784.854.85 query36 0.710.520.49 query37 0.090.070.06 query38 0.050.040.03 query39 0.030.020.03 query40 0.180.140.14 query41 0.080.030.03 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 103.44 s Total hot run time: 29.85 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030576404 TPC-DS: Total hot run time: 184677 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 ddbe46f64e17926d78283a601b75ee48e8a4de31, data reload: false query1 1030384 383 383 query2 6545173016771677 query3 6741209 209 209 query4 26574 23740 23174 23174 query5 4260560 432 432 query6 309 211 191 191 query7 4609486 288 288 query8 268 221 207 207 query9 8571261926392619 query10 458 315 274 274 query11 15698 15146 14877 14877 query12 164 104 104 104 query13 1640547 412 412 query14 9220575556985698 query15 205 182 166 166 query16 7220601 464 464 query17 1214719 596 596 query18 1966415 307 307 query19 200 195 159 159 query20 123 118 110 110 query21 214 125 112 112 query22 3938422640734073 query23 33955 33161 33129 33129 query24 8424237924082379 query25 546 477 397 397 query26 1223266 141 141 query27 2758526 338 338 query28 4291213421142114 query29 765 554 450 450 query30 283 215 194 194 query31 954 827 793 793 query32 70 63 58 58 query33 552 364 301 301 query34 795 843 521 521 query35 780 800 749 749 query36 927 967 856 856 query37 112 100 77 77 query38 4113421239993999 query39 1498141214251412 query40 212 117 102 102 query41 55 53 51 51 query42 120 106 107 106 query43 498 506 465 465 query44 1331811 809 809 query45 179 167 157 157 query46 849 1016631 631 query47 1725177116801680 query48 383 457 308 308 query49 730 479 392 392 query50 636 686 425 425 query51 4119418140454045 query52 103 108 100 100 query53 220 251 189 189 query54 581 565 497 497 query55 78 81 83 81 query56 305 285 289 285 query57 1168119211321132 query58 262 247 248 247 query59 2670266626322632 query60 332 324 304 304 query61 125 123 120 120 query62 803 717 659 659 query63 227 204 188 188 query64 4348986 640 640 query65 4286417541654165 query66 1140402 309 309 query67 15795 15733 15315 15315 query68 8371882 530 530 query69 464 303 265 265 query70 1220109010891089 query71 461 319 304 304 query72 5503466246564656 query73 683 575 344 344 query74 8920919890079007 query75 3804317126772677 query76 36491116676 676 query77 776 357 277 277 query78 10050 10190 93869386 query79 2147830 583 583 query80 570 578 460 460 query81 484 255 227 227 query82 459 120 91 91 query83 250 249 233 233 query84 249 99 88 88 query85 787 352 320 320 query86 385 306 286 286 query87 4437444042464246 query88 3633231822892289 query89 389 318 286 286 query90 1843210 202 202 query91 141 146 109 109 query92 68 56 60 56 query93 1625955 577 577 query94 655 411 308 308 query95 372 283 282 282 query96 504 561 285 285 query97 2717274926092609 query98 235 201 204 201 query99 1390138612541254 Total cold run time: 273734 ms Total hot run time: 184677 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030557782 TPC-H: Total hot run time: 34089 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ddbe46f64e17926d78283a601b75ee48e8a4de31, data reload: false -- Round 1 -- q1 17631 523351085108 q2 1930290 186 186 q3 10431 1286727 727 q4 10301 1021521 521 q5 8547238923422342 q6 180 159 129 129 q7 895 759 599 599 q8 9299125310821082 q9 6704507051265070 q10 6928236119741974 q11 478 290 282 282 q12 350 356 216 216 q13 17765 365731523152 q14 214 239 219 219 q15 569 484 483 483 q16 422 420 396 396 q17 583 835 370 370 q18 7407722871247124 q19 1591949 599 599 q20 322 338 214 214 q21 3725320523372337 q22 10291017959 959 Total cold run time: 107301 ms Total hot run time: 34089 ms - Round 2, with runtime_filter_mode=off - q1 5240520152025201 q2 242 320 217 217 q3 2144262422992299 q4 1387178913321332 q5 4195458145554555 q6 219 173 132 132 q7 2040194718161816 q8 2617262725352535 q9 7389716270937093 q10 3174325828882888 q11 580 537 508 508 q12 686 741 610 610 q13 3661393933283328 q14 307 317 306 306 q15 516 481 476 476 q16 471 484 446 446 q17 1199162513591359 q18 7980781774357435 q19 868 810 947 810 q20 2021206218471847 q21 4685425742584257 q22 10551035982 982 Total cold run time: 52676 ms Total hot run time: 50432 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030513530 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3030431419 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3028302674 TPC-DS: Total hot run time: 187151 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 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false query1 1009404 395 395 query2 6529174817011701 query3 6740210 211 210 query4 26765 23710 24032 23710 query5 4349590 426 426 query6 306 214 213 213 query7 4611513 292 292 query8 267 226 217 217 query9 8568265226592652 query10 477 319 281 281 query11 16207 15163 14954 14954 query12 152 107 111 107 query13 1654544 401 401 query14 8940576056655665 query15 209 179 174 174 query16 7208636 459 459 query17 1170721 591 591 query18 1980415 300 300 query19 194 189 157 157 query20 123 126 114 114 query21 214 128 108 108 query22 4041439245354392 query23 34936 33879 33788 33788 query24 8485234423912344 query25 538 454 413 413 query26 1222260 146 146 query27 2783544 352 352 query28 4287213021182118 query29 747 558 467 467 query30 285 237 198 198 query31 908 793 760 760 query32 69 63 57 57 query33 553 360 311 311 query34 796 848 514 514 query35 784 786 740 740 query36 934 971 884 884 query37 110 104 74 74 query38 4146411740864086 query39 1466141714681417 query40 208 117 105 105 query41 55 52 52 52 query42 120 107 110 107 query43 501 514 480 480 query44 1345832 833 832 query45 176 169 162 162 query46 839 1005628 628 query47 1732177917011701 query48 388 410 305 305 query49 744 476 404 404 query50 635 688 408 408 query51 4209419941184118 query52 111 109 99 99 query53 223 255 198 198 query54 587 571 526 526 query55 91 89 81 81 query56 313 310 318 310 query57 1199117211141114 query58 273 266 265 265 query59 2618265025592559 query60 358 329 337 329 query61 123 116 120 116 query62 801 731 659 659 query63 222 183 190 183 query64 4302980 645 645 query65 4336421242254212 query66 1123414 308 308 query67 15719 15572 15300 15300 query68 8049890 527 527 query69 489 310 296 296 query70 1173106211361062 query71 485 311 297 297 query72 5598484348974843 query73 720 634 354 354 query74 8892912589708970 query75 3952319726612661 query76 37301169741 741 query77 777 401 337 337 query78 10431 10455 95999599 query79 1794846 587 587 query80 629 527 443 443 query81 471 267 232 232 query82 424 133 101 101 query83 288 264 261 261 query84 288 109 84 84 query85 787 368 313 313 query86 329 303 279 279 query87 4455441243064306 query88 2793226222502250 query89 376 319 284 284 query90 1906211 200 200 query91 135 135 109 109 query92 75 62 60 60 query93 1118948 584 584 query94 671 412 287 287 query95 373 281 284 281 query96 529 566 278 278 query97 2805276126462646 query98 219 202 209 202 query99 1423136912831283 Total cold run time: 274297 ms Total hot run time: 187151 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3028319026 ClickBench: Total hot run time: 29.49 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.250.080.08 query4 1.610.110.11 query5 0.420.430.44 query6 1.180.650.65 query7 0.030.020.02 query8 0.040.040.03 query9 0.600.530.52 query10 0.570.580.56 query11 0.150.110.11 query12 0.150.120.12 query13 0.630.630.61 query14 0.790.800.79 query15 0.880.860.88 query16 0.400.390.38 query17 1.011.091.07 query18 0.220.210.20 query19 2.011.851.81 query20 0.010.010.02 query21 15.48 0.900.53 query22 0.741.160.60 query23 15.06 1.360.61 query24 6.950.960.82 query25 0.540.160.16 query26 0.650.160.14 query27 0.060.060.05 query28 9.710.920.44 query29 12.55 4.013.35 query30 0.250.090.06 query31 2.840.580.39 query32 3.230.550.47 query33 3.063.083.20 query34 16.03 5.424.72 query35 4.824.854.83 query36 0.690.500.49 query37 0.090.070.07 query38 0.040.040.03 query39 0.030.020.03 query40 0.170.130.14 query41 0.080.020.02 query42 0.040.020.02 query43 0.050.030.03 Total cold run time: 104.23 s Total hot run time: 29.49 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3028260254 TPC-H: Total hot run time: 34487 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false -- Round 1 -- q1 17632 524550475047 q2 1947281 194 194 q3 10310 1298708 708 q4 10225 1021526 526 q5 7509238023712371 q6 185 158 126 126 q7 879 779 604 604 q8 9327129310801080 q9 6738513751035103 q10 6906234919371937 q11 479 286 263 263 q12 334 347 218 218 q13 1 363531033103 q14 221 222 223 222 q15 530 471 482 471 q16 424 414 373 373 q17 591 859 356 356 q18 7445724370817081 q19 1077941 537 537 q20 321 345 211 211 q21 3741323930053005 q22 10441011951 951 Total cold run time: 105642 ms Total hot run time: 34487 ms - Round 2, with runtime_filter_mode=off - q1 5173512251305122 q2 236 322 221 221 q3 2178264122772277 q4 1358178713881388 q5 4236458245654565 q6 211 168 125 125 q7 1969192717971797 q8 2658264525992599 q9 7462708072997080 q10 3134332231663166 q11 569 522 498 498 q12 687 791 603 603 q13 3636397934863486 q14 309 317 278 278 q15 527 467 479 467 q16 482 490 454 454 q17 1186162913961396 q18 7884772575537553 q19 852 881 972 881 q20 2004204119571957 q21 5111457444074407 q22 1086108910581058 Total cold run time: 52948 ms Total hot run time: 51378 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3028197470 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026857255 TPC-H: Total hot run time: 33808 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false -- Round 1 -- q1 17610 526050635063 q2 1920276 204 204 q3 10306 1261718 718 q4 10231 1006504 504 q5 7487231223532312 q6 184 158 126 126 q7 865 729 594 594 q8 9295128210501050 q9 6732523050665066 q10 6874238319561956 q11 467 282 289 282 q12 341 349 212 212 q13 17790 365030793079 q14 224 218 218 218 q15 559 476 489 476 q16 434 428 383 383 q17 582 840 370 370 q18 7479718971357135 q19 1299956 557 557 q20 325 333 213 213 q21 3603250323322332 q22 10191023958 958 Total cold run time: 105626 ms Total hot run time: 33808 ms - Round 2, with runtime_filter_mode=off - q1 5141510050675067 q2 247 330 218 218 q3 2157257623122312 q4 1362179413661366 q5 4175432744784327 q6 212 165 123 123 q7 1997200718611861 q8 2606258726052587 q9 7339719372597193 q10 3067334628752875 q11 586 515 510 510 q12 666 780 610 610 q13 3540390236013601 q14 272 291 269 269 q15 505 475 472 472 q16 436 495 460 460 q17 1134159313831383 q18 7989763779137637 q19 831 825 823 823 q20 2072201718391839 q21 4630435442364236 q22 10731011987 987 Total cold run time: 52037 ms Total hot run time: 50756 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026908024 ClickBench: Total hot run time: 29.9 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.250.080.08 query4 1.600.100.11 query5 0.440.420.44 query6 1.150.660.66 query7 0.020.020.02 query8 0.040.030.04 query9 0.590.500.54 query10 0.570.570.57 query11 0.160.110.11 query12 0.150.120.11 query13 0.620.610.60 query14 0.780.820.81 query15 0.900.860.87 query16 0.390.400.40 query17 1.091.041.10 query18 0.220.210.22 query19 1.931.831.87 query20 0.020.010.01 query21 15.40 0.860.53 query22 0.751.210.72 query23 14.82 1.340.63 query24 6.641.791.10 query25 0.520.220.15 query26 0.580.160.15 query27 0.070.050.06 query28 9.970.870.46 query29 12.55 3.953.23 query30 0.240.080.07 query31 2.840.600.39 query32 3.230.540.49 query33 3.063.153.12 query34 16.05 5.344.77 query35 4.864.844.81 query36 0.680.490.48 query37 0.090.070.07 query38 0.050.040.03 query39 0.040.020.03 query40 0.160.140.13 query41 0.080.030.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.79 s Total hot run time: 29.9 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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026982210 # FE UT Coverage Report Increment line coverage ` 2.11% (9/427)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49109_282208e65fabe29ae6254233220ff2ad44d87a6b/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49109_282208e65fabe29ae6254233220ff2ad44d87a6b/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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026893428 TPC-DS: Total hot run time: 184968 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 282208e65fabe29ae6254233220ff2ad44d87a6b, data reload: false query1 1000388 384 384 query2 6543172017141714 query3 6738210 209 209 query4 26714 23584 23044 23044 query5 4372582 429 429 query6 302 211 214 211 query7 4611480 285 285 query8 268 210 216 210 query9 8623263726422637 query10 489 326 277 277 query11 15588 15006 14887 14887 query12 164 111 101 101 query13 1647533 402 402 query14 8865570156345634 query15 198 189 177 177 query16 7326630 466 466 query17 1187695 558 558 query18 1970387 291 291 query19 188 212 153 153 query20 123 119 114 114 query21 207 126 101 101 query22 4242447341154115 query23 33753 32903 32979 32903 query24 8471235023792350 query25 546 468 402 402 query26 1240262 146 146 query27 2763502 336 336 query28 4320213121172117 query29 734 582 444 444 query30 276 216 195 195 query31 893 803 741 741 query32 68 63 62 62 query33 553 342 311 311 query34 784 832 504 504 query35 790 802 732 732 query36 961 978 881 881 query37 106 98 73 73 query38 4067413840714071 query39 1470138814261388 query40 213 112 103 103 query41 55 52 51 51 query42 122 110 106 106 query43 499 526 484 484 query44 1312820 811 811 query45 177 163 163 163 query46 843 1005618 618 query47 1743181317141714 query48 378 415 305 305 query49 720 465 389 389 query50 624 668 416 416 query51 4172413340844084 query52 111 109 98 98 query53 222 248 184 184 query54 573 571 507 507 query55 81 79 81 79 query56 306 286 298 286 query57 1189119611351135 query58 266 258 261 258 query59 2658262726542627 query60 337 328 311 311 query61 126 121 121 121 query62 800 722 687 687 query63 216 191 183 183 query64 42981119758 758 query65 4257414841874148 query66 1159412 321 321 query67 15753 15531 15463 15463 query68 7856872 517 517 query69 470 297 261 261 query70 1185114211131113 query71 460 319 289 289 query72 5741483447584758 query73 687 659 352 352 query74 9236902389628962 query75 3818316827152715 query76 34721126709 709 query77 804 384 287 287 query78 10054 10321 94389438 query79 2330795 591 591 query80 646 511 486 486 query81 494 259 218 218 query82 181 127 95 95 query83 252 254 228 228 query84 249 105 100 100 query85 817 358 318 318 query86 382 297 272 272 query87 4424439342184218 query88 3430227622622262 query89 391 306 278 278 query90 1966205 203 203 query91 143 150 113 113 query92 83 63 54 54 query93 2489917 588 588 query94 623 410 309 309 query95 378 291 282 282 query96 487 573 283 283 query97 2689275326892689 query98 229 211 200 200 query99 1330142613151315 Total cold run time: 274166 ms Total hot run time: 184968 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026755745 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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026299020 # FE UT Coverage Report Increment line coverage ` 2.11% (9/427)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49109_1491b72591b075196b7b26f85faa6c5004883b1c/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49109_1491b72591b075196b7b26f85faa6c5004883b1c/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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026259798 ClickBench: Total hot run time: 29.29 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1491b72591b075196b7b26f85faa6c5004883b1c, data reload: false query1 0.040.040.04 query2 0.080.040.04 query3 0.240.070.08 query4 1.620.110.11 query5 0.440.450.42 query6 1.180.650.66 query7 0.030.020.02 query8 0.050.030.04 query9 0.600.530.52 query10 0.570.560.57 query11 0.150.110.11 query12 0.140.110.12 query13 0.630.630.61 query14 0.790.830.79 query15 0.910.880.86 query16 0.380.380.40 query17 1.061.101.11 query18 0.210.210.21 query19 1.961.811.80 query20 0.020.010.02 query21 15.38 0.880.55 query22 0.771.170.60 query23 15.04 1.330.63 query24 7.940.620.90 query25 0.470.250.14 query26 0.620.170.14 query27 0.070.050.06 query28 9.150.860.43 query29 12.52 3.843.32 query30 0.250.090.07 query31 2.830.590.39 query32 3.230.550.46 query33 3.053.113.06 query34 16.07 5.354.76 query35 4.824.854.80 query36 0.680.490.50 query37 0.100.070.07 query38 0.050.040.04 query39 0.030.030.03 query40 0.180.140.14 query41 0.090.020.03 query42 0.030.030.02 query43 0.030.020.02 Total cold run time: 104.5 s Total hot run time: 29.29 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026253933 TPC-DS: Total hot run time: 184911 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 1491b72591b075196b7b26f85faa6c5004883b1c, data reload: false query1 1001391 388 388 query2 6534163816781638 query3 6740211 216 211 query4 26251 23311 23420 23311 query5 4339583 436 436 query6 289 200 205 200 query7 4622502 283 283 query8 262 233 207 207 query9 8573258426152584 query10 466 337 259 259 query11 15654 15919 14860 14860 query12 156 100 101 100 query13 1640515 398 398 query14 8730566456835664 query15 201 190 170 170 query16 7152607 498 498 query17 1188707 559 559 query18 1977394 296 296 query19 188 201 151 151 query20 120 115 115 115 query21 215 120 103 103 query22 4079423241294129 query23 33698 32990 33117 32990 query24 8453238924172389 query25 576 501 423 423 query26 1243264 150 150 query27 2778507 347 347 query28 4337211420922092 query29 809 588 443 443 query30 289 223 195 195 query31 925 835 788 788 query32 74 66 64 64 query33 564 365 310 310 query34 787 836 521 521 query35 789 832 732 732 query36 939 953 880 880 query37 115 97 76 76 query38 4137418541714171 query39 1489142215821422 query40 223 123 108 108 query41 64 58 57 57 query42 121 108 110 108 query43 496 501 461 461 query44 1394818 816 816 query45 174 169 164 164 query46 832 991 624 624 query47 1742177316971697 query48 387 421 305 305 query49 738 466 382 382 query50 628 688 400 400 query51 4154418941054105 query52 108 103 98 98 query53 221 252 184 184 query54 563 619 498 498 query55 82 83 83 83 query56 313 296 286 286 query57 1154118011021102 query58 263 248 258 248 query59 2648265224792479 query60 321 314 302 302 query61 124 120 118 118 query62 815 732 668 668 query63 217 185 186 185 query64 43481063708 708 query65 4287419941764176 query66 1139404 300 300 query67 15822 15698 15260 15260 query68 8224891 538 538 query69 482 294 273 273 query70 1211113011171117 query71 461 308 297 297 query72 5361468947864689 query73 722 594 353 353 query74 9183908589858985 query75 3775315326882688 query76 36611135723 723 query77 781 396 307 307 query78 10133 10331 93189318 query79 1966801 587 587 query80 594 504 449 449 query81 482 256 223 223 query82 445 124 95 95 query83 256 249 228 228 query84 238 102 84 84 query85 803 395 312 312 query86 347 307 284 284 query87 4543451643774377 query88 3513226522632263 query89 383 314 282 282 query90 1925207 206 206 query91 137 145 107 107 query92 78 62 57 57 query93 1478942 582 582 query94 685 415 302 302 query95 378 293 283 283 query96 492 572 281 281 query97 2720269526382638 query98 228 284 204 204 query99 1657139613041304 Total cold run time: 273099 ms Total hot run time: 184911 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026159833 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3026238861 TPC-H: Total hot run time: 33631 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1491b72591b075196b7b26f85faa6c5004883b1c, data reload: false -- Round 1 -- q1 17576 516050485048 q2 1923278 186 186 q3 10307 1242672 672 q4 10213 1002518 518 q5 7474236023092309 q6 178 160 129 129 q7 869 731 613 613 q8 9296123410901090 q9 6728508750455045 q10 6866236619391939 q11 462 295 267 267 q12 339 340 201 201 q13 17755 364130543054 q14 229 227 208 208 q15 534 474 476 474 q16 412 430 382 382 q17 586 832 361 361 q18 7436709471597094 q19 1208938 525 525 q20 330 359 224 224 q21 3705254123332333 q22 984 993 959 959 Total cold run time: 105410 ms Total hot run time: 33631 ms - Round 2, with runtime_filter_mode=off - q1 5145512151295121 q2 232 316 220 220 q3 2154262322862286 q4 1314174613121312 q5 4182418845724188 q6 226 168 124 124 q7 1971201717841784 q8 2540252225332522 q9 7195729372687268 q10 3150332528642864 q11 557 522 512 512 q12 707 767 631 631 q13 3532396133473347 q14 283 292 265 265 q15 528 481 464 464 q16 436 481 435 435 q17 1173156513551355 q18 8130744076327440 q19 891 781 833 781 q20 1960206918361836 q21 4937424042684240 q22 1033101510031003 Total cold run time: 52276 ms Total hot run time: 49998 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3023091900 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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3023459185 # FE UT Coverage Report Increment line coverage ` 2.14% (9/421)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49109_3b5c6ad4565f6a1403aebe02070db8e2adcf6b9d/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49109_3b5c6ad4565f6a1403aebe02070db8e2adcf6b9d/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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3023430887 ClickBench: Total hot run time: 29.71 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3b5c6ad4565f6a1403aebe02070db8e2adcf6b9d, data reload: false query1 0.040.050.04 query2 0.090.040.04 query3 0.240.080.07 query4 1.620.110.12 query5 0.450.450.42 query6 1.170.660.67 query7 0.020.020.01 query8 0.040.030.04 query9 0.600.510.53 query10 0.590.570.58 query11 0.160.110.11 query12 0.150.110.12 query13 0.620.610.63 query14 0.790.810.81 query15 0.900.860.90 query16 0.390.390.42 query17 1.051.111.07 query18 0.230.220.21 query19 1.901.871.91 query20 0.020.020.01 query21 15.37 0.860.53 query22 0.761.220.78 query23 14.81 1.380.67 query24 7.511.150.62 query25 0.480.120.13 query26 0.680.170.15 query27 0.070.050.06 query28 8.920.920.44 query29 12.56 4.003.35 query30 0.250.090.06 query31 2.850.610.39 query32 3.230.550.47 query33 3.073.123.14 query34 16.22 5.464.78 query35 4.844.864.90 query36 0.680.500.48 query37 0.100.060.07 query38 0.050.040.04 query39 0.030.030.02 query40 0.170.140.13 query41 0.080.020.03 query42 0.030.030.02 query43 0.030.040.04 Total cold run time: 103.86 s Total hot run time: 29.71 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3023401756 TPC-DS: Total hot run time: 186647 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 3b5c6ad4565f6a1403aebe02070db8e2adcf6b9d, data reload: false query1 997 405 380 380 query2 6537184618171817 query3 6758234 230 230 query4 26703 23335 23460 23335 query5 4366583 475 475 query6 301 219 199 199 query7 4637514 287 287 query8 263 221 220 220 query9 8631272827862728 query10 501 358 271 271 query11 15252 15115 15291 15115 query12 169 111 106 106 query13 1658562 428 428 query14 9889569257165692 query15 209 190 173 173 query16 7654665 508 508 query17 1230737 591 591 query18 2042411 322 322 query19 210 205 164 164 query20 123 118 118 118 query21 215 134 115 115 query22 4233406542064065 query23 34007 33131 33321 33131 query24 8364239323872387 query25 516 466 390 390 query26 1242270 154 154 query27 2722516 352 352 query28 4295222722012201 query29 731 563 464 464 query30 288 225 221 221 query31 922 820 773 773 query32 73 63 64 63 query33 542 367 309 309 query34 820 856 533 533 query35 796 834 733 733 query36 966 1021914 914 query37 108 97 75 75 query38 4123421941954195 query39 1501143614301430 query40 210 114 103 103 query41 61 53 54 53 query42 127 106 117 106 query43 516 521 494 494 query44 1360854 851 851 query45 173 171 161 161 query46 868 1034661 661 query47 1802179817421742 query48 384 420 335 335 query49 751 519 399 399 query50 673 713 431 431 query51 4127418542704185 query52 111 108 99 99 query53 229 259 182 182 query54 588 569 508 508 query55 87 81 80 80 query56 286 321 290 290 query57 1176123010991099 query58 258 265 281 265 query59 2632278925962596 query60 325 318 318 318 query61 120 120 121 120 query62 801 698 655 655 query63 226 185 183 183 query64 4264996 642 642 query65 4255420541714171 query66 1053415 336 336 query67 15735 15580 15342 15342 query68 8569916 514 514 query69 458 295 252 252 query70 1232105610971056 query71 454 311 301 301 query72 5787477248664772 query73 733 638 350 350 query74 9112923289038903 query75 3862319227912791 query76 36271203719 719 query77 783 360 293 293 query78 999010425 93919391 query79 1908854 587 587 query80 584 511 455 455 query81 469 254 214 214 query82 455 127 95 95 query83 309 251 234 234 query84 246 102 84 84 query85 800 366 384 366 query86 352 307 279 279 query87 4365449243874387 query88 3467236123422342 query89 385 325 282 282 query90 1937224 211 211 query91 140 143 110 110 query92 77 60 56 56 query93 1487989 602 602 query94 673 405 285 285 query95 380 285 283 283 query96 494 578 288 288 query97 2735277626182618 query98 235 203 206 203 query99 1425140112531253 Total cold run time: 275322 ms Total hot run time: 186647 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3023351933 TPC-H: Total hot run time: 34148 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3b5c6ad4565f6a1403aebe02070db8e2adcf6b9d, data reload: false -- Round 1 -- q1 17591 521051175117 q2 1957305 194 194 q3 10431 1315720 720 q4 10312 1025523 523 q5 8518244823392339 q6 190 164 132 132 q7 895 735 604 604 q8 9315129111431143 q9 7560513951015101 q10 6906241519691969 q11 489 299 303 299 q12 350 353 224 224 q13 17789 370930913091 q14 231 242 219 219 q15 550 490 472 472 q16 435 421 391 391 q17 646 874 374 374 q18 7614714271387138 q19 1213973 533 533 q20 361 355 230 230 q21 4035331223722372 q22 10871050963 963 Total cold run time: 108475 ms Total hot run time: 34148 ms - Round 2, with runtime_filter_mode=off - q1 5126509455115094 q2 247 331 222 222 q3 2138268723272327 q4 1380180913661366 q5 4531442544994425 q6 215 171 124 124 q7 2024195217761776 q8 2755244226342442 q9 7612734275737342 q10 3085326529222922 q11 566 508 487 487 q12 633 736 589 589 q13 3343372031513151 q14 264 296 256 256 q15 527 475 456 456 q16 424 470 429 429 q17 1154153213051305 q18 7370731972077207 q19 798 864 923 864 q20 1901196718561856 q21 5229434243434342 q22 1121103510091009 Total cold run time: 52443 ms Total hot run time: 49991 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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016837310 # FE UT Coverage Report Increment line coverage ` 2.12% (9/425)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49109_87e436c5db502ea49878a3955f9fa1077108fabb/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49109_87e436c5db502ea49878a3955f9fa1077108fabb/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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016829586 ClickBench: Total hot run time: 29.94 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 87e436c5db502ea49878a3955f9fa1077108fabb, data reload: false query1 0.040.030.03 query2 0.080.050.04 query3 0.250.080.07 query4 1.620.110.10 query5 0.450.450.41 query6 1.140.660.66 query7 0.030.020.02 query8 0.040.030.04 query9 0.620.540.55 query10 0.570.580.59 query11 0.160.110.10 query12 0.160.110.12 query13 0.630.610.63 query14 0.790.830.82 query15 0.930.900.89 query16 0.380.410.41 query17 1.111.151.10 query18 0.220.210.22 query19 1.971.801.93 query20 0.020.010.01 query21 15.39 0.890.54 query22 0.751.120.61 query23 15.07 1.360.64 query24 6.691.111.18 query25 0.470.130.13 query26 0.680.160.14 query27 0.060.060.06 query28 9.690.940.45 query29 12.55 4.053.33 query30 0.250.090.07 query31 2.840.580.38 query32 3.240.560.46 query33 3.073.093.11 query34 16.09 5.454.78 query35 4.834.794.81 query36 0.670.500.48 query37 0.090.070.07 query38 0.060.050.04 query39 0.030.030.02 query40 0.170.150.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.040.04 Total cold run time: 104.06 s Total hot run time: 29.94 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016826328 TPC-DS: Total hot run time: 185593 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 87e436c5db502ea49878a3955f9fa1077108fabb, data reload: false query1 988 386 392 386 query2 6517179117491749 query3 6733217 222 217 query4 26559 23817 23056 23056 query5 4551599 462 462 query6 314 222 194 194 query7 4622495 293 293 query8 280 227 216 216 query9 8597262426242624 query10 482 317 287 287 query11 15530 15049 14819 14819 query12 176 112 103 103 query13 1675529 408 408 query14 9869584358345834 query15 198 192 179 179 query16 7658652 475 475 query17 1193716 601 601 query18 2025409 310 310 query19 206 197 170 170 query20 125 113 118 113 query21 220 135 107 107 query22 3979413439713971 query23 34529 33094 33171 33094 query24 8362238523832383 query25 535 472 400 400 query26 1224267 145 145 query27 2725514 342 342 query28 4256212021132113 query29 745 573 434 434 query30 286 227 179 179 query31 953 830 745 745 query32 72 66 62 62 query33 555 390 336 336 query34 790 835 533 533 query35 776 833 754 754 query36 947 959 895 895 query37 113 96 76 76 query38 4303411441374114 query39 1490141514011401 query40 210 122 104 104 query41 55 56 51 51 query42 125 107 105 105 query43 514 519 477 477 query44 1332822 838 822 query45 180 174 167 167 query46 849 994 648 648 query47 1749179017061706 query48 377 435 304 304 query49 738 491 405 405 query50 652 710 420 420 query51 4087411941144114 query52 115 105 100 100 query53 233 257 187 187 query54 580 579 523 523 query55 79 80 81 80 query56 303 311 292 292 query57 1178120811121112 query58 262 262 278 262 query59 2855286228132813 query60 322 306 300 300 query61 131 119 116 116 query62 803 700 657 657 query63 214 188 193 188 query64 42681016654 654 query65 4285419141844184 query66 1053412 314 314 query67 15654 15725 15253 15253 query68 8280904 523 523 query69 475 364 277 277 query70 1212112811191119 query71 444 318 308 308 query72 5768478048644780 query73 740 639 350 350 query74 8848916688918891 query75 3730321427422742 query76 36031146722 722 query77 806 418 308 308 query78 997210133 93749374 query79 2333788 595 595 query80 581 504 441 441 query81 490 262 229 229 query82 456 127 100 100 query83 253 247 233 233 query84 243 102 88 88 query85 818 359 385 359 query86 389 310 280 280 query87 4357450044144414 query88 3554225922772259 query89 388 311 292 292 query90 1830211 203 203 query91 139 141 112 112 query92 81 61 55 55 query93 1638962 590 590 query94 665 400 320 320 query95 376 370 297 297 query96 491 561 284 284 query97 2676272826502650 query98 227 205 207 205 query99 1448143912551255 Total cold run time: 275672 ms Total hot run time: 185593 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016818891 TPC-H: Total hot run time: 33771 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 87e436c5db502ea49878a3955f9fa1077108fabb, data reload: false -- Round 1 -- q1 17624 520450615061 q2 1916278 189 189 q3 10325 1268721 721 q4 10260 997 504 504 q5 8298241422622262 q6 211 155 130 130 q7 883 746 610 610 q8 9322129311151115 q9 6920503850455038 q10 6922236919641964 q11 486 291 271 271 q12 353 358 211 211 q13 17769 370030423042 q14 233 229 218 218 q15 563 476 476 476 q16 433 441 389 389 q17 600 841 361 361 q18 7407713271347132 q19 1515955 547 547 q20 326 346 223 223 q21 3615328923352335 q22 1015981 972 972 Total cold run time: 106996 ms Total hot run time: 33771 ms - Round 2, with runtime_filter_mode=off - q1 5177513150995099 q2 252 319 218 218 q3 2128265422932293 q4 1342174813791379 q5 4175432544304325 q6 200 162 126 126 q7 1908190317481748 q8 2634259225452545 q9 7066706971367069 q10 3044323327952795 q11 568 517 481 481 q12 691 747 599 599 q13 3613391832843284 q14 280 289 273 273 q15 519 479 470 470 q16 452 491 435 435 q17 1133149213231323 q18 7159718470287028 q19 744 754 782 754 q20 1961194317981798 q21 4615432642454245 q22 10721049997 997 Total cold run time: 50733 ms Total hot run time: 49284 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016791621 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016787878 TPC-DS: Total hot run time: 185125 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 97f8d8a431692df4062ba224bfe77d9b700fa074, data reload: false query1 1029377 382 377 query2 6535173817651738 query3 6737213 214 213 query4 26711 23380 23377 23377 query5 4454590 439 439 query6 302 231 198 198 query7 4644499 288 288 query8 275 219 204 204 query9 8628259926082599 query10 468 318 256 256 query11 15571 15005 14833 14833 query12 167 105 106 105 query13 1653527 411 411 query14 9667575257525752 query15 204 194 197 194 query16 7630596 431 431 query17 1165676 581 581 query18 2004398 288 288 query19 189 182 161 161 query20 115 117 118 117 query21 216 120 108 108 query22 4246406839533953 query23 33997 33063 33014 33014 query24 8368235923672359 query25 527 478 386 386 query26 1224266 144 144 query27 2756509 336 336 query28 4382211620852085 query29 719 563 423 423 query30 283 210 191 191 query31 947 866 749 749 query32 74 61 66 61 query33 548 339 309 309 query34 789 842 522 522 query35 801 810 721 721 query36 972 960 902 902 query37 102 91 76 76 query38 4115412841334128 query39 1491142914101410 query40 207 121 109 109 query41 55 55 50 50 query42 127 103 100 100 query43 505 518 491 491 query44 1361824 805 805 query45 177 171 163 163 query46 925 1000626 626 query47 1734179017021702 query48 376 421 304 304 query49 739 508 382 382 query50 649 696 414 414 query51 4119412141334121 query52 109 106 99 99 query53 225 253 187 187 query54 573 573 502 502 query55 79 80 80 80 query56 302 297 268 268 query57 1158118611301130 query58 263 245 249 245 query59 2695277727722772 query60 320 322 312 312 query61 122 118 118 118 query62 801 705 633 633 query63 225 181 183 181 query64 4218993 638 638 query65 4249416042304160 query66 1037401 297 297 query67 15628 15485 15262 15262 query68 7776867 510 510 query69 469 360 268 268 query70 1161112110841084 query71 426 318 298 298 query72 5530477646784678 query73 618 582 343 343 query74 8832916090009000 query75 3383318527312731 query76 33311167716 716 query77 639 381 294 294 query78 10086 10299 94429442 query79 1466799 589 589 query80 579 507 447 447 query81 474 251 219 219 query82 184 131 131 131 query83 244 257 229 229 query84 240 109 85 85 query85 765 358 309 309 query86 369 317 279 279 query87 4551453443554355 query88 2794225722492249 query89 377 321 279 279 query90 1837216 211 211 query91 130 139 115 115 query92 62 58 65 58 query93 1066956 594 594 query94 627 404 309 309 query95 378 293 285 285 query96 491 576 279 279 query97 2674275526572657 query98 227 213 218 213 query99 1328139512791279 Total cold run time: 270797 ms Total hot run time: 185125 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016779859 TPC-H: Total hot run time: 33679 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 97f8d8a431692df4062ba224bfe77d9b700fa074, data reload: false -- Round 1 -- q1 17583 518350645064 q2 1922306 182 182 q3 10299 1292688 688 q4 10240 1013534 534 q5 7528236623182318 q6 187 158 128 128 q7 867 726 580 580 q8 9325129510861086 q9 6797505750805057 q10 6892237119541954 q11 477 286 282 282 q12 338 346 204 204 q13 17765 366430393039 q14 238 235 206 206 q15 546 462 487 462 q16 416 418 375 375 q17 586 833 359 359 q18 7605717771877177 q19 1560946 553 553 q20 318 350 218 218 q21 3623254622392239 q22 10331003974 974 Total cold run time: 106145 ms Total hot run time: 33679 ms - Round 2, with runtime_filter_mode=off - q1 5133508150885081 q2 250 316 215 215 q3 2173264123062306 q4 1337175013041304 q5 4184423243194232 q6 207 166 122 122 q7 1965194317541754 q8 2582253825402538 q9 7189728972867286 q10 3101332428542854 q11 569 515 514 514 q12 685 792 666 666 q13 3531386332953295 q14 272 285 270 270 q15 507 502 474 474 q16 435 476 441 441 q17 1116154313381338 q18 7362718470137013 q19 762 823 930 823 q20 1925193317901790 q21 4689429442234223 q22 10621009981 981 Total cold run time: 51036 ms Total hot run time: 49520 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-3016761263 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2999237003 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2999686862 ClickBench: Total hot run time: 29.55 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 6997efdf5106ccf346b2ceb04ada99c03ad3458e, data reload: false query1 0.040.040.03 query2 0.070.040.04 query3 0.240.070.07 query4 1.610.100.10 query5 0.440.430.42 query6 1.160.670.68 query7 0.020.020.02 query8 0.050.040.04 query9 0.590.520.52 query10 0.570.600.58 query11 0.160.120.11 query12 0.150.120.12 query13 0.630.620.60 query14 0.820.810.81 query15 0.910.900.88 query16 0.390.410.41 query17 1.081.071.06 query18 0.230.220.22 query19 1.921.862.00 query20 0.020.010.02 query21 15.40 0.960.56 query22 0.751.160.62 query23 15.03 1.390.63 query24 7.401.260.50 query25 0.470.220.08 query26 0.570.160.15 query27 0.070.060.05 query28 9.850.950.45 query29 12.56 4.083.35 query30 0.250.090.07 query31 2.820.610.40 query32 3.240.570.47 query33 3.103.093.13 query34 16.08 5.504.85 query35 4.904.904.87 query36 0.690.520.49 query37 0.090.060.07 query38 0.050.050.04 query39 0.030.020.02 query40 0.180.140.14 query41 0.080.020.02 query42 0.040.030.03 query43 0.040.040.04 Total cold run time: 104.79 s Total hot run time: 29.55 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2999671731 TPC-DS: Total hot run time: 186791 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 6997efdf5106ccf346b2ceb04ada99c03ad3458e, data reload: false query1 1009415 425 415 query2 6536182917961796 query3 6757222 222 222 query4 25986 23875 23479 23479 query5 5150668 484 484 query6 322 222 206 206 query7 4633497 297 297 query8 268 227 212 212 query9 8646261626292616 query10 501 340 296 296 query11 15308 15143 14885 14885 query12 174 115 113 113 query13 1653559 422 422 query14 9899616262256162 query15 209 189 177 177 query16 7642664 505 505 query17 1225747 596 596 query18 2032408 362 362 query19 196 190 158 158 query20 124 117 120 117 query21 218 123 110 110 query22 3981438939453945 query23 34476 33296 33210 33210 query24 8440240523962396 query25 529 455 410 410 query26 835 280 152 152 query27 2682515 347 347 query28 4280212121162116 query29 664 553 438 438 query30 286 232 190 190 query31 943 829 744 744 query32 73 68 63 63 query33 552 381 311 311 query34 788 850 537 537 query35 764 830 735 735 query36 935 1015901 901 query37 118 108 78 78 query38 4165404642264046 query39 1494145814121412 query40 212 143 109 109 query41 68 58 60 58 query42 135 108 106 106 query43 502 509 462 462 query44 1312838 848 838 query45 179 175 175 175 query46 840 1024638 638 query47 1749176617061706 query48 389 422 307 307 query49 696 498 400 400 query50 639 725 402 402 query51 4146416741164116 query52 117 115 107 107 query53 237 253 193 193 query54 582 592 512 512 query55 88 83 87 83 query56 318 306 309 306 query57 1146122110951095 query58 272 278 280 278 query59 2540264825092509 query60 330 339 305 305 query61 131 124 125 124 query62 783 728 659 659 query63 231 191 186 186 query64 34791028667 667 query65 4309419141834183 query66 861 457 331 331 query67 15731 15578 15367 15367 query68 8864891 539 539 query69 496 304 272 272 query70 12101121 query71 468 333 301 301 query72 5190476648204766 query73 769 627 355 355 query74 8873913290639063 query75 4229318226962696 query76 36771225799 799 query77 806 406 298 298 query78 994410184 93919391 query79 2219835 596 596 query80 663 524 457 457 query81 480 265 224 224 query82 420 133 104 104 query83 284 243 239 239 query84 298 117 95 95 query85 754 348 322 322 query86 333 306 287 287 query87 442644544426 query88 3187229422982294 query89 393 313 289 289 query90 1981218 217 217 query91 140 141 113 113 query92 80 63 64 63 query93 1128946 590 590 query94 671 422 308 308 query95 379 299 286 286 query96 495 573 287 287 query97 2751279626632663 query98 236 212 205 205 query99 1430140512521252 Total cold run time: 273807 ms Total hot run time: 186791 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2999635163 TPC-H: Total hot run time: 34201 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 6997efdf5106ccf346b2ceb04ada99c03ad3458e, data reload: false -- Round 1 -- q1 17573 511050235023 q2 1970308 193 193 q3 10273 1337725 725 q4 10259 1083536 536 q5 7976239323942393 q6 185 168 130 130 q7 921 757 606 606 q8 9328137411091109 q9 6886510651445106 q10 6908238619881988 q11 476 287 274 274 q12 344 348 219 219 q13 17765 375630793079 q14 245 234 225 225 q15 580 496 472 472 q16 435 426 377 377 q17 610 870 364 364 q18 7529725171267126 q19 1545968 587 587 q20 328 338 227 227 q21 3822320424692469 q22 10601032973 973 Total cold run time: 107018 ms Total hot run time: 34201 ms - Round 2, with runtime_filter_mode=off - q1 5192510551135105 q2 244 315 221 221 q3 2161264822972297 q4 1395183213671367 q5 4305437344654373 q6 224 171 127 127 q7 2056191525181915 q8 2597248326182483 q9 7216713671687136 q10 3065322328412841 q11 573 507 521 507 q12 697 769 598 598 q13 3560380633143314 q14 301 312 275 275 q15 514 464 474 464 q16 434 489 432 432 q17 1119151913201320 q18 7389734471587158 q19 805 796 922 796 q20 1922200218181818 q21 4847430142484248 q22 1068999 990 990 Total cold run time: 51684 ms Total hot run time: 49785 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2999343032 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2969846216 ClickBench: Total hot run time: 28.75 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3c0d1eefd1478ce806e57d97a2b8f55606c20e18, data reload: false query1 0.030.030.02 query2 0.070.030.04 query3 0.230.060.07 query4 1.600.100.10 query5 0.440.420.42 query6 1.170.660.67 query7 0.030.010.02 query8 0.050.040.03 query9 0.580.520.52 query10 0.580.570.57 query11 0.160.100.11 query12 0.150.110.11 query13 0.630.600.59 query14 0.790.810.82 query15 0.880.860.88 query16 0.400.390.40 query17 1.061.021.02 query18 0.220.210.21 query19 1.961.821.78 query20 0.010.020.02 query21 15.40 0.920.55 query22 0.741.180.66 query23 14.96 1.400.62 query24 7.420.690.95 query25 0.510.210.13 query26 0.550.170.15 query27 0.050.060.05 query28 9.650.920.45 query29 12.55 4.073.35 query30 0.250.090.07 query31 2.820.610.39 query32 3.230.570.48 query33 3.133.093.06 query34 15.83 5.134.46 query35 4.564.534.52 query36 0.660.500.48 query37 0.090.070.07 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.140.13 query41 0.090.020.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 103.86 s Total hot run time: 28.75 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2969833355 TPC-DS: Total hot run time: 192755 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 3c0d1eefd1478ce806e57d97a2b8f55606c20e18, data reload: false query1 14111013989 989 query2 6142177117801771 query3 11017 462847164628 query4 53851 25267 23550 23550 query5 5200637 459 459 query6 351 205 200 200 query7 4874537 292 292 query8 303 231 211 211 query9 5412265226402640 query10 452 326 278 278 query11 15182 15031 14879 14879 query12 160 108 101 101 query13 1034536 412 412 query14 10213 636062306230 query15 211 201 180 180 query16 7120616 485 485 query17 1043743 587 587 query18 1598406 305 305 query19 203 190 175 175 query20 132 122 120 120 query21 209 128 115 115 query22 4389432942134213 query23 34176 33347 33634 33347 query24 6627238024232380 query25 461 465 408 408 query26 683 281 159 159 query27 2356514 338 338 query28 3022216621452145 query29 601 540 477 477 query30 270 214 189 189 query31 876 858 781 781 query32 69 61 62 61 query33 464 363 316 316 query34 790 885 533 533 query35 800 817 772 772 query36 960 976 873 873 query37 115 100 79 79 query38 4332434941794179 query39 1518144414381438 query40 224 124 109 109 query41 62 57 59 57 query42 126 111 118 111 query43 509 500 486 486 query44 1417863 863 863 query45 184 176 164 164 query46 847 1018647 647 query47 1799188817811781 query48 425 437 329 329 query49 646 481 408 408 query50 675 691 418 418 query51 4267416642444166 query52 113 118 106 106 query53 236 260 190 190 query54 577 578 522 522 query55 91 91 85 85 query56 330 316 309 309 query57 1203124711641164 query58 280 281 266 266 query59 2720275326982698 query60 347 341 326 326 query61 147 144 146 144 query62 740 749 683 683 query63 250 196 198 196 query64 17931022717 717 query65 4347416341234123 query66 722 397 305 305 query67 15857 15798 15397 15397 query68 6841902 554 554 query69 554 301 280 280 query70 1147112810931093 query71 507 394 305 305 query72 5768479849444798 query73 1510727 360 360 query74 9245910489988998 query75 4171321427052705 query76 42301218763 763 query77 791 379 298 298 query78 10173 10180 93539353 query79 2423873 614 614 query80 629 523 444 444 query81 482 263 224 224 query82 426 131 107 107 query83 273 254 289 254 query84 298 102 83 83 query85 793 356 321 321 query86 373 319 288 288 query87 4398450643054305 query88 3701232423032303 query89 392 320 283 283 query90 1900215 216 215 query91 151 160 110 110 query92 79 66 56 56 query93 1736968 602 602 query94 667 430 290 290 query95 384 304 290 290 query96 504 579 289 289 query97 2712280026472647 query98 235 212 200 200 query99 1465141312581258 Total cold run time: 298519 ms Total hot run time: 192755 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2969798945 TPC-H: Total hot run time: 34519 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3c0d1eefd1478ce806e57d97a2b8f55606c20e18, data reload: false -- Round 1 -- q1 17588 520349764976 q2 1927282 173 173 q3 10314 1271742 742 q4 10216 996 514 514 q5 7566230623322306 q6 185 160 130 130 q7 910 734 621 621 q8 9326123210741074 q9 6771510251185102 q10 6869231718801880 q11 504 298 286 286 q12 341 347 214 214 q13 17771 364831073107 q14 226 241 211 211 q15 565 481 481 481 q16 445 436 371 371 q17 621 854 380 380 q18 7404716972217169 q19 1723951 589 589 q20 343 332 215 215 q21 3698314130193019 q22 1038978 959 959 Total cold run time: 106351 ms Total hot run time: 34519 ms - Round 2, with runtime_filter_mode=off - q1 5114505749774977 q2 238 315 235 235 q3 2171265122902290 q4 1328177413671367 q5 4250413942964139 q6 215 166 128 128 q7 2020192717531753 q8 2600249624952495 q9 7155712971767129 q10 3031318926742674 q11 577 518 514 514 q12 737 787 637 637 q13 3525393933553355 q14 283 301 279 279 q15 508 485 473 473 q16 449 500 450 450 q17 1204154113761376 q18 7644746174337433 q19 859 820 846 820 q20 1985206219011901 q21 5023439443724372 q22 1107106910271027 Total cold run time: 52023 ms Total hot run time: 49824 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2969682374 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2954759554 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2828121632 ClickBench: Total hot run time: 30.11 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 95aa8c1fb16cbacc6b8c287b80f60e2f16dad274, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.260.190.19 query4 1.640.190.10 query5 0.560.550.56 query6 1.170.720.71 query7 0.030.020.02 query8 0.040.030.03 query9 0.580.520.51 query10 0.570.560.58 query11 0.160.100.11 query12 0.140.120.11 query13 0.610.600.60 query14 1.201.191.18 query15 0.860.830.85 query16 0.400.380.39 query17 1.051.051.06 query18 0.210.200.19 query19 1.871.791.78 query20 0.020.010.01 query21 15.40 0.900.55 query22 0.761.170.77 query23 14.83 1.450.68 query24 6.811.341.22 query25 0.450.290.07 query26 0.590.160.14 query27 0.050.050.04 query28 9.320.850.45 query29 12.56 3.983.32 query30 0.250.090.06 query31 2.820.580.38 query32 3.250.550.47 query33 2.993.113.10 query34 15.89 5.134.50 query35 4.534.524.52 query36 0.690.490.48 query37 0.090.060.06 query38 0.060.040.04 query39 0.030.020.03 query40 0.170.130.13 query41 0.080.020.03 query42 0.030.020.03 query43 0.040.030.03 Total cold run time: 103.22 s Total hot run time: 30.11 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2828073124 TPC-H: Total hot run time: 33882 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 95aa8c1fb16cbacc6b8c287b80f60e2f16dad274, data reload: false -- Round 1 -- q1 26358 513650545054 q2 2075275 186 186 q3 10400 1268698 698 q4 10240 982 546 546 q5 7503242422992299 q6 185 163 133 133 q7 915 757 607 607 q8 9336124510461046 q9 6865514151005100 q10 6812231618941894 q11 504 299 260 260 q12 338 351 215 215 q13 17771 372930163016 q14 222 228 209 209 q15 540 494 478 478 q16 439 443 389 389 q17 573 870 347 347 q18 7615733372667266 q19 1214954 544 544 q20 328 322 227 227 q21 3868336724172417 q22 1070994 951 951 Total cold run time: 115171 ms Total hot run time: 33882 ms - Round 2, with runtime_filter_mode=off - q1 5144511750895089 q2 234 324 222 222 q3 2133266023022302 q4 1420185813911391 q5 4541447343754375 q6 217 169 125 125 q7 1916190917771777 q8 2585252324962496 q9 7260718072897180 q10 3023319127272727 q11 583 493 471 471 q12 671 752 609 609 q13 3602394332663266 q14 292 298 275 275 q15 515 487 475 475 q16 474 513 455 455 q17 1137151514021402 q18 7716762573007300 q19 772 829 852 829 q20 1976204818771877 q21 5099484446834683 q22 10961071982 982 Total cold run time: 52406 ms Total hot run time: 50308 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2828104651 TPC-DS: Total hot run time: 186003 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 95aa8c1fb16cbacc6b8c287b80f60e2f16dad274, data reload: false query1 1032477 501 477 query2 6565181218081808 query3 6746226 221 221 query4 26029 23485 23744 23485 query5 4361620 450 450 query6 297 196 198 196 query7 4616481 277 277 query8 271 229 233 229 query9 8621256425892564 query10 442 311 269 269 query11 15320 15018 14935 14935 query12 170 125 107 107 query13 1651493 373 373 query14 8791608561306085 query15 197 200 176 176 query16 7120663 497 497 query17 946 727 573 573 query18 1972409 304 304 query19 195 182 161 161 query20 117 116 118 116 query21 217 126 105 105 query22 4082415640974097 query23 33840 32868 33157 32868 query24 8522240323782378 query25 571 472 416 416 query26 1249274 154 154 query27 2742508 329 329 query28 4325210020882088 query29 783 578 448 448 query30 280 227 191 191 query31 950 854 769 769 query32 71 65 67 65 query33 546 349 327 327 query34 880 851 503 503 query35 753 816 730 730 query36 928 957 895 895 query37 108 103 76 76 query38 4144422740394039 query39 1446139314311393 query40 218 121 107 107 query41 59 62 52 52 query42 116 108 112 108 query43 477 499 490 490 query44 1273806 800 800 query45 187 176 167 167 query46 825 993 613 613 query47 1754181017091709 query48 374 419 286 286 query49 765 514 417 417 query50 618 666 402 402 query51 4072408140584058 query52 105 102 95 95 query53 218 243 185 185 query54 581 576 493 493 query55 82 79 76 76 query56 293 312 299 299 query57 1128117711121112 query58 260 253 250 250 query59 2656260524912491 query60 315 305 316 305 query61 128 127 126 126 query62 793 745 675 675 query63 221 183 188 183 query64 43961029703 703 query65 4367428942284228 query66 1150409 311 311 query67 15841 15514 15480 15480 query68 8883882 510 510 query69 474 296 258 258 query70 1182112810551055 query71 466 316 295 295 query72 5590481049424810 query73 744 647 344 344 query74 8840895588788878 query75 4170317726772677 query76 36341189747 747 query77 803 359 280 280 query78 10094 997792209220 query79 2942771 562 562 query80 610 499 454 454 query81 493 262 219 219 query82 485 126 106 106 query83 287 247 245 245 query84 292 110 82 82 query85 832 355 312 312 query86 393 304 297 297 query87 4442431643024302 query88 3524224222342234 query89 409 315 292 292 query90 1851214 219 214 query91 144 143 115 115 query92 76 59 58 58 query93 2618940 581 581 query94 664 403 304 304 query95 367 296 290 290 query96 478 566 324 324 query97 3141324730423042 query98 241 209 204 204 query99 1478141512971297 Total cold run time: 275815 ms Total hot run time: 186003 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2827992670 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823536267 ClickBench: Total hot run time: 29.61 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 0135f5254abe29637c308da5fb1d7fea9959ce7d, data reload: false query1 0.040.040.03 query2 0.130.110.10 query3 0.260.200.19 query4 1.590.180.18 query5 0.590.590.60 query6 1.190.710.72 query7 0.020.020.02 query8 0.040.050.04 query9 0.570.540.51 query10 0.560.580.56 query11 0.150.110.11 query12 0.140.110.11 query13 0.620.590.61 query14 1.171.151.17 query15 0.870.850.85 query16 0.380.380.36 query17 1.020.991.03 query18 0.210.190.18 query19 1.881.761.77 query20 0.010.000.01 query21 15.41 0.940.55 query22 0.761.260.76 query23 14.79 1.370.60 query24 6.981.400.72 query25 0.520.210.19 query26 0.580.170.15 query27 0.050.050.04 query28 9.910.900.45 query29 12.55 3.973.28 query30 0.260.090.08 query31 2.830.620.40 query32 3.240.550.47 query33 3.093.013.16 query34 15.90 5.134.54 query35 4.534.564.54 query36 0.680.500.48 query37 0.080.070.06 query38 0.050.050.04 query39 0.030.020.02 query40 0.160.130.12 query41 0.090.030.03 query42 0.040.020.03 query43 0.040.040.03 Total cold run time: 104.01 s Total hot run time: 29.61 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823522240 TPC-DS: Total hot run time: 185264 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 0135f5254abe29637c308da5fb1d7fea9959ce7d, data reload: false query1 1010471 486 471 query2 6566185518491849 query3 6747218 211 211 query4 26255 23831 22998 22998 query5 4719625 466 466 query6 308 208 212 208 query7 4622480 296 296 query8 304 252 231 231 query9 8675255925632559 query10 490 334 271 271 query11 15573 15433 14825 14825 query12 173 110 115 110 query13 1658525 385 385 query14 10001 636862036203 query15 213 186 171 171 query16 7656661 500 500 query17 1255730 585 585 query18 2021397 315 315 query19 189 191 157 157 query20 128 120 127 120 query21 249 120 105 105 query22 4096412540834083 query23 33930 32738 33177 32738 query24 8393236223682362 query25 535 447 397 397 query26 1239266 172 172 query27 2695488 324 324 query28 4314209820932093 query29 713 550 427 427 query30 279 212 182 182 query31 955 865 752 752 query32 72 66 65 65 query33 568 401 301 301 query34 788 875 503 503 query35 792 815 741 741 query36 959 996 856 856 query37 123 101 76 76 query38 4198414941134113 query39 1446139213901390 query40 218 122 106 106 query41 57 55 54 54 query42 113 105 102 102 query43 482 515 473 473 query44 1298803 782 782 query45 177 171 163 163 query46 820 1029615 615 query47 1749178917241724 query48 374 415 293 293 query49 786 512 406 406 query50 625 694 395 395 query51 4120415440954095 query52 105 106 94 94 query53 211 254 188 188 query54 562 566 492 492 query55 87 80 81 80 query56 298 298 279 279 query57 1125116610891089 query58 260 250 261 250 query59 2646264826892648 query60 343 320 304 304 query61 128 124 126 124 query62 843 731 686 686 query63 232 186 184 184 query64 4227998 650 650 query65 4316419742254197 query66 1097430 314 314 query67 15881 15494 15440 15440 query68 8167877 505 505 query69 489 301 262 262 query70 1214117610931093 query71 482 315 294 294 query72 5527470447914704 query73 709 612 341 341 query74 9032914787078707 query75 3985316727112711 query76 36921185748 748 query77 789 389 288 288 query78 10101 994992129212 query79 2955802 561 561 query80 615 500 472 472 query81 495 250 213 213 query82 492 127 97 97 query83 279 257 241 241 query84 294 102 83 83 query85 805 346 312 312 query86 387 297 288 288 query87 4386441143394339 query88 3699227622062206 query89 387 315 276 276 query90 1829216 222 216 query91 140 143 110 110 query92 80 64 56 56 query93 2140925 567 567 query94 694 384 316 316 query95 370 296 284 284 query96 489 557 270 270 query97 3185323731593159 query98 229 204 205 204 query99 1495141612911291 Total cold run time: 277719 ms Total hot run time: 185264 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823489551 TPC-H: Total hot run time: 33768 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 0135f5254abe29637c308da5fb1d7fea9959ce7d, data reload: false -- Round 1 -- q1 25896 508349914991 q2 2082289 189 189 q3 10381 1260676 676 q4 10225 1019526 526 q5 7556225923852259 q6 180 161 132 132 q7 891 760 606 606 q8 9309131611411141 q9 6711514650785078 q10 6820229018651865 q11 494 291 273 273 q12 351 352 218 218 q13 17772 365330683068 q14 234 233 204 204 q15 526 493 499 493 q16 452 456 402 402 q17 586 852 374 374 q18 7567710971447109 q19 1222951 560 560 q20 348 326 220 220 q21 4042266824302430 q22 10551008954 954 Total cold run time: 114700 ms Total hot run time: 33768 ms - Round 2, with runtime_filter_mode=off - q1 5102506250485048 q2 251 327 235 235 q3 2158264722892289 q4 1428182514091409 q5 4486444244724442 q6 221 176 128 128 q7 1969197217071707 q8 2564250225562502 q9 7098705471037054 q10 3023320827742774 q11 575 488 477 477 q12 665 752 646 646 q13 3514387133053305 q14 268 304 262 262 q15 548 491 477 477 q16 457 484 459 459 q17 1139156013671367 q18 7711759574127412 q19 771 891 1007891 q20 1989200818871887 q21 5261457947064579 q22 10931030994 994 Total cold run time: 52291 ms Total hot run time: 50344 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823421485 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823012274 ClickBench: Total hot run time: 29.76 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 8df76d9f0dd0c3353222f1d96b2c73636e47ecc1, data reload: false query1 0.040.040.03 query2 0.120.110.10 query3 0.260.200.19 query4 1.590.200.10 query5 0.560.550.53 query6 1.220.710.73 query7 0.030.020.02 query8 0.040.030.03 query9 0.570.540.51 query10 0.570.580.56 query11 0.150.110.10 query12 0.140.120.12 query13 0.610.600.60 query14 1.191.161.18 query15 0.880.840.86 query16 0.390.400.38 query17 1.041.031.02 query18 0.210.200.20 query19 1.901.791.80 query20 0.020.010.01 query21 15.39 0.890.54 query22 0.791.000.61 query23 15.14 1.360.61 query24 6.742.401.01 query25 0.490.210.21 query26 0.650.160.15 query27 0.050.040.05 query28 9.780.810.43 query29 12.52 4.003.32 query30 0.250.090.07 query31 2.810.590.38 query32 3.220.540.48 query33 3.073.033.05 query34 15.85 5.144.54 query35 4.564.584.55 query36 0.660.500.47 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.030.02 query40 0.160.140.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.98 s Total hot run time: 29.76 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2823007155 TPC-DS: Total hot run time: 185543 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 8df76d9f0dd0c3353222f1d96b2c73636e47ecc1, data reload: false query1 999 460 487 460 query2 6582176217681762 query3 6755220 217 217 query4 25961 23839 23583 23583 query5 4377623 482 482 query6 313 208 199 199 query7 4634490 287 287 query8 304 255 245 245 query9 8616257825802578 query10 486 319 279 279 query11 15881 15470 14783 14783 query12 179 111 114 111 query13 1672520 396 396 query14 10080 614361346134 query15 202 207 178 178 query16 7682638 494 494 query17 1208708 578 578 query18 2019411 298 298 query19 206 186 170 170 query20 123 119 119 119 query21 217 131 110 110 query22 4066412039823982 query23 34000 32969 33016 32969 query24 8381237823752375 query25 517 453 386 386 query26 1226281 150 150 query27 2726492 321 321 query28 4348210920812081 query29 715 569 429 429 query30 285 219 186 186 query31 935 836 733 733 query32 71 64 67 64 query33 555 393 325 325 query34 803 859 524 524 query35 830 836 749 749 query36 951 998 903 903 query37 106 99 78 78 query38 4173411541014101 query39 1449141113881388 query40 213 119 104 104 query41 56 56 53 53 query42 113 105 107 105 query43 499 505 475 475 query44 1289806 803 803 query45 176 175 162 162 query46 839 1019616 616 query47 1756182317241724 query48 365 436 304 304 query49 791 517 449 449 query50 665 697 401 401 query51 4118406441104064 query52 108 106 101 101 query53 224 250 178 178 query54 576 575 491 491 query55 81 78 81 78 query56 312 281 288 281 query57 1182114910791079 query58 265 247 252 247 query59 2571266324612461 query60 322 316 297 297 query61 129 131 131 131 query62 812 765 642 642 query63 224 179 183 179 query64 42971069676 676 query65 4323424842644248 query66 1057414 312 312 query67 15671 15475 15218 15218 query68 8581887 518 518 query69 462 325 265 265 query70 1218112111081108 query71 454 310 306 306 query72 5298463445704570 query73 675 554 345 345 query74 9180911786538653 query75 3904317927232723 query76 37191196743 743 query77 785 384 281 281 query78 997610089 93019301 query79 2266818 575 575 query80 595 511 449 449 query81 481 268 217 217 query82 439 127 165 127 query83 282 256 222 222 query84 295 103 84 84 query85 784 351 316 316 query86 334 319 292 292 query87 4407441642924292 query88 3424225522462246 query89 397 313 283 283 query90 1956212 222 212 query91 148 152 119 119 query92 71 64 59 59 query93 1588973 581 581 query94 678 419 286 286 query95 381 299 287 287 query96 501 571 286 286 query97 3177323531923192 query98 238 210 203 203 query99 1452141013161316 Total cold run time: 275813 ms Total hot run time: 185543 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822995230 TPC-H: Total hot run time: 34033 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 8df76d9f0dd0c3353222f1d96b2c73636e47ecc1, data reload: false -- Round 1 -- q1 26137 506650065006 q2 2075289 187 187 q3 10533 1256695 695 q4 10268 1023537 537 q5 8751235727352357 q6 185 165 131 131 q7 910 748 613 613 q8 9307128810751075 q9 6823510651205106 q10 6801230018851885 q11 469 272 267 267 q12 346 345 224 224 q13 17755 368431023102 q14 226 229 209 209 q15 529 487 474 474 q16 440 450 402 402 q17 582 856 353 353 q18 7682723272867232 q19 1553956 559 559 q20 339 325 223 223 q21 3885262224072407 q22 10701033989 989 Total cold run time: 11 ms Total hot run time: 34033 ms - Round 2, with runtime_filter_mode=off - q1 5112506550835065 q2 244 326 232 232 q3 2170261522752275 q4 1433178914671467 q5 4539441943324332 q6 207 182 122 122 q7 1935193817201720 q8 2561247525042475 q9 7179722372257223 q10 3015318528762876 q11 563 519 508 508 q12 697 768 592 592 q13 3572391032943294 q14 274 310 268 268 q15 530 480 488 480 q16 471 513 465 465 q17 1147152413821382 q18 7673745373637363 q19 778 740 1024740 q20 1932194218431843 q21 5052474546174617 q22 1060103610531036 Total cold run time: 52144 ms Total hot run time: 50375 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822977437 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822973877 ClickBench: Total hot run time: 29.86 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 0a64b1b2d17d74e10066e9cb8658126f7c634e39, data reload: false query1 0.040.040.03 query2 0.130.110.11 query3 0.260.200.19 query4 1.590.200.20 query5 0.600.610.61 query6 1.180.720.72 query7 0.020.020.02 query8 0.040.040.03 query9 0.580.510.50 query10 0.580.570.57 query11 0.150.110.11 query12 0.150.110.12 query13 0.620.600.60 query14 1.161.181.16 query15 0.870.860.84 query16 0.390.390.37 query17 0.991.011.05 query18 0.220.200.19 query19 1.901.751.78 query20 0.020.010.01 query21 15.40 0.940.55 query22 0.751.200.89 query23 14.73 1.390.63 query24 6.951.750.91 query25 0.470.220.14 query26 0.610.160.14 query27 0.050.050.05 query28 9.250.810.44 query29 12.55 3.983.31 query30 0.250.090.06 query31 2.820.580.39 query32 3.240.540.46 query33 3.082.993.02 query34 15.84 5.134.50 query35 4.514.524.48 query36 0.650.490.47 query37 0.080.060.06 query38 0.050.040.04 query39 0.030.020.02 query40 0.160.130.13 query41 0.080.020.02 query42 0.030.020.03 query43 0.040.030.03 Total cold run time: 103.11 s Total hot run time: 29.86 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822968905 TPC-DS: Total hot run time: 192242 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 0a64b1b2d17d74e10066e9cb8658126f7c634e39, data reload: false query1 1403110810971097 query2 6291179817991798 query3 11029 465245834583 query4 53789 25811 22973 22973 query5 4997530 446 446 query6 333 197 201 197 query7 4901513 304 304 query8 327 253 241 241 query9 5687260325932593 query10 437 320 263 263 query11 15101 15105 14883 14883 query12 160 111 104 104 query13 1039508 418 418 query14 10195 634863586348 query15 227 205 177 177 query16 7093683 481 481 query17 1106776 593 593 query18 1561427 331 331 query19 210 188 169 169 query20 127 126 128 126 query21 214 125 106 106 query22 4391439243834383 query23 34084 33366 33564 33366 query24 6672241024202410 query25 468 476 412 412 query26 701 277 169 169 query27 2372500 338 338 query28 3133213021162116 query29 595 544 428 428 query30 266 219 195 195 query31 865 854 775 775 query32 90 65 63 63 query33 451 368 315 315 query34 773 887 527 527 query35 800 846 753 753 query36 914 1002890 890 query37 118 95 76 76 query38 4199421241634163 query39 1500143414241424 query40 216 124 106 106 query41 53 53 49 49 query42 120 117 112 112 query43 485 509 468 468 query44 1337845 848 845 query45 182 177 167 167 query46 856 1021651 651 query47 1881186818221822 query48 376 410 317 317 query49 702 536 427 427 query50 657 704 398 398 query51 4176424341864186 query52 120 107 96 96 query53 234 270 189 189 query54 580 581 519 519 query55 85 82 80 80 query56 299 303 300 300 query57 1143117911071107 query58 256 262 259 259 query59 2683267926592659 query60 327 314 313 313 query61 134 174 124 124 query62 736 739 668 668 query63 219 189 183 183 query64 20241048679 679 query65 4505429542534253 query66 741 411 302 302 query67 15720 15430 15226 15226 query68 7155863 512 512 query69 518 299 269 269 query70 1145110010531053 query71 507 307 293 293 query72 5917485548294829 query73 1443638 353 353 query74 8934917789118911 query75 3980319027082708 query76 41451186740 740 query77 679 374 276 276 query78 10028 10087 92519251 query79 2378809 560 560 query80 616 502 507 502 query81 473 261 214 214 query82 421 122 92 92 query83 320 249 231 231 query84 289 110 85 85 query85 777 360 315 315 query86 346 318 289 289 query87 4376445142824282 query88 3229223522112211 query89 394 307 283 283 query90 1906217 212 212 query91 156 147 111 111 query92 74 59 58 58 query93 1244936 584 584 query94 669 419 311 311 query95 369 290 279 279 query96 483 573 277 277 query97 3135324831323132 query98 230 202 194 194 query99 1445137312861286 Total cold run time: 297247 ms Total hot run time: 192242 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822956956 TPC-H: Total hot run time: 33851 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 0a64b1b2d17d74e10066e9cb8658126f7c634e39, data reload: false -- Round 1 -- q1 26463 507149994999 q2 2078279 194 194 q3 10492 1298692 692 q4 10241 995 529 529 q5 7838245623092309 q6 188 162 133 133 q7 897 724 620 620 q8 9308130610441044 q9 6924509851555098 q10 6847230918901890 q11 471 290 266 266 q12 350 359 220 220 q13 17797 365930953095 q14 243 231 213 213 q15 542 490 498 490 q16 440 452 403 403 q17 590 858 355 355 q18 7918718171537153 q19 1636976 547 547 q20 316 338 215 215 q21 3848335923922392 q22 10351023994 994 Total cold run time: 116462 ms Total hot run time: 33851 ms - Round 2, with runtime_filter_mode=off - q1 5187508050615061 q2 247 326 233 233 q3 2146268123082308 q4 1401195914681468 q5 4461442143954395 q6 216 172 127 127 q7 1983192517661766 q8 2597266025662566 q9 7323706670657065 q10 2998321227202720 q11 586 511 495 495 q12 684 789 600 600 q13 3527387433863386 q14 277 287 285 285 q15 521 475 477 475 q16 461 515 477 477 q17 1148161513751375 q18 7792765274767476 q19 795 767 840 767 q20 1997198218381838 q21 5268489047314731 q22 1062996 996 Total cold run time: 52726 ms Total hot run time: 50610 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2822838638 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-282036 ClickBench: Total hot run time: 29.95 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 79d643c49ecf1b1b4b32cfcba0375511f66df0ab, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.240.200.20 query4 1.600.200.20 query5 0.590.580.59 query6 1.210.730.74 query7 0.020.020.01 query8 0.050.030.03 query9 0.560.520.52 query10 0.560.570.55 query11 0.160.120.12 query12 0.140.110.11 query13 0.610.610.60 query14 1.161.171.17 query15 0.860.840.85 query16 0.370.390.39 query17 1.021.071.02 query18 0.210.200.19 query19 1.911.811.81 query20 0.010.010.01 query21 15.42 0.920.54 query22 0.741.220.69 query23 14.95 1.380.65 query24 7.091.361.09 query25 0.500.180.14 query26 0.600.150.12 query27 0.050.060.05 query28 9.910.900.45 query29 12.57 3.983.32 query30 0.250.100.07 query31 2.840.590.39 query32 3.220.550.48 query33 3.113.082.99 query34 15.82 5.104.48 query35 4.534.514.48 query36 0.670.500.49 query37 0.080.060.06 query38 0.050.030.04 query39 0.040.020.03 query40 0.160.130.13 query41 0.070.030.02 query42 0.030.030.02 query43 0.040.020.02 Total cold run time: 104.18 s Total hot run time: 29.95 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2820342165 TPC-DS: Total hot run time: 185160 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 79d643c49ecf1b1b4b32cfcba0375511f66df0ab, data reload: false query1 1021468 507 468 query2 6550178717581758 query3 6746222 212 212 query4 26340 23631 22953 22953 query5 4387634 470 470 query6 320 216 191 191 query7 4619489 286 286 query8 285 229 230 229 query9 8607252625572526 query10 472 322 274 274 query11 15936 15127 15059 15059 query12 160 112 112 112 query13 1671525 403 403 query14 9327604261286042 query15 204 195 169 169 query16 7219628 458 458 query17 1200749 586 586 query18 1973396 304 304 query19 192 186 164 164 query20 134 123 119 119 query21 214 128 106 106 query22 4123420339643964 query23 33826 33100 32895 32895 query24 8548237823982378 query25 560 484 459 459 query26 1229265 154 154 query27 2751489 331 331 query28 4383208920812081 query29 769 540 435 435 query30 284 209 186 186 query31 931 859 742 742 query32 75 64 66 64 query33 551 376 381 376 query34 801 838 520 520 query35 813 833 734 734 query36 956 988 901 901 query37 118 103 81 81 query38 4131412940904090 query39 1436141513891389 query40 213 119 106 106 query41 60 63 51 51 query42 121 108 102 102 query43 500 506 470 470 query44 1272788 778 778 query45 180 168 165 165 query46 834 1009629 629 query47 1784178917211721 query48 372 420 293 293 query49 783 513 418 418 query50 626 675 400 400 query51 4122404639913991 query52 110 108 101 101 query53 220 260 183 183 query54 574 570 512 512 query55 81 80 80 80 query56 303 300 290 290 query57 1135115210691069 query58 287 259 258 258 query59 2633265626272627 query60 322 318 307 307 query61 130 129 126 126 query62 799 726 667 667 query63 232 182 185 182 query64 4418995 727 727 query65 4312424242174217 query66 1128408 319 319 query67 15922 15692 15376 15376 query68 8557879 523 523 query69 474 306 268 268 query70 1153110210521052 query71 472 314 289 289 query72 5323474346674667 query73 709 583 339 339 query74 8831914287038703 query75 4097315727292729 query76 37601175743 743 query77 794 379 280 280 query78 10021 10148 92389238 query79 2106805 574 574 query80 572 522 508 508 query81 481 262 221 221 query82 452 123 106 106 query83 249 251 236 236 query84 246 117 90 90 query85 782 366 314 314 query86 388 289 284 284 query87 4395448442754275 query88 3532220922102209 query89 386 318 278 278 query90 1847213 208 208 query91 139 143 114 114 query92 78 62 58 58 query93 1618946 583 583 query94 665 409 303 303 query95 380 289 284 284 query96 472 565 282 282 query97 3172323631103110 query98 241 217 203 203 query99 1550142212551255 Total cold run time: 275277 ms Total hot run time: 185160 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 mysqlLoadCommand in nereids [doris]
doris-robot commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2820298210 TPC-H: Total hot run time: 33931 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 79d643c49ecf1b1b4b32cfcba0375511f66df0ab, data reload: false -- Round 1 -- q1 26195 501450195014 q2 2072276 185 185 q3 10399 1256700 700 q4 10232 992 530 530 q5 7515240523932393 q6 195 161 131 131 q7 908 756 614 614 q8 9307130510521052 q9 6784502650265026 q10 6827232218841884 q11 476 279 261 261 q12 334 356 210 210 q13 17761 367031323132 q14 228 217 220 217 q15 534 482 504 482 q16 452 443 399 399 q17 581 870 344 344 q18 7593718472177184 q19 1204973 529 529 q20 343 349 225 225 q21 3963270024402440 q22 10521029979 979 Total cold run time: 114955 ms Total hot run time: 33931 ms - Round 2, with runtime_filter_mode=off - q1 5130513750985098 q2 236 326 233 233 q3 2150264122822282 q4 1426184514331433 q5 4477443644214421 q6 214 160 124 124 q7 1933194317351735 q8 2645255825102510 q9 7055711371147113 q10 3021319727142714 q11 634 496 483 483 q12 694 763 598 598 q13 3459397533123312 q14 277 299 279 279 q15 521 475 475 475 q16 446 508 450 450 q17 1153159613891389 q18 7846760874057405 q19 800 798 822 798 q20 1983204519211921 q21 5362463446614634 q22 10791026977 977 Total cold run time: 52541 ms Total hot run time: 50384 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2820230501 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 mysqlLoadCommand in nereids [doris]
yx-keith commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2820142959 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 mysqlLoadCommand in nereids [doris]
hello-stephen commented on PR #49109: URL: https://github.com/apache/doris/pull/49109#issuecomment-2726696518 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]
