You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2024/10/31 02:44:23 UTC
[PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
github-actions[bot] opened a new pull request, #42965:
URL: https://github.com/apache/doris/pull/42965
PR Body: ## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
Bug:
In the previous implementation, the default compute group did not check if the user had usage permissions.
This issue has now been fixed.
When using the default compute group, a prerequisite for successfully setting it for userA is that userA already has usage permissions for the compute group.
For example:
```
1. GRANT USAGE_PRIV ON COMPUTE GROUP {cluster} TO userA
2. SET PROPERTY FOR userA 'DEFAULT_CLOUD_CLUSTER' = '{cluster}'
```
Cherry-picked from #42504
--
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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2461249625
<details>
<summary>TPC-DS: <b>Total hot run time: 192706 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 57284fa9c1d41ab61ab256d248f1202d7dfd9dfb, data reload: false
query1 2402 2229 2240 2229
query2 6239 2109 1987 1987
query3 14858 10202 242 242
query4 34819 23492 23346 23346
query5 5716 472 429 429
query6 376 176 195 176
query7 5540 304 304 304
query8 313 233 228 228
query9 9632 2657 2651 2651
query10 536 266 256 256
query11 18299 15074 15196 15074
query12 145 96 100 96
query13 1583 427 417 417
query14 11148 7081 7181 7081
query15 255 182 172 172
query16 7826 520 524 520
query17 1316 571 580 571
query18 2383 631 641 631
query19 286 209 194 194
query20 117 111 121 111
query21 208 107 105 105
query22 4462 4379 4205 4205
query23 34900 33937 33548 33548
query24 6781 3411 3394 3394
query25 578 404 408 404
query26 739 184 187 184
query27 1812 297 297 297
query28 4531 2512 2478 2478
query29 751 433 429 429
query30 385 307 300 300
query31 962 806 761 761
query32 84 56 55 55
query33 492 279 276 276
query34 891 501 506 501
query35 802 728 720 720
query36 1063 959 959 959
query37 117 72 70 70
query38 3963 3806 3811 3806
query39 1464 1416 1435 1416
query40 195 99 101 99
query41 51 53 51 51
query42 107 99 96 96
query43 534 501 485 485
query44 1154 792 779 779
query45 182 166 167 166
query46 1130 715 709 709
query47 1881 1808 1800 1800
query48 463 374 379 374
query49 744 391 389 389
query50 806 412 407 407
query51 7151 6903 7071 6903
query52 101 92 96 92
query53 252 180 185 180
query54 558 443 453 443
query55 76 77 74 74
query56 269 232 241 232
query57 1151 1119 1125 1119
query58 211 198 199 198
query59 3236 3034 2929 2929
query60 259 249 240 240
query61 106 106 113 106
query62 776 646 649 646
query63 213 189 201 189
query64 3275 616 595 595
query65 3238 3144 3185 3144
query66 669 304 303 303
query67 15861 15463 15403 15403
query68 4586 566 569 566
query69 454 259 288 259
query70 1228 1136 1108 1108
query71 360 246 248 246
query72 6767 3832 3850 3832
query73 749 338 338 338
query74 10007 8907 9031 8907
query75 3302 2628 2644 2628
query76 3020 1046 909 909
query77 592 257 268 257
query78 10649 9767 9569 9569
query79 8741 583 591 583
query80 2343 422 425 422
query81 560 242 243 242
query82 1449 120 114 114
query83 278 155 151 151
query84 293 79 73 73
query85 1817 296 278 278
query86 473 279 296 279
query87 4643 4189 4278 4189
query88 5777 2368 2376 2368
query89 559 283 288 283
query90 2335 187 177 177
query91 176 144 146 144
query92 67 48 46 46
query93 7813 547 527 527
query94 1055 278 286 278
query95 346 250 255 250
query96 624 283 289 283
query97 3323 3151 3149 3149
query98 215 197 190 190
query99 1578 1287 1290 1287
Total cold run time: 319602 ms
Total hot run time: 192706 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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2461239741
<details>
<summary>TPC-H: <b>Total hot run time: 40545 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 57284fa9c1d41ab61ab256d248f1202d7dfd9dfb, data reload: false
------ Round 1 ----------------------------------
q1 17565 7336 7239 7239
q2 2064 163 177 163
q3 10683 1068 1110 1068
q4 10537 729 770 729
q5 7745 2808 2822 2808
q6 233 148 146 146
q7 977 614 622 614
q8 9380 1962 2011 1962
q9 6543 6415 6400 6400
q10 6990 2288 2313 2288
q11 452 257 263 257
q12 404 209 206 206
q13 17784 2983 2961 2961
q14 246 206 216 206
q15 571 533 512 512
q16 685 601 615 601
q17 969 629 596 596
q18 7183 6701 6544 6544
q19 3019 1078 1000 1000
q20 482 196 197 196
q21 3965 3158 3069 3069
q22 1096 998 980 980
Total cold run time: 109573 ms
Total hot run time: 40545 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7322 7208 7217 7208
q2 399 324 318 318
q3 3033 2966 2976 2966
q4 2165 1908 1774 1774
q5 5694 5680 5706 5680
q6 217 147 144 144
q7 2146 1764 1738 1738
q8 3341 3527 3380 3380
q9 8880 8864 8791 8791
q10 3543 3511 3469 3469
q11 625 495 505 495
q12 842 610 590 590
q13 16458 3129 3175 3129
q14 315 288 288 288
q15 607 551 545 545
q16 720 665 655 655
q17 1851 1595 1587 1587
q18 8116 7893 7466 7466
q19 1797 1569 1641 1569
q20 2070 1847 1828 1828
q21 5332 5245 5175 5175
q22 1141 1056 1016 1016
Total cold run time: 76614 ms
Total hot run time: 59811 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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2448909312
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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #42965: branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage
URL: https://github.com/apache/doris/pull/42965
--
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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #42965:
URL: https://github.com/apache/doris/pull/42965
--
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] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2448909367
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2461201601
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