You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "catpineapple (via GitHub)" <gi...@apache.org> on 2026/01/08 11:12:04 UTC
[PR] [fix](nereids) show columns type hide Column Version [doris]
catpineapple opened a new pull request, #59684:
URL: https://github.com/apache/doris/pull/59684
### What problem does this PR solve?
This update fixes an issue where the `SHOW FULL COLUMNS` statement still displayed `version` for `date`, `datetime`, and `decimal` data types. This change aims for better compatibility with MySQL behavior and BI applications.
```txt
MySQL [(none)]> SHOW FULL COLUMNS FROM `doris_all_types_demo` FROM `tpch`;
+---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
| col_09_decimal | decimal(10,2) | | YES | NO | NULL | NONE | | DECIMAL: exact decimal (precision, scale) |
| col_14_date | date | | YES | NO | NULL | NONE | | DATE: date format YYYY-MM-DD |
| col_15_datetime | datetime | | YES | NO | NULL | NONE | | DATETIME: datetime format YYYY-MM-DD HH:MM:SS |
| col_16_datetime_precision | datetime(3) | | YES | NO | NULL | NONE | | DATETIME(3): datetime with millisecond precision |
+---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
```
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] 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.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] 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] [fix](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728066097
<details>
<summary>TPC-H: <b>Total hot run time: 31826 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 a256adced53008ce73727361d10276c9ae2ed7f6, data reload: false
------ Round 1 ----------------------------------
q1 17632 4232 4019 4019
q2 2061 352 240 240
q3 10125 1271 756 756
q4 10219 863 315 315
q5 7538 2143 1825 1825
q6 188 170 140 140
q7 928 791 668 668
q8 9286 1452 1153 1153
q9 4833 4669 4456 4456
q10 6752 1844 1411 1411
q11 520 305 297 297
q12 688 758 601 601
q13 17826 3824 3085 3085
q14 290 299 269 269
q15 566 513 514 513
q16 685 686 640 640
q17 677 806 480 480
q18 6577 6467 6673 6467
q19 1184 1094 673 673
q20 417 417 256 256
q21 3291 2592 2503 2503
q22 1162 1114 1059 1059
Total cold run time: 103445 ms
Total hot run time: 31826 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4311 4371 4274 4274
q2 325 401 333 333
q3 2299 2748 2546 2546
q4 1400 1835 1440 1440
q5 4365 4327 4300 4300
q6 213 169 129 129
q7 2010 1963 1759 1759
q8 2709 2393 2351 2351
q9 6995 7365 7022 7022
q10 2506 2679 2303 2303
q11 539 451 474 451
q12 680 778 595 595
q13 3583 4128 3357 3357
q14 295 306 273 273
q15 513 489 516 489
q16 672 687 638 638
q17 1174 1317 1382 1317
q18 7436 7234 7239 7234
q19 815 779 784 779
q20 1888 1985 1785 1785
q21 4563 4187 4101 4101
q22 1115 1051 995 995
Total cold run time: 50406 ms
Total hot run time: 48471 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](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3748933616
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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742492048
<details>
<summary>TPC-H: <b>Total hot run time: 31021 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 80a3b1ac9395a9ded6fdb852e8c64d1824ced92a, data reload: false
------ Round 1 ----------------------------------
q1 17615 4220 4043 4043
q2 2097 357 247 247
q3 10210 1327 693 693
q4 10228 916 320 320
q5 7576 2022 1902 1902
q6 190 173 138 138
q7 912 796 659 659
q8 9272 1418 1165 1165
q9 4905 4558 4546 4546
q10 6801 1826 1425 1425
q11 536 295 269 269
q12 712 723 561 561
q13 17766 3885 3039 3039
q14 291 292 271 271
q15 598 531 498 498
q16 682 664 617 617
q17 650 812 460 460
q18 6620 6505 6225 6225
q19 1129 947 568 568
q20 370 342 254 254
q21 2968 2394 2157 2157
q22 1033 1010 964 964
Total cold run time: 103161 ms
Total hot run time: 31021 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4119 4019 4032 4019
q2 316 384 314 314
q3 2106 2618 2162 2162
q4 1333 1723 1341 1341
q5 4058 3930 3961 3930
q6 213 170 129 129
q7 1807 1793 1696 1696
q8 2798 2525 2416 2416
q9 7401 7120 7194 7120
q10 2456 2700 2340 2340
q11 562 478 466 466
q12 714 781 601 601
q13 3605 4002 3396 3396
q14 297 306 282 282
q15 555 578 525 525
q16 661 667 642 642
q17 1137 1345 1414 1345
q18 7950 7987 7693 7693
q19 892 865 829 829
q20 2086 2085 1854 1854
q21 4937 4247 4145 4145
q22 1089 1021 1016 1016
Total cold run time: 51092 ms
Total hot run time: 48261 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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749117596
<details>
<summary>TPC-DS: <b>Total hot run time: 172944 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 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
query5 4451 620 478 478
query6 341 230 223 223
query7 4244 461 268 268
query8 347 259 243 243
query9 8749 2881 2864 2864
query10 468 370 319 319
query11 15250 15203 14998 14998
query12 179 119 116 116
query13 1250 479 394 394
query14 6245 2997 2759 2759
query14_1 2669 2638 2682 2638
query15 206 192 178 178
query16 985 472 396 396
query17 1104 683 562 562
query18 2472 440 336 336
query19 224 227 219 219
query20 119 117 111 111
query21 215 140 117 117
query22 3974 3964 4014 3964
query23 16119 15576 15460 15460
query23_1 15626 15583 15552 15552
query24 7126 1535 1182 1182
query24_1 1175 1172 1162 1162
query25 553 477 431 431
query26 1234 268 161 161
query27 2747 445 275 275
query28 4562 2149 2129 2129
query29 795 545 449 449
query30 317 248 218 218
query31 769 655 574 574
query32 84 76 78 76
query33 577 349 300 300
query34 900 886 516 516
query35 720 751 666 666
query36 847 871 845 845
query37 128 95 89 89
query38 2713 2706 2604 2604
query39 764 755 740 740
query39_1 697 720 713 713
query40 215 136 121 121
query41 82 61 60 60
query42 104 99 97 97
query43 422 460 413 413
query44 1297 717 732 717
query45 182 182 172 172
query46 826 964 564 564
query47 1487 1468 1436 1436
query48 309 312 247 247
query49 613 421 360 360
query50 598 258 203 203
query51 3773 3792 3785 3785
query52 100 110 94 94
query53 283 316 268 268
query54 290 269 248 248
query55 85 79 77 77
query56 312 300 318 300
query57 1053 1044 958 958
query58 273 252 253 252
query59 2085 2178 2047 2047
query60 336 348 313 313
query61 153 154 153 153
query62 413 382 313 313
query63 297 258 267 258
query64 4976 1284 993 993
query65 3841 3765 3759 3759
query66 1453 426 324 324
query67 15272 15315 14848 14848
query68 5964 989 696 696
query69 518 356 325 325
query70 1037 966 890 890
query71 346 308 287 287
query72 5716 3237 2618 2618
query73 775 706 299 299
query74 8676 8727 8572 8572
query75 2805 2784 2441 2441
query76 3336 1059 656 656
query77 509 377 293 293
query78 9760 9732 9160 9160
query79 1731 898 563 563
query80 747 584 504 504
query81 550 261 235 235
query82 419 145 108 108
query83 276 259 238 238
query84 262 115 98 98
query85 920 533 474 474
query86 441 297 287 287
query87 2833 2840 2747 2747
query88 3464 2569 2572 2569
query89 380 350 323 323
query90 2021 167 164 164
query91 171 163 138 138
query92 79 77 73 73
query93 1545 912 520 520
query94 631 321 294 294
query95 581 384 326 326
query96 635 504 224 224
query97 2316 2394 2305 2305
query98 242 201 195 195
query99 582 603 519 519
Total cold run time: 252292 ms
Total hot run time: 172944 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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742546020
<details>
<summary>TPC-DS: <b>Total hot run time: 173235 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 80a3b1ac9395a9ded6fdb852e8c64d1824ced92a, data reload: false
query5 4431 642 476 476
query6 340 236 211 211
query7 4208 462 256 256
query8 355 258 254 254
query9 8709 2903 2886 2886
query10 518 375 350 350
query11 15245 15051 14838 14838
query12 173 120 117 117
query13 1261 498 399 399
query14 6439 3054 2781 2781
query14_1 2723 2734 2695 2695
query15 200 188 170 170
query16 970 499 462 462
query17 1073 650 549 549
query18 2558 422 320 320
query19 222 218 194 194
query20 127 116 117 116
query21 211 140 124 124
query22 3761 3998 3885 3885
query23 15912 15453 15421 15421
query23_1 15403 15514 15458 15458
query24 7128 1525 1185 1185
query24_1 1179 1142 1179 1142
query25 529 450 395 395
query26 1236 273 155 155
query27 2759 432 267 267
query28 4573 2137 2120 2120
query29 751 559 457 457
query30 321 243 216 216
query31 820 633 545 545
query32 93 80 78 78
query33 535 361 306 306
query34 921 884 526 526
query35 726 761 677 677
query36 892 890 787 787
query37 137 105 85 85
query38 2710 2688 2649 2649
query39 794 753 769 753
query39_1 719 722 701 701
query40 221 141 124 124
query41 78 68 100 68
query42 107 104 108 104
query43 497 478 392 392
query44 1354 731 727 727
query45 185 187 176 176
query46 837 953 590 590
query47 1424 1493 1394 1394
query48 301 324 238 238
query49 607 420 340 340
query50 613 312 195 195
query51 3813 3808 3733 3733
query52 104 115 99 99
query53 292 327 275 275
query54 285 263 265 263
query55 85 79 75 75
query56 304 306 311 306
query57 991 1000 907 907
query58 273 260 255 255
query59 2131 2191 1910 1910
query60 343 320 311 311
query61 158 153 158 153
query62 374 353 328 328
query63 302 276 274 274
query64 4892 1293 982 982
query65 3798 3737 3779 3737
query66 1420 430 326 326
query67 15259 14829 15499 14829
query68 2787 1006 744 744
query69 464 353 323 323
query70 990 950 920 920
query71 326 314 293 293
query72 5946 3379 3627 3379
query73 585 732 309 309
query74 8816 8791 8551 8551
query75 2764 2815 2476 2476
query76 2644 1069 666 666
query77 530 412 331 331
query78 9603 9921 9170 9170
query79 917 918 563 563
query80 653 594 524 524
query81 504 264 238 238
query82 327 151 116 116
query83 280 266 247 247
query84 256 124 96 96
query85 1004 522 482 482
query86 343 291 292 291
query87 2843 2853 2777 2777
query88 2989 2143 2121 2121
query89 387 360 336 336
query90 1970 175 167 167
query91 173 165 141 141
query92 73 76 67 67
query93 941 895 538 538
query94 581 336 308 308
query95 576 336 372 336
query96 574 509 201 201
query97 2360 2375 2296 2296
query98 212 199 200 199
query99 588 561 482 482
Total cold run time: 245514 ms
Total hot run time: 173235 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](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770818207
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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749136608
<details>
<summary>ClickBench: <b>Total hot run time: 26.75 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 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.08 0.09
query4 1.60 0.12 0.12
query5 0.28 0.26 0.27
query6 1.16 0.66 0.66
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.56 0.51 0.51
query10 0.55 0.55 0.55
query11 0.14 0.09 0.11
query12 0.14 0.11 0.11
query13 0.61 0.58 0.58
query14 0.95 0.95 0.94
query15 0.79 0.78 0.79
query16 0.40 0.39 0.39
query17 1.05 1.06 0.99
query18 0.22 0.20 0.20
query19 1.96 1.82 1.87
query20 0.05 0.02 0.01
query21 15.43 0.24 0.14
query22 5.16 0.06 0.05
query23 15.97 0.28 0.10
query24 1.40 0.50 0.22
query25 0.08 0.08 0.09
query26 0.15 0.13 0.14
query27 0.09 0.05 0.08
query28 4.09 1.08 0.88
query29 12.53 3.85 3.15
query30 0.28 0.15 0.12
query31 2.82 0.65 0.40
query32 3.25 0.55 0.45
query33 3.02 3.02 3.02
query34 15.92 5.14 4.45
query35 4.45 4.44 4.46
query36 0.66 0.50 0.48
query37 0.11 0.06 0.07
query38 0.08 0.03 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.13
query41 0.08 0.04 0.03
query42 0.05 0.03 0.03
query43 0.05 0.03 0.04
Total cold run time: 96.83 s
Total hot run time: 26.75 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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770912265
<details>
<summary>TPC-DS: <b>Total hot run time: 174023 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 f06505305ef125755265835e28d064f6476fe03e, data reload: false
query5 4951 608 474 474
query6 335 237 219 219
query7 4222 464 267 267
query8 344 259 242 242
query9 8780 2919 2853 2853
query10 544 398 349 349
query11 15298 15115 14879 14879
query12 193 115 121 115
query13 1251 508 374 374
query14 6719 3014 2763 2763
query14_1 2677 2727 2628 2628
query15 203 193 169 169
query16 987 511 479 479
query17 1086 622 535 535
query18 2680 420 319 319
query19 218 214 183 183
query20 123 115 108 108
query21 209 131 114 114
query22 3971 4201 3951 3951
query23 16148 15627 15437 15437
query23_1 15445 15458 15354 15354
query24 7116 1538 1166 1166
query24_1 1172 1148 1155 1148
query25 502 413 388 388
query26 1235 274 148 148
query27 2751 442 279 279
query28 4545 2184 2163 2163
query29 790 496 413 413
query30 305 238 204 204
query31 779 604 567 567
query32 79 76 72 72
query33 522 336 313 313
query34 898 886 532 532
query35 724 764 682 682
query36 896 914 835 835
query37 137 98 91 91
query38 2654 2748 2613 2613
query39 794 760 752 752
query39_1 721 715 725 715
query40 217 132 116 116
query41 64 61 62 61
query42 101 102 97 97
query43 432 437 406 406
query44 1309 747 752 747
query45 183 183 176 176
query46 826 936 576 576
query47 1441 1462 1458 1458
query48 304 326 236 236
query49 604 426 337 337
query50 616 260 197 197
query51 3749 3750 3803 3750
query52 106 107 92 92
query53 289 313 269 269
query54 304 291 280 280
query55 81 79 78 78
query56 301 296 322 296
query57 1033 1019 885 885
query58 266 249 262 249
query59 2156 2223 2051 2051
query60 333 327 301 301
query61 147 145 143 143
query62 377 354 309 309
query63 308 268 266 266
query64 4913 1259 968 968
query65 3812 3751 3713 3713
query66 1383 418 323 323
query67 15380 15550 15470 15470
query68 2342 1100 778 778
query69 450 359 365 359
query70 971 907 946 907
query71 326 312 287 287
query72 5271 3352 3284 3284
query73 603 719 317 317
query74 8675 8778 8580 8580
query75 2774 2828 2447 2447
query76 2291 1053 647 647
query77 370 404 307 307
query78 9820 9752 9237 9237
query79 1053 902 572 572
query80 815 597 525 525
query81 501 259 238 238
query82 1347 147 112 112
query83 356 245 236 236
query84 248 109 90 90
query85 867 512 411 411
query86 363 296 315 296
query87 2852 2823 2768 2768
query88 3476 2579 2554 2554
query89 386 346 313 313
query90 1853 172 164 164
query91 159 160 127 127
query92 72 76 72 72
query93 938 900 540 540
query94 593 332 292 292
query95 581 399 314 314
query96 668 505 231 231
query97 2372 2387 2319 2319
query98 202 203 202 202
query99 608 603 536 536
Total cold run time: 248034 ms
Total hot run time: 174023 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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728110934
<details>
<summary>TPC-DS: <b>Total hot run time: 172961 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 a256adced53008ce73727361d10276c9ae2ed7f6, data reload: false
query5 5323 593 435 435
query6 335 220 200 200
query7 4240 450 266 266
query8 343 244 228 228
query9 8773 2656 2610 2610
query10 555 364 346 346
query11 15142 15092 14844 14844
query12 193 112 118 112
query13 1276 507 362 362
query14 7082 3100 2730 2730
query14_1 2637 2618 2655 2618
query15 200 193 173 173
query16 986 462 440 440
query17 1113 659 567 567
query18 2702 434 328 328
query19 229 238 198 198
query20 125 116 116 116
query21 225 141 121 121
query22 3816 3998 3805 3805
query23 15994 15648 15403 15403
query23_1 15311 15675 15433 15433
query24 7178 1547 1159 1159
query24_1 1189 1172 1189 1172
query25 524 453 389 389
query26 1243 260 151 151
query27 2776 458 283 283
query28 4576 2130 2092 2092
query29 766 531 427 427
query30 307 234 208 208
query31 814 633 535 535
query32 74 68 65 65
query33 535 322 279 279
query34 893 880 513 513
query35 752 778 698 698
query36 874 869 884 869
query37 127 105 83 83
query38 2732 2712 2672 2672
query39 773 760 730 730
query39_1 718 718 718 718
query40 218 130 118 118
query41 68 63 64 63
query42 105 101 103 101
query43 435 447 412 412
query44 1327 719 714 714
query45 186 184 173 173
query46 850 951 576 576
query47 1409 1438 1363 1363
query48 310 324 244 244
query49 605 421 334 334
query50 637 298 205 205
query51 3770 3750 3738 3738
query52 109 107 96 96
query53 294 333 282 282
query54 280 255 240 240
query55 77 75 72 72
query56 301 290 295 290
query57 1033 1033 972 972
query58 265 252 250 250
query59 2150 2166 1993 1993
query60 325 311 303 303
query61 165 156 169 156
query62 383 376 337 337
query63 298 276 274 274
query64 4989 1406 1097 1097
query65 3795 3720 3752 3720
query66 1396 430 321 321
query67 15582 15658 15358 15358
query68 2750 1013 754 754
query69 474 363 320 320
query70 1008 971 938 938
query71 327 300 283 283
query72 6386 3591 3429 3429
query73 586 725 301 301
query74 8792 8758 8613 8613
query75 2750 2801 2445 2445
query76 2880 1070 645 645
query77 346 378 272 272
query78 9822 10013 9162 9162
query79 1040 918 606 606
query80 1163 595 488 488
query81 576 261 234 234
query82 419 152 112 112
query83 366 253 237 237
query84 264 115 102 102
query85 943 512 454 454
query86 434 319 320 319
query87 2877 2904 2753 2753
query88 3251 2240 2233 2233
query89 387 333 333 333
query90 1989 156 141 141
query91 168 164 141 141
query92 72 68 64 64
query93 1097 911 528 528
query94 667 330 291 291
query95 604 381 302 302
query96 601 474 217 217
query97 2376 2364 2302 2302
query98 209 205 198 198
query99 581 590 513 513
Total cold run time: 250053 ms
Total hot run time: 172961 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](nereids) show columns type hide Column Version [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749215398
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/2)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_7696ecc58116fee112e99948b0d658a9961d4953/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_7696ecc58116fee112e99948b0d658a9961d4953/fe_report/index.html)
--
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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770924821
<details>
<summary>ClickBench: <b>Total hot run time: 26.5 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 f06505305ef125755265835e28d064f6476fe03e, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.04 0.04
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.28 0.25 0.25
query6 1.14 0.67 0.65
query7 0.03 0.02 0.03
query8 0.05 0.04 0.04
query9 0.55 0.51 0.51
query10 0.55 0.54 0.55
query11 0.13 0.10 0.10
query12 0.14 0.11 0.10
query13 0.59 0.59 0.59
query14 0.96 0.93 0.94
query15 0.80 0.76 0.77
query16 0.40 0.41 0.41
query17 0.99 1.00 1.02
query18 0.22 0.21 0.21
query19 1.92 1.73 1.78
query20 0.05 0.01 0.02
query21 15.43 0.26 0.15
query22 5.21 0.06 0.04
query23 16.08 0.28 0.10
query24 0.93 0.57 0.18
query25 0.13 0.09 0.08
query26 0.14 0.13 0.13
query27 0.09 0.05 0.05
query28 3.73 1.07 0.89
query29 12.57 3.90 3.11
query30 0.27 0.14 0.12
query31 2.83 0.64 0.40
query32 3.24 0.56 0.47
query33 2.99 3.04 2.97
query34 16.22 5.10 4.42
query35 4.52 4.42 4.50
query36 0.65 0.50 0.49
query37 0.10 0.06 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.17 0.15 0.14
query41 0.09 0.04 0.03
query42 0.04 0.03 0.02
query43 0.05 0.04 0.03
Total cold run time: 96.42 s
Total hot run time: 26.5 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](nereids) show columns type hide Column Version [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771194852
# FE Regression Coverage Report
Increment line coverage ` 100.00% (2/2)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e_merge_fe/report/index.html)
--
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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749080339
<details>
<summary>TPC-H: <b>Total hot run time: 31318 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 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
------ Round 1 ----------------------------------
q1 17615 4230 4042 4042
q2 2069 347 227 227
q3 10153 1253 694 694
q4 10227 898 303 303
q5 7558 2104 1797 1797
q6 187 179 140 140
q7 930 763 645 645
q8 9259 1409 1126 1126
q9 4839 4522 4527 4522
q10 6766 1778 1405 1405
q11 520 299 278 278
q12 687 733 603 603
q13 17793 3800 3085 3085
q14 285 303 276 276
q15 584 512 505 505
q16 689 690 640 640
q17 646 781 483 483
q18 6601 6487 6523 6487
q19 1125 973 593 593
q20 397 360 242 242
q21 2944 2426 2256 2256
q22 1045 1022 969 969
Total cold run time: 102919 ms
Total hot run time: 31318 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4078 4035 4009 4009
q2 330 414 336 336
q3 2058 2557 2223 2223
q4 1286 1758 1344 1344
q5 4188 3998 4035 3998
q6 222 168 129 129
q7 1931 1828 1630 1630
q8 2820 2505 2495 2495
q9 7311 7184 7091 7091
q10 2561 2748 2395 2395
q11 594 488 447 447
q12 709 766 663 663
q13 3589 4076 3504 3504
q14 298 301 278 278
q15 533 517 509 509
q16 643 672 628 628
q17 1150 1347 1567 1347
q18 8104 7682 7947 7682
q19 877 824 828 824
q20 2007 2122 1915 1915
q21 4512 4223 4177 4177
q22 1076 1059 986 986
Total cold run time: 50877 ms
Total hot run time: 48610 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](nereids) show columns type hide Column Version [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770988431
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/2)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e/fe_report/index.html)
--
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](nereids) show columns type hide Column Version [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771538705
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](nereids) show columns type hide Column Version [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3723386402
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] [fix](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple merged PR #59684:
URL: https://github.com/apache/doris/pull/59684
--
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](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770817697
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](nereids) show columns type hide Column Version [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770880666
<details>
<summary>TPC-H: <b>Total hot run time: 31291 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 f06505305ef125755265835e28d064f6476fe03e, data reload: false
------ Round 1 ----------------------------------
q1 17616 4254 4046 4046
q2 2139 381 239 239
q3 10070 1271 713 713
q4 10192 795 313 313
q5 7524 2110 1817 1817
q6 195 171 137 137
q7 922 791 647 647
q8 9272 1369 1111 1111
q9 4863 4659 4544 4544
q10 6726 1807 1404 1404
q11 499 298 288 288
q12 680 744 603 603
q13 17787 3777 3117 3117
q14 296 295 277 277
q15 609 512 511 511
q16 691 689 635 635
q17 648 763 587 587
q18 6724 6240 6324 6240
q19 1237 979 592 592
q20 400 361 251 251
q21 2990 2508 2254 2254
q22 1066 1022 965 965
Total cold run time: 103146 ms
Total hot run time: 31291 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4125 4058 4043 4043
q2 333 376 333 333
q3 2135 2607 2229 2229
q4 1361 1763 1319 1319
q5 4111 3977 4017 3977
q6 213 174 131 131
q7 1841 1792 1673 1673
q8 2787 2491 2581 2491
q9 7302 7196 7197 7196
q10 2745 2755 2278 2278
q11 564 539 449 449
q12 710 791 648 648
q13 3631 3977 3336 3336
q14 290 296 290 290
q15 539 513 495 495
q16 664 680 633 633
q17 1224 1303 1488 1303
q18 8184 7944 7913 7913
q19 891 819 807 807
q20 2054 2048 2021 2021
q21 4749 4691 4444 4444
q22 1056 1052 972 972
Total cold run time: 51509 ms
Total hot run time: 48981 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](nereids) show columns type hide Column Version [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771538822
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](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742321711
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](nereids) show columns type hide Column Version [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728282861
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/1)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_a256adced53008ce73727361d10276c9ae2ed7f6/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_a256adced53008ce73727361d10276c9ae2ed7f6/fe_report/index.html)
--
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](nereids) show columns type hide Column Version [doris]
Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3727956263
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