You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mymeiyi (via GitHub)" <gi...@apache.org> on 2024/06/12 11:31:43 UTC
[PR] [fix](regression) Fix test_disable_move_memtable [doris]
mymeiyi opened a new pull request, #36198:
URL: https://github.com/apache/doris/pull/36198
## Proposed changes
when `set enable_fold_constant_by_be = false`, the real error is `too many filtered row`:
```
Reason: column(k10) value is incorrect while strict mode is true, src value is 2022. src line [1 10 1000 1 1 1.000 a 2022 2022 a 1 1 hello 1];
```
--
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](regression) Fix test_disable_move_memtable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2162846310
<details>
<summary>ClickBench: <b>Total hot run time: 30.35 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 441573e7b5fb632a25c49df9c29773108ad3c6ce, data reload: false
query1 0.03 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.07 0.07
query5 0.51 0.48 0.51
query6 1.12 0.73 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.49
query10 0.55 0.55 0.55
query11 0.15 0.10 0.11
query12 0.15 0.12 0.12
query13 0.60 0.58 0.59
query14 0.78 0.78 0.76
query15 0.83 0.81 0.82
query16 0.36 0.38 0.39
query17 0.96 1.00 1.03
query18 0.26 0.20 0.29
query19 1.79 1.74 1.70
query20 0.01 0.01 0.01
query21 15.45 0.66 0.65
query22 3.86 8.13 1.88
query23 18.26 1.37 1.28
query24 2.14 0.23 0.22
query25 0.16 0.08 0.09
query26 0.26 0.18 0.17
query27 0.08 0.08 0.08
query28 13.20 1.01 1.00
query29 12.65 3.26 3.23
query30 0.26 0.06 0.06
query31 2.88 0.40 0.38
query32 3.24 0.48 0.47
query33 2.90 2.88 2.89
query34 17.23 4.35 4.39
query35 4.54 4.44 4.42
query36 0.66 0.47 0.46
query37 0.19 0.16 0.15
query38 0.16 0.15 0.15
query39 0.04 0.04 0.03
query40 0.17 0.15 0.14
query41 0.09 0.04 0.04
query42 0.05 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.21 s
Total hot run time: 30.35 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](regression) Fix test_disable_move_memtable [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2164210276
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](regression) Fix test_disable_move_memtable [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2164210247
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](regression) Fix test_disable_move_memtable [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2162784303
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](regression) Fix test_disable_move_memtable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2162836404
<details>
<summary>TPC-DS: <b>Total hot run time: 172737 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 441573e7b5fb632a25c49df9c29773108ad3c6ce, data reload: false
query1 926 370 386 370
query2 6484 2441 2354 2354
query3 6656 211 210 210
query4 19727 17379 17276 17276
query5 4145 472 457 457
query6 247 168 204 168
query7 4593 310 299 299
query8 316 320 283 283
query9 8533 2397 2358 2358
query10 589 297 281 281
query11 10549 10023 9926 9926
query12 136 86 91 86
query13 1628 371 370 370
query14 10134 7005 7633 7005
query15 241 195 195 195
query16 7829 280 274 274
query17 1891 555 570 555
query18 1964 270 269 269
query19 194 155 152 152
query20 88 80 82 80
query21 213 127 128 127
query22 4332 3975 4086 3975
query23 33538 33175 33110 33110
query24 12018 2875 2848 2848
query25 666 355 351 351
query26 1839 154 155 154
query27 3010 318 317 317
query28 7645 2009 2018 2009
query29 1178 612 605 605
query30 272 150 147 147
query31 946 732 764 732
query32 93 53 55 53
query33 762 319 280 280
query34 975 476 478 476
query35 726 633 638 633
query36 1106 959 972 959
query37 311 71 72 71
query38 2854 2768 2754 2754
query39 866 799 796 796
query40 286 123 123 123
query41 56 51 53 51
query42 121 100 101 100
query43 581 532 548 532
query44 1217 733 744 733
query45 196 170 169 169
query46 1085 733 734 733
query47 1836 1770 1771 1770
query48 371 293 297 293
query49 1188 414 396 396
query50 759 382 390 382
query51 6845 6725 6716 6716
query52 132 92 97 92
query53 357 293 289 289
query54 1015 451 444 444
query55 75 74 74 74
query56 285 257 258 257
query57 1144 1051 1060 1051
query58 252 236 255 236
query59 3563 3293 3102 3102
query60 304 268 283 268
query61 91 90 90 90
query62 650 444 456 444
query63 320 291 285 285
query64 9877 2244 1742 1742
query65 3180 3299 3107 3107
query66 1367 340 332 332
query67 15460 14906 14731 14731
query68 4553 562 550 550
query69 455 316 309 309
query70 1168 1096 1173 1096
query71 401 274 266 266
query72 7311 5388 5466 5388
query73 754 326 331 326
query74 5949 5499 5587 5499
query75 3397 2653 2668 2653
query76 2748 956 870 870
query77 450 311 304 304
query78 10409 9905 9860 9860
query79 2321 521 515 515
query80 1033 468 457 457
query81 585 219 222 219
query82 700 108 107 107
query83 239 172 174 172
query84 236 85 84 84
query85 2024 289 279 279
query86 502 332 329 329
query87 3258 3093 3053 3053
query88 4234 2440 2441 2440
query89 479 386 386 386
query90 1826 192 187 187
query91 128 108 102 102
query92 66 50 52 50
query93 2178 517 506 506
query94 1280 195 187 187
query95 393 319 319 319
query96 596 272 274 272
query97 3259 3041 3020 3020
query98 209 207 196 196
query99 1230 829 830 829
Total cold run time: 277204 ms
Total hot run time: 172737 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](regression) Fix test_disable_move_memtable [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36198:
URL: https://github.com/apache/doris/pull/36198
--
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](regression) Fix test_disable_move_memtable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2162779262
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](regression) Fix test_disable_move_memtable [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2164234888
run p0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](regression) Fix test_disable_move_memtable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36198:
URL: https://github.com/apache/doris/pull/36198#issuecomment-2162814392
<details>
<summary>TPC-H: <b>Total hot run time: 39960 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 441573e7b5fb632a25c49df9c29773108ad3c6ce, data reload: false
------ Round 1 ----------------------------------
q1 17628 4360 4237 4237
q2 2026 189 191 189
q3 10787 1165 1063 1063
q4 10821 810 745 745
q5 7472 2744 2702 2702
q6 232 144 145 144
q7 965 613 621 613
q8 9625 2111 2090 2090
q9 9150 6593 6579 6579
q10 9057 3721 3706 3706
q11 452 236 248 236
q12 491 234 224 224
q13 17774 2971 3000 2971
q14 281 222 219 219
q15 526 497 472 472
q16 521 377 373 373
q17 967 662 707 662
q18 8116 7576 7379 7379
q19 3342 1472 1502 1472
q20 667 303 315 303
q21 4982 3232 3830 3232
q22 400 349 349 349
Total cold run time: 116282 ms
Total hot run time: 39960 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4385 4233 4214 4214
q2 371 276 261 261
q3 2984 2779 2761 2761
q4 1851 1585 1631 1585
q5 5281 5288 5292 5288
q6 214 127 124 124
q7 2168 1788 1728 1728
q8 3171 3268 3288 3268
q9 8293 8355 8327 8327
q10 3863 3686 3677 3677
q11 584 481 478 478
q12 778 587 609 587
q13 17331 2987 3048 2987
q14 289 283 260 260
q15 518 485 475 475
q16 487 415 407 407
q17 1765 1491 1475 1475
q18 7711 7544 7446 7446
q19 1686 1613 1532 1532
q20 2001 1782 1768 1768
q21 4819 4765 4826 4765
q22 597 570 557 557
Total cold run time: 71147 ms
Total hot run time: 53970 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