You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2024/07/12 04:31:32 UTC
[PR] [fix](readconsistency) avoid table not exist error #37593 [doris]
dataroaring opened a new pull request, #37709:
URL: https://github.com/apache/doris/pull/37709
pick #37593
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #37709:
URL: https://github.com/apache/doris/pull/37709
--
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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224673095
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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224812457
<details>
<summary>ClickBench: <b>Total hot run time: 30.54 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
query1 0.02 0.02 0.02
query2 0.07 0.03 0.02
query3 0.25 0.05 0.05
query4 1.79 0.07 0.07
query5 0.54 0.52 0.51
query6 1.25 0.61 0.60
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.52 0.50 0.47
query10 0.56 0.55 0.54
query11 0.11 0.08 0.08
query12 0.12 0.10 0.09
query13 0.62 0.61 0.62
query14 0.78 0.79 0.80
query15 0.79 0.76 0.76
query16 0.39 0.36 0.38
query17 1.03 1.00 1.03
query18 0.21 0.28 0.24
query19 1.91 1.84 1.80
query20 0.01 0.01 0.01
query21 15.45 0.54 0.54
query22 2.30 2.16 1.50
query23 16.96 0.87 0.82
query24 5.56 1.04 1.19
query25 0.41 0.09 0.05
query26 0.61 0.16 0.15
query27 0.04 0.05 0.04
query28 7.38 0.76 0.74
query29 12.71 2.36 2.31
query30 0.63 0.56 0.54
query31 2.81 0.40 0.36
query32 3.35 0.50 0.50
query33 3.09 3.06 3.05
query34 15.24 4.76 4.80
query35 4.85 4.85 4.82
query36 1.06 1.02 1.01
query37 0.06 0.05 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.14
query41 0.06 0.01 0.02
query42 0.02 0.01 0.01
query43 0.02 0.01 0.02
Total cold run time: 103.86 s
Total hot run time: 30.54 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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224549035
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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224763458
<details>
<summary>TPC-H: <b>Total hot run time: 49647 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
------ Round 1 ----------------------------------
q1 17814 4363 4296 4296
q2 2073 158 146 146
q3 10272 1885 1932 1885
q4 10348 1235 1314 1235
q5 8839 3853 3843 3843
q6 248 124 122 122
q7 2024 1594 1619 1594
q8 9305 2720 2686 2686
q9 10560 10267 10255 10255
q10 8658 3460 3455 3455
q11 419 248 251 248
q12 472 303 315 303
q13 18353 3953 3968 3953
q14 351 327 333 327
q15 514 462 470 462
q16 673 567 582 567
q17 1139 946 976 946
q18 7188 6865 6841 6841
q19 1764 1663 1641 1641
q20 521 300 297 297
q21 4442 4130 4097 4097
q22 521 458 448 448
Total cold run time: 116498 ms
Total hot run time: 49647 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4320 4276 4278 4276
q2 321 232 225 225
q3 4186 4116 4131 4116
q4 2747 2747 2729 2729
q5 7103 7172 7107 7107
q6 236 121 119 119
q7 3237 2916 2812 2812
q8 4353 4454 4522 4454
q9 16851 16675 16652 16652
q10 4249 4225 4235 4225
q11 766 684 694 684
q12 1048 850 876 850
q13 7059 3760 3768 3760
q14 475 431 434 431
q15 511 462 466 462
q16 730 690 682 682
q17 3844 3848 3879 3848
q18 8672 8780 8832 8780
q19 1741 1691 1663 1663
q20 2360 2198 2096 2096
q21 8581 8459 8425 8425
q22 1026 948 979 948
Total cold run time: 84416 ms
Total hot run time: 79344 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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224797311
<details>
<summary>TPC-DS: <b>Total hot run time: 202999 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 95484dafcd789b546708b4898770c4e55784cbe0, data reload: false
query1 926 424 383 383
query2 6529 2851 2624 2624
query3 6917 211 201 201
query4 20116 18025 17911 17911
query5 19740 6511 6520 6511
query6 296 230 232 230
query7 4162 305 334 305
query8 483 425 442 425
query9 3076 2654 2616 2616
query10 410 292 308 292
query11 11380 10801 10815 10801
query12 130 85 75 75
query13 5606 706 720 706
query14 17572 13368 13811 13368
query15 372 244 244 244
query16 6467 295 266 266
query17 1733 1439 890 890
query18 2306 418 420 418
query19 211 154 148 148
query20 80 79 81 79
query21 190 98 92 92
query22 5181 4999 4970 4970
query23 32563 31813 31809 31809
query24 6949 6636 6491 6491
query25 538 421 425 421
query26 526 168 162 162
query27 1883 308 302 302
query28 6167 2360 2335 2335
query29 2833 2808 2855 2808
query30 245 161 169 161
query31 906 735 759 735
query32 71 63 62 62
query33 412 263 267 263
query34 842 476 460 460
query35 1128 942 930 930
query36 1335 1120 1127 1120
query37 91 60 61 60
query38 3088 2934 2904 2904
query39 1387 1325 1323 1323
query40 209 95 97 95
query41 47 45 44 44
query42 85 88 83 83
query43 930 631 616 616
query44 1108 735 736 735
query45 246 235 234 234
query46 1238 990 997 990
query47 1936 1738 1640 1640
query48 1035 735 730 730
query49 615 368 376 368
query50 859 613 647 613
query51 4724 4660 4714 4660
query52 90 81 76 76
query53 481 341 325 325
query54 2642 2449 2464 2449
query55 94 82 80 80
query56 211 225 194 194
query57 1107 1008 1154 1008
query58 209 197 201 197
query59 4212 3914 3813 3813
query60 212 221 213 213
query61 100 96 94 94
query62 871 450 512 450
query63 482 354 346 346
query64 2598 1530 1486 1486
query65 3660 3525 3558 3525
query66 778 371 380 371
query67 16643 15175 15279 15175
query68 8922 669 669 669
query69 577 352 367 352
query70 1614 1313 1392 1313
query71 423 310 331 310
query72 6517 3500 3547 3500
query73 734 328 321 321
query74 6287 5841 5851 5841
query75 5339 3677 3715 3677
query76 5451 1186 1211 1186
query77 907 271 260 260
query78 12664 11421 11784 11421
query79 9038 649 632 632
query80 1419 409 400 400
query81 489 238 240 238
query82 1629 105 99 99
query83 183 139 137 137
query84 263 70 71 70
query85 878 342 335 335
query86 335 295 287 287
query87 3227 3021 2993 2993
query88 4702 2346 2336 2336
query89 480 311 294 294
query90 1936 210 204 204
query91 174 155 140 140
query92 60 55 55 55
query93 6579 583 560 560
query94 690 213 215 213
query95 1132 1069 1046 1046
query96 646 332 329 329
query97 6453 6307 6426 6307
query98 200 175 171 171
query99 3009 857 792 792
Total cold run time: 315226 ms
Total hot run time: 202999 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](readconsistency) avoid table not exist error #37593 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37709:
URL: https://github.com/apache/doris/pull/37709#issuecomment-2224821114
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 95484dafcd789b546708b4898770c4e55784cbe0 with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 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: 21.5 seconds inserted 10000000 Rows, about 465K 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