You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "heguanhui (via GitHub)" <gi...@apache.org> on 2026/01/24 17:05:11 UTC
[PR] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
heguanhui opened a new pull request, #60209:
URL: https://github.com/apache/doris/pull/60209
### What problem does this PR solve?
Add IP field display for show frontends/backends/broker commands and RestAPIs
1. add ip field for show frontends command with fqdn mode
2. add ip field for show backends command with fqdn mode
3. add ip field for show broker command with fqdn mode
4. add ip field for frontends() udf
5. add ip field for backends() udf
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
[测试报告.docx](https://github.com/user-attachments/files/24838666/default.docx)
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795290066
<details>
<summary>ClickBench: <b>Total hot run time: 27.03 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 cde916d038ad559601ca6c71c9b8de08d7d4ea21, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.05 0.04
query3 0.26 0.09 0.09
query4 1.61 0.12 0.11
query5 0.28 0.27 0.26
query6 1.15 0.71 0.68
query7 0.03 0.02 0.03
query8 0.05 0.03 0.04
query9 0.57 0.50 0.50
query10 0.55 0.54 0.56
query11 0.15 0.09 0.10
query12 0.16 0.11 0.11
query13 0.62 0.60 0.59
query14 0.97 0.96 0.94
query15 0.81 0.79 0.79
query16 0.44 0.41 0.43
query17 1.08 1.04 0.99
query18 0.24 0.21 0.21
query19 1.91 1.76 1.89
query20 0.02 0.01 0.01
query21 15.47 0.28 0.14
query22 5.30 0.05 0.05
query23 15.98 0.28 0.10
query24 1.37 0.49 0.34
query25 0.08 0.08 0.09
query26 0.14 0.14 0.13
query27 0.07 0.04 0.07
query28 5.06 1.12 0.89
query29 12.57 3.95 3.16
query30 0.28 0.13 0.12
query31 2.82 0.67 0.42
query32 3.24 0.58 0.48
query33 3.07 3.07 3.08
query34 15.98 5.23 4.50
query35 4.50 4.45 4.54
query36 0.64 0.50 0.51
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.18 0.15 0.14
query41 0.09 0.03 0.02
query42 0.04 0.03 0.03
query43 0.06 0.03 0.04
Total cold run time: 98.21 s
Total hot run time: 27.03 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796142842
<details>
<summary>TPC-DS: <b>Total hot run time: 172033 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 c6fefedaab4157906ab7bac98f704ff5ef9959bf, data reload: false
query5 4407 636 489 489
query6 330 224 226 224
query7 4235 451 271 271
query8 344 237 228 228
query9 8717 2856 2851 2851
query10 455 318 282 282
query11 15225 15147 14737 14737
query12 174 122 118 118
query13 1254 468 373 373
query14 5927 3013 2772 2772
query14_1 2655 2638 2641 2638
query15 207 190 171 171
query16 986 469 467 467
query17 1075 641 554 554
query18 2422 417 321 321
query19 192 166 147 147
query20 121 117 111 111
query21 212 133 119 119
query22 4107 4216 4017 4017
query23 15931 15591 15359 15359
query23_1 15277 15594 15399 15399
query24 7143 1536 1164 1164
query24_1 1158 1136 1189 1136
query25 513 433 378 378
query26 1252 268 151 151
query27 2770 428 274 274
query28 4609 2152 2134 2134
query29 789 513 414 414
query30 308 241 194 194
query31 803 605 547 547
query32 82 80 72 72
query33 518 346 298 298
query34 910 893 526 526
query35 716 756 672 672
query36 893 900 854 854
query37 137 94 83 83
query38 2695 2638 2650 2638
query39 785 769 756 756
query39_1 698 732 704 704
query40 230 135 119 119
query41 72 67 70 67
query42 96 96 92 92
query43 432 475 420 420
query44 1309 751 749 749
query45 190 188 186 186
query46 830 934 566 566
query47 1489 1450 1396 1396
query48 310 323 245 245
query49 623 436 348 348
query50 666 269 204 204
query51 3779 3758 3765 3758
query52 95 89 80 80
query53 215 213 165 165
query54 269 258 241 241
query55 80 79 75 75
query56 286 278 281 278
query57 1021 1034 879 879
query58 266 260 247 247
query59 2166 2065 2067 2065
query60 323 324 311 311
query61 144 146 142 142
query62 381 363 310 310
query63 195 157 161 157
query64 4972 1134 798 798
query65 3821 3694 3720 3694
query66 1447 412 322 322
query67 15507 15633 15351 15351
query68 2346 1056 709 709
query69 382 310 267 267
query70 1017 964 847 847
query71 290 285 272 272
query72 5275 3252 3361 3252
query73 584 716 311 311
query74 8783 8731 8589 8589
query75 2298 2331 1873 1873
query76 2268 1046 665 665
query77 349 378 309 309
query78 9609 9780 9084 9084
query79 2291 892 584 584
query80 1701 543 455 455
query81 531 311 230 230
query82 1025 155 117 117
query83 330 264 244 244
query84 255 118 92 92
query85 891 477 409 409
query86 404 321 283 283
query87 2856 2815 2754 2754
query88 3470 2576 2551 2551
query89 308 249 240 240
query90 2027 170 164 164
query91 160 161 131 131
query92 70 76 66 66
query93 1176 1001 637 637
query94 630 306 278 278
query95 575 379 302 302
query96 636 489 229 229
query97 2396 2385 2311 2311
query98 216 209 200 200
query99 584 558 507 507
Total cold run time: 247544 ms
Total hot run time: 172033 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4933204034
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4920798009
# FE Regression Coverage Report
Increment line coverage ` 55.05% (109/198)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_8add931fb84195d98de85582d12850d883484dca_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_8add931fb84195d98de85582d12850d883484dca_merge_fe/report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795927326
<details>
<summary>TPC-H: <b>Total hot run time: 31429 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 3b5994adb5e85a21d3c27172ed261cad73130fcb, data reload: false
------ Round 1 ----------------------------------
q1 17612 4681 4545 4545
q2 2036 302 194 194
q3 10243 1290 750 750
q4 10207 809 301 301
q5 7500 2101 1801 1801
q6 186 167 140 140
q7 860 695 593 593
q8 9259 1346 1288 1288
q9 4836 4646 4652 4646
q10 6806 1667 1281 1281
q11 497 322 270 270
q12 340 372 218 218
q13 17809 3846 3087 3087
q14 231 226 214 214
q15 615 531 516 516
q16 653 647 576 576
q17 657 765 493 493
q18 6681 6463 6668 6463
q19 1325 1056 660 660
q20 459 370 255 255
q21 3055 2354 2071 2071
q22 1121 1145 1067 1067
Total cold run time: 102988 ms
Total hot run time: 31429 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5064 4944 4903 4903
q2 329 434 323 323
q3 2391 2903 2496 2496
q4 1442 1870 1417 1417
q5 4657 4373 4510 4373
q6 223 171 132 132
q7 2164 2036 1920 1920
q8 2556 2430 2437 2430
q9 7331 7359 7187 7187
q10 2577 2631 2133 2133
q11 523 452 467 452
q12 737 722 582 582
q13 3323 3769 3123 3123
q14 285 287 257 257
q15 544 510 505 505
q16 626 661 642 642
q17 1101 1254 1291 1254
q18 7454 7318 7088 7088
q19 816 805 799 799
q20 1929 1963 1826 1826
q21 5013 4264 4168 4168
q22 1075 1081 1012 1012
Total cold run time: 52160 ms
Total hot run time: 49022 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "yx-keith (via GitHub)" <gi...@apache.org>.
yx-keith commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4888759900
/review
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4926900938
<details>
<summary>TPC-DS: <b>Total hot run time: 179946 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 a752cf6e1c05ddbdbc52969572249476426cf88a, data reload: false
query5 4396 638 494 494
query6 475 226 223 223
query7 4870 590 362 362
query8 329 184 175 175
query9 8795 4022 4038 4022
query10 451 357 306 306
query11 5960 2357 2155 2155
query12 162 103 113 103
query13 1282 620 439 439
query14 6269 5287 4970 4970
query14_1 4296 4294 4321 4294
query15 215 206 183 183
query16 1015 473 464 464
query17 1148 762 598 598
query18 2450 472 369 369
query19 233 196 156 156
query20 115 108 105 105
query21 238 155 136 136
query22 13646 13684 13422 13422
query23 17406 16552 16189 16189
query23_1 16181 16272 16231 16231
query24 7565 1793 1304 1304
query24_1 1330 1313 1303 1303
query25 567 467 394 394
query26 1316 368 219 219
query27 2661 574 397 397
query28 4430 2079 1986 1986
query29 1102 637 500 500
query30 336 265 229 229
query31 1116 1099 987 987
query32 105 64 66 64
query33 531 329 260 260
query34 1187 1119 690 690
query35 759 798 682 682
query36 1401 1348 1208 1208
query37 158 103 98 98
query38 1905 1700 1648 1648
query39 984 924 896 896
query39_1 873 918 905 905
query40 255 150 141 141
query41 66 66 64 64
query42 99 91 94 91
query43 323 325 280 280
query44 1454 799 781 781
query45 206 189 180 180
query46 1105 1196 744 744
query47 2350 2314 2244 2244
query48 401 399 293 293
query49 576 463 336 336
query50 1073 424 334 334
query51 10908 10785 10740 10740
query52 85 86 73 73
query53 263 289 213 213
query54 288 233 222 222
query55 73 75 64 64
query56 295 274 315 274
query57 1426 1405 1302 1302
query58 276 247 249 247
query59 1574 1658 1469 1469
query60 300 264 248 248
query61 156 155 153 153
query62 707 648 590 590
query63 239 208 208 208
query64 2820 1035 861 861
query65 4815 4775 4741 4741
query66 1828 500 384 384
query67 29509 29435 28794 28794
query68 3340 1532 990 990
query69 414 313 325 313
query70 1080 983 966 966
query71 373 350 320 320
query72 3130 2692 2373 2373
query73 850 781 462 462
query74 5081 4949 4738 4738
query75 2578 2604 2275 2275
query76 2323 1187 780 780
query77 355 380 264 264
query78 12360 12293 11875 11875
query79 1430 1129 748 748
query80 1297 539 468 468
query81 524 324 276 276
query82 638 157 123 123
query83 381 321 287 287
query84 276 156 130 130
query85 1000 613 513 513
query86 418 290 279 279
query87 1833 1817 1754 1754
query88 3830 2932 2912 2912
query89 453 401 349 349
query90 1959 202 191 191
query91 200 188 159 159
query92 64 62 59 59
query93 1646 1584 1033 1033
query94 717 368 306 306
query95 749 478 461 461
query96 1154 823 326 326
query97 2677 2713 2527 2527
query98 211 216 200 200
query99 1145 1181 1031 1031
Total cold run time: 266599 ms
Total hot run time: 179946 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4933811450
# FE UT Coverage Report
Increment line coverage ` 67.42% (89/132)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_17242a0f3e787060511bd4683a9f0a6b4fd92cd4/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_17242a0f3e787060511bd4683a9f0a6b4fd92cd4/fe_report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4925165822
# FE Regression Coverage Report
Increment line coverage ` 75.17% (109/145)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_a752cf6e1c05ddbdbc52969572249476426cf88a_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_a752cf6e1c05ddbdbc52969572249476426cf88a_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3926211063
# FE UT Coverage Report
Increment line coverage ` 80.00% (16/20)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942/fe_report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3889408230
<details>
<summary>TPC-H: <b>Total hot run time: 29916 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 5c835d81b5e9d7035e1b63f784b83ab09cdbc942, data reload: false
------ Round 1 ----------------------------------
q1 17635 4552 4281 4281
q2 2001 352 237 237
q3 10178 1290 727 727
q4 10191 777 295 295
q5 7565 2204 1884 1884
q6 194 179 144 144
q7 880 741 617 617
q8 9302 1426 1210 1210
q9 4799 4649 4591 4591
q10 6819 1924 1533 1533
q11 467 259 246 246
q12 333 372 220 220
q13 17784 4044 3199 3199
q14 247 229 212 212
q15 898 817 808 808
q16 674 687 624 624
q17 714 852 493 493
q18 6414 5812 5591 5591
q19 1247 969 607 607
q20 502 480 379 379
q21 2489 1765 1772 1765
q22 328 286 253 253
Total cold run time: 101661 ms
Total hot run time: 29916 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4337 4326 4318 4318
q2 249 334 253 253
q3 2072 2664 2192 2192
q4 1337 1732 1273 1273
q5 4300 4172 4208 4172
q6 206 178 134 134
q7 1852 1784 1665 1665
q8 2449 2632 2493 2493
q9 7594 7603 7365 7365
q10 2881 3110 2613 2613
q11 505 446 426 426
q12 715 741 607 607
q13 3876 4423 3577 3577
q14 405 350 444 350
q15 896 798 817 798
q16 657 703 652 652
q17 1131 1328 1358 1328
q18 8255 7936 7777 7777
q19 889 841 817 817
q20 2037 2166 2041 2041
q21 4712 4843 4383 4383
q22 517 483 455 455
Total cold run time: 51872 ms
Total hot run time: 49689 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795944230
<details>
<summary>ClickBench: <b>Total hot run time: 26.78 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 3b5994adb5e85a21d3c27172ed261cad73130fcb, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.05 0.04
query3 0.25 0.08 0.09
query4 1.60 0.11 0.11
query5 0.27 0.25 0.26
query6 1.14 0.66 0.65
query7 0.03 0.02 0.02
query8 0.06 0.04 0.05
query9 0.58 0.50 0.49
query10 0.56 0.54 0.54
query11 0.15 0.10 0.10
query12 0.14 0.11 0.11
query13 0.60 0.58 0.59
query14 0.94 0.94 0.95
query15 0.80 0.78 0.79
query16 0.40 0.39 0.40
query17 1.05 1.05 1.01
query18 0.24 0.21 0.21
query19 1.94 1.82 1.76
query20 0.02 0.01 0.01
query21 15.44 0.27 0.13
query22 5.09 0.05 0.05
query23 15.82 0.28 0.10
query24 1.64 0.64 0.29
query25 0.09 0.07 0.07
query26 0.14 0.13 0.13
query27 0.09 0.07 0.04
query28 4.26 1.08 0.89
query29 12.54 3.94 3.17
query30 0.28 0.13 0.12
query31 2.82 0.63 0.40
query32 3.24 0.55 0.46
query33 3.00 3.02 3.04
query34 16.03 5.13 4.46
query35 4.44 4.48 4.45
query36 0.64 0.49 0.50
query37 0.11 0.07 0.07
query38 0.08 0.04 0.04
query39 0.04 0.02 0.03
query40 0.16 0.14 0.13
query41 0.08 0.03 0.03
query42 0.04 0.02 0.02
query43 0.05 0.04 0.04
Total cold run time: 97.05 s
Total hot run time: 26.78 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795968301
# FE UT Coverage Report
Increment line coverage ` 68.75% (22/32)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_3b5994adb5e85a21d3c27172ed261cad73130fcb/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_3b5994adb5e85a21d3c27172ed261cad73130fcb/fe_report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796133417
<details>
<summary>TPC-H: <b>Total hot run time: 30845 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 c6fefedaab4157906ab7bac98f704ff5ef9959bf, data reload: false
------ Round 1 ----------------------------------
q1 17646 4898 4562 4562
q2 2093 316 214 214
q3 10150 1306 757 757
q4 10196 793 303 303
q5 7509 2079 1780 1780
q6 184 170 139 139
q7 884 734 591 591
q8 9261 1370 1021 1021
q9 4860 4521 4527 4521
q10 6785 1645 1250 1250
q11 523 299 270 270
q12 345 381 235 235
q13 17771 3794 3111 3111
q14 227 246 216 216
q15 595 519 520 519
q16 642 621 581 581
q17 637 767 506 506
q18 6853 6438 6663 6438
q19 1258 980 641 641
q20 397 344 238 238
q21 2719 2110 1973 1973
q22 1025 1022 979 979
Total cold run time: 102560 ms
Total hot run time: 30845 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4766 4735 4709 4709
q2 322 391 347 347
q3 2213 2730 2330 2330
q4 1351 1789 1354 1354
q5 4196 3996 4061 3996
q6 217 170 132 132
q7 1929 1871 1926 1871
q8 2578 2586 2464 2464
q9 7254 7121 7124 7121
q10 2430 2833 2364 2364
q11 558 494 455 455
q12 717 804 641 641
q13 3627 4001 3559 3559
q14 293 311 282 282
q15 548 523 521 521
q16 650 668 631 631
q17 1121 1427 1333 1333
q18 7985 7810 7940 7810
q19 851 834 879 834
q20 2025 2095 1911 1911
q21 4482 4130 4147 4130
q22 1070 998 961 961
Total cold run time: 51183 ms
Total hot run time: 49756 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4919734082
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r2797276397
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/BrokerMgr.java:
##########
@@ -52,7 +53,7 @@
*/
public class BrokerMgr {
public static final ImmutableList<String> BROKER_PROC_NODE_TITLE_NAMES = new ImmutableList.Builder<String>()
- .add("Name").add("Host").add("Port").add("Alive")
+ .add("Name").add("Host").add("IP").add("Port").add("Alive")
Review Comment:
> better append new column to the end for better compatibility. it is the same for the other similar occurrences
hello, I have already put this field to the end, and please review again~
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r2726649905
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/BrokerMgr.java:
##########
@@ -52,7 +53,7 @@
*/
public class BrokerMgr {
public static final ImmutableList<String> BROKER_PROC_NODE_TITLE_NAMES = new ImmutableList.Builder<String>()
- .add("Name").add("Host").add("Port").add("Alive")
+ .add("Name").add("Host").add("IP").add("Port").add("Alive")
Review Comment:
https://github.com/apache/doris/pull/60211,https://github.com/apache/doris/pull/60210
Because of this two bugs in these two PRs, if I put this IP field to the end, it will result in display incorrectly, or you can merge these two PRs firstly, then I can rebase and adjust this field to the end.
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4933973697
<details>
<summary>TPC-DS: <b>Total hot run time: 181029 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 17242a0f3e787060511bd4683a9f0a6b4fd92cd4, data reload: false
query5 4331 648 475 475
query6 473 247 230 230
query7 4866 583 346 346
query8 341 190 177 177
query9 8779 4130 4160 4130
query10 469 386 341 341
query11 5899 2357 2144 2144
query12 160 104 101 101
query13 1279 594 432 432
query14 6264 5276 4941 4941
query14_1 4316 4321 4311 4311
query15 217 212 181 181
query16 1009 471 474 471
query17 951 751 610 610
query18 2459 484 361 361
query19 207 189 148 148
query20 110 109 105 105
query21 230 151 137 137
query22 13625 13539 13359 13359
query23 17466 16559 16196 16196
query23_1 16385 16317 16338 16317
query24 7436 1777 1307 1307
query24_1 1310 1327 1299 1299
query25 584 478 398 398
query26 1335 344 214 214
query27 2691 636 386 386
query28 4489 2030 2050 2030
query29 1107 637 510 510
query30 327 273 226 226
query31 1125 1089 988 988
query32 114 71 63 63
query33 557 329 275 275
query34 1195 1125 643 643
query35 770 803 688 688
query36 1427 1386 1300 1300
query37 159 110 92 92
query38 1885 1735 1641 1641
query39 921 913 882 882
query39_1 884 873 905 873
query40 240 156 141 141
query41 68 62 64 62
query42 92 94 94 94
query43 317 324 288 288
query44 1423 781 779 779
query45 206 189 185 185
query46 1063 1187 709 709
query47 2374 2360 2291 2291
query48 416 425 277 277
query49 577 415 322 322
query50 1045 425 344 344
query51 11068 10736 10600 10600
query52 95 88 72 72
query53 265 289 205 205
query54 278 242 229 229
query55 76 77 67 67
query56 282 291 286 286
query57 1445 1419 1348 1348
query58 275 258 251 251
query59 1593 1677 1488 1488
query60 307 266 260 260
query61 156 153 155 153
query62 697 646 580 580
query63 244 201 209 201
query64 2844 1080 843 843
query65 4880 4781 4773 4773
query66 1871 515 390 390
query67 29619 29518 29342 29342
query68 3156 1601 967 967
query69 404 310 272 272
query70 1108 964 935 935
query71 376 336 309 309
query72 3128 2720 2417 2417
query73 842 776 440 440
query74 5127 4933 4770 4770
query75 2646 2602 2230 2230
query76 2319 1215 766 766
query77 379 386 294 294
query78 12296 12390 11723 11723
query79 1414 1176 757 757
query80 1282 528 481 481
query81 558 319 280 280
query82 638 166 123 123
query83 413 327 295 295
query84 324 162 131 131
query85 986 600 538 538
query86 431 297 270 270
query87 1832 1825 1762 1762
query88 3719 2836 2818 2818
query89 461 405 353 353
query90 1903 195 203 195
query91 207 187 169 169
query92 64 61 62 61
query93 1656 1459 957 957
query94 735 359 319 319
query95 801 562 484 484
query96 1051 805 385 385
query97 2689 2705 2562 2562
query98 214 208 210 208
query99 1155 1217 1034 1034
Total cold run time: 266587 ms
Total hot run time: 181029 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4933888249
<details>
<summary>TPC-H: <b>Total hot run time: 29574 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 17242a0f3e787060511bd4683a9f0a6b4fd92cd4, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17664 4064 4015 4015
q2 2096 340 201 201
q3 10283 1390 808 808
q4 4687 476 339 339
q5 7590 857 582 582
q6 184 174 142 142
q7 787 843 620 620
q8 9376 1614 1585 1585
q9 5675 4417 4443 4417
q10 6791 1809 1531 1531
q11 507 342 328 328
q12 709 552 421 421
q13 18125 3379 2778 2778
q14 264 260 248 248
q15 q16 799 790 717 717
q17 1001 982 957 957
q18 7032 5840 5539 5539
q19 1312 1339 1013 1013
q20 719 654 558 558
q21 5918 2633 2474 2474
q22 434 354 301 301
Total cold run time: 101953 ms
Total hot run time: 29574 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4365 4275 4275 4275
q2 291 333 224 224
q3 4600 4963 4392 4392
q4 2062 2175 1367 1367
q5 4428 4284 4305 4284
q6 236 174 134 134
q7 1749 1997 1819 1819
q8 2565 2191 2200 2191
q9 8118 8141 7839 7839
q10 4735 4661 4237 4237
q11 574 439 392 392
q12 769 814 552 552
q13 3233 3576 2945 2945
q14 309 311 274 274
q15 q16 736 717 649 649
q17 1334 1326 1335 1326
q18 8030 7345 7433 7345
q19 1134 1114 1051 1051
q20 2202 2203 1937 1937
q21 5250 4565 4467 4467
q22 502 471 402 402
Total cold run time: 57222 ms
Total hot run time: 52102 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4882514273
<details>
<summary>ClickBench: <b>Total hot run time: 25.56 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 0b954fff78b3cc81b9cba81027159affbfa3a64f, data reload: false
query1 0.01 0.01 0.01
query2 0.10 0.05 0.04
query3 0.25 0.14 0.14
query4 1.62 0.14 0.14
query5 0.25 0.23 0.23
query6 1.27 1.11 1.16
query7 0.04 0.00 0.00
query8 0.06 0.04 0.04
query9 0.39 0.33 0.31
query10 0.56 0.61 0.57
query11 0.20 0.15 0.14
query12 0.18 0.14 0.15
query13 0.48 0.50 0.47
query14 1.02 1.01 1.01
query15 0.62 0.61 0.59
query16 0.34 0.33 0.34
query17 1.12 1.16 1.12
query18 0.23 0.23 0.23
query19 2.05 1.94 1.99
query20 0.02 0.01 0.01
query21 15.48 0.18 0.14
query22 4.95 0.06 0.06
query23 16.09 0.32 0.12
query24 3.00 0.41 0.35
query25 0.12 0.07 0.04
query26 0.72 0.21 0.16
query27 0.03 0.04 0.05
query28 3.48 0.93 0.56
query29 12.47 4.30 3.46
query30 0.28 0.15 0.15
query31 2.79 0.60 0.33
query32 3.23 0.59 0.49
query33 3.33 3.18 3.25
query34 15.64 4.23 3.54
query35 3.50 3.55 3.56
query36 0.58 0.44 0.43
query37 0.09 0.07 0.07
query38 0.05 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.17 0.16
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.05 0.04 0.03
Total cold run time: 97.04 s
Total hot run time: 25.56 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4882441697
<details>
<summary>TPC-H: <b>Total hot run time: 29796 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 0b954fff78b3cc81b9cba81027159affbfa3a64f, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17634 4109 4069 4069
q2 2109 317 191 191
q3 10229 1357 824 824
q4 4677 463 336 336
q5 7499 865 579 579
q6 189 176 140 140
q7 768 826 615 615
q8 9838 1640 1606 1606
q9 6312 4441 4421 4421
q10 6840 1766 1511 1511
q11 485 338 314 314
q12 761 559 438 438
q13 18122 3262 2770 2770
q14 267 253 244 244
q15 q16 795 784 713 713
q17 1050 960 1064 960
q18 7065 5900 5606 5606
q19 1419 1364 1142 1142
q20 766 627 549 549
q21 5668 2686 2460 2460
q22 438 360 308 308
Total cold run time: 102931 ms
Total hot run time: 29796 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4533 4460 4450 4450
q2 307 316 208 208
q3 4619 4983 4439 4439
q4 2074 2159 1396 1396
q5 4515 4562 4337 4337
q6 237 191 132 132
q7 2420 1907 1603 1603
q8 2602 2240 2234 2234
q9 7952 7962 7910 7910
q10 4704 4735 4208 4208
q11 588 585 392 392
q12 726 746 533 533
q13 3311 3660 2957 2957
q14 307 310 258 258
q15 q16 746 737 647 647
q17 1405 1376 1349 1349
q18 8179 7605 6881 6881
q19 1141 1087 1138 1087
q20 2222 2211 1952 1952
q21 5306 4621 4515 4515
q22 529 463 409 409
Total cold run time: 58423 ms
Total hot run time: 51897 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4916500758
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r3339036843
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/BrokerMgr.java:
##########
@@ -392,6 +393,7 @@ public ProcResult fetchResult() {
row.add(TimeUtils.longToTimeString(broker.lastStartTime));
row.add(TimeUtils.longToTimeString(broker.lastUpdateTime));
Review Comment:
This resolves DNS while `BrokerMgr.lock` is still held by `BrokerProcNode.fetchResult()`. `HostUtils.resolveHostToIp()` calls `InetAddress.getByName()`, which may block on external DNS; during that time broker add/drop/replay and normal broker lookups that need the same lock are stalled. Please snapshot the broker rows under the lock and resolve IPs after releasing it, or cache/store the resolved address outside this metadata lock. This is distinct from the existing review thread, which only covered where the new column is placed.
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r2726528502
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/BrokerMgr.java:
##########
@@ -52,7 +53,7 @@
*/
public class BrokerMgr {
public static final ImmutableList<String> BROKER_PROC_NODE_TITLE_NAMES = new ImmutableList.Builder<String>()
- .add("Name").add("Host").add("Port").add("Alive")
+ .add("Name").add("Host").add("IP").add("Port").add("Alive")
Review Comment:
better append new column to the end for better compatibility.
it is the same for the other similar occurrences
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796266902
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3889498469
<details>
<summary>ClickBench: <b>Total hot run time: 28.74 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 5c835d81b5e9d7035e1b63f784b83ab09cdbc942, data reload: false
query1 0.06 0.05 0.04
query2 0.09 0.05 0.04
query3 0.25 0.08 0.08
query4 1.60 0.11 0.11
query5 0.27 0.25 0.25
query6 1.17 0.68 0.67
query7 0.03 0.03 0.03
query8 0.05 0.03 0.04
query9 0.56 0.50 0.49
query10 0.55 0.56 0.55
query11 0.14 0.10 0.09
query12 0.14 0.11 0.10
query13 0.64 0.61 0.62
query14 1.07 1.05 1.03
query15 0.88 0.86 0.86
query16 0.40 0.39 0.40
query17 1.16 1.08 1.11
query18 0.22 0.21 0.21
query19 2.11 1.99 2.04
query20 0.02 0.02 0.02
query21 15.42 0.28 0.15
query22 5.14 0.06 0.06
query23 15.89 0.29 0.11
query24 1.27 0.76 0.91
query25 0.09 0.05 0.06
query26 0.14 0.13 0.13
query27 0.06 0.11 0.06
query28 4.91 1.15 0.97
query29 12.60 3.96 3.20
query30 0.28 0.16 0.12
query31 2.82 0.63 0.40
query32 3.24 0.60 0.49
query33 3.31 3.25 3.22
query34 16.17 5.32 4.72
query35 4.73 4.77 4.81
query36 0.65 0.51 0.49
query37 0.11 0.06 0.06
query38 0.08 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.16 0.15
query41 0.10 0.03 0.03
query42 0.04 0.04 0.03
query43 0.05 0.04 0.03
Total cold run time: 98.73 s
Total hot run time: 28.74 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r3556177781
##########
fe/fe-core/src/main/java/org/apache/doris/common/proc/BackendsProcDir.java:
##########
@@ -167,6 +169,10 @@ public static List<List<String>> getBackendInfos() {
// node role, show the value only when backend is alive.
backendInfo.add(backend.isAlive() ? backend.getNodeRoleTag().value : "");
+ // ip
+ if (Config.enable_fqdn_mode) {
Review Comment:
This adds the resolved `Ip` for the SHOW/PROC/TVF backend paths, but the connector-facing REST endpoint is still a parallel path: `/api/backends` in `BackendsAction` returns `backendRow.ip = be.getHost()`. In FQDN mode `Backend.getHost()` is the stable hostname, so callers of that REST API still get a hostname in the JSON `ip` field instead of the resolved address this PR is adding elsewhere. Since that endpoint is documented as being used by flink/spark connectors for stream-load backend discovery, please update it to use the same FQDN-mode resolution or add a separate resolved-IP field so the REST API behavior matches `SHOW BACKENDS`.
##########
fe/fe-core/src/main/java/org/apache/doris/common/util/HostUtils.java:
##########
@@ -0,0 +1,58 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.common.util;
+
+import com.github.benmanes.caffeine.cache.CacheLoader;
+import com.github.benmanes.caffeine.cache.Caffeine;
+import com.github.benmanes.caffeine.cache.LoadingCache;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.net.InetAddress;
+import java.util.concurrent.TimeUnit;
+
+/**
+ * HostUtils
+ */
+public class HostUtils {
+
+ private static final Logger LOG = LogManager.getLogger(HostUtils.class);
+ private static final LoadingCache<String, String> HOST_TO_IP_CACHE = Caffeine.newBuilder()
Review Comment:
This cache can make the new `Ip` columns stale in exactly the FQDN-mode case they are meant to help. `enable_fqdn_mode` is used when the pod name remains stable but the IP can change; Doris already sets the JVM DNS TTL to 60s and has `Env.getDnsCache()` refreshing FQDN answers every 60s while preserving the last good IP on lookup failure. This new Caffeine cache keeps a successful answer for 10 minutes and also caches the literal `Unknown` returned on a transient failure, so `SHOW BACKENDS`/`SHOW FRONTENDS`/TVFs can report an obsolete IP or `Unknown` well after DNS has recovered. Please reuse the existing DNS cache behavior or avoid caching failed resolutions.
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4919893970
<details>
<summary>TPC-H: <b>Total hot run time: 29261 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 8add931fb84195d98de85582d12850d883484dca, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17678 4063 3983 3983
q2 2004 323 195 195
q3 10282 1425 809 809
q4 4681 468 334 334
q5 7517 854 573 573
q6 183 186 145 145
q7 763 844 630 630
q8 9544 1510 1588 1510
q9 6007 4349 4304 4304
q10 6834 1765 1524 1524
q11 504 345 317 317
q12 732 558 426 426
q13 18100 3298 2734 2734
q14 262 262 246 246
q15 q16 791 783 709 709
q17 1041 988 1058 988
q18 6732 5765 5457 5457
q19 1543 1280 1094 1094
q20 747 629 517 517
q21 5878 2567 2472 2472
q22 432 352 294 294
Total cold run time: 102255 ms
Total hot run time: 29261 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4346 4227 4287 4227
q2 280 309 223 223
q3 4492 4952 4381 4381
q4 2022 2141 1370 1370
q5 4382 4291 4298 4291
q6 224 170 128 128
q7 1724 1676 1898 1676
q8 2459 2231 2108 2108
q9 7912 8015 7727 7727
q10 4733 4665 4275 4275
q11 598 426 370 370
q12 754 780 535 535
q13 3448 3576 3017 3017
q14 315 305 272 272
q15 q16 698 753 648 648
q17 1295 1306 1306 1306
q18 8124 7338 6964 6964
q19 1068 1072 1050 1050
q20 2225 2210 1948 1948
q21 5227 4550 4361 4361
q22 521 471 408 408
Total cold run time: 56847 ms
Total hot run time: 51285 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4225678490
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884626161
# FE UT Coverage Report
Increment line coverage ` 43.48% (20/46)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_fd68b3705c2068ca299757dce404b4500a41db2d/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_fd68b3705c2068ca299757dce404b4500a41db2d/fe_report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884801628
# FE Regression Coverage Report
Increment line coverage ` 91.30% (42/46)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_fd68b3705c2068ca299757dce404b4500a41db2d_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_fd68b3705c2068ca299757dce404b4500a41db2d_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3889470240
<details>
<summary>TPC-DS: <b>Total hot run time: 188265 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 5c835d81b5e9d7035e1b63f784b83ab09cdbc942, data reload: false
query5 4322 623 530 530
query6 340 215 211 211
query7 4226 468 276 276
query8 341 245 242 242
query9 8719 2746 2730 2730
query10 521 384 328 328
query11 17108 17023 16779 16779
query12 181 124 123 123
query13 1268 442 362 362
query14 6141 3180 3009 3009
query14_1 2818 2763 2780 2763
query15 204 190 175 175
query16 981 468 430 430
query17 1103 661 564 564
query18 2428 437 326 326
query19 204 200 172 172
query20 140 128 125 125
query21 226 135 115 115
query22 4919 4998 4971 4971
query23 17243 16948 16666 16666
query23_1 16754 16905 16718 16718
query24 7161 1598 1208 1208
query24_1 1218 1215 1232 1215
query25 517 433 385 385
query26 817 260 153 153
query27 2768 448 291 291
query28 4510 1839 1826 1826
query29 767 537 438 438
query30 316 254 218 218
query31 868 720 658 658
query32 83 72 77 72
query33 516 332 284 284
query34 904 905 555 555
query35 639 670 589 589
query36 1085 1181 997 997
query37 140 99 87 87
query38 2917 2907 2894 2894
query39 1024 847 851 847
query39_1 971 826 789 789
query40 215 134 121 121
query41 70 64 65 64
query42 112 111 106 106
query43 381 389 362 362
query44 1302 739 725 725
query45 204 196 185 185
query46 884 990 613 613
query47 2109 2157 2073 2073
query48 313 318 244 244
query49 604 467 353 353
query50 657 275 207 207
query51 4269 4113 4043 4043
query52 104 104 96 96
query53 289 330 276 276
query54 285 261 254 254
query55 86 84 79 79
query56 309 303 316 303
query57 1369 1356 1294 1294
query58 279 272 266 266
query59 2577 2669 2579 2579
query60 336 334 315 315
query61 143 146 148 146
query62 621 591 503 503
query63 312 277 273 273
query64 4231 1229 937 937
query65 4622 4498 4541 4498
query66 1395 453 347 347
query67 16290 16350 16264 16264
query68 2450 1067 709 709
query69 413 325 279 279
query70 1052 930 967 930
query71 330 312 297 297
query72 2826 2486 2456 2456
query73 516 542 316 316
query74 9567 9541 9373 9373
query75 2759 2754 2445 2445
query76 2295 1060 669 669
query77 360 389 307 307
query78 10774 11085 10423 10423
query79 1073 918 592 592
query80 638 594 482 482
query81 491 284 254 254
query82 1355 147 111 111
query83 362 256 229 229
query84 248 116 99 99
query85 821 456 400 400
query86 383 304 291 291
query87 3097 3115 3011 3011
query88 3517 2668 2651 2651
query89 439 373 343 343
query90 1871 177 160 160
query91 162 156 127 127
query92 74 75 71 71
query93 880 852 494 494
query94 477 310 301 301
query95 578 331 306 306
query96 631 510 230 230
query97 2459 2491 2461 2461
query98 223 215 215 215
query99 1013 954 944 944
Total cold run time: 257648 ms
Total hot run time: 188265 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796686109
<details>
<summary>TPC-DS: <b>Total hot run time: 172049 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 c869fb3847552324fbba6a888060dd6431627e0d, data reload: false
query5 4667 644 508 508
query6 310 216 183 183
query7 4211 443 251 251
query8 325 237 237 237
query9 8725 2872 2869 2869
query10 464 294 273 273
query11 15165 15050 14988 14988
query12 173 117 113 113
query13 1250 434 371 371
query14 6066 2973 2733 2733
query14_1 2631 2609 2651 2609
query15 199 191 171 171
query16 976 474 441 441
query17 1083 675 577 577
query18 2458 430 328 328
query19 196 177 170 170
query20 116 118 109 109
query21 208 134 112 112
query22 4269 4136 4109 4109
query23 15778 15617 15296 15296
query23_1 15284 15404 15320 15320
query24 7213 1565 1151 1151
query24_1 1155 1176 1176 1176
query25 531 420 375 375
query26 1240 258 144 144
query27 2784 447 272 272
query28 4536 2166 2147 2147
query29 731 510 417 417
query30 303 230 206 206
query31 785 624 562 562
query32 86 70 77 70
query33 506 353 301 301
query34 870 867 524 524
query35 707 754 673 673
query36 871 935 807 807
query37 132 97 88 88
query38 2793 2665 2654 2654
query39 755 746 754 746
query39_1 705 726 716 716
query40 221 128 118 118
query41 73 60 61 60
query42 96 98 89 89
query43 431 459 403 403
query44 1329 742 764 742
query45 185 185 175 175
query46 825 931 574 574
query47 1393 1497 1399 1399
query48 325 321 233 233
query49 611 440 339 339
query50 673 268 204 204
query51 3704 3750 3752 3750
query52 89 90 80 80
query53 216 218 163 163
query54 269 270 244 244
query55 83 79 77 77
query56 299 315 315 315
query57 974 1031 978 978
query58 279 265 253 253
query59 2066 2188 2149 2149
query60 344 364 310 310
query61 170 171 168 168
query62 411 371 322 322
query63 200 161 170 161
query64 4958 1201 816 816
query65 3784 3707 3694 3694
query66 1448 426 306 306
query67 15364 15495 15338 15338
query68 2460 1082 728 728
query69 400 330 280 280
query70 971 951 897 897
query71 305 278 270 270
query72 5240 3055 3221 3055
query73 591 709 315 315
query74 8743 8703 8571 8571
query75 2274 2315 1884 1884
query76 2255 1034 641 641
query77 358 368 292 292
query78 9638 9792 9192 9192
query79 1064 890 585 585
query80 1268 530 428 428
query81 542 260 226 226
query82 1047 149 116 116
query83 327 249 244 244
query84 257 120 99 99
query85 871 455 413 413
query86 406 291 281 281
query87 2871 2870 2712 2712
query88 3506 2596 2558 2558
query89 305 265 237 237
query90 1944 169 171 169
query91 162 159 131 131
query92 74 75 69 69
query93 1065 1025 648 648
query94 627 348 268 268
query95 578 331 301 301
query96 640 519 227 227
query97 2339 2421 2321 2321
query98 210 220 221 220
query99 586 579 539 539
Total cold run time: 244675 ms
Total hot run time: 172049 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796674649
<details>
<summary>TPC-H: <b>Total hot run time: 30694 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 c869fb3847552324fbba6a888060dd6431627e0d, data reload: false
------ Round 1 ----------------------------------
q1 17634 4762 4567 4567
q2 1997 349 201 201
q3 10223 1303 710 710
q4 10213 852 301 301
q5 7513 2064 1818 1818
q6 186 171 138 138
q7 853 703 594 594
q8 9259 1387 1149 1149
q9 4962 4529 4536 4529
q10 6764 1622 1253 1253
q11 524 283 265 265
q12 334 376 225 225
q13 17769 3799 3076 3076
q14 219 232 209 209
q15 617 516 526 516
q16 643 627 588 588
q17 656 776 510 510
q18 6654 6513 6282 6282
q19 1090 968 618 618
q20 379 345 240 240
q21 2598 1959 1937 1937
q22 1041 993 968 968
Total cold run time: 102128 ms
Total hot run time: 30694 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4774 4668 4686 4668
q2 332 390 323 323
q3 2153 2642 2246 2246
q4 1322 1763 1280 1280
q5 4063 3955 4040 3955
q6 229 179 140 140
q7 1946 1901 1779 1779
q8 2834 2565 2587 2565
q9 7321 7280 7138 7138
q10 2524 2644 2350 2350
q11 583 482 443 443
q12 688 721 635 635
q13 3587 4103 3435 3435
q14 435 344 274 274
q15 563 525 505 505
q16 637 683 648 648
q17 1182 1458 1419 1419
q18 8211 7746 7590 7590
q19 848 799 835 799
q20 2005 2043 1978 1978
q21 4933 4455 4102 4102
q22 1104 1062 973 973
Total cold run time: 52274 ms
Total hot run time: 49245 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795315525
# FE UT Coverage Report
Increment line coverage ` 68.75% (22/32)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_cde916d038ad559601ca6c71c9b8de08d7d4ea21/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_cde916d038ad559601ca6c71c9b8de08d7d4ea21/fe_report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795938862
<details>
<summary>TPC-DS: <b>Total hot run time: 173486 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 3b5994adb5e85a21d3c27172ed261cad73130fcb, data reload: false
query5 4652 664 512 512
query6 326 215 194 194
query7 4238 465 258 258
query8 359 249 247 247
query9 8719 2843 2846 2843
query10 446 333 277 277
query11 15274 15144 14901 14901
query12 171 122 123 122
query13 1250 477 382 382
query14 6222 3154 2961 2961
query14_1 2798 2811 2784 2784
query15 202 195 173 173
query16 974 497 465 465
query17 1082 682 580 580
query18 2494 438 340 340
query19 194 184 156 156
query20 130 117 116 116
query21 216 140 116 116
query22 3977 4004 3976 3976
query23 15941 15784 15285 15285
query23_1 15326 15485 15327 15327
query24 7193 1579 1192 1192
query24_1 1172 1172 1186 1172
query25 546 464 424 424
query26 1246 277 162 162
query27 2746 447 279 279
query28 4538 2157 2136 2136
query29 816 550 478 478
query30 311 249 210 210
query31 828 702 566 566
query32 87 79 75 75
query33 537 375 330 330
query34 902 870 563 563
query35 723 770 681 681
query36 896 888 843 843
query37 144 98 92 92
query38 2734 2778 2689 2689
query39 766 744 734 734
query39_1 703 714 713 713
query40 232 138 125 125
query41 73 74 67 67
query42 97 98 96 96
query43 465 470 393 393
query44 1370 753 754 753
query45 198 193 182 182
query46 854 954 621 621
query47 1378 1404 1337 1337
query48 323 329 245 245
query49 593 440 346 346
query50 678 294 203 203
query51 3737 3759 3750 3750
query52 89 97 84 84
query53 205 225 168 168
query54 282 259 262 259
query55 82 80 82 80
query56 305 315 295 295
query57 1110 1007 947 947
query58 287 275 267 267
query59 2141 2218 2026 2026
query60 337 338 325 325
query61 144 147 148 147
query62 393 353 298 298
query63 203 167 169 167
query64 4983 1189 802 802
query65 3793 3772 3789 3772
query66 1427 436 326 326
query67 15708 15644 15572 15572
query68 2414 1064 727 727
query69 398 328 277 277
query70 1019 878 945 878
query71 309 297 280 280
query72 5197 3198 3155 3155
query73 614 736 333 333
query74 8765 8726 8600 8600
query75 2298 2328 1870 1870
query76 2283 1066 670 670
query77 364 383 301 301
query78 9731 9839 9162 9162
query79 1080 912 600 600
query80 1321 551 434 434
query81 543 265 236 236
query82 1008 152 118 118
query83 337 266 247 247
query84 260 115 97 97
query85 869 487 412 412
query86 419 295 298 295
query87 3001 2907 2853 2853
query88 3506 2586 2557 2557
query89 322 262 241 241
query90 2006 173 173 173
query91 181 160 135 135
query92 79 78 71 71
query93 1161 1043 643 643
query94 660 323 302 302
query95 574 395 323 323
query96 641 517 229 229
query97 2370 2415 2336 2336
query98 210 205 205 205
query99 591 582 518 518
Total cold run time: 247055 ms
Total hot run time: 173486 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795895319
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4926947004
<details>
<summary>ClickBench: <b>Total hot run time: 25.13 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 a752cf6e1c05ddbdbc52969572249476426cf88a, data reload: false
query1 0.00 0.00 0.00
query2 0.10 0.06 0.05
query3 0.26 0.14 0.14
query4 1.61 0.13 0.13
query5 0.25 0.25 0.22
query6 1.22 1.08 1.03
query7 0.04 0.01 0.00
query8 0.06 0.04 0.04
query9 0.42 0.33 0.32
query10 0.58 0.61 0.57
query11 0.20 0.14 0.14
query12 0.19 0.15 0.14
query13 0.49 0.49 0.48
query14 1.00 1.01 1.02
query15 0.64 0.60 0.60
query16 0.32 0.33 0.34
query17 1.12 1.13 1.12
query18 0.24 0.24 0.23
query19 2.02 1.97 2.00
query20 0.02 0.01 0.01
query21 15.42 0.20 0.13
query22 5.02 0.05 0.05
query23 16.04 0.32 0.12
query24 2.92 0.42 0.33
query25 0.11 0.06 0.04
query26 0.74 0.22 0.15
query27 0.04 0.04 0.03
query28 3.55 0.92 0.52
query29 12.49 4.07 3.24
query30 0.27 0.16 0.15
query31 2.77 0.61 0.32
query32 3.23 0.59 0.50
query33 3.30 3.28 3.19
query34 15.60 4.27 3.50
query35 3.52 3.50 3.50
query36 0.57 0.46 0.44
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.03
query40 0.18 0.17 0.16
query41 0.09 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 96.89 s
Total hot run time: 25.13 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4934011760
<details>
<summary>ClickBench: <b>Total hot run time: 25.28 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 17242a0f3e787060511bd4683a9f0a6b4fd92cd4, data reload: false
query1 0.01 0.01 0.01
query2 0.10 0.05 0.04
query3 0.25 0.14 0.14
query4 1.63 0.14 0.13
query5 0.23 0.22 0.22
query6 1.27 1.14 1.06
query7 0.04 0.01 0.01
query8 0.05 0.04 0.04
query9 0.39 0.32 0.33
query10 0.57 0.56 0.58
query11 0.19 0.14 0.14
query12 0.18 0.15 0.15
query13 0.46 0.47 0.47
query14 1.01 1.02 1.02
query15 0.61 0.59 0.61
query16 0.31 0.33 0.32
query17 1.10 1.12 1.14
query18 0.23 0.22 0.21
query19 2.07 1.95 2.07
query20 0.01 0.01 0.02
query21 15.44 0.22 0.14
query22 4.89 0.06 0.05
query23 16.16 0.31 0.12
query24 2.97 0.40 0.34
query25 0.12 0.06 0.04
query26 0.74 0.22 0.14
query27 0.04 0.04 0.04
query28 3.51 0.94 0.56
query29 12.47 4.11 3.34
query30 0.26 0.15 0.16
query31 2.77 0.59 0.32
query32 3.28 0.60 0.48
query33 3.12 3.22 3.24
query34 15.55 4.21 3.53
query35 3.56 3.51 3.62
query36 0.58 0.45 0.43
query37 0.09 0.06 0.06
query38 0.05 0.03 0.04
query39 0.04 0.03 0.03
query40 0.18 0.17 0.15
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.7 s
Total hot run time: 25.28 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796089571
# FE Regression Coverage Report
Increment line coverage ` 78.12% (25/32)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_3b5994adb5e85a21d3c27172ed261cad73130fcb_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_3b5994adb5e85a21d3c27172ed261cad73130fcb_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3889204835
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4920223652
# FE UT Coverage Report
Increment line coverage ` 72.59% (98/135)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_8add931fb84195d98de85582d12850d883484dca/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_8add931fb84195d98de85582d12850d883484dca/fe_report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4882311784
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4934272941
Codex automated review failed and did not complete.
Error: You've hit your usage limit. Visit https://chatgpt.com/codex/settings/usage to purchase more credits or try again at 10:57 AM.
Workflow run: https://github.com/apache/doris/actions/runs/29083051264
Please inspect the workflow logs and rerun the review after the underlying issue is resolved.
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4919954925
<details>
<summary>TPC-DS: <b>Total hot run time: 179616 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 8add931fb84195d98de85582d12850d883484dca, data reload: false
query5 4323 632 491 491
query6 452 219 210 210
query7 4828 564 329 329
query8 328 192 187 187
query9 8815 3988 3997 3988
query10 458 345 281 281
query11 5958 2375 2141 2141
query12 172 99 103 99
query13 1258 597 434 434
query14 6236 5267 4922 4922
query14_1 4277 4246 4258 4246
query15 217 200 176 176
query16 1034 464 435 435
query17 1103 712 559 559
query18 2450 452 351 351
query19 199 183 141 141
query20 108 108 106 106
query21 226 154 135 135
query22 13686 13659 13405 13405
query23 17409 16528 16066 16066
query23_1 16249 16313 16340 16313
query24 7547 1740 1293 1293
query24_1 1322 1316 1273 1273
query25 580 471 408 408
query26 1322 351 214 214
query27 2678 586 388 388
query28 4465 2010 1958 1958
query29 1076 641 491 491
query30 355 278 229 229
query31 1119 1089 979 979
query32 109 64 63 63
query33 529 332 266 266
query34 1178 1198 632 632
query35 766 788 683 683
query36 1364 1418 1245 1245
query37 167 111 94 94
query38 1879 1710 1637 1637
query39 913 918 898 898
query39_1 889 895 911 895
query40 254 177 141 141
query41 79 69 68 68
query42 95 93 95 93
query43 318 324 283 283
query44 1412 766 774 766
query45 208 202 217 202
query46 1051 1235 758 758
query47 2459 2404 2243 2243
query48 421 409 298 298
query49 577 426 333 333
query50 1149 434 339 339
query51 10850 10775 10578 10578
query52 89 92 75 75
query53 270 274 209 209
query54 281 224 214 214
query55 73 69 69 69
query56 293 298 274 274
query57 1434 1384 1329 1329
query58 277 243 238 238
query59 1550 1608 1448 1448
query60 311 259 244 244
query61 153 153 150 150
query62 709 647 587 587
query63 258 201 198 198
query64 2805 1039 860 860
query65 4846 4763 4797 4763
query66 1826 505 378 378
query67 29469 29475 29321 29321
query68 3327 1589 970 970
query69 404 303 267 267
query70 1062 1000 974 974
query71 349 332 298 298
query72 3082 2715 2392 2392
query73 822 743 434 434
query74 5118 5003 4767 4767
query75 2611 2561 2224 2224
query76 2331 1177 769 769
query77 374 385 278 278
query78 12171 12303 11845 11845
query79 1335 1154 784 784
query80 1191 532 469 469
query81 499 305 274 274
query82 579 164 119 119
query83 397 310 281 281
query84 282 157 129 129
query85 969 596 526 526
query86 406 310 301 301
query87 1850 1820 1777 1777
query88 3656 2747 2742 2742
query89 446 397 359 359
query90 1795 187 194 187
query91 202 191 162 162
query92 61 65 58 58
query93 1719 1555 921 921
query94 655 352 314 314
query95 769 505 536 505
query96 1079 777 366 366
query97 2698 2682 2546 2546
query98 215 211 201 201
query99 1159 1189 1050 1050
Total cold run time: 265561 ms
Total hot run time: 179616 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4919983442
<details>
<summary>ClickBench: <b>Total hot run time: 25.02 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 8add931fb84195d98de85582d12850d883484dca, data reload: false
query1 0.01 0.01 0.00
query2 0.09 0.05 0.04
query3 0.26 0.14 0.14
query4 1.61 0.18 0.14
query5 0.26 0.22 0.23
query6 1.21 1.07 1.07
query7 0.04 0.01 0.01
query8 0.05 0.04 0.03
query9 0.37 0.31 0.30
query10 0.54 0.54 0.54
query11 0.19 0.14 0.14
query12 0.18 0.15 0.15
query13 0.47 0.47 0.48
query14 1.01 1.01 1.02
query15 0.62 0.62 0.60
query16 0.32 0.33 0.30
query17 1.09 1.10 1.07
query18 0.23 0.21 0.21
query19 2.00 1.99 1.96
query20 0.02 0.01 0.02
query21 15.42 0.19 0.14
query22 4.91 0.05 0.05
query23 16.15 0.31 0.13
query24 2.89 0.42 0.31
query25 0.11 0.05 0.04
query26 0.76 0.21 0.15
query27 0.05 0.04 0.04
query28 3.50 0.95 0.59
query29 12.47 4.06 3.22
query30 0.27 0.15 0.17
query31 2.76 0.60 0.31
query32 3.22 0.59 0.50
query33 3.23 3.31 3.18
query34 15.50 4.25 3.52
query35 3.50 3.54 3.52
query36 0.55 0.45 0.41
query37 0.08 0.06 0.07
query38 0.04 0.03 0.04
query39 0.04 0.03 0.03
query40 0.18 0.16 0.15
query41 0.08 0.03 0.02
query42 0.04 0.03 0.03
query43 0.05 0.04 0.03
Total cold run time: 96.37 s
Total hot run time: 25.02 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4926795368
<details>
<summary>TPC-H: <b>Total hot run time: 29797 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 a752cf6e1c05ddbdbc52969572249476426cf88a, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17929 4124 4052 4052
q2 2077 333 199 199
q3 10209 1489 870 870
q4 4685 472 336 336
q5 7526 837 586 586
q6 182 168 138 138
q7 788 844 626 626
q8 9317 1529 1675 1529
q9 5692 4381 4372 4372
q10 6790 1805 1544 1544
q11 499 336 311 311
q12 706 555 417 417
q13 18066 3364 2766 2766
q14 274 259 241 241
q15 q16 789 782 709 709
q17 1018 990 1139 990
q18 6855 5773 5513 5513
q19 1192 1210 1002 1002
q20 751 647 590 590
q21 6003 2879 2694 2694
q22 454 386 312 312
Total cold run time: 101802 ms
Total hot run time: 29797 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 5074 4814 4724 4724
q2 307 323 221 221
q3 4902 5275 4766 4766
q4 2074 2153 1351 1351
q5 4823 4964 4697 4697
q6 232 172 131 131
q7 1896 1783 1591 1591
q8 2467 2201 2292 2201
q9 7797 7539 7270 7270
q10 4652 4623 4184 4184
q11 537 411 355 355
q12 723 745 531 531
q13 3031 3359 2810 2810
q14 275 276 253 253
q15 q16 686 697 612 612
q17 1277 1251 1257 1251
q18 7384 6877 6970 6877
q19 1092 1033 1075 1033
q20 2244 2226 1943 1943
q21 5298 4754 4530 4530
q22 519 448 405 405
Total cold run time: 57290 ms
Total hot run time: 51736 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4599162718
/review
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795098082
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).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796097837
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3925663356
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3891204620
# FE Regression Coverage Report
Increment line coverage ` 80.00% (16/20)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884437615
<details>
<summary>TPC-H: <b>Total hot run time: 29921 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 fd68b3705c2068ca299757dce404b4500a41db2d, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17729 4065 4002 4002
q2 2042 326 204 204
q3 10249 1407 869 869
q4 4681 469 341 341
q5 7515 908 583 583
q6 180 175 137 137
q7 788 852 646 646
q8 9365 1673 1506 1506
q9 5654 4465 4460 4460
q10 6797 1813 1526 1526
q11 502 344 335 335
q12 729 564 450 450
q13 18106 3401 2758 2758
q14 268 261 246 246
q15 q16 802 779 711 711
q17 961 971 1006 971
q18 7059 5763 5572 5572
q19 1354 1223 1098 1098
q20 753 637 589 589
q21 6086 2688 2609 2609
q22 442 362 308 308
Total cold run time: 102062 ms
Total hot run time: 29921 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4425 4314 4335 4314
q2 294 317 213 213
q3 4621 4949 4416 4416
q4 2082 2132 1392 1392
q5 4465 4359 4333 4333
q6 231 177 131 131
q7 1830 2085 1693 1693
q8 2554 2190 2167 2167
q9 8190 8183 7811 7811
q10 4718 4678 4262 4262
q11 568 411 390 390
q12 791 767 543 543
q13 3245 3641 3031 3031
q14 288 298 277 277
q15 q16 702 724 689 689
q17 1345 1338 1440 1338
q18 7940 7388 7341 7341
q19 1168 1138 1100 1100
q20 2209 2209 1948 1948
q21 5240 4530 4417 4417
q22 513 452 414 414
Total cold run time: 57419 ms
Total hot run time: 52220 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884667362
<details>
<summary>TPC-H: <b>Total hot run time: 29208 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 fd68b3705c2068ca299757dce404b4500a41db2d, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17637 4032 3991 3991
q2 2001 312 197 197
q3 10303 1431 808 808
q4 4677 475 336 336
q5 7476 839 597 597
q6 192 171 138 138
q7 778 841 620 620
q8 9866 1296 1264 1264
q9 6018 4423 4394 4394
q10 6839 1795 1522 1522
q11 501 337 320 320
q12 761 548 424 424
q13 18086 3276 2730 2730
q14 263 255 240 240
q15 q16 780 776 718 718
q17 1079 1099 984 984
q18 6854 5800 5687 5687
q19 1333 1226 1017 1017
q20 758 674 532 532
q21 5933 2737 2392 2392
q22 441 362 297 297
Total cold run time: 102576 ms
Total hot run time: 29208 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4349 4280 4269 4269
q2 294 313 208 208
q3 4551 4933 4381 4381
q4 2067 2171 1361 1361
q5 4452 4355 4349 4349
q6 226 172 124 124
q7 1689 1956 1722 1722
q8 2457 2196 2091 2091
q9 7904 7767 7621 7621
q10 4723 4679 4262 4262
q11 578 426 388 388
q12 755 745 534 534
q13 3447 3503 3010 3010
q14 338 306 301 301
q15 q16 724 767 660 660
q17 1348 1324 1306 1306
q18 7910 7285 6808 6808
q19 1117 1092 1092 1092
q20 2224 2223 1934 1934
q21 5242 4544 4400 4400
q22 512 450 399 399
Total cold run time: 56907 ms
Total hot run time: 51220 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4882498855
<details>
<summary>TPC-DS: <b>Total hot run time: 173599 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 0b954fff78b3cc81b9cba81027159affbfa3a64f, data reload: false
query5 4325 626 488 488
query6 460 220 211 211
query7 4845 569 350 350
query8 391 187 173 173
query9 8766 4068 4009 4009
query10 499 353 307 307
query11 5935 2347 2174 2174
query12 159 100 101 100
query13 1263 626 428 428
query14 6274 5322 5001 5001
query14_1 4307 4308 4249 4249
query15 212 200 186 186
query16 999 460 440 440
query17 1028 686 586 586
query18 2448 464 339 339
query19 201 180 147 147
query20 110 104 107 104
query21 231 158 134 134
query22 13713 13717 13393 13393
query23 17203 16600 16202 16202
query23_1 16288 16326 16339 16326
query24 7510 1776 1296 1296
query24_1 1316 1310 1300 1300
query25 567 496 439 439
query26 1809 401 211 211
query27 2705 559 377 377
query28 4863 2095 2091 2091
query29 1113 673 513 513
query30 344 269 237 237
query31 1131 1116 1004 1004
query32 106 68 63 63
query33 539 332 261 261
query34 1196 1148 658 658
query35 769 792 675 675
query36 1453 1406 1261 1261
query37 163 112 95 95
query38 1889 1717 1644 1644
query39 943 927 916 916
query39_1 872 889 879 879
query40 253 166 145 145
query41 72 69 69 69
query42 95 98 97 97
query43 336 347 295 295
query44 1466 787 779 779
query45 211 190 182 182
query46 1087 1249 749 749
query47 2360 2333 2266 2266
query48 391 398 318 318
query49 602 428 323 323
query50 1090 442 340 340
query51 4435 4467 4564 4467
query52 89 86 76 76
query53 264 281 216 216
query54 313 246 250 246
query55 75 71 69 69
query56 270 288 284 284
query57 1412 1433 1287 1287
query58 293 254 258 254
query59 1600 1640 1485 1485
query60 327 267 259 259
query61 150 146 148 146
query62 699 647 572 572
query63 246 205 224 205
query64 2548 786 611 611
query65 4879 4846 4773 4773
query66 1849 513 390 390
query67 29524 29394 28694 28694
query68 3192 1621 969 969
query69 403 300 264 264
query70 1092 988 956 956
query71 376 327 303 303
query72 2970 2689 2340 2340
query73 886 847 398 398
query74 5114 4971 4752 4752
query75 2624 2596 2209 2209
query76 2333 1228 805 805
query77 358 379 275 275
query78 12391 12379 11966 11966
query79 1423 1204 762 762
query80 690 560 469 469
query81 470 338 292 292
query82 586 161 121 121
query83 402 322 299 299
query84 313 166 135 135
query85 963 638 524 524
query86 387 302 279 279
query87 1823 1823 1761 1761
query88 3770 2823 2796 2796
query89 451 409 351 351
query90 1962 205 198 198
query91 214 189 167 167
query92 66 58 56 56
query93 1552 1623 981 981
query94 572 351 331 331
query95 798 595 457 457
query96 1062 801 349 349
query97 2712 2747 2557 2557
query98 224 209 201 201
query99 1175 1151 1030 1030
Total cold run time: 259817 ms
Total hot run time: 173599 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4923582135
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4567100126
<details>
<summary>TPC-DS: <b>Total hot run time: 172021 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 e91d378791fea091012e1b64f9a0ad4c34ba224f, data reload: false
query5 4327 654 523 523
query6 333 223 204 204
query7 4236 558 311 311
query8 325 228 237 228
query9 8785 3978 3963 3963
query10 452 345 304 304
query11 5814 2430 2243 2243
query12 190 130 127 127
query13 1278 610 455 455
query14 6086 5439 5119 5119
query14_1 4454 4490 4440 4440
query15 215 205 184 184
query16 979 439 441 439
query17 979 760 581 581
query18 2470 478 345 345
query19 210 199 167 167
query20 138 129 124 124
query21 215 135 111 111
query22 13604 13547 13268 13268
query23 17244 16422 16120 16120
query23_1 16290 16430 16265 16265
query24 7396 1759 1279 1279
query24_1 1321 1298 1317 1298
query25 554 474 412 412
query26 1318 298 171 171
query27 2752 573 356 356
query28 4454 2025 1982 1982
query29 1015 628 484 484
query30 318 238 194 194
query31 1124 1075 960 960
query32 92 76 72 72
query33 530 349 294 294
query34 1211 1102 661 661
query35 791 787 713 713
query36 1477 1396 1265 1265
query37 152 105 84 84
query38 3261 3211 3097 3097
query39 970 969 920 920
query39_1 919 938 931 931
query40 236 148 129 129
query41 65 64 63 63
query42 110 114 111 111
query43 330 344 295 295
query44
query45 215 210 213 210
query46 1132 1277 771 771
query47 2335 2390 2282 2282
query48 431 431 308 308
query49 654 505 395 395
query50 1033 359 264 264
query51 4363 4305 4291 4291
query52 108 114 96 96
query53 260 286 212 212
query54 330 293 277 277
query55 94 93 86 86
query56 314 325 323 323
query57 1459 1417 1360 1360
query58 303 302 275 275
query59 1605 1675 1459 1459
query60 331 327 326 326
query61 189 181 181 181
query62 701 656 591 591
query63 246 205 210 205
query64 2458 859 681 681
query65
query66 1750 522 361 361
query67 29842 29723 29587 29587
query68
query69 477 354 305 305
query70 1029 994 977 977
query71 306 271 262 262
query72 2994 2686 2410 2410
query73 823 777 427 427
query74 5091 4941 4788 4788
query75 2691 2592 2260 2260
query76 2273 1151 754 754
query77 397 400 333 333
query78 12530 12426 11796 11796
query79 1521 1018 753 753
query80 1336 531 492 492
query81 519 282 240 240
query82 1233 157 123 123
query83 356 293 253 253
query84 316 138 111 111
query85 927 567 453 453
query86 479 320 306 306
query87 3409 3422 3236 3236
query88 3603 2739 2730 2730
query89 459 394 345 345
query90 1933 171 183 171
query91 181 164 141 141
query92 75 87 74 74
query93 1519 1413 876 876
query94 761 349 302 302
query95 667 469 344 344
query96 1017 783 331 331
query97 2708 2703 2629 2629
query98 229 223 231 223
query99 1177 1140 1034 1034
Total cold run time: 255154 ms
Total hot run time: 172021 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3925886372
<details>
<summary>TPC-H: <b>Total hot run time: 28919 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 5c835d81b5e9d7035e1b63f784b83ab09cdbc942, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17649 4475 4350 4350
q2 q3 11167 759 515 515
q4 4714 356 260 260
q5 7611 1229 1034 1034
q6 179 179 148 148
q7 795 858 677 677
q8 9305 1447 1297 1297
q9 4787 4706 4701 4701
q10 6814 1865 1648 1648
q11 485 259 242 242
q12 716 558 463 463
q13 17769 4218 3406 3406
q14 232 227 215 215
q15 940 785 794 785
q16 754 716 688 688
q17 709 827 462 462
q18 5970 5284 5284 5284
q19 1126 964 604 604
q20 499 488 386 386
q21 4458 1944 1494 1494
q22 390 318 260 260
Total cold run time: 97069 ms
Total hot run time: 28919 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 4730 4670 4576 4576
q2 q3 1844 2222 1800 1800
q4 865 1169 773 773
q5 4012 4345 4327 4327
q6 177 174 136 136
q7 1760 1631 1523 1523
q8 2473 2692 2487 2487
q9 7497 7299 7448 7299
q10 2704 2803 2403 2403
q11 509 430 411 411
q12 501 590 459 459
q13 4072 4607 3581 3581
q14 288 306 268 268
q15 856 810 833 810
q16 723 792 758 758
q17 1209 1496 1308 1308
q18 7096 6762 6543 6543
q19 865 859 891 859
q20 2039 2144 2014 2014
q21 3887 3479 3383 3383
q22 507 466 420 420
Total cold run time: 48614 ms
Total hot run time: 46138 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3926826966
# FE Regression Coverage Report
Increment line coverage ` 80.00% (16/20)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796626020
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795283343
<details>
<summary>TPC-DS: <b>Total hot run time: 172048 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 cde916d038ad559601ca6c71c9b8de08d7d4ea21, data reload: false
query5 4415 629 505 505
query6 328 219 197 197
query7 4214 452 245 245
query8 319 253 237 237
query9 8729 2847 2809 2809
query10 461 319 254 254
query11 15246 15087 14960 14960
query12 181 120 117 117
query13 1254 448 368 368
query14 6013 3032 2802 2802
query14_1 2673 2661 2684 2661
query15 206 192 176 176
query16 968 409 482 409
query17 1094 673 559 559
query18 2418 435 328 328
query19 228 169 142 142
query20 124 114 116 114
query21 209 143 114 114
query22 3931 4052 4040 4040
query23 16135 15733 15302 15302
query23_1 15361 15738 15372 15372
query24 7302 1546 1129 1129
query24_1 1151 1145 1152 1145
query25 502 434 375 375
query26 1238 270 148 148
query27 2768 433 271 271
query28 4581 2152 2149 2149
query29 755 527 416 416
query30 316 240 206 206
query31 812 628 560 560
query32 82 73 73 73
query33 523 339 298 298
query34 891 861 519 519
query35 730 758 669 669
query36 890 886 831 831
query37 134 95 87 87
query38 2663 2646 2654 2646
query39 777 769 733 733
query39_1 696 706 705 705
query40 220 133 112 112
query41 65 61 61 61
query42 91 91 92 91
query43 441 443 438 438
query44 1321 750 736 736
query45 188 183 177 177
query46 848 935 577 577
query47 1361 1372 1377 1372
query48 308 310 234 234
query49 602 425 327 327
query50 678 268 201 201
query51 3720 3779 3710 3710
query52 96 91 80 80
query53 204 230 162 162
query54 270 285 241 241
query55 81 85 74 74
query56 286 277 297 277
query57 983 1002 957 957
query58 261 253 265 253
query59 2041 2150 2114 2114
query60 328 319 308 308
query61 157 136 136 136
query62 395 361 302 302
query63 192 163 164 163
query64 4908 1160 867 867
query65 3832 3734 3697 3697
query66 1441 434 313 313
query67 15343 15598 15401 15401
query68 2492 1070 716 716
query69 384 305 274 274
query70 1020 949 953 949
query71 298 284 264 264
query72 5277 3271 3429 3271
query73 586 721 315 315
query74 8766 8791 8566 8566
query75 2343 2316 1893 1893
query76 2264 1055 653 653
query77 353 426 297 297
query78 9588 9903 9034 9034
query79 1087 914 579 579
query80 1476 509 438 438
query81 532 259 228 228
query82 1308 145 115 115
query83 340 257 244 244
query84 259 120 92 92
query85 1110 468 408 408
query86 418 302 279 279
query87 2841 2860 2748 2748
query88 3468 2577 2557 2557
query89 309 254 237 237
query90 1876 171 166 166
query91 156 151 131 131
query92 74 72 68 68
query93 1068 998 642 642
query94 641 314 293 293
query95 571 335 311 311
query96 648 506 229 229
query97 2393 2361 2314 2314
query98 208 201 198 198
query99 607 554 495 495
Total cold run time: 246031 ms
Total hot run time: 172048 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795487936
# FE Regression Coverage Report
Increment line coverage ` 78.12% (25/32)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_cde916d038ad559601ca6c71c9b8de08d7d4ea21_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_cde916d038ad559601ca6c71c9b8de08d7d4ea21_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "yx-keith (via GitHub)" <gi...@apache.org>.
yx-keith commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4933925379
/review
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4883157869
# FE Regression Coverage Report
Increment line coverage ` 91.30% (42/46)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_0b954fff78b3cc81b9cba81027159affbfa3a64f_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_0b954fff78b3cc81b9cba81027159affbfa3a64f_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884386143
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884702913
<details>
<summary>ClickBench: <b>Total hot run time: 25.92 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 fd68b3705c2068ca299757dce404b4500a41db2d, data reload: false
query1 0.01 0.01 0.01
query2 0.10 0.05 0.05
query3 0.25 0.14 0.14
query4 1.60 0.14 0.14
query5 0.26 0.25 0.28
query6 1.27 1.14 1.09
query7 0.04 0.01 0.01
query8 0.05 0.03 0.04
query9 0.40 0.35 0.32
query10 0.61 0.60 0.60
query11 0.20 0.15 0.14
query12 0.18 0.14 0.15
query13 0.52 0.51 0.50
query14 1.05 1.04 1.03
query15 0.64 0.62 0.63
query16 0.32 0.33 0.34
query17 1.16 1.15 1.13
query18 0.23 0.22 0.22
query19 2.14 2.00 1.98
query20 0.01 0.01 0.02
query21 15.41 0.22 0.13
query22 4.80 0.05 0.05
query23 16.13 0.32 0.12
query24 2.99 0.43 0.34
query25 0.11 0.04 0.04
query26 0.73 0.21 0.15
query27 0.04 0.04 0.04
query28 3.55 0.97 0.52
query29 12.48 4.40 3.47
query30 0.28 0.15 0.15
query31 2.77 0.65 0.34
query32 3.23 0.62 0.50
query33 3.23 3.24 3.25
query34 15.63 4.68 3.65
query35 3.67 3.64 3.72
query36 0.58 0.43 0.44
query37 0.10 0.07 0.06
query38 0.05 0.04 0.03
query39 0.04 0.03 0.03
query40 0.19 0.18 0.16
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 97.21 s
Total hot run time: 25.92 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4568157082
# FE Regression Coverage Report
Increment line coverage ` 80.00% (16/20)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_e91d378791fea091012e1b64f9a0ad4c34ba224f_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_e91d378791fea091012e1b64f9a0ad4c34ba224f_merge_fe/report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on code in PR #60209:
URL: https://github.com/apache/doris/pull/60209#discussion_r2726649905
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/BrokerMgr.java:
##########
@@ -52,7 +53,7 @@
*/
public class BrokerMgr {
public static final ImmutableList<String> BROKER_PROC_NODE_TITLE_NAMES = new ImmutableList.Builder<String>()
- .add("Name").add("Host").add("Port").add("Alive")
+ .add("Name").add("Host").add("IP").add("Port").add("Alive")
Review Comment:
https://github.com/apache/doris/pull/60211
https://github.com/apache/doris/pull/60210
Because of this two bugs in these two PRs, if I put this IP field to the end, it will result in display incorrectly, or you can merge these two PRs firstly, then I can rebase and adjust this field to the end.
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796694532
<details>
<summary>ClickBench: <b>Total hot run time: 26.94 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 c869fb3847552324fbba6a888060dd6431627e0d, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.09 0.08
query4 1.60 0.11 0.11
query5 0.27 0.25 0.25
query6 1.14 0.66 0.65
query7 0.03 0.03 0.02
query8 0.05 0.03 0.04
query9 0.58 0.49 0.50
query10 0.55 0.54 0.54
query11 0.14 0.09 0.09
query12 0.14 0.10 0.11
query13 0.59 0.58 0.58
query14 0.95 0.95 0.93
query15 0.78 0.77 0.79
query16 0.41 0.39 0.41
query17 1.01 1.08 1.05
query18 0.22 0.22 0.21
query19 1.91 1.83 1.84
query20 0.02 0.02 0.01
query21 15.42 0.29 0.14
query22 5.43 0.05 0.04
query23 16.29 0.27 0.10
query24 1.06 0.63 0.59
query25 0.10 0.13 0.05
query26 0.14 0.13 0.13
query27 0.08 0.06 0.06
query28 4.97 1.06 0.88
query29 12.57 3.87 3.13
query30 0.27 0.16 0.13
query31 2.81 0.62 0.37
query32 3.23 0.55 0.46
query33 2.91 2.97 2.98
query34 16.12 5.05 4.37
query35 4.48 4.44 4.46
query36 0.64 0.49 0.48
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.16 0.15 0.14
query41 0.09 0.03 0.03
query42 0.04 0.04 0.03
query43 0.05 0.04 0.04
Total cold run time: 97.87 s
Total hot run time: 26.94 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3797030346
# FE Regression Coverage Report
Increment line coverage ` 84.62% (22/26)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_c869fb3847552324fbba6a888060dd6431627e0d_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_c869fb3847552324fbba6a888060dd6431627e0d_merge_fe/report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795098714
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3795266440
<details>
<summary>TPC-H: <b>Total hot run time: 30842 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 cde916d038ad559601ca6c71c9b8de08d7d4ea21, data reload: false
------ Round 1 ----------------------------------
q1 17681 4851 4560 4560
q2 2060 309 190 190
q3 10240 1318 721 721
q4 10197 811 306 306
q5 7511 2066 1885 1885
q6 193 170 138 138
q7 854 724 575 575
q8 9263 1411 1142 1142
q9 5011 4674 4527 4527
q10 6808 1645 1264 1264
q11 505 291 287 287
q12 351 374 218 218
q13 17802 3861 3129 3129
q14 234 227 214 214
q15 601 535 525 525
q16 655 638 577 577
q17 647 744 560 560
q18 6690 6494 6398 6398
q19 1255 992 644 644
q20 388 350 222 222
q21 2711 1974 1837 1837
q22 1019 992 923 923
Total cold run time: 102676 ms
Total hot run time: 30842 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4768 4745 4700 4700
q2 337 395 329 329
q3 2178 2683 2282 2282
q4 1337 1815 1276 1276
q5 4147 3982 3957 3957
q6 209 172 135 135
q7 1936 1840 1804 1804
q8 2697 2514 2464 2464
q9 7195 7309 7200 7200
q10 2542 2761 2326 2326
q11 557 477 465 465
q12 748 776 656 656
q13 3632 4175 3536 3536
q14 322 299 292 292
q15 573 517 550 517
q16 659 721 640 640
q17 1169 1314 1405 1314
q18 7774 7666 7724 7666
q19 1016 949 848 848
q20 2029 2080 1898 1898
q21 4902 4274 4170 4170
q22 1032 1015 953 953
Total cold run time: 51759 ms
Total hot run time: 49428 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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796732547
# FE UT Coverage Report
Increment line coverage ` 69.23% (18/26)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_c869fb3847552324fbba6a888060dd6431627e0d/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_c869fb3847552324fbba6a888060dd6431627e0d/fe_report/index.html)
--
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] [Feature] (show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3796146852
<details>
<summary>ClickBench: <b>Total hot run time: 26.7 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 c6fefedaab4157906ab7bac98f704ff5ef9959bf, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.04 0.04
query3 0.25 0.09 0.08
query4 1.61 0.11 0.11
query5 0.26 0.26 0.24
query6 1.14 0.66 0.66
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.59 0.50 0.50
query10 0.55 0.56 0.55
query11 0.14 0.09 0.09
query12 0.15 0.10 0.11
query13 0.61 0.58 0.59
query14 0.94 0.94 0.94
query15 0.80 0.77 0.76
query16 0.40 0.39 0.39
query17 1.05 1.04 1.01
query18 0.22 0.20 0.20
query19 1.95 1.79 1.82
query20 0.01 0.01 0.02
query21 15.44 0.24 0.14
query22 5.03 0.06 0.05
query23 15.75 0.29 0.10
query24 1.49 0.31 0.45
query25 0.10 0.08 0.05
query26 0.15 0.14 0.13
query27 0.08 0.06 0.06
query28 4.01 1.08 0.88
query29 12.59 3.97 3.16
query30 0.29 0.14 0.12
query31 2.81 0.62 0.40
query32 3.25 0.55 0.46
query33 2.96 2.98 3.05
query34 15.95 5.02 4.45
query35 4.41 4.42 4.41
query36 0.64 0.50 0.49
query37 0.12 0.07 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.13 0.14
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 96.43 s
Total hot run time: 26.7 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3925970879
<details>
<summary>TPC-DS: <b>Total hot run time: 183502 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 5c835d81b5e9d7035e1b63f784b83ab09cdbc942, data reload: false
query5 4574 639 507 507
query6 338 220 208 208
query7 4233 479 282 282
query8 348 265 229 229
query9 8773 2781 2759 2759
query10 532 384 354 354
query11 16949 17323 17330 17323
query12 199 136 137 136
query13 1331 495 370 370
query14 6922 3294 2980 2980
query14_1 2865 2855 2908 2855
query15 217 274 180 180
query16 961 482 469 469
query17 1272 739 591 591
query18 2838 462 342 342
query19 216 221 182 182
query20 144 146 135 135
query21 218 148 122 122
query22 4950 5076 4690 4690
query23 17221 16720 16537 16537
query23_1 16716 16626 16773 16626
query24 7413 1621 1220 1220
query24_1 1224 1240 1215 1215
query25 520 452 395 395
query26 1226 263 146 146
query27 2792 476 280 280
query28 4534 1870 1854 1854
query29 791 565 456 456
query30 313 235 206 206
query31 878 728 631 631
query32 77 74 70 70
query33 514 348 314 314
query34 908 916 567 567
query35 637 657 596 596
query36 1075 1131 985 985
query37 132 95 85 85
query38 2945 2913 2915 2913
query39 898 880 854 854
query39_1 833 820 834 820
query40 224 148 137 137
query41 62 70 62 62
query42 108 103 103 103
query43 366 372 350 350
query44
query45 197 188 180 180
query46 888 980 602 602
query47 2126 2165 2047 2047
query48 306 322 233 233
query49 647 458 377 377
query50 671 276 215 215
query51 4049 4100 4042 4042
query52 108 108 96 96
query53 289 326 291 291
query54 297 286 270 270
query55 90 84 87 84
query56 306 311 317 311
query57 1374 1343 1261 1261
query58 281 267 269 267
query59 2544 2626 2529 2529
query60 337 339 323 323
query61 147 145 148 145
query62 629 588 545 545
query63 310 277 275 275
query64 4856 1349 1088 1088
query65
query66 1408 469 370 370
query67 16451 16462 16294 16294
query68
query69 419 320 291 291
query70 998 970 888 888
query71 346 321 298 298
query72 2947 2913 2597 2597
query73 535 542 321 321
query74 9940 9925 9719 9719
query75 2824 2734 2476 2476
query76 2287 1021 658 658
query77 363 375 321 321
query78 11115 11331 10675 10675
query79 3001 817 596 596
query80 1772 633 543 543
query81 563 284 249 249
query82 992 149 113 113
query83 334 259 251 251
query84 253 124 97 97
query85 898 482 427 427
query86 410 324 292 292
query87 3086 3119 3004 3004
query88 3560 2667 2672 2667
query89 428 365 338 338
query90 1997 183 181 181
query91 162 156 132 132
query92 80 74 74 74
query93 1266 838 506 506
query94 639 320 276 276
query95 595 345 320 320
query96 641 520 231 231
query97 2465 2472 2418 2418
query98 243 214 217 214
query99 1006 1003 911 911
Total cold run time: 256214 ms
Total hot run time: 183502 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-3926811421
# FE Regression Coverage Report
Increment line coverage ` 80.00% (16/20)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60209_5c835d81b5e9d7035e1b63f784b83ab09cdbc942_merge_fe/report/index.html)
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4884692292
<details>
<summary>TPC-DS: <b>Total hot run time: 174367 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 fd68b3705c2068ca299757dce404b4500a41db2d, data reload: false
query5 4314 636 489 489
query6 480 214 197 197
query7 4848 591 347 347
query8 341 194 171 171
query9 8776 4074 4075 4074
query10 447 344 309 309
query11 5960 2348 2125 2125
query12 164 102 98 98
query13 1255 629 431 431
query14 6238 5317 5038 5038
query14_1 4290 4336 4317 4317
query15 214 199 181 181
query16 1000 456 431 431
query17 1105 709 585 585
query18 2424 459 332 332
query19 204 182 145 145
query20 114 102 109 102
query21 231 162 136 136
query22 13806 13602 13401 13401
query23 17297 16481 16135 16135
query23_1 16219 16321 16254 16254
query24 7674 1773 1307 1307
query24_1 1317 1297 1285 1285
query25 548 443 388 388
query26 1337 358 210 210
query27 2602 604 398 398
query28 4512 2036 2000 2000
query29 1088 626 511 511
query30 334 270 232 232
query31 1119 1095 996 996
query32 101 64 62 62
query33 538 339 274 274
query34 1189 1154 653 653
query35 771 802 678 678
query36 1420 1384 1243 1243
query37 156 111 96 96
query38 1912 1737 1654 1654
query39 932 927 903 903
query39_1 887 928 933 928
query40 252 171 146 146
query41 72 71 72 71
query42 99 96 98 96
query43 335 341 288 288
query44 1466 824 792 792
query45 213 193 193 193
query46 1100 1238 780 780
query47 2443 2368 2267 2267
query48 403 422 298 298
query49 578 414 324 324
query50 1082 413 335 335
query51 4462 4395 4370 4370
query52 86 83 74 74
query53 270 268 208 208
query54 282 242 199 199
query55 75 79 69 69
query56 294 285 280 280
query57 1452 1407 1306 1306
query58 297 260 256 256
query59 1563 1632 1420 1420
query60 301 274 245 245
query61 154 150 152 150
query62 691 651 571 571
query63 254 202 211 202
query64 2528 771 602 602
query65 4865 4820 4780 4780
query66 1815 505 391 391
query67 29531 29489 29368 29368
query68 3270 1561 931 931
query69 415 316 296 296
query70 1077 1010 907 907
query71 365 338 299 299
query72 2898 2678 2382 2382
query73 807 810 442 442
query74 5098 4999 4760 4760
query75 2601 2597 2275 2275
query76 2334 1186 790 790
query77 351 376 294 294
query78 12412 12347 11809 11809
query79 1338 1166 784 784
query80 649 524 459 459
query81 502 327 280 280
query82 573 157 121 121
query83 393 315 295 295
query84 273 162 136 136
query85 925 604 519 519
query86 363 299 266 266
query87 1833 1823 1755 1755
query88 3669 2804 2850 2804
query89 449 405 355 355
query90 1951 215 196 196
query91 199 195 162 162
query92 67 57 57 57
query93 1614 1572 980 980
query94 546 365 328 328
query95 790 578 484 484
query96 1070 797 351 351
query97 2691 2687 2635 2635
query98 215 212 200 200
query99 1175 1177 1027 1027
Total cold run time: 258415 ms
Total hot run time: 174367 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "yx-keith (via GitHub)" <gi...@apache.org>.
yx-keith commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4931621930
/review
--
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4567018168
<details>
<summary>TPC-H: <b>Total hot run time: 31038 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 e91d378791fea091012e1b64f9a0ad4c34ba224f, data reload: false
------ Round 1 ----------------------------------
orders Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 17677 3972 3966 3966
q2 q3 10797 1397 788 788
q4 4684 468 345 345
q5 7558 2239 2086 2086
q6 246 178 133 133
q7 948 786 629 629
q8 9386 1681 1594 1594
q9 6563 4952 4917 4917
q10 6429 2224 1888 1888
q11 428 277 253 253
q12 689 427 298 298
q13 18243 3345 2760 2760
q14 271 256 237 237
q15 q16 827 771 707 707
q17 987 951 1027 951
q18 7089 5794 5574 5574
q19 1186 1260 1077 1077
q20 532 392 261 261
q21 5747 2662 2279 2279
q22 425 353 295 295
Total cold run time: 100712 ms
Total hot run time: 31038 ms
----- Round 2, with runtime_filter_mode=off -----
orders Doris NULL NULL 150000000 42 6422171781 NULL 22778155 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL
============================================
q1 4280 4410 4214 4214
q2 q3 4509 4917 4358 4358
q4 2054 2183 1356 1356
q5 4406 4285 4265 4265
q6 226 169 169 169
q7 2180 1857 1699 1699
q8 2448 2147 2083 2083
q9 8087 7977 7882 7882
q10 4807 4750 4363 4363
q11 770 471 372 372
q12 734 747 530 530
q13 3353 3592 2975 2975
q14 297 319 268 268
q15 q16 750 754 650 650
q17 1355 1308 1292 1292
q18 7962 7326 6978 6978
q19 1099 1095 1089 1089
q20 2220 2219 1921 1921
q21 5216 4511 4405 4405
q22 527 473 398 398
Total cold run time: 57280 ms
Total hot run time: 51267 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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "heguanhui (via GitHub)" <gi...@apache.org>.
heguanhui commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4566775573
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] [Feature](show) add IP field display for show frontends/backends/broker commands and RestAPIs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60209:
URL: https://github.com/apache/doris/pull/60209#issuecomment-4890333394
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