You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "cambyzju (via GitHub)" <gi...@apache.org> on 2025/04/11 11:46:55 UTC
[PR] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
cambyzju opened a new pull request, #49996:
URL: https://github.com/apache/doris/pull/49996
### What problem does this PR solve?
pick #49658 to branch-3.0
### Release note
None
### 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? -->
- 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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2796769785
<details>
<summary>TPC-H: <b>Total hot run time: 39931 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 2681610d68b5d2479be00174ed8972a2407f88e3, data reload: false
------ Round 1 ----------------------------------
q1 17577 6729 6630 6630
q2 2075 176 189 176
q3 10546 1097 1190 1097
q4 10566 703 705 703
q5 7726 2802 2742 2742
q6 221 132 129 129
q7 969 618 607 607
q8 9353 1918 2034 1918
q9 6597 6387 6387 6387
q10 7044 2225 2293 2225
q11 476 265 270 265
q12 397 218 210 210
q13 17771 2976 2984 2976
q14 244 206 223 206
q15 506 477 466 466
q16 678 617 592 592
q17 972 525 579 525
q18 7355 6763 6742 6742
q19 1396 1020 1064 1020
q20 472 209 202 202
q21 4137 3271 3168 3168
q22 1115 1001 945 945
Total cold run time: 108193 ms
Total hot run time: 39931 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6666 6593 6676 6593
q2 334 249 240 240
q3 2973 2907 2993 2907
q4 2086 1920 1902 1902
q5 5873 5740 5714 5714
q6 215 125 128 125
q7 2200 1813 1826 1813
q8 3413 3566 3529 3529
q9 8692 8929 8880 8880
q10 3565 3547 3511 3511
q11 593 514 481 481
q12 825 591 603 591
q13 9821 3255 3137 3137
q14 297 268 273 268
q15 518 464 455 455
q16 679 649 667 649
q17 1865 1603 1614 1603
q18 8298 7943 7709 7709
q19 1662 1590 1584 1584
q20 2103 1896 1876 1876
q21 5389 5403 5352 5352
q22 1113 1028 998 998
Total cold run time: 69180 ms
Total hot run time: 59917 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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2845733244
will merge to 3.1
--
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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2796684998
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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2796811090
<details>
<summary>ClickBench: <b>Total hot run time: 32.15 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 2681610d68b5d2479be00174ed8972a2407f88e3, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.03
query3 0.24 0.06 0.06
query4 1.62 0.10 0.10
query5 0.51 0.53 0.50
query6 1.15 0.73 0.73
query7 0.02 0.01 0.01
query8 0.05 0.03 0.03
query9 0.56 0.50 0.48
query10 0.54 0.55 0.55
query11 0.16 0.10 0.10
query12 0.14 0.11 0.11
query13 0.61 0.61 0.59
query14 2.71 2.76 2.79
query15 0.90 0.83 0.82
query16 0.39 0.38 0.39
query17 1.03 1.08 1.06
query18 0.24 0.21 0.22
query19 1.90 1.77 1.93
query20 0.01 0.01 0.00
query21 15.35 0.59 0.60
query22 2.28 2.67 1.58
query23 17.05 1.06 0.86
query24 3.57 2.22 1.27
query25 0.35 0.15 0.04
query26 0.45 0.14 0.13
query27 0.06 0.05 0.06
query28 8.65 0.52 0.49
query29 12.55 3.30 3.22
query30 0.25 0.06 0.07
query31 2.84 0.39 0.37
query32 3.25 0.46 0.46
query33 2.96 3.00 3.02
query34 17.15 4.48 4.50
query35 4.52 4.46 4.51
query36 0.69 0.47 0.48
query37 0.09 0.06 0.06
query38 0.04 0.03 0.03
query39 0.03 0.02 0.02
query40 0.16 0.14 0.13
query41 0.07 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 105.32 s
Total hot run time: 32.15 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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2796684825
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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49996:
URL: https://github.com/apache/doris/pull/49996#issuecomment-2796799144
<details>
<summary>TPC-DS: <b>Total hot run time: 197808 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 2681610d68b5d2479be00174ed8972a2407f88e3, data reload: false
query1 1311 914 923 914
query2 6242 2030 1979 1979
query3 10864 4221 4454 4221
query4 60941 28797 23620 23620
query5 5183 490 455 455
query6 404 185 186 185
query7 5471 338 314 314
query8 316 228 225 225
query9 8541 2613 2588 2588
query10 482 286 265 265
query11 17838 15423 15621 15423
query12 157 104 102 102
query13 1406 461 459 459
query14 10790 7218 7079 7079
query15 200 188 179 179
query16 7423 514 466 466
query17 1145 593 614 593
query18 1895 342 337 337
query19 220 164 158 158
query20 119 118 110 110
query21 206 108 105 105
query22 4571 4637 4546 4546
query23 34560 34482 33924 33924
query24 6197 2996 3054 2996
query25 564 416 411 411
query26 670 171 172 171
query27 1905 346 364 346
query28 4261 2477 2435 2435
query29 671 450 448 448
query30 243 177 169 169
query31 998 811 824 811
query32 73 61 60 60
query33 429 329 324 324
query34 922 526 534 526
query35 860 726 743 726
query36 1114 967 977 967
query37 116 68 81 68
query38 4071 3948 4005 3948
query39 1545 1496 1479 1479
query40 204 99 100 99
query41 48 53 51 51
query42 114 100 99 99
query43 538 492 491 491
query44 1198 835 842 835
query45 186 173 178 173
query46 1157 742 767 742
query47 2030 1889 1912 1889
query48 483 380 388 380
query49 725 395 391 391
query50 863 436 423 423
query51 7382 7160 7244 7160
query52 103 92 96 92
query53 269 184 191 184
query54 590 473 482 473
query55 76 76 79 76
query56 266 267 249 249
query57 1238 1162 1166 1162
query58 234 218 235 218
query59 3068 2823 2999 2823
query60 273 256 260 256
query61 133 134 130 130
query62 762 677 659 659
query63 228 195 193 193
query64 1402 688 664 664
query65 3268 3194 3210 3194
query66 711 310 302 302
query67 15790 15621 15603 15603
query68 4245 586 569 569
query69 434 269 303 269
query70 1134 1138 1141 1138
query71 342 267 254 254
query72 6366 4050 3995 3995
query73 773 353 361 353
query74 10342 9191 9067 9067
query75 3340 2688 2625 2625
query76 2039 1135 1030 1030
query77 491 280 272 272
query78 10549 9821 9597 9597
query79 1349 597 607 597
query80 860 448 443 443
query81 529 238 238 238
query82 1179 92 91 91
query83 239 142 142 142
query84 279 88 77 77
query85 878 306 306 306
query86 330 297 300 297
query87 4479 4258 4374 4258
query88 3604 2420 2377 2377
query89 421 289 289 289
query90 2022 184 190 184
query91 185 146 152 146
query92 60 51 50 50
query93 1595 553 563 553
query94 755 296 291 291
query95 367 261 260 260
query96 610 286 282 282
query97 3325 3166 3181 3166
query98 214 200 197 197
query99 1583 1252 1304 1252
Total cold run time: 313181 ms
Total hot run time: 197808 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] [feat](bi) support default_init_catalog user property for external catalog (#49658) [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed pull request #49996: [feat](bi) support default_init_catalog user property for external catalog (#49658)
URL: https://github.com/apache/doris/pull/49996
--
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