You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yulei-Yang (via GitHub)" <gi...@apache.org> on 2024/06/24 03:20:09 UTC
[PR] [fix](planner) fix result wrong caused by mixed use multiple columns … [doris]
Yulei-Yang opened a new pull request, #36724:
URL: https://github.com/apache/doris/pull/36724
…with type of datetime/datetimev2/date/datev2 of function coalesce & ifnull
cherry-pick: #36688, #36640, #36583
--
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185819702
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185695513
<details>
<summary>TPC-DS: <b>Total hot run time: 169525 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 6aadf2cf1b490ccbf1fa243583aa82152f2e0eb6, data reload: false
query1 946 374 388 374
query2 6447 2461 2333 2333
query3 6652 205 207 205
query4 20199 17267 17381 17267
query5 4153 475 466 466
query6 247 156 173 156
query7 4601 299 304 299
query8 323 294 294 294
query9 8607 2364 2356 2356
query10 632 305 273 273
query11 10474 10018 9925 9925
query12 138 87 87 87
query13 1651 380 385 380
query14 10152 7676 6209 6209
query15 231 189 191 189
query16 7761 299 280 280
query17 1867 560 564 560
query18 1952 290 293 290
query19 202 159 164 159
query20 92 87 85 85
query21 213 125 125 125
query22 4235 4096 4040 4040
query23 33778 32888 33223 32888
query24 12037 2804 2942 2804
query25 699 375 380 375
query26 1790 159 158 158
query27 2973 318 322 318
query28 7598 2060 2039 2039
query29 1125 643 629 629
query30 313 165 153 153
query31 979 766 763 763
query32 91 56 58 56
query33 781 300 294 294
query34 919 466 470 466
query35 765 656 642 642
query36 1102 944 946 944
query37 256 75 75 75
query38 2885 2736 2744 2736
query39 864 792 824 792
query40 292 131 129 129
query41 61 54 53 53
query42 135 100 102 100
query43 598 573 575 573
query44 1287 749 756 749
query45 206 174 167 167
query46 1080 743 719 719
query47 1844 1795 1794 1794
query48 381 310 307 307
query49 1203 426 429 426
query50 771 390 397 390
query51 6898 6767 6805 6767
query52 113 100 96 96
query53 374 294 294 294
query54 1051 468 458 458
query55 81 78 80 78
query56 303 278 288 278
query57 1217 1028 1027 1027
query58 272 261 257 257
query59 3608 3171 3023 3023
query60 321 288 293 288
query61 112 111 218 111
query62 638 437 425 425
query63 327 301 285 285
query64 9878 2224 1778 1778
query65 3299 3118 3108 3108
query66 1382 340 331 331
query67 15811 14970 14890 14890
query68 8949 568 546 546
query69 680 480 424 424
query70 1412 1124 1084 1084
query71 522 283 299 283
query72 8851 2791 2619 2619
query73 2285 332 337 332
query74 5887 5502 5492 5492
query75 5305 2638 2649 2638
query76 5621 984 868 868
query77 758 317 314 314
query78 10523 9766 9785 9766
query79 7511 510 527 510
query80 955 466 479 466
query81 550 223 228 223
query82 279 112 114 112
query83 351 179 169 169
query84 272 88 88 88
query85 989 286 274 274
query86 344 312 322 312
query87 3291 3082 3088 3082
query88 4477 2479 2484 2479
query89 524 383 400 383
query90 1900 192 195 192
query91 133 100 104 100
query92 61 53 50 50
query93 5814 519 510 510
query94 1274 194 191 191
query95 408 312 319 312
query96 604 272 273 272
query97 3183 3028 3068 3028
query98 227 208 200 200
query99 1147 821 827 821
Total cold run time: 299360 ms
Total hot run time: 169525 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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185643393
run performance
--
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185702780
<details>
<summary>ClickBench: <b>Total hot run time: 30.88 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 6aadf2cf1b490ccbf1fa243583aa82152f2e0eb6, data reload: false
query1 0.04 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.06 0.07
query4 1.67 0.10 0.10
query5 0.50 0.49 0.49
query6 1.13 0.75 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.53 0.48 0.48
query10 0.53 0.54 0.55
query11 0.16 0.11 0.11
query12 0.15 0.12 0.12
query13 0.59 0.58 0.58
query14 0.76 0.77 0.79
query15 0.82 0.81 0.82
query16 0.35 0.37 0.37
query17 1.03 0.96 0.96
query18 0.23 0.22 0.26
query19 1.81 1.72 1.66
query20 0.02 0.01 0.01
query21 15.41 0.66 0.66
query22 3.88 6.64 2.24
query23 18.26 1.36 1.26
query24 2.11 0.23 0.25
query25 0.15 0.08 0.08
query26 0.27 0.17 0.17
query27 0.07 0.07 0.08
query28 13.17 1.01 0.99
query29 12.63 3.36 3.31
query30 0.25 0.07 0.06
query31 2.85 0.39 0.40
query32 3.28 0.47 0.48
query33 2.94 2.98 2.90
query34 17.13 4.44 4.39
query35 4.52 4.54 4.47
query36 0.65 0.48 0.45
query37 0.18 0.16 0.16
query38 0.16 0.15 0.15
query39 0.04 0.04 0.03
query40 0.17 0.14 0.17
query41 0.09 0.05 0.04
query42 0.05 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 108.99 s
Total hot run time: 30.88 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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2186332564
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185511676
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2186012247
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185680394
<details>
<summary>TPC-H: <b>Total hot run time: 39822 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 6aadf2cf1b490ccbf1fa243583aa82152f2e0eb6, data reload: false
------ Round 1 ----------------------------------
q1 18592 4549 4370 4370
q2 2750 197 195 195
q3 10981 1094 1181 1094
q4 10749 857 776 776
q5 7810 2685 2680 2680
q6 220 132 133 132
q7 954 610 615 610
q8 9226 2058 2049 2049
q9 8793 6440 6433 6433
q10 8963 3726 3725 3725
q11 474 236 231 231
q12 454 232 220 220
q13 18796 2962 2947 2947
q14 274 209 214 209
q15 510 490 481 481
q16 572 370 367 367
q17 952 615 680 615
q18 8082 7537 7428 7428
q19 7488 1491 1486 1486
q20 665 317 313 313
q21 4874 3129 3307 3129
q22 407 334 332 332
Total cold run time: 122586 ms
Total hot run time: 39822 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4453 4226 4215 4215
q2 378 255 261 255
q3 2987 2722 2748 2722
q4 1923 1645 1600 1600
q5 5280 5260 5272 5260
q6 217 128 128 128
q7 2137 1722 1783 1722
q8 3188 3359 3293 3293
q9 8244 8299 8303 8299
q10 3859 3632 3609 3609
q11 560 487 483 483
q12 791 615 588 588
q13 16291 2972 2975 2972
q14 306 255 261 255
q15 519 478 490 478
q16 476 410 432 410
q17 1795 1499 1481 1481
q18 7687 7480 7350 7350
q19 1691 1493 1544 1493
q20 1984 1796 1779 1779
q21 4797 4707 4798 4707
q22 613 548 560 548
Total cold run time: 70176 ms
Total hot run time: 53647 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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2186500526
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185952194
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2186500457
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](planner) fix result wrong caused by mixed use multiple columns … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36724:
URL: https://github.com/apache/doris/pull/36724#issuecomment-2185511114
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