Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


doris-robot commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2461249625

   
   
   TPC-DS: Total hot run time: 192706 ms
   
   ```
   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   2402222922402229
   query2   6239210919871987
   query3   14858   10202   242 242
   query4   34819   23492   23346   23346
   query5   5716472 429 429
   query6   376 176 195 176
   query7   5540304 304 304
   query8   313 233 228 228
   query9   9632265726512651
   query10  536 266 256 256
   query11  18299   15074   15196   15074
   query12  145 96  100 96
   query13  1583427 417 417
   query14  11148   708171817081
   query15  255 182 172 172
   query16  7826520 524 520
   query17  1316571 580 571
   query18  2383631 641 631
   query19  286 209 194 194
   query20  117 111 121 111
   query21  208 107 105 105
   query22  4462437942054205
   query23  34900   33937   33548   33548
   query24  6781341133943394
   query25  578 404 408 404
   query26  739 184 187 184
   query27  1812297 297 297
   query28  4531251224782478
   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  1063959 959 959
   query37  117 72  70  70
   query38  3963380638113806
   query39  1464141614351416
   query40  195 99  101 99
   query41  51  53  51  51
   query42  107 99  96  96
   query43  534 501 485 485
   query44  1154792 779 779
   query45  182 166 167 166
   query46  1130715 709 709
   query47  1881180818001800
   query48  463 374 379 374
   query49  744 391 389 389
   query50  806 412 407 407
   query51  7151690370716903
   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  1151111911251119
   query58  211 198 199 198
   query59  3236303429292929
   query60  259 249 240 240
   query61  106 106 113 106
   query62  776 646 649 646
   query63  213 189 201 189
   query64  3275616 595 595
   query65  3238314431853144
   query66  669 304 303 303
   query67  15861   15463   15403   15403
   query68  4586566 569 566
   query69  454 259 288 259
   query70  1228113611081108
   query71  360 246 248 246
   query72  6767383238503832
   query73  749 338 338 338
   query74  10007   890790318907
   query75  3302262826442628
   query76  30201046909 909
   query77  592 257 268 257
   query78  10649   976795699569
   query79  8741583 591 583
   query80  2343422 425 422
   query81  560 242 243 242
   query82  1449120 114 114
   query83  278 155 151 151
   query84  293 79  73  73
   query85  1817296 278 278
   query86  473 279 296 279
   query87  4643418942784189
   query88  5777236823762368
   query89  559 283 288 283
   query90  2335187 177 177
   query91  176 144 146 144
   query92  67  48  46  46
   query93  7813547 527 527
   query94  1055278 286 278
   query95  346 250 255 250
   query96  624 283 289 283
   query97  3323315131493149
   query98  215 197 190 190
   query99  1578128712901287
   Total cold run time: 319602 ms
   Total hot run time: 192706 ms
   ```
   
   


-- 
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 t

Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


doris-robot commented on PR #42965:
URL: https://github.com/apache/doris/pull/42965#issuecomment-2461239741

   
   
   TPC-H: Total hot run time: 40545 ms
   
   ```
   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   733672397239
   q2   2064163 177 163
   q3   10683   106811101068
   q4   10537   729 770 729
   q5   7745280828222808
   q6   233 148 146 146
   q7   977 614 622 614
   q8   9380196220111962
   q9   6543641564006400
   q10  6990228823132288
   q11  452 257 263 257
   q12  404 209 206 206
   q13  17784   298329612961
   q14  246 206 216 206
   q15  571 533 512 512
   q16  685 601 615 601
   q17  969 629 596 596
   q18  7183670165446544
   q19  3019107810001000
   q20  482 196 197 196
   q21  3965315830693069
   q22  1096998 980 980
   Total cold run time: 109573 ms
   Total hot run time: 40545 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7322720872177208
   q2   399 324 318 318
   q3   3033296629762966
   q4   2165190817741774
   q5   5694568057065680
   q6   217 147 144 144
   q7   2146176417381738
   q8   3341352733803380
   q9   8880886487918791
   q10  3543351134693469
   q11  625 495 505 495
   q12  842 610 590 590
   q13  16458   312931753129
   q14  315 288 288 288
   q15  607 551 545 545
   q16  720 665 655 655
   q17  1851159515871587
   q18  8116789374667466
   q19  1797156916411569
   q20  2070184718281828
   q21  5332524551755175
   q22  1141105610161016
   Total cold run time: 76614 ms
   Total hot run time: 59811 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



[PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


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
   
   
   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-11-06 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



[PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-10-30 Thread via GitHub


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
   
   
   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-10-30 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [fix](cloud)Compatibility with the initial default compute group usage [doris]

2024-10-30 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]