You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/06/07 02:58:18 UTC
[PR] [fix](mtmv)mtmv add case and fix bug [doris]
zddr opened a new pull request, #36019:
URL: https://github.com/apache/doris/pull/36019
- q
--
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](mtmv)mtmv add case and fix bug [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on code in PR #36019:
URL: https://github.com/apache/doris/pull/36019#discussion_r1635883047
##########
regression-test/suites/mtmv_p0/test_light_schema_change_mtmv.groovy:
##########
@@ -0,0 +1,64 @@
+// 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.
+
+import org.junit.Assert;
+
+suite("test_light_schema_change_mtmv","mtmv") {
Review Comment:
The materialized view does not allow schema changes. This only applies to light_schema_change and does not affect the normal functionality of the materialized view
--
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154365682
<details>
<summary>ClickBench: <b>Total hot run time: 30.06 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 54cf67b0b0d90f737a22a7192835d27dd6fa6f27, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.03 0.04
query3 0.23 0.04 0.05
query4 1.68 0.06 0.08
query5 0.52 0.49 0.50
query6 1.13 0.72 0.73
query7 0.02 0.02 0.02
query8 0.05 0.04 0.04
query9 0.54 0.48 0.50
query10 0.55 0.55 0.55
query11 0.16 0.11 0.11
query12 0.14 0.13 0.12
query13 0.60 0.59 0.58
query14 0.78 0.78 0.76
query15 0.83 0.82 0.81
query16 0.37 0.37 0.37
query17 0.97 0.96 1.03
query18 0.21 0.26 0.21
query19 1.82 1.73 1.69
query20 0.02 0.01 0.01
query21 15.44 0.71 0.67
query22 3.89 7.58 1.53
query23 18.32 1.40 1.36
query24 2.15 0.21 0.21
query25 0.16 0.09 0.08
query26 0.26 0.17 0.17
query27 0.08 0.09 0.08
query28 13.21 1.01 0.98
query29 13.23 3.27 3.26
query30 0.24 0.06 0.05
query31 2.86 0.38 0.37
query32 3.32 0.47 0.46
query33 2.88 2.91 2.84
query34 17.04 4.43 4.45
query35 4.49 4.46 4.48
query36 0.63 0.46 0.46
query37 0.17 0.18 0.15
query38 0.15 0.14 0.15
query39 0.04 0.03 0.04
query40 0.17 0.13 0.15
query41 0.09 0.04 0.05
query42 0.05 0.05 0.05
query43 0.04 0.04 0.03
Total cold run time: 109.65 s
Total hot run time: 30.06 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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2153898894
<details>
<summary>ClickBench: <b>Total hot run time: 30.41 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 93b1df8221ac09f25e2dc0ddc408190bf00c3a63, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.04
query3 0.24 0.04 0.04
query4 1.68 0.06 0.07
query5 0.51 0.48 0.47
query6 1.13 0.73 0.74
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.53 0.50 0.50
query10 0.54 0.54 0.54
query11 0.15 0.11 0.10
query12 0.15 0.13 0.12
query13 0.58 0.59 0.61
query14 0.77 0.78 0.77
query15 0.84 0.82 0.81
query16 0.34 0.38 0.37
query17 0.98 1.01 1.03
query18 0.22 0.22 0.25
query19 1.81 1.70 1.68
query20 0.02 0.01 0.02
query21 15.50 0.69 0.65
query22 4.24 7.45 1.90
query23 18.30 1.40 1.22
query24 2.08 0.22 0.22
query25 0.15 0.08 0.10
query26 0.26 0.17 0.17
query27 0.08 0.09 0.07
query28 13.21 1.01 0.98
query29 13.23 3.32 3.28
query30 0.25 0.05 0.05
query31 2.87 0.38 0.38
query32 3.28 0.47 0.46
query33 2.93 2.95 2.93
query34 17.05 4.38 4.38
query35 4.48 4.45 4.49
query36 0.65 0.49 0.48
query37 0.18 0.15 0.15
query38 0.16 0.13 0.14
query39 0.04 0.04 0.03
query40 0.16 0.15 0.14
query41 0.09 0.04 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.97 s
Total hot run time: 30.41 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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2153884886
<details>
<summary>TPC-DS: <b>Total hot run time: 171043 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 93b1df8221ac09f25e2dc0ddc408190bf00c3a63, data reload: false
query1 924 378 367 367
query2 6440 2525 2205 2205
query3 6654 204 215 204
query4 19346 17429 17067 17067
query5 4125 446 460 446
query6 250 152 172 152
query7 4591 297 287 287
query8 324 276 281 276
query9 8631 2399 2403 2399
query10 456 290 268 268
query11 10412 10156 10009 10009
query12 138 84 85 84
query13 1667 366 362 362
query14 10279 6228 6078 6078
query15 231 184 182 182
query16 7354 274 260 260
query17 1335 518 512 512
query18 1934 266 266 266
query19 184 153 151 151
query20 89 84 83 83
query21 204 136 129 129
query22 4282 4116 4067 4067
query23 33599 32880 33210 32880
query24 11460 2922 2799 2799
query25 638 348 357 348
query26 1521 159 155 155
query27 3155 319 317 317
query28 7451 2048 2053 2048
query29 1056 607 602 602
query30 281 153 148 148
query31 967 751 738 738
query32 90 53 56 53
query33 758 280 274 274
query34 992 467 456 456
query35 740 635 604 604
query36 1110 946 939 939
query37 155 67 71 67
query38 2858 2728 2692 2692
query39 882 815 790 790
query40 220 124 121 121
query41 57 52 52 52
query42 124 100 100 100
query43 597 565 551 551
query44 1256 749 747 747
query45 209 172 170 170
query46 1080 724 742 724
query47 1839 1746 1780 1746
query48 365 295 305 295
query49 1142 406 425 406
query50 779 385 418 385
query51 6795 6633 6632 6632
query52 102 99 95 95
query53 368 291 296 291
query54 956 460 468 460
query55 78 83 79 79
query56 292 274 273 273
query57 1156 1044 1083 1044
query58 261 275 260 260
query59 3532 3074 3362 3074
query60 343 271 265 265
query61 90 88 87 87
query62 691 460 444 444
query63 315 293 286 286
query64 10002 2252 1716 1716
query65 3212 3113 3105 3105
query66 1404 332 334 332
query67 15333 14985 14796 14796
query68 5693 538 527 527
query69 613 445 378 378
query70 1183 1076 1147 1076
query71 461 264 274 264
query72 7837 5619 5626 5619
query73 769 319 321 319
query74 5872 5614 5489 5489
query75 3762 2666 2680 2666
query76 3169 980 896 896
query77 662 299 292 292
query78 10222 9879 9763 9763
query79 3272 510 515 510
query80 2131 462 451 451
query81 578 224 219 219
query82 1481 108 100 100
query83 350 161 167 161
query84 275 87 82 82
query85 1576 274 270 270
query86 466 311 317 311
query87 3253 3031 3056 3031
query88 4151 2335 2321 2321
query89 466 387 377 377
query90 1762 192 190 190
query91 123 96 99 96
query92 64 52 49 49
query93 3570 516 507 507
query94 1170 184 185 184
query95 398 385 309 309
query96 597 262 266 262
query97 3173 2980 2996 2980
query98 232 198 191 191
query99 1230 856 853 853
Total cold run time: 280722 ms
Total hot run time: 171043 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](mtmv)mtmv add case and fix bug [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on code in PR #36019:
URL: https://github.com/apache/doris/pull/36019#discussion_r1635880820
##########
regression-test/suites/mtmv_p0/test_create_mv_mtmv.groovy:
##########
@@ -0,0 +1,90 @@
+// 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.
+
+import org.junit.Assert;
+
+suite("test_create_mv_mtmv","mtmv") {
Review Comment:
yes
--
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](mtmv)mtmv add case and fix bug [doris]
Posted by "zfr9527 (via GitHub)" <gi...@apache.org>.
zfr9527 commented on code in PR #36019:
URL: https://github.com/apache/doris/pull/36019#discussion_r1635831996
##########
regression-test/suites/mtmv_p0/test_create_mv_mtmv.groovy:
##########
@@ -0,0 +1,90 @@
+// 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.
+
+import org.junit.Assert;
+
+suite("test_create_mv_mtmv","mtmv") {
Review Comment:
Do we need to support building mv on mtmv?
##########
regression-test/suites/mtmv_p0/test_light_schema_change_mtmv.groovy:
##########
@@ -0,0 +1,64 @@
+// 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.
+
+import org.junit.Assert;
+
+suite("test_light_schema_change_mtmv","mtmv") {
Review Comment:
My understanding of light_schema_change is the meaning of adding or deleting a certain column of the table, right? But this logic is not seen in the case?
--
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154487056
<details>
<summary>TPC-DS: <b>Total hot run time: 168694 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 857044aae2aee39ee03624df0aedc4b898db2103, data reload: false
query1 924 373 361 361
query2 6441 2352 2218 2218
query3 6644 209 218 209
query4 22238 17317 17477 17317
query5 4184 460 453 453
query6 249 159 155 155
query7 4586 296 298 296
query8 301 268 281 268
query9 8475 2394 2384 2384
query10 441 285 282 282
query11 10486 9971 9908 9908
query12 143 90 83 83
query13 1629 363 357 357
query14 10210 6463 6473 6463
query15 237 189 183 183
query16 7825 275 269 269
query17 1603 539 531 531
query18 1971 281 290 281
query19 210 162 157 157
query20 91 86 83 83
query21 205 135 131 131
query22 4229 4052 4006 4006
query23 33577 32979 32978 32978
query24 12182 2860 2862 2860
query25 697 370 370 370
query26 1855 156 151 151
query27 3104 319 313 313
query28 7736 2032 2038 2032
query29 1209 628 599 599
query30 290 148 151 148
query31 925 743 738 738
query32 96 56 58 56
query33 778 299 290 290
query34 960 464 465 464
query35 747 643 629 629
query36 1147 943 923 923
query37 282 71 74 71
query38 2869 2723 2726 2723
query39 858 778 776 776
query40 285 124 125 124
query41 59 52 56 52
query42 124 98 97 97
query43 573 526 539 526
query44 1209 743 753 743
query45 201 165 165 165
query46 1151 710 698 698
query47 1862 1772 1785 1772
query48 381 286 290 286
query49 1176 398 437 398
query50 792 385 384 384
query51 6783 6704 6640 6640
query52 106 89 93 89
query53 353 282 282 282
query54 903 455 428 428
query55 73 75 75 75
query56 270 251 244 244
query57 1107 1050 1072 1050
query58 251 243 240 240
query59 3454 3042 3356 3042
query60 287 274 268 268
query61 89 89 90 89
query62 657 462 458 458
query63 319 287 288 287
query64 9821 2232 1717 1717
query65 3177 3085 3081 3081
query66 1365 333 331 331
query67 15653 15084 14884 14884
query68 4724 576 547 547
query69 522 293 293 293
query70 1170 1127 1102 1102
query71 425 279 266 266
query72 8579 5082 2727 2727
query73 738 317 319 317
query74 6107 5507 5415 5415
query75 4190 2654 2679 2654
query76 3117 914 912 912
query77 717 295 284 284
query78 10322 10369 9769 9769
query79 2915 513 507 507
query80 1106 471 496 471
query81 554 217 222 217
query82 616 99 106 99
query83 372 162 167 162
query84 267 85 85 85
query85 2047 289 266 266
query86 467 306 318 306
query87 3223 3099 3043 3043
query88 3957 2329 2324 2324
query89 497 392 399 392
query90 1915 188 178 178
query91 124 100 95 95
query92 64 50 49 49
query93 4297 523 504 504
query94 1352 188 183 183
query95 398 308 304 304
query96 631 259 260 259
query97 3175 2996 2983 2983
query98 232 201 195 195
query99 1197 839 820 820
Total cold run time: 285132 ms
Total hot run time: 168694 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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154496151
<details>
<summary>ClickBench: <b>Total hot run time: 30.48 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 857044aae2aee39ee03624df0aedc4b898db2103, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.05 0.06
query4 1.68 0.06 0.07
query5 0.48 0.49 0.48
query6 1.14 0.74 0.73
query7 0.02 0.02 0.01
query8 0.06 0.04 0.04
query9 0.53 0.49 0.48
query10 0.54 0.55 0.53
query11 0.17 0.11 0.11
query12 0.15 0.12 0.12
query13 0.60 0.58 0.61
query14 0.79 0.79 0.77
query15 0.84 0.82 0.82
query16 0.35 0.36 0.36
query17 1.01 0.97 0.96
query18 0.22 0.22 0.25
query19 1.86 1.71 1.78
query20 0.02 0.01 0.01
query21 15.54 0.67 0.66
query22 4.38 7.15 1.85
query23 18.27 1.45 1.37
query24 2.17 0.21 0.22
query25 0.16 0.10 0.09
query26 0.27 0.17 0.17
query27 0.09 0.07 0.08
query28 13.25 1.01 1.00
query29 13.18 3.24 3.22
query30 0.25 0.06 0.06
query31 2.87 0.38 0.38
query32 3.29 0.48 0.46
query33 2.86 2.92 2.90
query34 17.20 4.42 4.43
query35 4.47 4.48 4.46
query36 0.64 0.48 0.46
query37 0.17 0.15 0.16
query38 0.16 0.15 0.15
query39 0.04 0.03 0.04
query40 0.16 0.13 0.14
query41 0.09 0.05 0.05
query42 0.05 0.05 0.05
query43 0.05 0.03 0.03
Total cold run time: 110.42 s
Total hot run time: 30.48 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](mtmv)mtmv add case and fix bug [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2153763179
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](mtmv)mtmv add case and fix bug [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154424418
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2153858365
<details>
<summary>TPC-H: <b>Total hot run time: 40335 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 93b1df8221ac09f25e2dc0ddc408190bf00c3a63, data reload: false
------ Round 1 ----------------------------------
q1 17829 4549 4908 4549
q2 2560 201 191 191
q3 11035 1159 1184 1159
q4 10878 785 786 785
q5 7544 2728 2706 2706
q6 220 135 134 134
q7 958 607 597 597
q8 9653 2132 2100 2100
q9 8796 6519 6476 6476
q10 8924 3730 3734 3730
q11 458 244 237 237
q12 461 220 223 220
q13 18786 2993 3023 2993
q14 267 213 214 213
q15 514 482 467 467
q16 526 376 378 376
q17 977 698 762 698
q18 8071 7413 7481 7413
q19 7200 1551 1558 1551
q20 693 318 311 311
q21 4960 3078 3928 3078
q22 400 352 351 351
Total cold run time: 121710 ms
Total hot run time: 40335 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4376 4305 4218 4218
q2 364 263 262 262
q3 2969 2763 2770 2763
q4 1884 1598 1587 1587
q5 5229 5305 5257 5257
q6 214 124 125 124
q7 2071 1729 1723 1723
q8 3212 3335 3319 3319
q9 8277 8309 8303 8303
q10 3893 3648 3716 3648
q11 570 482 484 482
q12 779 596 594 594
q13 17398 2965 2959 2959
q14 293 256 263 256
q15 513 480 492 480
q16 487 409 414 409
q17 1807 1486 1483 1483
q18 7714 7590 7350 7350
q19 1683 1581 1637 1581
q20 2022 1775 1780 1775
q21 4948 4661 4578 4578
q22 587 556 553 553
Total cold run time: 71290 ms
Total hot run time: 53704 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](mtmv)mtmv add case and fix bug [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2162073258
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154337645
<details>
<summary>TPC-H: <b>Total hot run time: 39942 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 54cf67b0b0d90f737a22a7192835d27dd6fa6f27, data reload: false
------ Round 1 ----------------------------------
q1 18084 4387 4381 4381
q2 2570 202 191 191
q3 10980 1236 1253 1236
q4 10527 790 739 739
q5 7593 2672 2786 2672
q6 222 133 134 133
q7 949 606 615 606
q8 9312 2077 2118 2077
q9 8789 6487 6461 6461
q10 9018 3708 3704 3704
q11 442 236 239 236
q12 456 223 222 222
q13 17766 2975 2989 2975
q14 267 216 226 216
q15 519 457 469 457
q16 514 372 377 372
q17 957 661 702 661
q18 7927 7539 7399 7399
q19 7036 1539 1405 1405
q20 656 315 304 304
q21 5176 3169 3205 3169
q22 382 333 326 326
Total cold run time: 120142 ms
Total hot run time: 39942 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4346 4215 4261 4215
q2 358 266 269 266
q3 2930 2707 2756 2707
q4 1861 1619 1602 1602
q5 5232 5244 5251 5244
q6 211 125 124 124
q7 2057 1665 1735 1665
q8 3185 3311 3307 3307
q9 8344 8343 8281 8281
q10 3864 3626 3643 3626
q11 593 491 485 485
q12 746 613 602 602
q13 16424 2980 2956 2956
q14 301 269 265 265
q15 506 469 488 469
q16 471 401 392 392
q17 1769 1503 1454 1454
q18 7608 7406 7358 7358
q19 1699 1604 1642 1604
q20 1990 1794 1793 1793
q21 5053 4657 4824 4657
q22 588 505 518 505
Total cold run time: 70136 ms
Total hot run time: 53577 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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154356298
<details>
<summary>TPC-DS: <b>Total hot run time: 172061 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 54cf67b0b0d90f737a22a7192835d27dd6fa6f27, data reload: false
query1 938 375 376 375
query2 6439 2406 2351 2351
query3 6647 206 209 206
query4 19183 17431 17249 17249
query5 4143 447 441 441
query6 259 160 156 156
query7 4592 301 289 289
query8 309 274 267 267
query9 8471 2402 2375 2375
query10 436 282 264 264
query11 10451 10138 9992 9992
query12 134 89 84 84
query13 1632 363 373 363
query14 9356 7360 7549 7360
query15 256 186 184 184
query16 8075 296 253 253
query17 1825 517 515 515
query18 2056 264 264 264
query19 204 159 144 144
query20 86 83 82 82
query21 205 127 127 127
query22 4346 4249 4125 4125
query23 33616 32819 33055 32819
query24 11884 2931 2885 2885
query25 656 350 349 349
query26 1745 151 151 151
query27 2960 315 316 315
query28 7738 2027 2053 2027
query29 1031 615 594 594
query30 274 145 150 145
query31 940 757 722 722
query32 103 52 59 52
query33 772 302 276 276
query34 971 469 464 464
query35 735 602 591 591
query36 1103 910 907 907
query37 291 68 71 68
query38 2865 2740 2718 2718
query39 873 789 783 783
query40 279 120 120 120
query41 52 52 50 50
query42 118 95 94 94
query43 554 542 552 542
query44 1178 730 741 730
query45 212 164 161 161
query46 1076 742 698 698
query47 1881 1792 1795 1792
query48 365 291 291 291
query49 1187 404 407 404
query50 787 380 393 380
query51 6808 6609 6603 6603
query52 104 91 90 90
query53 354 282 286 282
query54 987 448 468 448
query55 72 70 71 70
query56 269 250 249 249
query57 1157 1074 1047 1047
query58 246 233 243 233
query59 3412 3164 3300 3164
query60 284 267 271 267
query61 93 91 92 91
query62 660 439 442 439
query63 315 283 286 283
query64 9866 2349 1764 1764
query65 3309 3072 3103 3072
query66 1372 335 324 324
query67 15380 14877 15066 14877
query68 4548 541 544 541
query69 440 288 295 288
query70 1192 1034 1130 1034
query71 416 262 263 262
query72 7142 5258 5519 5258
query73 752 316 322 316
query74 5836 5510 5444 5444
query75 3568 2615 2680 2615
query76 2879 890 846 846
query77 444 295 297 295
query78 10292 9925 9733 9733
query79 1840 512 552 512
query80 1148 450 459 450
query81 576 224 219 219
query82 1076 103 99 99
query83 228 162 163 162
query84 235 83 83 83
query85 1247 284 268 268
query86 401 314 334 314
query87 3231 3148 3078 3078
query88 2874 2326 2313 2313
query89 471 384 382 382
query90 1749 186 189 186
query91 122 97 102 97
query92 62 50 48 48
query93 1449 519 505 505
query94 1196 192 237 192
query95 394 296 296 296
query96 582 262 261 261
query97 3212 3040 3035 3035
query98 230 204 196 196
query99 1280 836 843 836
Total cold run time: 272089 ms
Total hot run time: 172061 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](mtmv)mtmv add case and fix bug [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #36019:
URL: https://github.com/apache/doris/pull/36019
--
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2153760186
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](mtmv)mtmv add case and fix bug [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154297564
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](mtmv)mtmv add case and fix bug [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2154468888
<details>
<summary>TPC-H: <b>Total hot run time: 40082 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 857044aae2aee39ee03624df0aedc4b898db2103, data reload: false
------ Round 1 ----------------------------------
q1 17969 6805 4335 4335
q2 2036 186 181 181
q3 11285 1178 1155 1155
q4 10609 778 797 778
q5 7563 2749 2589 2589
q6 222 135 134 134
q7 955 611 596 596
q8 9299 2123 2113 2113
q9 9210 6602 6566 6566
q10 9227 3682 3685 3682
q11 459 242 244 242
q12 402 221 226 221
q13 17897 2969 2951 2951
q14 264 224 221 221
q15 511 462 476 462
q16 512 377 375 375
q17 959 744 731 731
q18 8088 7412 7367 7367
q19 5985 1554 1523 1523
q20 657 313 306 306
q21 4914 3241 3223 3223
q22 385 331 333 331
Total cold run time: 119408 ms
Total hot run time: 40082 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4384 4245 4257 4245
q2 381 271 265 265
q3 3005 2760 2754 2754
q4 1891 1599 1593 1593
q5 5223 5262 5234 5234
q6 216 132 127 127
q7 2109 1712 1768 1712
q8 3188 3337 3332 3332
q9 8332 8233 8253 8233
q10 3864 3638 3600 3600
q11 582 476 503 476
q12 784 597 594 594
q13 17554 2960 2997 2960
q14 290 276 261 261
q15 511 473 472 472
q16 479 430 409 409
q17 1785 1459 1494 1459
q18 7537 7408 7352 7352
q19 1651 1558 1635 1558
q20 1980 1760 1769 1760
q21 4835 4799 4577 4577
q22 605 518 505 505
Total cold run time: 71186 ms
Total hot run time: 53478 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](mtmv)mtmv add case and fix bug [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36019:
URL: https://github.com/apache/doris/pull/36019#issuecomment-2162073227
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