You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "cambyzju (via GitHub)" <gi...@apache.org> on 2025/04/11 08:16:59 UTC
[PR] [improve](schema) add column comment length limit [doris]
cambyzju opened a new pull request, #49989:
URL: https://github.com/apache/doris/pull/49989
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
1. add a config `column_comment_length_limit` to limit the max column comment length;
2. Mysql already enlarge this limit from 255 to 1024, after MySQL 5.5.3;
### 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] [improve](schema) add column comment length limit [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2803964185
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] [improve](schema) add column comment length limit [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2803964122
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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796628041
<details>
<summary>TPC-DS: <b>Total hot run time: 193187 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 b64e72b00da0e4d6d05875f34703d0e07e4ac4da, data reload: false
query1 1358 1097 1096 1096
query2 6147 1904 1903 1903
query3 11067 4577 4543 4543
query4 56173 25545 23368 23368
query5 4774 482 458 458
query6 368 202 192 192
query7 4952 492 274 274
query8 332 232 225 225
query9 6508 2583 2599 2583
query10 433 330 272 272
query11 15052 15048 14939 14939
query12 165 111 107 107
query13 1115 516 408 408
query14 10045 6374 6296 6296
query15 200 205 179 179
query16 7103 647 511 511
query17 1084 781 631 631
query18 1595 417 339 339
query19 208 201 172 172
query20 126 122 122 122
query21 216 137 111 111
query22 4474 4685 4187 4187
query23 34107 33819 33652 33652
query24 6545 2424 2409 2409
query25 454 471 405 405
query26 667 269 147 147
query27 2285 505 320 320
query28 3099 2443 2459 2443
query29 598 566 450 450
query30 280 222 197 197
query31 878 894 819 819
query32 71 64 62 62
query33 441 372 314 314
query34 787 871 519 519
query35 810 840 752 752
query36 974 1003 875 875
query37 117 101 74 74
query38 4152 4290 4182 4182
query39 1493 1423 1410 1410
query40 206 116 107 107
query41 54 51 52 51
query42 124 108 106 106
query43 498 508 470 470
query44 1289 807 800 800
query45 180 166 160 160
query46 825 1016 623 623
query47 1768 1798 1741 1741
query48 374 407 285 285
query49 712 495 427 427
query50 623 681 418 418
query51 4161 4144 4092 4092
query52 108 98 98 98
query53 221 266 188 188
query54 566 570 514 514
query55 81 83 83 83
query56 329 305 289 289
query57 1134 1155 1076 1076
query58 261 257 257 257
query59 2623 2615 2539 2539
query60 318 308 292 292
query61 131 125 124 124
query62 719 704 679 679
query63 226 185 185 185
query64 1488 1033 759 759
query65 4309 4236 4249 4236
query66 708 406 303 303
query67 15976 15602 15592 15592
query68 7677 875 504 504
query69 556 299 263 263
query70 1197 1118 1035 1035
query71 521 314 285 285
query72 5941 4746 4828 4746
query73 1374 642 357 357
query74 8992 9186 8890 8890
query75 3849 3178 2700 2700
query76 4342 1189 758 758
query77 647 373 284 284
query78 10512 10105 9337 9337
query79 2515 815 558 558
query80 669 498 431 431
query81 490 253 224 224
query82 524 127 100 100
query83 253 246 228 228
query84 306 97 81 81
query85 865 354 309 309
query86 397 294 280 280
query87 4408 4510 4395 4395
query88 3567 2249 2224 2224
query89 399 327 274 274
query90 1784 209 220 209
query91 139 146 117 117
query92 78 67 58 58
query93 2259 933 569 569
query94 668 416 364 364
query95 369 296 285 285
query96 485 562 275 275
query97 3228 3215 3151 3151
query98 238 210 207 207
query99 1449 1383 1249 1249
Total cold run time: 301963 ms
Total hot run time: 193187 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] [improve](schema) add column comment length limit [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on code in PR #49989:
URL: https://github.com/apache/doris/pull/49989#discussion_r2039163570
##########
fe/fe-common/src/main/java/org/apache/doris/common/Config.java:
##########
@@ -1765,6 +1765,12 @@ public class Config extends ConfigBase {
@ConfField(mutable = true, masterOnly = true)
public static int table_name_length_limit = 64;
+ @ConfField(mutable = true, description = {
+ "用于限制列注释长度；如果存量的列注释超长，则显示时进行截断",
+ "Used to limit the length of column comment; "
+ + "If the existing column comment is too long, it will be truncated when displayed."})
+ public static int column_comment_length_limit = 1024;
Review Comment:
good idea, done
--
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] [improve](schema) add column comment length limit [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on code in PR #49989:
URL: https://github.com/apache/doris/pull/49989#discussion_r2039163570
##########
fe/fe-common/src/main/java/org/apache/doris/common/Config.java:
##########
@@ -1765,6 +1765,12 @@ public class Config extends ConfigBase {
@ConfField(mutable = true, masterOnly = true)
public static int table_name_length_limit = 64;
+ @ConfField(mutable = true, description = {
+ "用于限制列注释长度；如果存量的列注释超长，则显示时进行截断",
+ "Used to limit the length of column comment; "
+ + "If the existing column comment is too long, it will be truncated when displayed."})
+ public static int column_comment_length_limit = 1024;
Review Comment:
good idea, I change it later
--
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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796644225
<details>
<summary>ClickBench: <b>Total hot run time: 30.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 b64e72b00da0e4d6d05875f34703d0e07e4ac4da, data reload: false
query1 0.05 0.03 0.03
query2 0.12 0.11 0.10
query3 0.27 0.19 0.20
query4 1.59 0.19 0.19
query5 0.62 0.56 0.61
query6 1.20 0.72 0.72
query7 0.02 0.02 0.01
query8 0.05 0.03 0.03
query9 0.56 0.52 0.50
query10 0.57 0.57 0.57
query11 0.16 0.10 0.10
query12 0.15 0.11 0.12
query13 0.61 0.60 0.60
query14 2.70 2.82 2.69
query15 0.92 0.86 0.85
query16 0.39 0.38 0.38
query17 1.04 1.00 1.02
query18 0.21 0.19 0.20
query19 1.86 1.84 1.86
query20 0.02 0.02 0.01
query21 15.37 0.88 0.56
query22 0.77 1.16 0.59
query23 15.05 1.38 0.61
query24 6.52 1.49 0.58
query25 0.48 0.18 0.06
query26 0.59 0.17 0.15
query27 0.05 0.05 0.05
query28 9.18 0.88 0.44
query29 12.57 3.99 3.33
query30 0.25 0.08 0.06
query31 2.83 0.58 0.37
query32 3.22 0.55 0.47
query33 3.06 3.06 3.05
query34 15.82 5.09 4.46
query35 4.53 4.53 4.52
query36 0.67 0.49 0.47
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.18 0.14 0.13
query41 0.09 0.02 0.02
query42 0.04 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 104.59 s
Total hot run time: 30.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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796543086
<details>
<summary>ClickBench: <b>Total hot run time: 31.23 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 bf4e408a5ac45238a0832ff9c49f0c54b4b4a601, data reload: false
query1 0.04 0.03 0.03
query2 0.13 0.11 0.11
query3 0.26 0.19 0.19
query4 1.59 0.20 0.19
query5 0.59 0.58 0.59
query6 1.19 0.72 0.71
query7 0.02 0.02 0.02
query8 0.04 0.04 0.03
query9 0.56 0.53 0.51
query10 0.58 0.56 0.57
query11 0.16 0.12 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.59
query14 2.80 2.70 2.69
query15 0.93 0.85 0.85
query16 0.39 0.37 0.40
query17 1.05 1.03 1.01
query18 0.21 0.20 0.19
query19 1.90 1.88 1.84
query20 0.01 0.02 0.01
query21 15.37 0.92 0.54
query22 0.77 1.24 0.71
query23 14.81 1.39 0.63
query24 7.17 1.04 0.82
query25 0.49 0.22 0.15
query26 0.57 0.16 0.15
query27 0.04 0.05 0.04
query28 9.70 0.85 0.43
query29 12.52 4.05 3.31
query30 0.24 0.09 0.05
query31 2.83 0.58 0.39
query32 3.23 0.54 0.47
query33 3.00 3.15 3.08
query34 15.75 5.07 4.49
query35 4.59 4.50 4.48
query36 0.66 0.49 0.48
query37 0.09 0.06 0.06
query38 0.06 0.04 0.03
query39 0.03 0.03 0.02
query40 0.18 0.13 0.13
query41 0.08 0.03 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 105.47 s
Total hot run time: 31.23 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] [improve](schema) add column comment length limit [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796558352
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] [improve](schema) add column comment length limit [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #49989:
URL: https://github.com/apache/doris/pull/49989#discussion_r2039049832
##########
fe/fe-common/src/main/java/org/apache/doris/common/Config.java:
##########
@@ -1765,6 +1765,12 @@ public class Config extends ConfigBase {
@ConfField(mutable = true, masterOnly = true)
public static int table_name_length_limit = 64;
+ @ConfField(mutable = true, description = {
+ "用于限制列注释长度；如果存量的列注释超长，则显示时进行截断",
+ "Used to limit the length of column comment; "
+ + "If the existing column comment is too long, it will be truncated when displayed."})
+ public static int column_comment_length_limit = 1024;
Review Comment:
maybe default value should be `-1` to avoid some ddl that could run on privous version, failed after upgrade
--
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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796602559
<details>
<summary>TPC-H: <b>Total hot run time: 34111 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 b64e72b00da0e4d6d05875f34703d0e07e4ac4da, data reload: false
------ Round 1 ----------------------------------
q1 26410 5130 5052 5052
q2 2075 279 188 188
q3 10470 1242 701 701
q4 10275 989 540 540
q5 8973 2371 2428 2371
q6 210 164 133 133
q7 907 755 608 608
q8 9311 1325 1112 1112
q9 6877 5107 5139 5107
q10 6822 2309 1877 1877
q11 495 287 274 274
q12 360 366 219 219
q13 17782 3666 3072 3072
q14 234 230 210 210
q15 537 487 481 481
q16 635 616 576 576
q17 591 879 356 356
q18 7811 7206 7036 7036
q19 1474 973 564 564
q20 319 331 217 217
q21 4065 2667 2449 2449
q22 1078 1016 968 968
Total cold run time: 117711 ms
Total hot run time: 34111 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5149 5079 5089 5079
q2 245 321 230 230
q3 2153 2651 2277 2277
q4 1452 1876 1485 1485
q5 4538 4423 4343 4343
q6 216 178 126 126
q7 1971 1970 1777 1777
q8 2670 2533 2460 2460
q9 7333 7257 7058 7058
q10 2976 3200 2725 2725
q11 582 508 492 492
q12 691 791 639 639
q13 3547 4017 3306 3306
q14 286 297 277 277
q15 521 490 475 475
q16 660 693 657 657
q17 1166 1499 1421 1421
q18 7863 7528 7236 7236
q19 836 792 874 792
q20 2000 2023 1915 1915
q21 5346 4958 4847 4847
q22 1094 1184 1036 1036
Total cold run time: 53295 ms
Total hot run time: 50653 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] [improve](schema) add column comment length limit [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju merged PR #49989:
URL: https://github.com/apache/doris/pull/49989
--
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] [improve](schema) add column comment length limit [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796182260
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] [improve](schema) add column comment length limit [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796400575
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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796532189
<details>
<summary>TPC-DS: <b>Total hot run time: 186489 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 bf4e408a5ac45238a0832ff9c49f0c54b4b4a601, data reload: false
query1 1022 499 507 499
query2 6531 1881 1894 1881
query3 6759 221 216 216
query4 26536 24188 23346 23346
query5 4751 631 469 469
query6 305 202 197 197
query7 4617 486 278 278
query8 311 256 250 250
query9 8673 2588 2613 2588
query10 487 316 271 271
query11 15347 15124 14910 14910
query12 162 110 110 110
query13 1654 512 387 387
query14 8668 6047 6134 6047
query15 199 181 178 178
query16 7264 625 482 482
query17 1185 727 583 583
query18 1991 402 323 323
query19 220 177 148 148
query20 116 115 117 115
query21 211 121 103 103
query22 4262 4256 4191 4191
query23 34082 33025 33104 33025
query24 8402 2353 2402 2353
query25 549 442 390 390
query26 1239 262 151 151
query27 2750 496 326 326
query28 4374 2407 2417 2407
query29 780 567 415 415
query30 294 218 190 190
query31 910 865 798 798
query32 72 61 58 58
query33 560 353 308 308
query34 784 871 502 502
query35 814 804 743 743
query36 946 994 863 863
query37 111 99 78 78
query38 4197 4222 4190 4190
query39 1451 1390 1401 1390
query40 215 114 107 107
query41 55 53 52 52
query42 117 106 111 106
query43 492 499 478 478
query44 1285 796 796 796
query45 180 172 170 170
query46 839 1027 608 608
query47 1800 1799 1738 1738
query48 371 422 293 293
query49 767 524 407 407
query50 627 679 394 394
query51 4104 4110 4147 4110
query52 107 101 103 101
query53 227 262 181 181
query54 579 571 503 503
query55 82 82 80 80
query56 307 308 298 298
query57 1132 1155 1057 1057
query58 261 263 249 249
query59 2551 2537 2555 2537
query60 323 319 295 295
query61 137 126 127 126
query62 812 723 651 651
query63 229 184 184 184
query64 4437 1026 684 684
query65 4318 4232 4240 4232
query66 1168 448 323 323
query67 15740 15606 15334 15334
query68 7872 898 522 522
query69 514 305 268 268
query70 1202 1099 1098 1098
query71 451 318 292 292
query72 5584 4688 4811 4688
query73 693 617 341 341
query74 9270 8813 8897 8813
query75 3784 3195 2690 2690
query76 3562 1179 754 754
query77 785 390 322 322
query78 10011 10046 9283 9283
query79 2611 808 559 559
query80 581 519 447 447
query81 499 264 221 221
query82 478 120 98 98
query83 287 265 255 255
query84 295 115 89 89
query85 789 368 324 324
query86 391 314 293 293
query87 4444 4475 4393 4393
query88 3534 2214 2193 2193
query89 394 311 278 278
query90 1848 207 211 207
query91 147 144 114 114
query92 83 60 58 58
query93 2066 938 572 572
query94 667 373 309 309
query95 371 290 285 285
query96 487 574 271 271
query97 3178 3204 3138 3138
query98 242 208 201 201
query99 1450 1443 1260 1260
Total cold run time: 275418 ms
Total hot run time: 186489 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] [improve](schema) add column comment length limit [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49989:
URL: https://github.com/apache/doris/pull/49989#issuecomment-2796502808
<details>
<summary>TPC-H: <b>Total hot run time: 34311 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 bf4e408a5ac45238a0832ff9c49f0c54b4b4a601, data reload: false
------ Round 1 ----------------------------------
q1 26367 5093 5016 5016
q2 2063 293 199 199
q3 10355 1253 726 726
q4 10229 1018 570 570
q5 7518 2464 2380 2380
q6 201 165 134 134
q7 935 768 624 624
q8 9339 1355 1130 1130
q9 6816 5146 5113 5113
q10 6815 2308 1863 1863
q11 474 286 276 276
q12 344 358 219 219
q13 17764 3685 3085 3085
q14 235 242 210 210
q15 522 502 486 486
q16 619 621 565 565
q17 575 852 357 357
q18 7493 7191 7080 7080
q19 1216 958 560 560
q20 341 322 216 216
q21 4468 3374 2496 2496
q22 1030 1022 1006 1006
Total cold run time: 115719 ms
Total hot run time: 34311 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5132 5070 5068 5068
q2 240 335 224 224
q3 2129 2674 2277 2277
q4 1446 1817 1508 1508
q5 4523 4509 4377 4377
q6 204 162 126 126
q7 1980 1897 1723 1723
q8 2610 2503 2548 2503
q9 7228 7156 7201 7156
q10 3033 3213 2735 2735
q11 576 502 501 501
q12 687 752 590 590
q13 3512 3803 3225 3225
q14 279 301 285 285
q15 525 485 483 483
q16 664 690 659 659
q17 1190 1601 1371 1371
q18 7733 7494 7441 7441
q19 811 833 882 833
q20 2020 1983 1805 1805
q21 5132 4770 4583 4583
q22 1059 1013 977 977
Total cold run time: 52713 ms
Total hot run time: 50450 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