You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BePPPower (via GitHub)" <gi...@apache.org> on 2024/01/19 04:54:18 UTC
[PR] [Fix](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
BePPPower opened a new pull request, #30125:
URL: https://github.com/apache/doris/pull/30125
## 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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #30125:
URL: https://github.com/apache/doris/pull/30125
--
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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "BePPPower (via GitHub)" <gi...@apache.org>.
BePPPower commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899769631
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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899896833
<details>
<summary>TPC-H: <b>Total hot run time: 49703 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 d50d1ca0396ed2bb4cf9cc13b425008efe5d69be, data reload: false
------ Round 1 ----------------------------------
q1 18267 4390 4307 4307
q2 2031 144 138 138
q3 10407 1924 1942 1924
q4 10319 1239 1321 1239
q5 8459 3969 3947 3947
q6 221 122 124 122
q7 2010 1570 1593 1570
q8 9471 2689 2715 2689
q9 10601 10452 10441 10441
q10 8632 3529 3506 3506
q11 419 249 233 233
q12 454 293 295 293
q13 18322 3905 4023 3905
q14 359 327 316 316
q15 508 459 446 446
q16 696 590 590 590
q17 1120 967 993 967
q18 7270 6825 6836 6825
q19 1669 1548 1526 1526
q20 526 306 284 284
q21 4469 4049 4074 4049
q22 513 386 402 386
Total cold run time: 116743 ms
Total hot run time: 49703 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4316 4336 4288 4288
q2 315 224 218 218
q3 4099 4125 4131 4125
q4 2729 2749 2727 2727
q5 7278 7240 7164 7164
q6 231 113 114 113
q7 3208 2805 2844 2805
q8 4414 4517 4498 4498
q9 17049 17055 16937 16937
q10 4181 4247 4216 4216
q11 771 666 690 666
q12 1011 852 860 852
q13 6778 3721 3734 3721
q14 442 422 427 422
q15 503 454 454 454
q16 757 709 694 694
q17 4038 3822 3859 3822
q18 8763 8738 8748 8738
q19 1678 1702 1642 1642
q20 2374 2098 2099 2098
q21 8458 8413 8484 8413
q22 1026 941 916 916
Total cold run time: 84419 ms
Total hot run time: 79529 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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899916816
<details>
<summary>ClickBench: <b>Total hot run time: 30.55 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 d50d1ca0396ed2bb4cf9cc13b425008efe5d69be, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.25 0.04 0.05
query4 1.82 0.06 0.06
query5 0.54 0.52 0.52
query6 1.25 0.61 0.62
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.52 0.48 0.47
query10 0.53 0.55 0.54
query11 0.12 0.08 0.09
query12 0.11 0.09 0.10
query13 0.62 0.61 0.62
query14 0.79 0.79 0.78
query15 0.77 0.76 0.77
query16 0.36 0.35 0.37
query17 1.02 0.98 1.03
query18 0.22 0.25 0.26
query19 1.91 1.86 1.86
query20 0.02 0.01 0.01
query21 15.46 0.56 0.55
query22 1.83 2.06 1.20
query23 17.04 1.01 0.86
query24 6.52 2.01 1.05
query25 2.21 0.16 0.14
query26 0.15 0.14 0.14
query27 0.15 0.16 0.15
query28 6.30 0.80 0.74
query29 12.66 2.37 2.33
query30 0.56 0.54 0.52
query31 2.81 0.39 0.38
query32 3.42 0.49 0.48
query33 3.08 3.08 3.09
query34 15.26 4.78 4.81
query35 4.87 4.82 4.84
query36 1.05 1.01 1.00
query37 0.05 0.05 0.04
query38 0.04 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.14 0.14
query41 0.07 0.01 0.01
query42 0.02 0.01 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.74 s
Total hot run time: 30.55 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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899910959
<details>
<summary>TPC-DS: <b>Total hot run time: 234216 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 d50d1ca0396ed2bb4cf9cc13b425008efe5d69be, data reload: false
query1 904 383 391 383
query2 6517 2102 1936 1936
query3 6913 201 198 198
query4 20121 17883 17885 17883
query5 19737 6243 6236 6236
query6 276 208 219 208
query7 4151 289 293 289
query8 264 241 218 218
query9 3073 2645 2584 2584
query10 403 298 281 281
query11 11168 10741 10738 10738
query12 123 78 71 71
query13 5645 635 627 627
query14 17400 13245 13576 13245
query15 351 230 240 230
query16 6459 264 254 254
query17 3237 887 868 868
query18 2272 427 391 391
query19 203 142 149 142
query20 71 72 75 72
query21 182 97 92 92
query22 5241 4996 5102 4996
query23 32682 32152 32043 32043
query24 7122 6580 6546 6546
query25 553 456 463 456
query26 535 169 160 160
query27 1865 291 306 291
query28 6213 2269 2260 2260
query29 3002 2630 2837 2630
query30 240 158 156 156
query31 894 746 743 743
query32 66 55 62 55
query33 388 260 260 260
query34 868 471 482 471
query35 1134 940 924 924
query36 1688 1532 1640 1532
query37 92 63 57 57
query38 3163 2924 2939 2924
query39 1384 1330 1324 1324
query40 197 95 95 95
query41 35 34 30 30
query42 86 81 82 81
query43 719 671 568 568
query44 1111 698 711 698
query45 244 231 221 221
query46 1239 976 983 976
query47 1950 1700 1693 1693
query48 971 695 661 661
query49 610 358 365 358
query50 872 592 574 574
query51 5653 5605 5550 5550
query52 97 81 75 75
query53 437 318 313 313
query54 2420 2270 2259 2259
query55 80 74 72 72
query56 219 206 199 199
query57 1157 1119 1032 1032
query58 224 208 198 198
query59 3458 3185 3241 3185
query60 203 186 193 186
query61 84 83 86 83
query62 845 515 470 470
query63 486 324 329 324
query64 1981 1284 1293 1284
query65 3671 3652 3609 3609
query66 812 369 345 345
query67 15434 15110 17161 15110
query68 8257 638 668 638
query69 555 341 341 341
query70 1976 1544 1541 1541
query71 403 282 301 282
query72 4538 3422 3373 3373
query73 723 319 312 312
query74 6291 5911 5864 5864
query75 4315 3620 3545 3545
query76 4647 1207 1197 1197
query77 562 235 240 235
query78 33514 48582 44105 44105
query79 15048 626 647 626
query80 4886 390 379 379
query81 552 229 228 228
query82 1093 96 95 95
query83 326 134 127 127
query84 263 68 68 68
query85 2443 287 272 272
query86 474 370 376 370
query87 3225 3017 3013 3013
query88 6756 2284 2282 2282
query89 401 284 283 283
query90 2511 213 201 201
query91 162 124 129 124
query92 61 52 55 52
query93 5135 620 575 575
query94 1867 205 210 205
query95 1100 1048 1058 1048
query96 639 320 332 320
query97 6485 6335 6397 6335
query98 185 177 164 164
query99 3840 993 1018 993
Total cold run time: 345128 ms
Total hot run time: 234216 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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1903027362
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] [Fix](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "BePPPower (via GitHub)" <gi...@apache.org>.
BePPPower commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899866881
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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1899920291
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d50d1ca0396ed2bb4cf9cc13b425008efe5d69be with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 22.0 seconds inserted 10000000 Rows, about 454K 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](Export) Fix the bug that `tablets_num` is always zero in `show export` result [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30125:
URL: https://github.com/apache/doris/pull/30125#issuecomment-1903027458
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