You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "w41ter (via GitHub)" <gi...@apache.org> on 2024/09/23 10:01:55 UTC
[PR] [fix](restore) Fix view signature #41120 [doris]
w41ter opened a new pull request, #41149:
URL: https://github.com/apache/doris/pull/41149
cherry pick from #41120
--
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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367956579
<details>
<summary>TPC-DS: <b>Total hot run time: 212989 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 f40f458cc33beee4c91fff2c95c3589cb5b71157, data reload: false
query1 926 389 439 389
query2 6532 2284 2269 2269
query3 6921 203 200 200
query4 24167 21524 21504 21504
query5 19767 6493 6546 6493
query6 279 221 227 221
query7 4161 302 303 302
query8 258 241 236 236
query9 3090 2665 2610 2610
query10 409 316 299 299
query11 15395 15301 15487 15301
query12 121 76 75 75
query13 1024 449 438 438
query14 17341 13697 13373 13373
query15 384 219 227 219
query16 6642 290 260 260
query17 1837 962 967 962
query18 899 318 307 307
query19 205 158 149 149
query20 105 100 102 100
query21 190 98 92 92
query22 5227 5023 4960 4960
query23 34325 33414 33558 33414
query24 7812 6292 6286 6286
query25 529 438 428 428
query26 1269 176 164 164
query27 2507 300 295 295
query28 6119 2255 2252 2252
query29 2856 2793 2621 2621
query30 240 172 168 168
query31 920 747 739 739
query32 68 60 58 58
query33 461 270 258 258
query34 841 481 478 478
query35 1122 1370 894 894
query36 1431 1138 1052 1052
query37 176 60 60 60
query38 3080 2898 2933 2898
query39 1379 1319 1315 1315
query40 311 96 95 95
query41 39 37 36 36
query42 97 93 86 86
query43 655 618 572 572
query44 1159 718 712 712
query45 243 230 232 230
query46 1231 966 953 953
query47 1843 1824 1687 1687
query48 505 427 408 408
query49 648 375 368 368
query50 865 651 621 621
query51 4789 4636 4739 4636
query52 108 71 80 71
query53 231 191 195 191
query54 2660 2472 2482 2472
query55 95 81 84 81
query56 216 216 193 193
query57 1197 1167 1135 1135
query58 218 194 218 194
query59 3580 3334 3359 3334
query60 229 206 213 206
query61 100 98 100 98
query62 840 492 425 425
query63 205 185 185 185
query64 3525 1610 1444 1444
query65 3616 3513 3553 3513
query66 762 412 429 412
query67 15771 15550 16951 15550
query68 9528 647 656 647
query69 531 265 250 250
query70 1481 1387 1405 1387
query71 409 315 305 305
query72 6904 4825 4839 4825
query73 753 328 339 328
query74 6273 5912 5786 5786
query75 4987 3665 3701 3665
query76 5144 1126 1201 1126
query77 873 262 249 249
query78 12559 11728 11938 11728
query79 7611 635 631 631
query80 1576 392 385 385
query81 500 236 243 236
query82 1438 98 98 98
query83 168 131 142 131
query84 258 72 72 72
query85 1013 320 313 313
query86 351 288 305 288
query87 3207 3066 3054 3054
query88 4532 2313 2311 2311
query89 379 285 279 279
query90 1886 204 208 204
query91 160 131 128 128
query92 60 52 48 48
query93 5604 596 563 563
query94 753 208 204 204
query95 2002 2073 1951 1951
query96 650 323 327 323
query97 6412 6345 6322 6322
query98 223 208 202 202
query99 2927 903 930 903
Total cold run time: 317905 ms
Total hot run time: 212989 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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367872884
<details>
<summary>TPC-H: <b>Total hot run time: 49314 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 916d7fd1fc898b2e1f5c8371bb3c36f46d26fbf8, data reload: false
------ Round 1 ----------------------------------
q1 17615 4529 4435 4435
q2 2032 153 145 145
q3 10472 1902 1937 1902
q4 10211 1305 1328 1305
q5 8511 4228 3955 3955
q6 243 151 141 141
q7 2035 1591 1584 1584
q8 9276 2775 2738 2738
q9 10196 9818 9872 9818
q10 8648 3538 3541 3538
q11 415 254 256 254
q12 472 300 298 298
q13 18341 3973 4025 3973
q14 360 317 322 317
q15 515 462 451 451
q16 540 453 464 453
q17 1157 962 940 940
q18 7253 6865 6783 6783
q19 1690 1580 1474 1474
q20 540 302 306 302
q21 4488 4181 4107 4107
q22 489 422 401 401
Total cold run time: 115499 ms
Total hot run time: 49314 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4308 4330 4334 4330
q2 325 230 221 221
q3 4220 4199 4150 4150
q4 2763 2748 2757 2748
q5 7193 7150 7175 7150
q6 239 118 117 117
q7 3207 2842 2912 2842
q8 4384 4503 4498 4498
q9 13726 13661 13619 13619
q10 4221 4278 4264 4264
q11 747 682 677 677
q12 1021 847 866 847
q13 6872 3751 3752 3751
q14 449 425 437 425
q15 494 466 452 452
q16 617 578 580 578
q17 3848 3863 3848 3848
q18 8872 8732 8829 8732
q19 1735 1656 1674 1656
q20 2381 2126 2117 2117
q21 8560 8567 8519 8519
q22 1048 951 965 951
Total cold run time: 81230 ms
Total hot run time: 76492 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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367754481
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](restore) Fix view signature #41120 [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367754343
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](restore) Fix view signature #41120 [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter merged PR #41149:
URL: https://github.com/apache/doris/pull/41149
--
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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367977109
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit f40f458cc33beee4c91fff2c95c3589cb5b71157 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 57 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 20.7 seconds inserted 10000000 Rows, about 483K 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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367969936
<details>
<summary>ClickBench: <b>Total hot run time: 31.11 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 f40f458cc33beee4c91fff2c95c3589cb5b71157, data reload: false
query1 0.03 0.03 0.02
query2 0.06 0.03 0.02
query3 0.25 0.05 0.04
query4 1.79 0.07 0.05
query5 0.54 0.53 0.52
query6 1.25 0.63 0.63
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.51 0.50 0.47
query10 0.53 0.54 0.54
query11 0.11 0.09 0.09
query12 0.11 0.09 0.09
query13 0.63 0.61 0.62
query14 0.79 0.78 0.79
query15 0.78 0.76 0.76
query16 0.36 0.35 0.38
query17 0.98 0.99 0.99
query18 0.23 0.25 0.24
query19 1.92 1.77 1.84
query20 0.01 0.01 0.01
query21 15.45 0.55 0.57
query22 2.13 2.13 1.51
query23 17.44 1.01 0.88
query24 4.79 1.66 2.89
query25 0.34 0.10 0.06
query26 0.82 0.15 0.14
query27 0.03 0.04 0.04
query28 6.33 0.72 0.76
query29 12.66 2.24 2.21
query30 0.59 0.52 0.60
query31 2.82 0.39 0.36
query32 3.38 0.50 0.49
query33 3.09 3.04 3.09
query34 15.28 4.78 4.81
query35 4.84 4.86 4.88
query36 1.06 1.02 1.02
query37 0.05 0.05 0.04
query38 0.04 0.02 0.02
query39 0.02 0.02 0.02
query40 0.17 0.14 0.14
query41 0.07 0.02 0.02
query42 0.02 0.01 0.01
query43 0.03 0.02 0.01
Total cold run time: 102.39 s
Total hot run time: 31.11 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](restore) Fix view signature #41120 [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367885766
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](restore) Fix view signature #41120 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41149:
URL: https://github.com/apache/doris/pull/41149#issuecomment-2367931508
<details>
<summary>TPC-H: <b>Total hot run time: 48917 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 f40f458cc33beee4c91fff2c95c3589cb5b71157, data reload: false
------ Round 1 ----------------------------------
q1 17564 4405 4342 4342
q2 2081 148 153 148
q3 10267 1937 1920 1920
q4 10263 1236 1330 1236
q5 8546 3898 3867 3867
q6 237 122 125 122
q7 2006 1625 1589 1589
q8 9293 2739 2701 2701
q9 10198 9759 9711 9711
q10 8637 3538 3523 3523
q11 423 255 254 254
q12 463 298 309 298
q13 18343 3967 4001 3967
q14 349 315 328 315
q15 495 455 482 455
q16 559 460 473 460
q17 1131 919 931 919
q18 7219 6864 6828 6828
q19 1647 1570 1487 1487
q20 520 300 313 300
q21 4382 4126 4077 4077
q22 486 398 399 398
Total cold run time: 115109 ms
Total hot run time: 48917 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4323 4270 4332 4270
q2 333 231 224 224
q3 4169 4150 4144 4144
q4 2760 2755 2748 2748
q5 7211 7059 7038 7038
q6 240 116 120 116
q7 3295 2890 2866 2866
q8 4339 4509 4521 4509
q9 13729 13461 13598 13461
q10 4237 4246 4251 4246
q11 753 687 679 679
q12 1023 857 834 834
q13 7594 3728 3767 3728
q14 451 440 428 428
q15 498 457 461 457
q16 636 592 610 592
q17 3843 3833 3797 3797
q18 8808 8767 8705 8705
q19 1713 1665 1661 1661
q20 2386 2173 2128 2128
q21 8459 8434 8517 8434
q22 1041 970 953 953
Total cold run time: 81841 ms
Total hot run time: 76018 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