You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Lchangliang (via GitHub)" <gi...@apache.org> on 2024/07/10 07:39:43 UTC
[PR] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Lchangliang opened a new pull request, #37596:
URL: https://github.com/apache/doris/pull/37596
https://github.com/apache/doris/pull/34598
--
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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219842052
<details>
<summary>TPC-DS: <b>Total hot run time: 202730 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 8e54babc057c926401540967860d03a217920904, data reload: false
query1 918 420 374 374
query2 6525 2805 2641 2641
query3 6921 202 205 202
query4 20164 18039 17919 17919
query5 19738 6469 6444 6444
query6 295 212 227 212
query7 4150 305 313 305
query8 427 446 440 440
query9 3079 2622 2565 2565
query10 404 310 292 292
query11 11477 10683 10677 10677
query12 129 77 76 76
query13 5598 712 697 697
query14 18160 13769 13405 13405
query15 366 249 249 249
query16 6486 301 263 263
query17 1673 1467 887 887
query18 2308 414 419 414
query19 219 144 149 144
query20 82 78 87 78
query21 189 94 96 94
query22 5179 5095 5054 5054
query23 32834 31912 31953 31912
query24 6966 6491 6445 6445
query25 521 442 437 437
query26 533 164 163 163
query27 1889 301 297 297
query28 6131 2347 2276 2276
query29 2945 2738 2826 2738
query30 238 163 167 163
query31 909 736 737 736
query32 65 64 60 60
query33 407 257 264 257
query34 864 477 468 468
query35 1110 964 932 932
query36 1407 1120 1157 1120
query37 88 63 61 61
query38 3079 2917 2947 2917
query39 1362 1341 1320 1320
query40 203 95 95 95
query41 46 44 45 44
query42 84 83 79 79
query43 814 690 680 680
query44 1149 736 734 734
query45 244 242 233 233
query46 1221 980 983 980
query47 1916 1651 1837 1651
query48 1014 731 734 731
query49 622 374 379 374
query50 879 635 586 586
query51 4757 4638 4670 4638
query52 93 78 83 78
query53 463 326 321 321
query54 2638 2468 2470 2468
query55 83 78 80 78
query56 252 220 209 209
query57 1259 1057 1154 1057
query58 207 199 186 186
query59 4263 3957 3948 3948
query60 218 200 207 200
query61 96 92 92 92
query62 781 482 482 482
query63 483 342 348 342
query64 2621 1533 1349 1349
query65 3627 3558 3544 3544
query66 832 377 373 373
query67 15706 15182 14565 14565
query68 10070 648 673 648
query69 588 359 347 347
query70 2025 1440 1383 1383
query71 404 314 326 314
query72 6531 3526 3446 3446
query73 738 315 324 315
query74 6275 5856 5898 5856
query75 5466 3773 3719 3719
query76 6525 1196 1192 1192
query77 1071 258 257 257
query78 12593 12424 11696 11696
query79 11819 661 651 651
query80 789 401 397 397
query81 495 233 238 233
query82 948 97 99 97
query83 177 132 133 132
query84 261 72 70 70
query85 879 327 333 327
query86 317 297 289 289
query87 3264 3011 3029 3011
query88 5543 2337 2333 2333
query89 425 289 306 289
query90 2218 197 215 197
query91 177 145 156 145
query92 58 57 51 51
query93 5773 569 552 552
query94 811 210 210 210
query95 1113 1056 1028 1028
query96 638 330 326 326
query97 6527 6347 6376 6347
query98 186 182 167 167
query99 3021 854 882 854
Total cold run time: 320131 ms
Total hot run time: 202730 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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "Lchangliang (via GitHub)" <gi...@apache.org>.
Lchangliang commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219902614
run feut
--
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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219860474
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 8e54babc057c926401540967860d03a217920904 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 21.6 seconds inserted 10000000 Rows, about 462K 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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219852331
<details>
<summary>ClickBench: <b>Total hot run time: 31.14 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 8e54babc057c926401540967860d03a217920904, data reload: false
query1 0.03 0.02 0.02
query2 0.08 0.02 0.02
query3 0.25 0.05 0.06
query4 1.78 0.10 0.10
query5 0.55 0.52 0.53
query6 1.31 0.60 0.61
query7 0.01 0.00 0.01
query8 0.03 0.02 0.02
query9 0.52 0.48 0.48
query10 0.55 0.53 0.52
query11 0.12 0.09 0.09
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.79 0.80 0.78
query15 0.79 0.75 0.75
query16 0.36 0.37 0.35
query17 1.02 1.00 1.01
query18 0.22 0.26 0.24
query19 1.96 1.84 1.85
query20 0.02 0.01 0.01
query21 15.49 0.57 0.54
query22 1.99 2.33 1.67
query23 16.62 1.06 0.89
query24 5.67 2.24 1.52
query25 0.39 0.12 0.05
query26 0.77 0.16 0.15
query27 0.05 0.03 0.03
query28 5.73 0.78 0.73
query29 12.65 2.26 2.11
query30 0.58 0.52 0.62
query31 2.80 0.39 0.38
query32 3.39 0.51 0.49
query33 3.09 3.06 3.11
query34 15.26 4.79 4.80
query35 4.87 4.85 4.85
query36 1.08 1.02 1.04
query37 0.06 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.02
query40 0.17 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 101.95 s
Total hot run time: 31.14 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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219814897
<details>
<summary>TPC-H: <b>Total hot run time: 49884 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 8e54babc057c926401540967860d03a217920904, data reload: false
------ Round 1 ----------------------------------
q1 17985 6588 4339 4339
q2 2078 156 147 147
q3 10528 1905 1927 1905
q4 10343 1235 1342 1235
q5 8434 3932 3949 3932
q6 234 126 128 126
q7 2047 1584 1587 1584
q8 9496 2731 2707 2707
q9 13363 10348 10226 10226
q10 8652 3528 3507 3507
q11 418 251 252 251
q12 470 303 309 303
q13 18358 3951 4101 3951
q14 356 330 333 330
q15 523 464 472 464
q16 670 574 570 570
q17 1129 952 903 903
q18 7204 6965 6906 6906
q19 1818 1700 1633 1633
q20 527 321 311 311
q21 4424 4179 4105 4105
q22 531 451 449 449
Total cold run time: 119588 ms
Total hot run time: 49884 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4337 4307 4323 4307
q2 313 222 222 222
q3 4193 4175 4145 4145
q4 2743 2750 2734 2734
q5 7131 7048 7085 7048
q6 240 122 120 120
q7 3256 2873 2833 2833
q8 4357 4445 4477 4445
q9 16999 16955 16898 16898
q10 4206 4310 4278 4278
q11 734 713 677 677
q12 1027 869 862 862
q13 6806 3755 3732 3732
q14 445 434 425 425
q15 515 471 453 453
q16 738 685 690 685
q17 3797 3924 3842 3842
q18 8770 8840 8709 8709
q19 1752 1685 1659 1659
q20 2392 2151 2116 2116
q21 8545 8426 8501 8426
q22 1068 933 988 933
Total cold run time: 84364 ms
Total hot run time: 79549 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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "Lchangliang (via GitHub)" <gi...@apache.org>.
Lchangliang commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219779451
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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219779396
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] [Bugfix] Fix mv column type is not changed when do schema change [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #37596:
URL: https://github.com/apache/doris/pull/37596
--
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