You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "DongLiang-0 (via GitHub)" <gi...@apache.org> on 2024/03/26 09:58:06 UTC
[PR] [fix](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be deleted [doris]
DongLiang-0 opened a new pull request, #32843:
URL: https://github.com/apache/doris/pull/32843
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 closed pull request #32843: [fix](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped
URL: https://github.com/apache/doris/pull/32843
--
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2020108629
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a33d60f34af1f1a7c1462cdea00c2941f666b897 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 20.1 seconds inserted 10000000 Rows, about 497K ops/s
```
--
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021841465
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2022072800
<details>
<summary>TPC-DS: <b>Total hot run time: 181263 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 ce94cc6347fc6c5f462f63789d51456ea9a81fcb, data reload: false
query1 935 367 350 350
query2 6562 1912 1976 1912
query3 6709 223 221 221
query4 31796 21533 21296 21296
query5 4294 404 394 394
query6 272 192 173 173
query7 4620 287 283 283
query8 232 174 172 172
query9 9289 2261 2270 2261
query10 573 252 249 249
query11 15440 14349 14354 14349
query12 138 90 89 89
query13 1626 431 432 431
query14 11127 7069 7611 7069
query15 254 187 188 187
query16 8142 255 261 255
query17 1940 578 527 527
query18 2076 286 273 273
query19 308 147 148 147
query20 90 87 90 87
query21 196 124 124 124
query22 4957 4792 4751 4751
query23 33394 33033 32801 32801
query24 10796 2817 2890 2817
query25 616 400 392 392
query26 1606 159 150 150
query27 2980 358 365 358
query28 7764 1902 1887 1887
query29 954 637 629 629
query30 306 147 148 147
query31 982 722 760 722
query32 96 57 56 56
query33 770 258 252 252
query34 1067 486 491 486
query35 854 609 612 609
query36 1021 902 910 902
query37 111 66 62 62
query38 3573 3468 3452 3452
query39 1571 1437 1442 1437
query40 227 118 116 116
query41 51 50 48 48
query42 104 100 93 93
query43 491 454 459 454
query44 1196 749 728 728
query45 259 265 271 265
query46 1124 700 708 700
query47 1947 1835 1864 1835
query48 447 367 363 363
query49 1200 336 346 336
query50 760 375 372 372
query51 6660 6642 6623 6623
query52 113 91 96 91
query53 343 278 274 274
query54 340 249 232 232
query55 95 83 86 83
query56 255 241 233 233
query57 1231 1146 1148 1146
query58 238 206 212 206
query59 2756 2649 2469 2469
query60 265 248 259 248
query61 115 115 113 113
query62 677 449 451 449
query63 304 277 271 271
query64 7068 4113 4018 4018
query65 3149 3026 3044 3026
query66 1446 390 370 370
query67 15809 14896 14858 14858
query68 7094 549 539 539
query69 634 389 397 389
query70 1242 1137 1181 1137
query71 502 275 271 271
query72 6802 2729 2526 2526
query73 717 322 330 322
query74 7910 6415 6389 6389
query75 3507 2225 2167 2167
query76 4832 926 869 869
query77 635 263 250 250
query78 10927 10208 10128 10128
query79 8193 531 529 529
query80 1366 406 373 373
query81 533 221 224 221
query82 895 86 86 86
query83 205 147 144 144
query84 285 82 80 80
query85 1509 328 318 318
query86 477 312 312 312
query87 3725 3519 3515 3515
query88 4923 2361 2357 2357
query89 520 377 371 371
query90 2010 177 173 173
query91 171 135 139 135
query92 63 47 47 47
query93 6797 517 489 489
query94 1147 174 177 174
query95 438 333 329 329
query96 622 268 272 268
query97 2636 2540 2473 2473
query98 232 216 206 206
query99 1236 926 897 897
Total cold run time: 311492 ms
Total hot run time: 181263 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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2020102343
<details>
<summary>TPC-DS: <b>Total hot run time: 181808 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 a33d60f34af1f1a7c1462cdea00c2941f666b897, data reload: false
query1 936 366 348 348
query2 6527 1961 1917 1917
query3 6715 230 238 230
query4 31831 21341 21435 21341
query5 4304 415 396 396
query6 273 177 184 177
query7 4637 301 300 300
query8 227 170 182 170
query9 9001 2252 2224 2224
query10 565 240 251 240
query11 14752 14236 14244 14236
query12 136 89 89 89
query13 1627 419 415 415
query14 9649 7642 7881 7642
query15 265 194 212 194
query16 8107 273 263 263
query17 1948 589 558 558
query18 2072 296 285 285
query19 251 159 166 159
query20 96 89 92 89
query21 202 127 126 126
query22 5004 4913 4768 4768
query23 33636 32930 32727 32727
query24 11131 2846 2901 2846
query25 642 395 413 395
query26 1201 166 165 165
query27 3019 353 355 353
query28 7748 1881 1870 1870
query29 922 680 634 634
query30 299 149 142 142
query31 971 726 717 717
query32 94 58 57 57
query33 762 248 251 248
query34 1020 484 504 484
query35 819 619 618 618
query36 1025 896 886 886
query37 116 61 65 61
query38 3544 3454 3494 3454
query39 1507 1454 1402 1402
query40 204 114 114 114
query41 52 47 45 45
query42 103 96 93 93
query43 481 459 463 459
query44 1103 730 725 725
query45 268 248 251 248
query46 1104 691 700 691
query47 1919 1855 1830 1830
query48 444 360 355 355
query49 1112 324 329 324
query50 763 374 378 374
query51 6807 6522 6540 6522
query52 111 93 94 93
query53 342 281 275 275
query54 286 236 235 235
query55 90 79 82 79
query56 243 220 218 218
query57 1203 1137 1139 1137
query58 225 205 206 205
query59 2774 2638 2491 2491
query60 283 239 247 239
query61 97 95 95 95
query62 665 458 444 444
query63 310 282 285 282
query64 5762 4071 4071 4071
query65 3100 3069 3058 3058
query66 950 385 380 380
query67 15006 15227 14699 14699
query68 5349 518 526 518
query69 582 403 385 385
query70 1182 1230 1195 1195
query71 434 278 277 277
query72 6489 2875 2698 2698
query73 700 333 323 323
query74 7662 6444 6493 6444
query75 2982 2230 2194 2194
query76 3318 885 902 885
query77 628 269 273 269
query78 10840 10106 10293 10106
query79 8546 543 544 543
query80 1557 378 371 371
query81 528 215 222 215
query82 815 86 86 86
query83 204 142 143 142
query84 288 81 79 79
query85 1462 319 316 316
query86 428 305 297 297
query87 3773 3496 3509 3496
query88 5156 2378 2377 2377
query89 520 381 367 367
query90 1967 180 181 180
query91 170 139 141 139
query92 59 50 48 48
query93 6750 499 484 484
query94 1148 180 176 176
query95 443 341 333 333
query96 616 278 268 268
query97 2681 2479 2477 2477
query98 225 219 212 212
query99 1208 901 911 901
Total cold run time: 302098 ms
Total hot run time: 181808 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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2022033904
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2020003797
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2022082041
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ce94cc6347fc6c5f462f63789d51456ea9a81fcb with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.8 seconds inserted 10000000 Rows, about 724K ops/s
```
--
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2022061196
<details>
<summary>TPC-H: <b>Total hot run time: 38330 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 ce94cc6347fc6c5f462f63789d51456ea9a81fcb, data reload: false
------ Round 1 ----------------------------------
q1 18303 4188 4129 4129
q2 2110 156 155 155
q3 10580 1129 1201 1129
q4 10834 803 791 791
q5 8240 3001 3021 3001
q6 202 125 122 122
q7 1032 609 567 567
q8 9339 2010 1986 1986
q9 8792 6751 6688 6688
q10 8740 3668 3723 3668
q11 440 240 234 234
q12 461 215 206 206
q13 18661 2850 2909 2850
q14 252 203 217 203
q15 537 481 487 481
q16 730 395 391 391
q17 1388 549 558 549
q18 7751 6469 6554 6469
q19 5747 1387 1368 1368
q20 547 253 261 253
q21 3529 2803 2930 2803
q22 359 296 287 287
Total cold run time: 118574 ms
Total hot run time: 38330 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4137 4089 4031 4031
q2 325 226 227 226
q3 2951 2866 2840 2840
q4 1796 1615 1546 1546
q5 5335 5342 5311 5311
q6 201 115 117 115
q7 2275 1844 1875 1844
q8 3132 3244 3256 3244
q9 8679 8669 8738 8669
q10 3751 3768 3816 3768
q11 541 446 435 435
q12 697 570 537 537
q13 16938 2839 2852 2839
q14 270 256 258 256
q15 495 463 462 462
q16 465 436 420 420
q17 1712 1460 1435 1435
q18 7425 7052 7039 7039
q19 1595 1537 1548 1537
q20 1888 1708 1692 1692
q21 4842 4606 4709 4606
q22 515 450 454 450
Total cold run time: 69965 ms
Total hot run time: 53302 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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be deleted [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2019989979
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021878281
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 1caaeeb4801441cb252e8cb82807e51e21f61c75 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.8 seconds inserted 10000000 Rows, about 724K ops/s
```
--
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021820186
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "DongLiang-0 (via GitHub)" <gi...@apache.org>.
DongLiang-0 commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021819637
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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021872111
<details>
<summary>TPC-DS: <b>Total hot run time: 181945 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 1caaeeb4801441cb252e8cb82807e51e21f61c75, data reload: false
query1 942 367 362 362
query2 6528 1941 1860 1860
query3 6717 220 227 220
query4 31752 21567 21282 21282
query5 4323 408 401 401
query6 273 182 189 182
query7 4621 293 293 293
query8 225 170 172 170
query9 9274 2276 2284 2276
query10 574 252 274 252
query11 15440 14140 14355 14140
query12 144 102 84 84
query13 1606 422 427 422
query14 9954 7649 7514 7514
query15 233 220 201 201
query16 8037 273 268 268
query17 1937 578 561 561
query18 2008 301 290 290
query19 236 167 165 165
query20 93 89 89 89
query21 200 134 127 127
query22 4940 4793 4789 4789
query23 33406 32956 33037 32956
query24 10914 2905 2908 2905
query25 639 391 395 391
query26 1371 159 170 159
query27 3057 359 358 358
query28 7709 1894 1863 1863
query29 959 657 627 627
query30 300 151 152 151
query31 994 740 738 738
query32 103 60 60 60
query33 788 279 265 265
query34 1056 495 496 495
query35 857 626 615 615
query36 1003 886 892 886
query37 117 69 68 68
query38 3556 3454 3423 3423
query39 1504 1483 1429 1429
query40 213 116 112 112
query41 52 47 49 47
query42 111 98 100 98
query43 490 437 460 437
query44 1184 741 752 741
query45 274 255 257 255
query46 1116 730 722 722
query47 1909 1827 1842 1827
query48 453 368 363 363
query49 1120 334 331 331
query50 754 375 380 375
query51 6768 6662 6518 6518
query52 118 94 96 94
query53 348 279 276 276
query54 287 231 237 231
query55 93 80 81 80
query56 249 221 223 221
query57 1216 1130 1136 1130
query58 224 205 205 205
query59 2765 2591 2598 2591
query60 266 259 250 250
query61 97 95 94 94
query62 671 454 466 454
query63 315 277 278 277
query64 5837 3966 4033 3966
query65 3149 3029 3028 3028
query66 1128 374 359 359
query67 15211 15072 14849 14849
query68 5394 529 534 529
query69 583 384 383 383
query70 1225 1095 1212 1095
query71 405 272 267 267
query72 6266 2830 2706 2706
query73 717 332 333 332
query74 7667 6513 6423 6423
query75 2971 2245 2216 2216
query76 3552 874 896 874
query77 405 284 270 270
query78 10747 10025 10133 10025
query79 7864 544 552 544
query80 1413 389 390 389
query81 529 239 228 228
query82 899 91 92 91
query83 212 159 153 153
query84 298 82 85 82
query85 1536 389 313 313
query86 461 319 288 288
query87 3740 3495 3590 3495
query88 5143 2421 2387 2387
query89 508 374 369 369
query90 1998 180 176 176
query91 165 142 137 137
query92 66 51 48 48
query93 6085 508 497 497
query94 1168 178 177 177
query95 433 337 327 327
query96 605 281 272 272
query97 2678 2462 2479 2462
query98 232 216 213 213
query99 1239 909 917 909
Total cold run time: 302012 ms
Total hot run time: 181945 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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2020076235
<details>
<summary>TPC-H: <b>Total hot run time: 38145 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 a33d60f34af1f1a7c1462cdea00c2941f666b897, data reload: false
------ Round 1 ----------------------------------
q1 17973 4189 4113 4113
q2 2113 157 152 152
q3 10576 1146 1205 1146
q4 10972 796 828 796
q5 7992 3057 2965 2965
q6 209 127 125 125
q7 1064 621 606 606
q8 9440 2049 2027 2027
q9 8972 6731 6691 6691
q10 8642 3479 3645 3479
q11 1332 235 227 227
q12 716 203 200 200
q13 19392 2909 2892 2892
q14 226 218 218 218
q15 508 468 459 459
q16 496 373 379 373
q17 943 531 618 531
q18 7146 6463 6353 6353
q19 3396 1431 1377 1377
q20 545 251 268 251
q21 3675 3057 2862 2862
q22 349 308 302 302
Total cold run time: 116677 ms
Total hot run time: 38145 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4121 4069 4063 4063
q2 337 233 230 230
q3 2955 2835 2869 2835
q4 1854 1586 1580 1580
q5 5280 5297 5342 5297
q6 191 116 119 116
q7 2237 1861 1859 1859
q8 3153 3298 3288 3288
q9 8723 8625 8655 8625
q10 3742 3800 3713 3713
q11 579 440 447 440
q12 743 543 547 543
q13 16926 2878 2856 2856
q14 279 253 255 253
q15 506 451 459 451
q16 472 429 423 423
q17 1729 1466 1463 1463
q18 7383 7110 6974 6974
q19 1596 1464 1524 1464
q20 1890 1724 1717 1717
q21 4924 4788 4836 4788
q22 569 469 467 467
Total cold run time: 70189 ms
Total hot run time: 53445 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](schema-change)Fix the light-schema-change api's incorrect judgment on whether the current column can be dropped [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32843:
URL: https://github.com/apache/doris/pull/32843#issuecomment-2021863744
<details>
<summary>TPC-H: <b>Total hot run time: 37854 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 1caaeeb4801441cb252e8cb82807e51e21f61c75, data reload: false
------ Round 1 ----------------------------------
q1 17628 4294 4091 4091
q2 2115 159 155 155
q3 10648 1186 1196 1186
q4 10249 811 779 779
q5 7466 3015 2974 2974
q6 205 127 124 124
q7 1022 592 582 582
q8 9331 1978 1999 1978
q9 7093 6613 6567 6567
q10 8439 3422 3556 3422
q11 433 229 219 219
q12 397 204 198 198
q13 17799 2838 2833 2833
q14 228 215 224 215
q15 508 448 456 448
q16 497 382 376 376
q17 940 533 584 533
q18 7120 6411 6408 6408
q19 1894 1429 1493 1429
q20 538 252 265 252
q21 3548 2914 2794 2794
q22 345 304 291 291
Total cold run time: 108443 ms
Total hot run time: 37854 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4080 4028 4076 4028
q2 334 242 225 225
q3 2960 2851 2835 2835
q4 1844 1551 1543 1543
q5 5303 5303 5313 5303
q6 201 116 118 116
q7 2267 1832 1879 1832
q8 3127 3268 3282 3268
q9 8672 8644 8639 8639
q10 3804 3787 3799 3787
q11 549 444 446 444
q12 703 550 551 550
q13 16914 2868 2851 2851
q14 281 250 255 250
q15 498 465 461 461
q16 466 441 425 425
q17 1727 1492 1449 1449
q18 7303 7193 7058 7058
q19 1618 1459 1536 1459
q20 1902 1742 1715 1715
q21 4868 4581 4816 4581
q22 546 473 474 473
Total cold run time: 69967 ms
Total hot run time: 53292 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