You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zclllyybb (via GitHub)" <gi...@apache.org> on 2025/04/16 12:37:50 UTC
[PR] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
zclllyybb opened a new pull request, #50108:
URL: https://github.com/apache/doris/pull/50108
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6)
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [x] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [x] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [x] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813001948
<details>
<summary>TPC-DS: <b>Total hot run time: 192553 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 601c869d349804d1eed605a30be5037dbae13e84, data reload: false
query1 1422 1071 1059 1059
query2 6098 1779 1817 1779
query3 11014 4491 4460 4460
query4 25964 23826 23362 23362
query5 5093 611 460 460
query6 319 203 209 203
query7 4000 495 280 280
query8 303 257 243 243
query9 8524 2525 2539 2525
query10 470 317 277 277
query11 15340 15136 14996 14996
query12 162 114 106 106
query13 1731 504 410 410
query14 10093 5933 6027 5933
query15 218 197 167 167
query16 7595 622 473 473
query17 1318 778 623 623
query18 2055 418 312 312
query19 189 195 180 180
query20 137 126 129 126
query21 217 123 107 107
query22 4550 4515 4371 4371
query23 34582 33568 33477 33477
query24 8419 2409 2418 2409
query25 561 494 398 398
query26 1345 273 155 155
query27 2805 500 325 325
query28 4718 2111 2109 2109
query29 716 593 430 430
query30 278 224 190 190
query31 918 874 802 802
query32 70 65 62 62
query33 541 348 301 301
query34 809 857 518 518
query35 823 855 770 770
query36 968 982 878 878
query37 116 100 76 76
query38 4123 4224 4122 4122
query39 1501 1429 1567 1429
query40 226 120 118 118
query41 64 60 61 60
query42 117 103 114 103
query43 500 510 489 489
query44 1329 818 811 811
query45 178 173 168 168
query46 850 1025 634 634
query47 1828 1911 1795 1795
query48 373 409 302 302
query49 752 512 406 406
query50 659 707 404 404
query51 4304 4205 4198 4198
query52 111 116 114 114
query53 224 263 196 196
query54 573 584 520 520
query55 81 80 78 78
query56 295 308 313 308
query57 1190 1183 1177 1177
query58 275 270 260 260
query59 2601 2770 2691 2691
query60 317 311 312 311
query61 128 127 125 125
query62 804 727 676 676
query63 232 186 179 179
query64 4023 1044 723 723
query65 4510 4339 4395 4339
query66 949 421 304 304
query67 15871 15386 15353 15353
query68 6590 882 505 505
query69 483 300 272 272
query70 1144 1141 1128 1128
query71 448 298 292 292
query72 5609 4725 4724 4724
query73 712 596 353 353
query74 9085 9049 9059 9049
query75 3215 3197 2683 2683
query76 3192 1177 744 744
query77 468 383 272 272
query78 9890 10190 9345 9345
query79 2052 810 595 595
query80 1283 513 454 454
query81 518 254 223 223
query82 406 126 93 93
query83 252 251 220 220
query84 252 100 90 90
query85 798 344 319 319
query86 446 306 291 291
query87 4359 4461 4326 4326
query88 2776 2198 2191 2191
query89 395 313 281 281
query90 1777 202 205 202
query91 155 140 108 108
query92 66 59 59 59
query93 1687 925 565 565
query94 688 398 296 296
query95 365 299 278 278
query96 477 561 273 273
query97 3073 3197 3096 3096
query98 221 203 201 201
query99 1337 1430 1280 1280
Total cold run time: 277688 ms
Total hot run time: 192553 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813452986
<details>
<summary>TPC-DS: <b>Total hot run time: 192103 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 4dd2550d06fed3d808df46e68eb7db8d4e287ee3, data reload: false
query1 1399 1077 1054 1054
query2 6206 1783 1841 1783
query3 11031 4372 4472 4372
query4 53870 25494 23511 23511
query5 5310 507 474 474
query6 419 202 185 185
query7 5330 484 266 266
query8 318 235 221 221
query9 7163 2510 2540 2510
query10 436 303 256 256
query11 15181 14923 14920 14920
query12 160 111 105 105
query13 1269 511 399 399
query14 9944 6230 6330 6230
query15 213 197 183 183
query16 6941 622 493 493
query17 1102 761 612 612
query18 1544 415 318 318
query19 204 193 176 176
query20 123 125 120 120
query21 206 126 106 106
query22 4552 4486 4301 4301
query23 34255 33535 33400 33400
query24 6631 2417 2378 2378
query25 464 449 410 410
query26 765 272 146 146
query27 2348 501 336 336
query28 3143 2138 2119 2119
query29 568 535 428 428
query30 272 238 190 190
query31 882 862 769 769
query32 76 66 59 59
query33 430 364 320 320
query34 757 866 517 517
query35 774 842 745 745
query36 950 996 895 895
query37 115 101 80 80
query38 4133 4346 4342 4342
query39 1478 1459 1433 1433
query40 215 122 107 107
query41 53 50 55 50
query42 128 113 104 104
query43 485 499 466 466
query44 1288 804 798 798
query45 185 171 162 162
query46 838 1031 641 641
query47 1893 1884 1803 1803
query48 378 408 304 304
query49 696 516 453 453
query50 662 703 405 405
query51 4210 4313 4183 4183
query52 115 114 101 101
query53 239 267 181 181
query54 565 561 506 506
query55 82 80 80 80
query56 305 295 311 295
query57 1201 1246 1138 1138
query58 264 246 269 246
query59 2654 2749 2659 2659
query60 318 314 310 310
query61 131 128 124 124
query62 719 755 690 690
query63 232 210 183 183
query64 1891 1046 706 706
query65 4387 4359 4254 4254
query66 726 416 302 302
query67 15671 15525 15540 15525
query68 7436 871 499 499
query69 536 309 263 263
query70 1203 1095 1111 1095
query71 542 315 289 289
query72 5762 4687 4837 4687
query73 1039 582 347 347
query74 8967 8840 8715 8715
query75 3777 3190 2691 2691
query76 4440 1190 756 756
query77 639 365 277 277
query78 9972 10126 9213 9213
query79 1483 808 576 576
query80 639 557 436 436
query81 481 252 223 223
query82 306 129 97 97
query83 339 242 231 231
query84 286 98 91 91
query85 760 376 316 316
query86 334 282 280 280
query87 4349 4315 4220 4220
query88 2796 2235 2237 2235
query89 383 315 268 268
query90 2102 201 206 201
query91 141 141 111 111
query92 79 60 56 56
query93 1121 939 570 570
query94 702 388 308 308
query95 360 292 286 286
query96 478 564 275 275
query97 3134 3209 3094 3094
query98 227 220 206 206
query99 1410 1426 1253 1253
Total cold run time: 297716 ms
Total hot run time: 192103 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813047786
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2809538794
<details>
<summary>TPC-DS: <b>Total hot run time: 185674 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 b4b053c8207a487c3c66d2f7b318aaa98419e539, data reload: false
query1 1015 482 493 482
query2 6570 1830 1786 1786
query3 6765 218 226 218
query4 26524 23748 23322 23322
query5 4339 598 434 434
query6 291 205 197 197
query7 4622 528 277 277
query8 313 253 245 245
query9 8623 2552 2549 2549
query10 473 342 259 259
query11 15371 15157 14940 14940
query12 159 112 109 109
query13 1666 534 397 397
query14 8773 6095 6332 6095
query15 194 179 167 167
query16 7343 629 471 471
query17 1183 702 577 577
query18 1961 394 290 290
query19 185 196 154 154
query20 118 118 111 111
query21 216 125 107 107
query22 4134 4151 4022 4022
query23 33823 32810 32929 32810
query24 8443 2364 2338 2338
query25 530 448 373 373
query26 1232 268 148 148
query27 2764 495 330 330
query28 4306 2114 2094 2094
query29 750 551 433 433
query30 281 211 187 187
query31 909 819 768 768
query32 71 67 65 65
query33 554 384 322 322
query34 787 860 501 501
query35 794 824 754 754
query36 967 985 902 902
query37 116 102 84 84
query38 4154 4132 4149 4132
query39 1450 1394 1385 1385
query40 205 127 106 106
query41 54 53 52 52
query42 122 102 106 102
query43 491 488 490 488
query44 1271 807 811 807
query45 182 177 169 169
query46 832 1033 628 628
query47 1746 1788 1709 1709
query48 373 412 300 300
query49 810 526 438 438
query50 619 694 417 417
query51 4133 4156 4111 4111
query52 111 111 102 102
query53 239 260 198 198
query54 583 587 509 509
query55 83 83 83 83
query56 344 295 291 291
query57 1159 1131 1041 1041
query58 258 259 244 244
query59 2504 2701 2538 2538
query60 333 342 300 300
query61 152 125 126 125
query62 764 714 682 682
query63 221 180 186 180
query64 4317 1008 650 650
query65 4357 4246 4228 4228
query66 1152 403 305 305
query67 15695 15478 15192 15192
query68 8500 880 511 511
query69 469 327 268 268
query70 1188 1090 1106 1090
query71 466 318 297 297
query72 5610 4661 4779 4661
query73 709 586 344 344
query74 8913 9065 8965 8965
query75 4019 3253 2692 2692
query76 3658 1192 765 765
query77 785 376 283 283
query78 10014 10369 9276 9276
query79 1207 867 566 566
query80 724 518 448 448
query81 466 254 218 218
query82 416 133 99 99
query83 285 259 233 233
query84 302 102 83 83
query85 771 386 322 322
query86 337 298 283 283
query87 4392 4429 4387 4387
query88 2815 2235 2263 2235
query89 387 309 286 286
query90 1982 216 223 216
query91 142 140 107 107
query92 78 61 59 59
query93 1092 943 580 580
query94 676 410 285 285
query95 371 286 289 286
query96 486 565 279 279
query97 3158 3229 3171 3171
query98 220 206 204 204
query99 1416 1399 1345 1345
Total cold run time: 271933 ms
Total hot run time: 185674 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2812767419
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813426371
<details>
<summary>TPC-H: <b>Total hot run time: 33957 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 4dd2550d06fed3d808df46e68eb7db8d4e287ee3, data reload: false
------ Round 1 ----------------------------------
q1 25734 5248 5037 5037
q2 2065 281 177 177
q3 10394 1266 674 674
q4 10225 1003 538 538
q5 7537 2379 2313 2313
q6 178 165 132 132
q7 894 728 626 626
q8 9339 1283 1060 1060
q9 6843 5074 5080 5074
q10 6841 2305 1868 1868
q11 476 278 256 256
q12 353 350 222 222
q13 17802 3703 3252 3252
q14 223 223 212 212
q15 542 481 491 481
q16 438 448 407 407
q17 580 854 349 349
q18 7435 7153 7115 7115
q19 1222 959 566 566
q20 339 339 211 211
q21 3918 3352 2395 2395
q22 1034 997 992 992
Total cold run time: 114412 ms
Total hot run time: 33957 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5103 5071 5070 5070
q2 239 339 227 227
q3 2163 2613 2294 2294
q4 1370 1775 1357 1357
q5 4390 4504 4403 4403
q6 217 165 123 123
q7 1971 1918 1764 1764
q8 2541 2590 2533 2533
q9 7212 7208 7000 7000
q10 3027 3160 2750 2750
q11 572 491 476 476
q12 685 785 628 628
q13 3536 3893 3261 3261
q14 274 299 291 291
q15 523 495 494 494
q16 476 507 457 457
q17 1120 1558 1393 1393
q18 7738 7488 7461 7461
q19 791 812 846 812
q20 1998 2040 1851 1851
q21 5134 4805 4835 4805
q22 1073 1075 1017 1017
Total cold run time: 52153 ms
Total hot run time: 50467 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2809454563
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2814704458
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 merged PR #50108:
URL: https://github.com/apache/doris/pull/50108
--
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2809509235
<details>
<summary>TPC-H: <b>Total hot run time: 34249 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 b4b053c8207a487c3c66d2f7b318aaa98419e539, data reload: false
------ Round 1 ----------------------------------
q1 25908 5690 5043 5043
q2 2070 284 188 188
q3 10378 1251 687 687
q4 10232 1005 546 546
q5 7518 2361 2405 2361
q6 186 167 131 131
q7 924 742 613 613
q8 9323 1281 1159 1159
q9 6764 5079 5064 5064
q10 6832 2314 1897 1897
q11 481 281 269 269
q12 360 382 226 226
q13 17778 3732 3125 3125
q14 232 232 214 214
q15 542 479 496 479
q16 459 447 406 406
q17 580 865 364 364
q18 7580 7340 7223 7223
q19 1230 981 582 582
q20 331 333 223 223
q21 3925 3377 2494 2494
q22 1065 1010 955 955
Total cold run time: 114698 ms
Total hot run time: 34249 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5147 5073 5122 5073
q2 250 344 235 235
q3 2142 2690 2313 2313
q4 1409 1804 1434 1434
q5 4512 4420 4381 4381
q6 214 171 128 128
q7 1993 1947 1737 1737
q8 2676 2537 2492 2492
q9 7104 7070 7216 7070
q10 2964 3202 2765 2765
q11 586 514 507 507
q12 665 809 583 583
q13 3485 3969 3243 3243
q14 286 312 284 284
q15 518 476 473 473
q16 462 509 469 469
q17 1151 1548 1427 1427
q18 7794 7600 7383 7383
q19 804 865 881 865
q20 1989 2002 1886 1886
q21 5320 4622 4659 4622
q22 1056 1014 993 993
Total cold run time: 52527 ms
Total hot run time: 50363 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2809455001
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2809553108
<details>
<summary>ClickBench: <b>Total hot run time: 29.63 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 b4b053c8207a487c3c66d2f7b318aaa98419e539, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.11 0.10
query3 0.27 0.20 0.20
query4 1.60 0.20 0.11
query5 0.56 0.57 0.56
query6 1.25 0.71 0.73
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.57 0.54 0.52
query10 0.59 0.58 0.56
query11 0.16 0.10 0.11
query12 0.15 0.12 0.11
query13 0.62 0.59 0.60
query14 1.16 1.16 1.15
query15 0.86 0.84 0.86
query16 0.38 0.37 0.38
query17 1.05 1.07 1.01
query18 0.22 0.20 0.20
query19 1.93 1.83 1.73
query20 0.01 0.01 0.01
query21 15.39 0.90 0.54
query22 0.75 1.18 0.96
query23 14.71 1.38 0.65
query24 7.42 1.37 0.80
query25 0.49 0.27 0.08
query26 0.45 0.17 0.14
query27 0.04 0.06 0.05
query28 9.84 0.82 0.45
query29 12.55 4.00 3.31
query30 0.25 0.09 0.07
query31 2.81 0.60 0.40
query32 3.23 0.55 0.47
query33 3.05 3.04 3.21
query34 15.68 5.08 4.44
query35 4.49 4.48 4.51
query36 0.66 0.49 0.48
query37 0.09 0.06 0.07
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.17 0.13 0.14
query41 0.08 0.03 0.02
query42 0.04 0.02 0.03
query43 0.04 0.03 0.03
Total cold run time: 103.91 s
Total hot run time: 29.63 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2812967350
<details>
<summary>TPC-H: <b>Total hot run time: 33722 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 601c869d349804d1eed605a30be5037dbae13e84, data reload: false
------ Round 1 ----------------------------------
q1 26024 5070 4995 4995
q2 2062 281 187 187
q3 10378 1238 701 701
q4 10222 985 540 540
q5 7535 2365 2328 2328
q6 183 166 130 130
q7 899 746 598 598
q8 9303 1277 1049 1049
q9 6754 5087 5092 5087
q10 6856 2298 1892 1892
q11 470 295 284 284
q12 339 347 219 219
q13 17776 3675 3049 3049
q14 225 224 209 209
q15 529 487 480 480
q16 441 442 392 392
q17 591 836 344 344
q18 7766 7232 7066 7066
q19 1607 940 540 540
q20 338 328 219 219
q21 3867 2613 2438 2438
q22 1040 1012 975 975
Total cold run time: 115205 ms
Total hot run time: 33722 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5135 5027 5082 5027
q2 240 329 226 226
q3 2107 2628 2338 2338
q4 1390 1801 1392 1392
q5 4391 4300 4368 4300
q6 232 170 124 124
q7 1958 1897 1795 1795
q8 2597 2593 2473 2473
q9 7245 7254 7022 7022
q10 3051 3185 2795 2795
q11 599 509 501 501
q12 665 765 623 623
q13 3479 3942 3318 3318
q14 268 297 270 270
q15 519 482 484 482
q16 476 512 462 462
q17 1155 1559 1380 1380
q18 7728 7719 7529 7529
q19 787 798 940 798
q20 1989 1999 1854 1854
q21 5128 4804 4752 4752
q22 1084 1048 1027 1027
Total cold run time: 52223 ms
Total hot run time: 50488 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813047923
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813015399
<details>
<summary>ClickBench: <b>Total hot run time: 29.27 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 601c869d349804d1eed605a30be5037dbae13e84, data reload: false
query1 0.03 0.04 0.03
query2 0.12 0.10 0.12
query3 0.24 0.20 0.19
query4 1.59 0.20 0.20
query5 0.61 0.58 0.58
query6 1.17 0.73 0.72
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.56 0.53 0.53
query10 0.57 0.58 0.58
query11 0.16 0.11 0.11
query12 0.15 0.10 0.11
query13 0.62 0.61 0.59
query14 1.16 1.18 1.16
query15 0.87 0.85 0.86
query16 0.40 0.38 0.41
query17 1.04 1.05 1.03
query18 0.21 0.19 0.19
query19 1.92 1.81 1.75
query20 0.01 0.01 0.02
query21 15.40 0.90 0.55
query22 0.75 1.26 0.65
query23 14.92 1.38 0.64
query24 7.25 1.72 0.52
query25 0.45 0.07 0.09
query26 0.64 0.17 0.13
query27 0.05 0.05 0.06
query28 9.02 0.84 0.42
query29 12.57 3.97 3.30
query30 0.24 0.09 0.07
query31 2.84 0.60 0.38
query32 3.22 0.54 0.46
query33 3.08 3.09 3.07
query34 15.78 5.08 4.48
query35 4.51 4.56 4.54
query36 0.66 0.50 0.49
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.02 0.02 0.02
query40 0.17 0.14 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 103.35 s
Total hot run time: 29.27 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813288165
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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2813463549
<details>
<summary>ClickBench: <b>Total hot run time: 29.56 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 4dd2550d06fed3d808df46e68eb7db8d4e287ee3, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.10 0.11
query3 0.26 0.20 0.18
query4 1.59 0.19 0.19
query5 0.60 0.60 0.60
query6 1.20 0.71 0.73
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.57 0.53 0.51
query10 0.56 0.58 0.57
query11 0.16 0.11 0.10
query12 0.16 0.12 0.12
query13 0.61 0.60 0.60
query14 1.16 1.16 1.17
query15 0.87 0.84 0.86
query16 0.38 0.38 0.38
query17 1.05 1.00 1.02
query18 0.21 0.20 0.20
query19 1.89 1.87 1.78
query20 0.01 0.01 0.01
query21 15.42 0.90 0.58
query22 0.79 1.24 0.67
query23 14.87 1.36 0.62
query24 6.68 1.28 0.81
query25 0.49 0.32 0.08
query26 0.53 0.17 0.15
query27 0.05 0.06 0.05
query28 9.52 0.88 0.44
query29 12.62 4.08 3.31
query30 0.24 0.08 0.06
query31 2.82 0.58 0.39
query32 3.22 0.55 0.48
query33 3.02 3.08 3.11
query34 15.73 5.07 4.44
query35 4.51 4.51 4.48
query36 0.66 0.49 0.48
query37 0.08 0.06 0.06
query38 0.05 0.04 0.03
query39 0.03 0.02 0.02
query40 0.17 0.13 0.12
query41 0.07 0.03 0.03
query42 0.03 0.02 0.03
query43 0.04 0.03 0.03
Total cold run time: 103.14 s
Total hot run time: 29.56 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] [Enhencement](datetime) Implicit conversion from DATE gets DATETIME(0) instead of DATETIME(6) [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #50108:
URL: https://github.com/apache/doris/pull/50108#issuecomment-2812876955
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