You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gavinchou (via GitHub)" <gi...@apache.org> on 2024/06/09 18:44:27 UTC
[PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
gavinchou opened a new pull request, #36080:
URL: https://github.com/apache/doris/pull/36080
The properties rewrite policy is not applied for CreateTableStmt and CreateMTMVStmt because the `analyze()` of CreateTableStmt is not called when executed by nereids.
There are some properties, e.g. replication_num, are not correctly processed in cloud mode, which will cause the following error
```
2024-06-09 02:30:42,602 WARN (mtmv-task-execute-1-thread-1|139) [OlapInsertExecutor.onFail():218] insert [label_87cd2cb386774f4a_a14a00e9c7d93a51] with query id 87cd2cb386774f4a-a14a00e9c7d93a51 failed
org.apache.doris.nereids.exceptions.AnalysisException: errCode = 3, detailMessage = tablet 469525 alive replica num 1 < load required replica num 2, alive backends: [10002], detail: Visible Replicas:Visible version: 1, Replicas: [replicaId=469526, backendId=-1, backend=null, version=1, state=NORMAL]. or you may not have permission to access the current cluster = gavin_cluster_name0
at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:152) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:200) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.runInternal(InsertIntoTableCommand.java:219) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.run(InsertIntoTableCommand.java:103) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.runInsertCommand(InsertOverwriteTableCommand.java:185) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.insertInto(InsertOverwriteTableCommand.java:235) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.run(InsertOverwriteTableCommand.java:164) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.extensions.mtmv.MTMVTask.exec(MTMVTask.java:235) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.extensions.mtmv.MTMVTask.run(MTMVTask.java:200) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.task.AbstractTask.runTask(AbstractTask.java:167) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.extensions.mtmv.MTMVTask.runTask(MTMVTask.java:310) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.executor.DefaultTaskExecutorHandler.onEvent(DefaultTaskExecutorHandler.java:50) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.job.executor.DefaultTaskExecutorHandler.onEvent(DefaultTaskExecutorHandler.java:33) ~[doris-fe.jar:1.2-SNAPSHOT]
at com.lmax.disruptor.WorkProcessor.run(WorkProcessor.java:143) ~[disruptor-3.4.4.jar:?]
at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: org.apache.doris.common.UserException: errCode = 3, detailMessage = tablet 469525 alive replica num 1 < load required replica num 2, alive backends: [10002], detail: Visible Replicas:Visible version: 1, Replicas: [replicaId=469526, backendId=-1, backend=null, version=1, state=NORMAL]. or you may not have permission to access the current cluster = gavin_cluster_name0
at org.apache.doris.planner.OlapTableSink.createLocation(OlapTableSink.java:642) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OlapTableSink.complete(OlapTableSink.java:226) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:126) ~[doris-fe.jar:1.2-SNAPSHOT]
... 14 more
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159012228
<details>
<summary>ClickBench: <b>Total hot run time: 30.01 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.03
query3 0.22 0.06 0.06
query4 1.65 0.09 0.08
query5 0.50 0.49 0.49
query6 1.14 0.73 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.54 0.51 0.49
query10 0.55 0.56 0.54
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.57 0.59
query14 0.77 0.79 0.78
query15 0.84 0.81 0.82
query16 0.35 0.34 0.37
query17 0.95 0.96 1.00
query18 0.23 0.25 0.22
query19 1.78 1.69 1.72
query20 0.02 0.01 0.01
query21 15.41 0.67 0.65
query22 4.90 7.46 1.47
query23 18.31 1.30 1.27
query24 2.16 0.22 0.22
query25 0.15 0.07 0.08
query26 0.28 0.18 0.18
query27 0.08 0.08 0.08
query28 13.21 1.02 0.99
query29 12.65 3.31 3.25
query30 0.26 0.06 0.06
query31 2.86 0.39 0.38
query32 3.30 0.47 0.46
query33 2.85 2.84 2.94
query34 17.01 4.44 4.41
query35 4.51 4.52 4.56
query36 0.65 0.46 0.48
query37 0.18 0.15 0.15
query38 0.15 0.14 0.14
query39 0.04 0.03 0.04
query40 0.17 0.14 0.14
query41 0.10 0.05 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 109.96 s
Total hot run time: 30.01 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159710071
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2158979210
<details>
<summary>TPC-H: <b>Total hot run time: 39850 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
------ Round 1 ----------------------------------
q1 17655 4340 4252 4252
q2 2028 198 210 198
q3 10427 1177 1116 1116
q4 10184 814 793 793
q5 7452 2661 2670 2661
q6 220 136 137 136
q7 951 607 599 599
q8 9223 2058 2076 2058
q9 8938 6500 6465 6465
q10 8943 3742 3692 3692
q11 445 238 241 238
q12 440 233 231 231
q13 17761 2970 2967 2967
q14 268 218 221 218
q15 529 480 486 480
q16 525 385 377 377
q17 959 668 790 668
q18 7941 7382 7445 7382
q19 6210 1468 1568 1468
q20 654 316 313 313
q21 4839 3196 4051 3196
q22 406 342 346 342
Total cold run time: 116998 ms
Total hot run time: 39850 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4455 4260 4243 4243
q2 375 273 267 267
q3 2931 2898 2911 2898
q4 1974 1651 1730 1651
q5 5631 5500 5444 5444
q6 220 133 136 133
q7 2296 1858 1886 1858
q8 3336 3462 3423 3423
q9 8784 8893 8893 8893
q10 4249 3783 3851 3783
q11 617 491 502 491
q12 832 685 607 607
q13 15990 3271 3204 3204
q14 322 293 281 281
q15 548 487 485 485
q16 521 440 440 440
q17 1824 1562 1507 1507
q18 8114 8071 8201 8071
q19 1844 1687 1649 1649
q20 3302 1939 1948 1939
q21 5296 5235 4970 4970
q22 692 599 582 582
Total cold run time: 74153 ms
Total hot run time: 56819 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2164233538
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156734536
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159750860
<details>
<summary>TPC-DS: <b>Total hot run time: 173493 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
query1 813 383 377 377
query2 6405 2504 2515 2504
query3 6400 206 208 206
query4 20073 17510 17236 17236
query5 3891 472 452 452
query6 244 163 177 163
query7 4462 297 290 290
query8 321 286 287 286
query9 8282 2399 2378 2378
query10 569 329 285 285
query11 10634 10062 10004 10004
query12 142 89 85 85
query13 1572 366 358 358
query14 9774 7169 7598 7169
query15 242 210 182 182
query16 7727 265 261 261
query17 1670 547 508 508
query18 1880 275 277 275
query19 189 150 152 150
query20 88 83 83 83
query21 209 125 120 120
query22 4307 4148 4020 4020
query23 33635 33606 33360 33360
query24 11055 2782 2776 2776
query25 610 354 347 347
query26 1382 154 150 150
query27 2926 316 315 315
query28 7461 2061 2053 2053
query29 934 620 602 602
query30 245 151 152 151
query31 931 739 737 737
query32 94 57 56 56
query33 768 297 297 297
query34 866 486 471 471
query35 738 657 622 622
query36 1089 953 949 949
query37 151 73 73 73
query38 2843 2718 2735 2718
query39 861 794 804 794
query40 217 133 133 133
query41 58 55 56 55
query42 126 102 100 100
query43 612 565 552 552
query44 1200 745 729 729
query45 200 166 162 162
query46 1084 787 702 702
query47 1854 1776 1776 1776
query48 386 295 293 293
query49 868 417 402 402
query50 767 395 379 379
query51 6817 6669 6655 6655
query52 100 102 92 92
query53 360 296 298 296
query54 834 456 446 446
query55 76 74 82 74
query56 280 258 267 258
query57 1171 1018 1089 1018
query58 267 312 268 268
query59 3581 3445 3136 3136
query60 299 275 277 275
query61 89 89 91 89
query62 633 440 443 440
query63 320 290 293 290
query64 8815 2226 1751 1751
query65 3187 3151 3092 3092
query66 1325 323 327 323
query67 15427 14946 14966 14946
query68 4506 538 542 538
query69 608 452 421 421
query70 1146 1120 1142 1120
query71 421 273 286 273
query72 7253 5613 5529 5529
query73 775 320 318 318
query74 5800 5482 5508 5482
query75 3307 2656 2664 2656
query76 2247 885 896 885
query77 480 296 302 296
query78 10189 9846 9723 9723
query79 2421 518 529 518
query80 1695 483 460 460
query81 575 223 225 223
query82 948 110 103 103
query83 279 169 168 168
query84 247 93 96 93
query85 1476 274 269 269
query86 481 316 347 316
query87 3237 3081 3078 3078
query88 4277 2355 2363 2355
query89 471 374 382 374
query90 1835 191 193 191
query91 142 110 109 109
query92 68 52 54 52
query93 1686 503 495 495
query94 1252 198 198 198
query95 414 326 326 326
query96 586 275 267 267
query97 3205 3034 3126 3034
query98 228 203 195 195
query99 1075 845 833 833
Total cold run time: 270766 ms
Total hot run time: 173493 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159002694
<details>
<summary>TPC-DS: <b>Total hot run time: 174837 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
query1 930 383 378 378
query2 6447 2412 2399 2399
query3 6633 205 205 205
query4 19816 17369 17281 17281
query5 3720 481 464 464
query6 240 158 155 155
query7 4585 302 293 293
query8 312 287 299 287
query9 8598 2399 2365 2365
query10 557 293 281 281
query11 10396 10047 10058 10047
query12 126 88 83 83
query13 1634 362 351 351
query14 10076 7819 7948 7819
query15 297 206 188 188
query16 8083 258 259 258
query17 1917 528 517 517
query18 2062 298 265 265
query19 286 152 154 152
query20 91 85 81 81
query21 213 124 130 124
query22 4633 4009 4212 4009
query23 33889 33822 33729 33729
query24 10851 2840 2819 2819
query25 596 387 378 378
query26 721 162 164 162
query27 2192 331 322 322
query28 6475 2108 2098 2098
query29 887 618 628 618
query30 251 152 153 152
query31 939 757 750 750
query32 102 56 56 56
query33 764 287 299 287
query34 1093 493 471 471
query35 791 669 659 659
query36 1141 987 966 966
query37 150 72 75 72
query38 2952 2825 2794 2794
query39 925 823 820 820
query40 208 133 133 133
query41 57 53 51 51
query42 123 96 103 96
query43 613 561 562 561
query44 1189 730 730 730
query45 205 171 165 165
query46 1068 713 721 713
query47 1845 1801 1767 1767
query48 366 286 297 286
query49 843 410 407 407
query50 770 390 404 390
query51 6791 6708 6712 6708
query52 100 91 91 91
query53 357 294 285 285
query54 937 453 443 443
query55 75 75 73 73
query56 280 252 272 252
query57 1120 1018 1044 1018
query58 252 244 255 244
query59 3356 3271 3164 3164
query60 295 281 295 281
query61 113 111 106 106
query62 620 439 444 439
query63 326 304 303 303
query64 8760 2339 1831 1831
query65 3345 3142 3110 3110
query66 723 333 333 333
query67 15488 14955 14897 14897
query68 4625 540 548 540
query69 595 460 425 425
query70 1126 1149 1062 1062
query71 426 283 274 274
query72 8377 5925 5473 5473
query73 753 319 322 319
query74 5842 5509 5521 5509
query75 3496 2693 2657 2657
query76 2706 967 899 899
query77 680 308 307 307
query78 10537 9768 9770 9768
query79 2986 522 515 515
query80 1558 470 465 465
query81 553 227 226 226
query82 981 107 111 107
query83 348 171 168 168
query84 269 90 86 86
query85 2029 288 276 276
query86 473 321 305 305
query87 3294 3097 3107 3097
query88 4229 2342 2331 2331
query89 488 378 379 378
query90 1880 192 185 185
query91 129 100 97 97
query92 62 49 51 49
query93 4775 509 503 503
query94 1243 187 180 180
query95 409 319 316 316
query96 604 280 271 271
query97 3190 2983 2986 2983
query98 212 195 198 195
query99 1281 839 848 839
Total cold run time: 276752 ms
Total hot run time: 174837 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2163484607
<details>
<summary>TPC-H: <b>Total hot run time: 40326 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
------ Round 1 ----------------------------------
q1 17606 4308 4272 4272
q2 2023 189 191 189
q3 10467 1164 1144 1144
q4 10182 727 798 727
q5 7493 2671 2647 2647
q6 217 134 133 133
q7 958 608 591 591
q8 9211 2065 2044 2044
q9 8846 6509 6447 6447
q10 9006 3747 3700 3700
q11 458 245 244 244
q12 502 241 233 233
q13 17770 2976 2966 2966
q14 264 225 222 222
q15 522 475 473 473
q16 515 373 367 367
q17 957 702 661 661
q18 7905 7508 7360 7360
q19 6116 1543 1457 1457
q20 659 318 335 318
q21 4916 3799 3907 3799
q22 397 336 332 332
Total cold run time: 116990 ms
Total hot run time: 40326 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4372 4220 4222 4220
q2 366 268 268 268
q3 2972 2923 2868 2868
q4 2013 1703 1762 1703
q5 5538 5502 5421 5421
q6 217 134 128 128
q7 2154 1892 1820 1820
q8 3292 3406 3409 3406
q9 8701 8701 8783 8701
q10 4079 3765 3770 3765
q11 624 494 503 494
q12 809 648 638 638
q13 17113 3152 3136 3136
q14 295 295 292 292
q15 537 486 462 462
q16 493 439 447 439
q17 1793 1506 1493 1493
q18 8057 7840 7684 7684
q19 1799 1652 1577 1577
q20 2159 1889 1835 1835
q21 5078 4909 4854 4854
q22 624 534 569 534
Total cold run time: 73085 ms
Total hot run time: 55738 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159741586
<details>
<summary>TPC-H: <b>Total hot run time: 41087 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
------ Round 1 ----------------------------------
q1 17601 4343 4332 4332
q2 2040 200 201 200
q3 10438 1093 1121 1093
q4 10196 784 718 718
q5 7490 2716 2617 2617
q6 223 143 139 139
q7 951 610 621 610
q8 9252 2067 2087 2067
q9 8814 6489 6458 6458
q10 8993 3805 3703 3703
q11 461 240 239 239
q12 455 239 231 231
q13 17766 3043 2990 2990
q14 257 218 223 218
q15 544 494 498 494
q16 531 393 380 380
q17 972 727 630 630
q18 8539 8075 7952 7952
q19 7717 1467 1381 1381
q20 704 327 328 327
q21 5261 3956 4062 3956
q22 429 352 365 352
Total cold run time: 119634 ms
Total hot run time: 41087 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4599 4482 4432 4432
q2 365 263 271 263
q3 3128 2888 2906 2888
q4 1965 1670 1722 1670
q5 5538 5594 5556 5556
q6 227 133 128 128
q7 2193 1869 1857 1857
q8 3301 3417 3439 3417
q9 8754 8769 8751 8751
q10 4092 3856 3826 3826
q11 600 496 502 496
q12 862 668 620 620
q13 17177 3044 3186 3044
q14 339 276 271 271
q15 525 483 501 483
q16 486 449 424 424
q17 1791 1522 1485 1485
q18 8035 7833 7775 7775
q19 1753 1745 1612 1612
q20 2111 1865 1874 1865
q21 5127 4984 4888 4888
q22 663 561 593 561
Total cold run time: 73631 ms
Total hot run time: 56312 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2167191121
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156995327
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156751905
<details>
<summary>TPC-DS: <b>Total hot run time: 170914 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
query1 923 375 382 375
query2 6448 2408 2391 2391
query3 6635 205 206 205
query4 18798 17029 17242 17029
query5 3574 466 482 466
query6 241 161 158 158
query7 4580 303 297 297
query8 315 283 273 273
query9 8389 2378 2369 2369
query10 572 300 287 287
query11 10387 10063 9859 9859
query12 122 86 84 84
query13 1653 358 364 358
query14 10377 7777 7726 7726
query15 270 184 192 184
query16 8025 279 265 265
query17 1891 563 543 543
query18 2104 280 280 280
query19 202 157 154 154
query20 91 83 86 83
query21 210 132 130 130
query22 4288 4146 3934 3934
query23 33902 33703 33655 33655
query24 10858 2858 2906 2858
query25 599 444 348 348
query26 713 150 157 150
query27 2262 327 329 327
query28 6082 2134 2104 2104
query29 863 611 605 605
query30 253 158 158 158
query31 982 769 753 753
query32 99 52 54 52
query33 685 278 274 274
query34 871 476 485 476
query35 745 637 644 637
query36 1118 973 983 973
query37 141 72 71 71
query38 2949 2809 2832 2809
query39 901 841 843 841
query40 230 129 124 124
query41 59 51 50 50
query42 106 101 101 101
query43 617 562 543 543
query44 1087 730 719 719
query45 203 164 174 164
query46 1080 736 716 716
query47 1844 1785 1792 1785
query48 360 293 288 288
query49 823 395 408 395
query50 772 391 395 391
query51 6777 6741 6655 6655
query52 107 90 93 90
query53 352 297 294 294
query54 861 453 451 451
query55 76 77 75 75
query56 273 253 252 252
query57 1111 1070 1013 1013
query58 261 250 239 239
query59 3525 3259 3116 3116
query60 292 289 279 279
query61 89 87 88 87
query62 599 442 443 442
query63 318 298 289 289
query64 8537 2245 1712 1712
query65 3312 3055 3162 3055
query66 746 321 375 321
query67 16378 14902 14836 14836
query68 8445 542 544 542
query69 623 454 387 387
query70 1175 1046 1062 1046
query71 483 283 272 272
query72 7403 5290 2733 2733
query73 1238 320 325 320
query74 5816 5556 5435 5435
query75 4254 2652 2688 2652
query76 4290 999 952 952
query77 679 295 306 295
query78 10298 9801 9777 9777
query79 1921 508 529 508
query80 2048 471 473 471
query81 573 216 222 216
query82 269 102 104 102
query83 251 164 176 164
query84 278 83 83 83
query85 829 278 258 258
query86 348 327 312 312
query87 3297 3151 3040 3040
query88 3878 2338 2318 2318
query89 491 390 399 390
query90 1843 190 192 190
query91 174 98 99 98
query92 60 49 50 49
query93 3811 504 499 499
query94 1201 193 187 187
query95 398 317 311 311
query96 596 259 258 258
query97 3190 3079 3002 3002
query98 212 200 188 188
query99 1312 842 836 836
Total cold run time: 276597 ms
Total hot run time: 170914 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156754076
<details>
<summary>ClickBench: <b>Total hot run time: 30.4 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.03 0.04
query3 0.23 0.06 0.06
query4 1.66 0.09 0.10
query5 0.50 0.48 0.50
query6 1.13 0.73 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.50 0.48
query10 0.54 0.54 0.53
query11 0.14 0.12 0.12
query12 0.15 0.12 0.12
query13 0.59 0.60 0.60
query14 0.78 0.79 0.77
query15 0.83 0.81 0.83
query16 0.34 0.37 0.40
query17 1.01 0.99 0.96
query18 0.22 0.24 0.27
query19 1.78 1.72 1.72
query20 0.02 0.01 0.01
query21 15.40 0.66 0.65
query22 4.63 7.40 1.73
query23 18.30 1.39 1.26
query24 2.15 0.21 0.21
query25 0.16 0.08 0.10
query26 0.26 0.17 0.17
query27 0.08 0.09 0.07
query28 13.31 1.01 0.99
query29 12.59 3.36 3.33
query30 0.26 0.07 0.05
query31 2.86 0.38 0.39
query32 3.27 0.49 0.47
query33 2.89 2.87 2.88
query34 17.09 4.41 4.42
query35 4.40 4.51 4.50
query36 0.65 0.47 0.45
query37 0.18 0.15 0.15
query38 0.14 0.14 0.15
query39 0.04 0.03 0.03
query40 0.18 0.14 0.15
query41 0.10 0.05 0.05
query42 0.05 0.04 0.04
query43 0.04 0.03 0.04
Total cold run time: 109.69 s
Total hot run time: 30.4 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156748197
<details>
<summary>TPC-H: <b>Total hot run time: 39734 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
------ Round 1 ----------------------------------
q1 17629 4318 4254 4254
q2 2026 199 191 191
q3 10459 1188 1104 1104
q4 10182 823 787 787
q5 7439 2697 2630 2630
q6 221 138 134 134
q7 958 611 602 602
q8 9217 2062 2094 2062
q9 8970 6491 6454 6454
q10 8972 3709 3712 3709
q11 448 229 236 229
q12 419 231 225 225
q13 18833 3002 3002 3002
q14 263 220 221 220
q15 519 483 474 474
q16 493 389 372 372
q17 960 659 702 659
q18 7997 7438 7300 7300
q19 4392 1478 1526 1478
q20 647 312 317 312
q21 4948 3208 3982 3208
q22 395 328 337 328
Total cold run time: 116387 ms
Total hot run time: 39734 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4312 4224 4220 4220
q2 363 257 256 256
q3 2951 2852 2925 2852
q4 1990 1707 1649 1649
q5 5635 5509 5453 5453
q6 227 133 132 132
q7 2168 1871 1859 1859
q8 3255 3421 3510 3421
q9 8673 8701 8795 8701
q10 4147 3783 3725 3725
q11 583 487 487 487
q12 842 639 633 633
q13 16064 3202 3137 3137
q14 302 271 286 271
q15 548 474 476 474
q16 499 441 433 433
q17 1808 1504 1485 1485
q18 8090 7951 7729 7729
q19 2167 1594 1689 1594
q20 2078 1885 1863 1863
q21 5238 4956 4774 4774
q22 623 576 559 559
Total cold run time: 72563 ms
Total hot run time: 55707 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156734559
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156995350
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2163503349
<details>
<summary>TPC-DS: <b>Total hot run time: 173498 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
query1 935 391 364 364
query2 6583 2365 2451 2365
query3 6643 205 205 205
query4 19910 17072 17284 17072
query5 3604 460 461 460
query6 245 168 160 160
query7 4581 295 297 295
query8 314 298 305 298
query9 8391 2461 2440 2440
query10 547 283 303 283
query11 10450 9976 10027 9976
query12 127 91 87 87
query13 1652 379 364 364
query14 10195 7590 7698 7590
query15 237 188 190 188
query16 7780 268 263 263
query17 1911 533 513 513
query18 1841 277 279 277
query19 192 150 146 146
query20 86 81 82 81
query21 212 126 122 122
query22 4342 4025 3960 3960
query23 33808 33472 33435 33435
query24 10900 2871 2849 2849
query25 586 388 368 368
query26 704 157 157 157
query27 2286 326 350 326
query28 6004 2144 2162 2144
query29 886 654 648 648
query30 257 154 157 154
query31 994 751 783 751
query32 92 51 58 51
query33 696 290 312 290
query34 897 493 477 477
query35 754 645 634 634
query36 1143 949 987 949
query37 145 71 74 71
query38 2886 2819 2824 2819
query39 892 857 825 825
query40 223 130 122 122
query41 63 51 51 51
query42 110 105 107 105
query43 622 558 570 558
query44 1114 735 740 735
query45 197 163 174 163
query46 1084 772 680 680
query47 1818 1757 1782 1757
query48 370 286 303 286
query49 841 434 407 407
query50 767 400 407 400
query51 6807 6587 6646 6587
query52 103 88 91 88
query53 374 279 281 279
query54 882 448 458 448
query55 72 74 71 71
query56 274 254 270 254
query57 1114 1057 1023 1023
query58 232 266 235 235
query59 3410 3123 3163 3123
query60 293 272 272 272
query61 94 95 89 89
query62 616 442 450 442
query63 314 286 292 286
query64 8728 2239 1760 1760
query65 3209 3071 3089 3071
query66 743 321 320 320
query67 15426 15053 14827 14827
query68 5250 538 536 536
query69 622 471 376 376
query70 1201 1129 1011 1011
query71 451 271 275 271
query72 7278 5380 5441 5380
query73 774 326 329 326
query74 5870 5477 5448 5448
query75 3643 2671 2684 2671
query76 3129 941 992 941
query77 611 293 302 293
query78 10314 9808 9683 9683
query79 1684 524 516 516
query80 1962 542 477 477
query81 608 216 217 216
query82 444 101 102 101
query83 301 172 182 172
query84 269 84 87 84
query85 1002 278 268 268
query86 454 333 320 320
query87 3221 3031 3079 3031
query88 3752 2465 2458 2458
query89 476 377 371 371
query90 1605 190 190 190
query91 132 100 107 100
query92 61 51 51 51
query93 2081 502 506 502
query94 1057 186 188 186
query95 398 315 315 315
query96 592 278 274 274
query97 3176 3013 3093 3013
query98 233 200 197 197
query99 1178 824 827 824
Total cold run time: 268437 ms
Total hot run time: 173498 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36080:
URL: https://github.com/apache/doris/pull/36080
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2159755129
<details>
<summary>ClickBench: <b>Total hot run time: 31.11 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
query1 0.05 0.03 0.04
query2 0.08 0.04 0.04
query3 0.24 0.05 0.05
query4 1.67 0.10 0.10
query5 0.49 0.47 0.48
query6 1.13 0.72 0.74
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.54 0.49 0.47
query10 0.53 0.54 0.53
query11 0.16 0.11 0.11
query12 0.14 0.13 0.12
query13 0.59 0.59 0.62
query14 0.77 0.79 0.81
query15 0.84 0.81 0.81
query16 0.36 0.36 0.36
query17 0.96 1.05 1.04
query18 0.22 0.26 0.25
query19 1.75 1.72 1.73
query20 0.02 0.01 0.01
query21 15.41 0.65 0.64
query22 4.83 6.01 2.03
query23 18.32 1.37 1.36
query24 2.07 0.23 0.22
query25 0.14 0.09 0.08
query26 0.28 0.17 0.18
query27 0.09 0.08 0.08
query28 13.28 1.02 0.99
query29 12.60 3.27 3.31
query30 0.29 0.07 0.06
query31 2.86 0.39 0.39
query32 3.25 0.49 0.47
query33 2.88 2.96 2.97
query34 17.13 4.64 4.67
query35 4.81 4.64 4.45
query36 0.66 0.46 0.49
query37 0.18 0.15 0.16
query38 0.15 0.14 0.14
query39 0.04 0.04 0.03
query40 0.16 0.14 0.14
query41 0.08 0.04 0.04
query42 0.06 0.05 0.05
query43 0.04 0.04 0.03
Total cold run time: 110.22 s
Total hot run time: 31.11 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2163395619
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2168033082
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2167221694
<details>
<summary>TPC-H: <b>Total hot run time: 40120 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
------ Round 1 ----------------------------------
q1 17626 4297 4231 4231
q2 2029 196 191 191
q3 10447 1095 1106 1095
q4 10197 793 737 737
q5 7458 2640 2573 2573
q6 217 139 133 133
q7 947 598 589 589
q8 9231 2047 2036 2036
q9 9001 6459 6462 6459
q10 8972 3696 3691 3691
q11 458 240 238 238
q12 525 225 228 225
q13 17759 2962 2963 2962
q14 264 230 240 230
q15 523 482 475 475
q16 522 393 379 379
q17 953 743 673 673
q18 8232 8067 7839 7839
q19 8082 1565 1432 1432
q20 691 337 325 325
q21 5060 3261 4077 3261
q22 407 349 346 346
Total cold run time: 119601 ms
Total hot run time: 40120 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4649 4457 4358 4358
q2 378 274 264 264
q3 3056 2938 2937 2937
q4 2044 1754 1677 1677
q5 5571 5558 5556 5556
q6 226 126 133 126
q7 2159 1852 1777 1777
q8 3224 3367 3381 3367
q9 8667 8623 8638 8623
q10 4066 3874 3873 3873
q11 624 489 491 489
q12 828 616 615 615
q13 15903 2976 3122 2976
q14 315 270 263 263
q15 513 474 503 474
q16 507 418 431 418
q17 1814 1520 1462 1462
q18 7956 7676 7542 7542
q19 1749 1501 1576 1501
q20 3344 1857 1884 1857
q21 8525 4636 4838 4636
q22 653 565 580 565
Total cold run time: 76771 ms
Total hot run time: 55356 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2167235806
<details>
<summary>ClickBench: <b>Total hot run time: 32.45 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.04
query4 1.68 0.07 0.07
query5 0.50 0.47 0.47
query6 1.13 0.73 0.72
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.48 0.48
query10 0.55 0.55 0.54
query11 0.15 0.11 0.11
query12 0.15 0.13 0.11
query13 0.60 0.59 0.61
query14 0.80 0.76 0.78
query15 0.82 0.81 0.81
query16 0.35 0.37 0.37
query17 0.99 1.06 0.95
query18 0.23 0.22 0.26
query19 1.94 1.75 1.70
query20 0.01 0.00 0.00
query21 15.40 0.65 0.65
query22 3.76 5.52 3.95
query23 18.34 1.31 1.33
query24 2.19 0.21 0.22
query25 0.16 0.09 0.09
query26 0.27 0.17 0.17
query27 0.09 0.08 0.08
query28 13.23 1.02 0.99
query29 12.62 3.30 3.26
query30 0.26 0.06 0.07
query31 2.86 0.40 0.38
query32 3.27 0.48 0.47
query33 2.94 2.88 2.89
query34 16.93 4.41 4.39
query35 4.49 4.51 4.44
query36 0.66 0.48 0.48
query37 0.19 0.16 0.15
query38 0.15 0.14 0.14
query39 0.04 0.03 0.03
query40 0.18 0.14 0.15
query41 0.09 0.05 0.05
query42 0.06 0.05 0.04
query43 0.04 0.03 0.04
Total cold run time: 109.08 s
Total hot run time: 32.45 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2158918820
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #36080:
URL: https://github.com/apache/doris/pull/36080#discussion_r1636731462
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java:
##########
@@ -189,6 +189,7 @@ public CreateTableStmt(boolean ifNotExists, boolean isExternal, TableName tableN
this.partitionDesc = partitionDesc;
this.distributionDesc = distributionDesc;
this.properties = properties;
+ PropertyAnalyzer.getInstance().rewriteForceProperties(this.properties);
Review Comment:
Try to rewrite properties in all possible path.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #36080:
URL: https://github.com/apache/doris/pull/36080#discussion_r1635723868
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java:
##########
@@ -189,6 +189,7 @@ public CreateTableStmt(boolean ifNotExists, boolean isExternal, TableName tableN
this.partitionDesc = partitionDesc;
this.distributionDesc = distributionDesc;
this.properties = properties;
+ PropertyAnalyzer.getInstance().rewriteForceProperties(this.properties);
Review Comment:
better to rewrite them in Nereids CreateTableCommand
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2163512444
<details>
<summary>ClickBench: <b>Total hot run time: 30.39 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.03
query3 0.24 0.05 0.05
query4 1.66 0.08 0.09
query5 0.50 0.49 0.48
query6 1.13 0.72 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.56 0.50 0.48
query10 0.54 0.54 0.52
query11 0.15 0.12 0.11
query12 0.15 0.12 0.12
query13 0.60 0.59 0.60
query14 0.78 0.81 0.78
query15 0.84 0.82 0.82
query16 0.34 0.36 0.36
query17 1.01 1.01 0.99
query18 0.23 0.25 0.23
query19 1.81 1.71 1.70
query20 0.01 0.00 0.01
query21 15.46 0.65 0.64
query22 3.95 7.68 1.77
query23 18.29 1.38 1.30
query24 2.08 0.23 0.21
query25 0.15 0.09 0.08
query26 0.27 0.17 0.17
query27 0.08 0.09 0.08
query28 13.24 1.01 1.01
query29 12.66 3.27 3.26
query30 0.26 0.06 0.08
query31 2.84 0.40 0.39
query32 3.25 0.48 0.48
query33 2.90 2.93 2.88
query34 17.15 4.44 4.43
query35 4.45 4.47 4.45
query36 0.65 0.46 0.46
query37 0.18 0.15 0.15
query38 0.15 0.14 0.14
query39 0.05 0.03 0.03
query40 0.18 0.14 0.14
query41 0.09 0.04 0.05
query42 0.05 0.05 0.05
query43 0.04 0.03 0.04
Total cold run time: 109.16 s
Total hot run time: 30.39 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) Fix replication_num properties when create table and MTMV [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2167230851
<details>
<summary>TPC-DS: <b>Total hot run time: 172875 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
query1 818 390 380 380
query2 6336 2334 2458 2334
query3 6399 203 205 203
query4 20162 17356 17329 17329
query5 3739 471 486 471
query6 242 161 153 153
query7 4459 298 296 296
query8 335 283 293 283
query9 8321 2393 2386 2386
query10 570 305 286 286
query11 10626 10093 10021 10021
query12 139 90 85 85
query13 1582 370 369 369
query14 10041 7606 6926 6926
query15 236 183 187 183
query16 7809 269 260 260
query17 1858 533 520 520
query18 1924 270 275 270
query19 193 152 150 150
query20 93 86 82 82
query21 206 122 123 122
query22 4201 3993 4193 3993
query23 33689 33403 33496 33403
query24 10856 2777 2764 2764
query25 576 378 354 354
query26 711 157 149 149
query27 2208 321 324 321
query28 5861 2036 2044 2036
query29 863 625 617 617
query30 250 148 151 148
query31 958 719 711 711
query32 97 52 55 52
query33 756 273 278 273
query34 910 479 460 460
query35 725 644 620 620
query36 1093 957 948 948
query37 135 67 70 67
query38 2927 2762 2723 2723
query39 864 806 811 806
query40 200 128 133 128
query41 56 53 54 53
query42 118 98 103 98
query43 620 559 540 540
query44 1189 731 733 731
query45 194 166 161 161
query46 1060 725 688 688
query47 1877 1792 1825 1792
query48 357 298 302 298
query49 860 411 399 399
query50 757 388 385 385
query51 6780 6755 6640 6640
query52 111 88 95 88
query53 351 285 289 285
query54 895 451 436 436
query55 77 74 78 74
query56 280 249 316 249
query57 1166 1056 1063 1056
query58 251 246 237 237
query59 3296 3303 3238 3238
query60 291 276 276 276
query61 99 89 89 89
query62 630 436 452 436
query63 322 292 295 292
query64 8547 2290 1777 1777
query65 3148 3144 3076 3076
query66 782 324 330 324
query67 15376 14807 14861 14807
query68 4506 540 537 537
query69 585 464 421 421
query70 1187 1052 1150 1052
query71 402 280 283 280
query72 7488 5746 5547 5547
query73 771 321 319 319
query74 5941 5445 5478 5445
query75 3401 2707 2667 2667
query76 2404 907 971 907
query77 519 303 302 302
query78 10144 10047 9670 9670
query79 2120 515 515 515
query80 1062 463 453 453
query81 584 215 215 215
query82 823 100 98 98
query83 235 164 158 158
query84 239 84 82 82
query85 1860 271 269 269
query86 481 309 326 309
query87 3267 3047 3087 3047
query88 4157 2365 2342 2342
query89 480 396 375 375
query90 1859 189 186 186
query91 130 95 100 95
query92 60 50 48 48
query93 2274 511 501 501
query94 1256 188 189 188
query95 407 314 308 308
query96 590 272 260 260
query97 3268 3046 3031 3031
query98 213 192 196 192
query99 1260 867 849 849
Total cold run time: 267431 ms
Total hot run time: 172875 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org