Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
w41ter commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561751094 @justfortaste Please update the doris_website. -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
lide-reed merged PR #44905: URL: https://github.com/apache/doris/pull/44905 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561677813 ClickBench: Total hot run time: 31.46 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit bb3c295d2aee0e08c15186bc3163bd3ad1988481, data reload: false query1 0.030.030.03 query2 0.070.030.03 query3 0.240.080.08 query4 1.610.110.11 query5 0.410.440.43 query6 1.160.660.65 query7 0.020.020.02 query8 0.040.040.04 query9 0.580.500.50 query10 0.550.580.56 query11 0.150.100.10 query12 0.130.110.10 query13 0.610.610.61 query14 2.742.772.84 query15 0.880.830.83 query16 0.380.380.38 query17 1.061.061.05 query18 0.220.200.21 query19 1.871.882.00 query20 0.010.000.01 query21 15.38 0.920.57 query22 0.750.860.70 query23 15.22 1.450.58 query24 3.300.861.25 query25 0.170.110.08 query26 0.290.150.14 query27 0.050.060.05 query28 14.01 1.551.06 query29 12.57 3.973.26 query30 0.250.090.07 query31 2.820.600.39 query32 3.230.560.48 query33 3.003.053.08 query34 16.65 5.154.48 query35 4.514.544.52 query36 0.650.490.51 query37 0.090.060.06 query38 0.040.040.04 query39 0.040.030.02 query40 0.160.130.12 query41 0.080.030.02 query42 0.040.030.02 query43 0.030.040.03 Total cold run time: 106.09 s Total hot run time: 31.46 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561675174 TPC-DS: Total hot run time: 197667 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 bb3c295d2aee0e08c15186bc3163bd3ad1988481, data reload: false query1 13001011917 917 query2 6331237423102310 query3 11086 485650494856 query4 33492 24125 23368 23368 query5 5362632 456 456 query6 281 201 211 201 query7 3992489 305 305 query8 291 245 235 235 query9 9742273127312731 query10 491 297 238 238 query11 18036 15521 15184 15184 query12 158 103 106 103 query13 1629541 394 394 query14 11105 747969476947 query15 238 204 193 193 query16 7916658 443 443 query17 1491754 586 586 query18 2055410 321 321 query19 197 182 177 177 query20 130 122 114 114 query21 206 130 109 109 query22 4759456045244524 query23 34268 33612 33496 33496 query24 6302235923382338 query25 474 462 382 382 query26 874 266 160 160 query27 2097469 341 341 query28 5696253424882488 query29 607 558 422 422 query30 209 181 150 150 query31 980 958 844 844 query32 72 63 58 58 query33 481 359 304 304 query34 778 853 513 513 query35 828 832 761 761 query36 10241060974 974 query37 117 105 76 76 query38 4463436342164216 query39 1585147114351435 query40 221 123 113 113 query41 48 49 45 45 query42 121 103 102 102 query43 533 523 494 494 query44 1382829 843 829 query45 189 186 183 183 query46 921 1062651 651 query47 2036202919271927 query48 396 421 323 323 query49 728 468 397 397 query50 632 679 404 404 query51 7135733971907190 query52 101 101 95 95 query53 237 252 182 182 query54 475 495 452 452 query55 87 81 80 80 query56 255 280 253 253 query57 1226121511951195 query58 230 235 226 226 query59 3124329832193219 query60 285 267 248 248 query61 102 114 114 114 query62 896 798 758 758 query63 230 186 196 186 query64 32891038684 684 query65 3332327232453245 query66 1051411 317 317 query67 16985 15828 15530 15530 query68 9780763 526 526 query69 497 287 250 250 query70 1209114111431141 query71 462 285 252 252 query72 5934386238213821 query73 863 750 360 360 query74 10319 932492989298 query75 4811313826932693 query76 56201187768 768 query77 1044356 269 269 query78 10155 10197 99559955 query79 3571888 589 589 query80 686 509 441 441 query81 492 260 224 224 query82 460 144 121 121 query83 196 167 152 152 query84 280 95 66 66 query85 754 362 294 294 query86 441 304 305 304 query87 4671450945034503 query88 3536223922072207 query89 411 331 310 310 query90 2036187 181 181 query91 134 140 104 104 query92 71 57 50 50 query93 1361886 545 545 query94 661 400 289 289 query95 331 265 247 247 query96 487 607 279 279 query97 2765285326512651 query98 233 203 197 197 query99 1680155514681468 Total cold run time: 303341 ms Total hot run time: 197667 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 t
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561668933 TPC-H: Total hot run time: 32776 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit bb3c295d2aee0e08c15186bc3163bd3ad1988481, data reload: false -- Round 1 -- q1 17587 615760606060 q2 2056293 159 159 q3 10441 1261732 732 q4 10207 864 423 423 q5 7525218819581958 q6 205 183 144 144 q7 897 778 609 609 q8 9247134711461146 q9 5225500349914991 q10 6770230619021902 q11 478 281 254 254 q12 350 359 219 219 q13 18109 367430173017 q14 244 240 220 220 q15 584 511 516 511 q16 617 621 583 583 q17 556 842 314 314 q18 7026643468266434 q19 1644980 559 559 q20 305 324 198 198 q21 2901230920252025 q22 383 352 318 318 Total cold run time: 103357 ms Total hot run time: 32776 ms - Round 2, with runtime_filter_mode=off - q1 6345631263886312 q2 244 324 237 237 q3 2257281124882488 q4 1436186414101410 q5 4562490851064908 q6 191 180 143 143 q7 2145209519271927 q8 2708284127582758 q9 7380737571777177 q10 3020340728542854 q11 597 506 492 492 q12 706 753 567 567 q13 3356376130543054 q14 289 298 280 280 q15 574 546 530 530 q16 676 686 636 636 q17 1186173612611261 q18 7552752574337433 q19 803 117810701070 q20 1938203519081908 q21 5718541149804980 q22 614 604 559 559 Total cold run time: 54297 ms Total hot run time: 52984 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
liutang123 commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561650159 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
github-actions[bot] commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2561046994 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2560613379 runbuild all -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2560523567 ClickBench: Total hot run time: 32.95 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 424bbf8f5cf625d8f59ad13089bb0c6d37a38f2e, data reload: false query1 0.040.040.03 query2 0.080.030.03 query3 0.230.070.07 query4 1.610.110.11 query5 0.410.390.41 query6 1.160.660.64 query7 0.020.020.02 query8 0.040.030.03 query9 0.570.520.52 query10 0.550.550.54 query11 0.140.100.10 query12 0.140.110.11 query13 0.610.600.59 query14 2.702.732.71 query15 0.900.830.83 query16 0.390.390.37 query17 1.081.081.02 query18 0.230.230.22 query19 1.851.892.00 query20 0.010.010.01 query21 15.37 0.590.58 query22 2.972.161.63 query23 16.95 1.160.84 query24 3.021.501.99 query25 0.260.240.06 query26 0.510.130.14 query27 0.050.050.04 query28 9.511.111.08 query29 12.65 3.273.23 query30 0.240.060.06 query31 2.870.390.39 query32 3.240.460.47 query33 3.233.163.02 query34 16.87 4.454.54 query35 4.484.484.49 query36 0.700.480.49 query37 0.100.060.07 query38 0.050.040.03 query39 0.040.030.02 query40 0.170.130.12 query41 0.070.020.02 query42 0.030.020.02 query43 0.030.020.03 Total cold run time: 106.17 s Total hot run time: 32.95 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2560520381 TPC-DS: Total hot run time: 196134 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 424bbf8f5cf625d8f59ad13089bb0c6d37a38f2e, data reload: false query1 1305944 930 930 query2 6258232522512251 query3 10962 465247934652 query4 33632 23309 23406 23309 query5 4736463 437 437 query6 292 232 193 193 query7 4002300 304 300 query8 311 238 239 238 query9 9572276727602760 query10 504 259 258 258 query11 17906 15101 15123 15101 query12 164 106 103 103 query13 1584429 443 429 query14 10119 686968016801 query15 266 180 213 180 query16 7977472 426 426 query17 1592589 591 589 query18 2087306 317 306 query19 368 167 161 161 query20 136 113 118 113 query21 203 114 109 109 query22 4854471444714471 query23 34441 33908 33857 33857 query24 10436 252325552523 query25 641 388 390 388 query26 1195160 165 160 query27 2657336 336 336 query28 7746250724982498 query29 820 427 439 427 query30 238 150 151 150 query31 1055848 852 848 query32 94 58 56 56 query33 766 295 304 295 query34 1146537 518 518 query35 913 745 749 745 query36 1121971 961 961 query37 154 79 74 74 query38 4346416143344161 query39 1507149414121412 query40 211 104 103 103 query41 45 44 44 44 query42 120 108 104 104 query43 543 507 502 502 query44 1317864 847 847 query45 189 197 172 172 query46 1187763 750 750 query47 1983190319081903 query48 444 336 338 336 query49 933 395 392 392 query50 843 392 383 383 query51 7317710372407103 query52 99 94 91 91 query53 266 185 183 183 query54 1172415 421 415 query55 78 88 79 79 query56 258 242 246 242 query57 1276116311711163 query58 245 226 244 226 query59 3439341031373137 query60 288 285 270 270 query61 137 153 135 135 query62 906 685 695 685 query63 217 180 184 180 query64 4068699 655 655 query65 3274320432243204 query66 1139304 321 304 query67 15883 15653 15447 15447 query68 4842570 567 567 query69 445 263 251 251 query70 1196112311361123 query71 409 252 247 247 query72 6975411840204020 query73 784 359 363 359 query74 10105 877288988772 query75 3422267126682668 query76 2874118910671067 query77 378 269 272 269 query78 10367 935194359351 query79 1108598 674 598 query80 851 439 439 439 query81 532 226 231 226 query82 373 117 119 117 query83 266 154 151 151 query84 237 73 66 66 query85 1188312 346 312 query86 373 303 312 303 query87 4486426143264261 query88 3651223522112211 query89 414 286 292 286 query90 1988193 189 189 query91 141 104 108 104 query92 60 51 51 51 query93 1592554 550 550 query94 850 283 285 283 query95 352 250 249 249 query96 621 274 283 274 query97 2830270226782678 query98 212 196 197 196 query99 1526131513151315 Total cold run time: 301431 ms Total hot run time: 196134 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2560511469 TPC-H: Total hot run time: 40072 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 424bbf8f5cf625d8f59ad13089bb0c6d37a38f2e, data reload: false -- Round 1 -- q1 17600 751172957295 q2 2059181 175 175 q3 10624 107412091074 q4 10556 767 780 767 q5 7632273527382735 q6 244 146 151 146 q7 992 627 616 616 q8 9247188019011880 q9 6614640164096401 q10 7039230123352301 q11 494 272 272 272 q12 414 216 227 216 q13 17797 293829562938 q14 245 213 217 213 q15 569 519 492 492 q16 664 582 589 582 q17 972 547 548 547 q18 7324674867576748 q19 1415105110231023 q20 485 187 191 187 q21 4100314934483149 q22 381 323 315 315 Total cold run time: 107467 ms Total hot run time: 40072 ms - Round 2, with runtime_filter_mode=off - q1 7344730372427242 q2 331 232 229 229 q3 2872278829352788 q4 2038182417951795 q5 5672568556165616 q6 223 145 149 145 q7 2233176918521769 q8 3437354934933493 q9 8862900189198919 q10 3600354835293529 q11 614 513 512 512 q12 832 616 608 608 q13 12609 312630673067 q14 304 284 290 284 q15 547 506 506 506 q16 713 659 677 659 q17 1867160816311608 q18 8266774674887488 q19 1720164714661466 q20 2090184718581847 q21 5691553054945494 q22 650 596 585 585 Total cold run time: 72515 ms Total hot run time: 59649 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2560497044 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
zddr commented on code in PR #44905:
URL: https://github.com/apache/doris/pull/44905#discussion_r1895579614
##
fe/fe-core/src/main/java/org/apache/doris/backup/RestoreJob.java:
##
@@ -1263,6 +1315,205 @@ private void checkAndRestoreResources() {
}
}
+private void checkAndRestorePrivileges() {
+List users =
jobInfo.newBackupObjects.backupGlobalInfo.getUserList();
+List localUsers = Lists.newArrayList();
+
+for (User user : users) {
+if
(Env.getCurrentEnv().getAuth().doesUserExist(user.getUserIdentity())) {
+localUsers.add(user.getUserIdentity());
+continue;
+}
+try {
+
Env.getCurrentEnv().getAuth().createUserInternal(user.getUserIdentity(), null,
+user.getPassword().getPassword(), true,
PasswordOptions.UNSET_OPTION,
+user.getComment(), UUID.randomUUID().toString(),
false);
+} catch (DdlException e) {
+LOG.error("restore user fail should not happen", e);
+status = new Status(ErrCode.COMMON_ERROR, "restore user "
++ user.getUserIdentity().toString() + " failed:" +
e.getMessage());
+return;
+}
+restoredUsers.add(user);
+}
+
+List userProperties =
jobInfo.newBackupObjects.backupGlobalInfo.getUserProperties();
+for (UserProperty userProperty : userProperties) {
+for (UserIdentity localIdentity : localUsers) {
+if
(localIdentity.getUser().equals(userProperty.getQualifiedUser())) {
+continue;
+}
+}
+try {
+List> properties = Lists.newArrayList();
+List> list = userProperty.fetchProperty();
+for (List row : list) {
+String key = row.get(0);
+String value = row.get(1);
+if (key.equals(UserProperty.PROP_RESOURCE_TAGS)) {
+continue;
+}
+
+if (key.equals(UserProperty.PROP_WORKLOAD_GROUP) &&
!reserveWorkloadGroup) {
+properties.add(Pair.of(key,
WorkloadGroupMgr.DEFAULT_GROUP_NAME));
+continue;
+}
+
+if (!value.equals("")) {
+properties.add(Pair.of(key, value));
+}
+
+}
+
Env.getCurrentEnv().getAuth().updateUserPropertyInternal(userProperty.getQualifiedUser(),
+properties, false /* is replay */);
+} catch (Exception e) {
+LOG.error("restore user property fail should not happen", e);
+status = new Status(ErrCode.COMMON_ERROR, "restore user "
++ userProperty.getQualifiedUser() + "'s property
failed:" + e.getMessage());
+return;
+}
+}
+
+Map policyMap =
jobInfo.newBackupObjects.backupGlobalInfo.getPolicyMap();
+for (Map.Entry entry :
policyMap.entrySet()) {
+UserIdentity identity = entry.getKey();
+PasswordPolicy passwordPolicy = entry.getValue();
+for (UserIdentity localIdentity : localUsers) {
+if (localIdentity.equals(identity)) {
+continue;
+}
+}
+try {
+PasswordOptions passwordOptions = new
PasswordOptions(passwordPolicy.getExpirePolicy().expirationSecond,
+passwordPolicy.getHistoryPolicy().historyNum, -2,
+passwordPolicy.getFailedLoginPolicy().numFailedLogin,
+
passwordPolicy.getFailedLoginPolicy().passwordLockSeconds, -2);
+
Env.getCurrentEnv().getAuth().getPasswdPolicyManager().updatePolicy(identity,
null, passwordOptions);
+} catch (Exception e) {
+LOG.error("restore user password policy fail should not
happen", e);
+status = new Status(ErrCode.COMMON_ERROR, "restore user "
++ identity.toString() + "'s password policy
failed:" + e.getMessage());
+return;
+}
+}
+
+List rowPolicies =
jobInfo.newBackupObjects.backupGlobalInfo.getRowPolicies();
+for (Policy policy : rowPolicies) {
+RowPolicy rowPolicy = (RowPolicy) policy;
+if (Env.getCurrentEnv().getPolicyMgr().existPolicy(policy)) {
+continue;
+}
+
+try {
+Env.getCurrentEnv().getPolicyMgr().createRowPolicy(rowPolicy);
+} catch (Exception e) {
+LOG.error("restore row policy fail should not happen", e);
+status = new Status(ErrCode.COMMON_ERROR, "restore row policy "
++ policy.getPolicyName() +
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
github-actions[bot] commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2559306043 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2559255423 ClickBench: Total hot run time: 31.96 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d1bd1044f8f11adc6655ad732ce676bf3b99ee17, data reload: false query1 0.040.030.03 query2 0.070.030.03 query3 0.240.070.07 query4 1.620.100.10 query5 0.440.430.41 query6 1.170.640.67 query7 0.020.020.01 query8 0.040.030.03 query9 0.560.520.50 query10 0.570.560.56 query11 0.140.110.10 query12 0.140.120.11 query13 0.620.600.61 query14 2.762.742.77 query15 0.900.830.84 query16 0.380.370.38 query17 1.061.031.08 query18 0.220.210.20 query19 2.001.872.05 query20 0.010.010.02 query21 15.37 0.590.59 query22 2.462.141.58 query23 17.20 0.980.81 query24 3.100.630.47 query25 0.220.050.06 query26 0.420.140.14 query27 0.040.050.07 query28 11.53 1.101.07 query29 12.63 3.263.23 query30 0.240.060.06 query31 2.870.390.39 query32 3.250.460.47 query33 3.193.073.11 query34 17.15 4.484.54 query35 4.534.504.56 query36 0.640.480.53 query37 0.090.060.05 query38 0.050.040.03 query39 0.040.020.02 query40 0.170.130.12 query41 0.080.030.02 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 108.35 s Total hot run time: 31.96 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2559245933 TPC-DS: Total hot run time: 190236 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 d1bd1044f8f11adc6655ad732ce676bf3b99ee17, data reload: false query1 968 401 392 392 query2 6517237324312373 query3 6704224 207 207 query4 33995 23462 23217 23217 query5 4443473 451 451 query6 287 206 191 191 query7 4644302 302 302 query8 306 243 234 234 query9 9675276927522752 query10 485 256 250 250 query11 18178 15101 15236 15101 query12 160 106 106 106 query13 1668446 425 425 query14 10138 768068536853 query15 334 178 188 178 query16 8417471 463 463 query17 1759593 582 582 query18 2179286 286 286 query19 360 154 144 144 query20 118 108 113 108 query21 206 134 107 107 query22 4774460244434443 query23 34551 35026 33572 33572 query24 11365 246824502450 query25 581 382 395 382 query26 1286149 150 149 query27 2848329 328 328 query28 7937243624312431 query29 663 398 397 397 query30 298 146 148 146 query31 1057776 820 776 query32 98 58 59 58 query33 768 324 295 295 query34 964 513 517 513 query35 885 732 739 732 query36 1137918 963 918 query37 200 73 78 73 query38 4265429041304130 query39 1485144014171417 query40 305 104 97 97 query41 49 45 48 45 query42 111 99 100 99 query43 539 502 494 494 query44 1287800 799 799 query45 177 168 163 163 query46 1165711 710 710 query47 1984189218851885 query48 421 332 322 322 query49 1259403 387 387 query50 800 382 385 382 query51 7206701870807018 query52 103 97 95 95 query53 253 183 192 183 query54 1125394 414 394 query55 80 83 101 83 query56 256 239 232 232 query57 1243111011221110 query58 247 221 217 217 query59 3231306830963068 query60 275 253 248 248 query61 112 110 106 106 query62 927 666 669 666 query63 215 187 195 187 query64 4972706 655 655 query65 3227319131973191 query66 1302306 315 306 query67 15736 15653 15588 15588 query68 5795563 561 561 query69 426 254 254 254 query70 1208111011341110 query71 416 255 247 247 query72 6404417140374037 query73 782 369 365 365 query74 10438 881488108810 query75 3431260526412605 query76 3560110810851085 query77 546 287 275 275 query78 10252 941594329415 query79 1849600 606 600 query80 1033427 453 427 query81 531 231 226 226 query82 955 116 121 116 query83 242 144 152 144 query84 240 69 76 69 query85 1309313 308 308 query86 416 303 304 303 query87 4498446542734273 query88 3441226022122212 query89 399 292 290 290 query90 2232187 188 187 query91 134 109 104 104 query92 61 52 52 52 query93 1318553 563 553 query94 1150284 260 260 query95 360 246 250 246 query96 608 280 291 280 query97 2859268226952682 query98 230 195 196 195 query99 1552135112831283 Total cold run time: 303985 ms Total hot run time: 190236 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2559225576 TPC-H: Total hot run time: 39970 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d1bd1044f8f11adc6655ad732ce676bf3b99ee17, data reload: false -- Round 1 -- q1 17675 743072547254 q2 2064186 177 177 q3 10544 115111481148 q4 10228 752 754 752 q5 7590268126872681 q6 239 147 149 147 q7 999 649 601 601 q8 9263186219331862 q9 6662642364816423 q10 6999234023392339 q11 466 256 262 256 q12 405 224 223 223 q13 17758 297029432943 q14 241 220 214 214 q15 552 509 513 509 q16 640 593 597 593 q17 989 582 561 561 q18 7462667267416672 q19 13441012976 976 q20 464 184 185 184 q21 4017313333383133 q22 388 323 322 322 Total cold run time: 106989 ms Total hot run time: 39970 ms - Round 2, with runtime_filter_mode=off - q1 7224722772147214 q2 333 232 234 232 q3 2910282630452826 q4 2175191418711871 q5 5568563556965635 q6 218 136 141 136 q7 2174177818391778 q8 3369353034893489 q9 886690398866 q10 3629354135523541 q11 606 503 494 494 q12 797 599 593 593 q13 13303 310830303030 q14 302 273 284 273 q15 557 499 500 499 q16 681 659 636 636 q17 1820159515661566 q18 7943728972727272 q19 1687159015491549 q20 2071179418131794 q21 5448538252525252 q22 637 555 543 543 Total cold run time: 72340 ms Total hot run time: 59089 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2559142076 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2558744532 ClickBench: Total hot run time: 32.19 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 9056d853ea4c578b4e0d0787e616498a60fc2dd1, data reload: false query1 0.040.030.03 query2 0.080.030.04 query3 0.220.070.07 query4 1.620.100.11 query5 0.400.400.41 query6 1.170.650.65 query7 0.020.010.01 query8 0.040.040.03 query9 0.590.520.52 query10 0.550.570.57 query11 0.140.110.11 query12 0.140.110.11 query13 0.600.630.60 query14 2.712.832.74 query15 0.900.840.81 query16 0.400.370.37 query17 1.011.081.07 query18 0.220.210.22 query19 1.851.792.01 query20 0.020.010.02 query21 15.35 0.600.60 query22 2.541.801.61 query23 16.76 0.910.96 query24 2.900.651.07 query25 0.100.100.24 query26 0.440.140.13 query27 0.050.050.04 query28 11.11 1.091.07 query29 12.61 3.223.24 query30 0.240.060.06 query31 2.870.400.38 query32 3.230.460.46 query33 3.063.063.11 query34 16.85 4.454.44 query35 4.494.444.48 query36 0.670.490.48 query37 0.090.060.06 query38 0.050.030.03 query39 0.040.030.02 query40 0.170.150.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 106.49 s Total hot run time: 32.19 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2558738063 TPC-DS: Total hot run time: 195817 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 9056d853ea4c578b4e0d0787e616498a60fc2dd1, data reload: false query1 12991020901 901 query2 6243247022952295 query3 11001 474247154715 query4 33771 23386 23555 23386 query5 4854439 468 439 query6 278 199 198 198 query7 3998308 314 308 query8 303 237 245 237 query9 9449267826732673 query10 520 240 235 235 query11 18115 15036 15212 15036 query12 163 108 106 106 query13 1569425 404 404 query14 9532691567386738 query15 253 211 186 186 query16 8109463 457 457 query17 1476603 608 603 query18 2232316 341 316 query19 325 175 176 175 query20 132 120 126 120 query21 214 113 110 110 query22 4813430543674305 query23 34633 33757 33569 33569 query24 10415 246324742463 query25 640 402 427 402 query26 1249157 152 152 query27 2437331 329 329 query28 7522245924532453 query29 844 405 422 405 query30 227 147 147 147 query31 1003837 820 820 query32 93 58 58 58 query33 768 322 296 296 query34 1154523 536 523 query35 895 754 777 754 query36 1085940 972 940 query37 144 73 77 73 query38 4340424741664166 query39 1542146114721461 query40 224 111 99 99 query41 48 43 46 43 query42 115 107 103 103 query43 536 512 489 489 query44 1388849 838 838 query45 185 169 179 169 query46 1184719 725 719 query47 2073194519221922 query48 442 337 323 323 query49 989 395 390 390 query50 831 416 391 391 query51 7355722572467225 query52 106 99 94 94 query53 262 187 187 187 query54 1162425 448 425 query55 83 80 81 80 query56 298 253 262 253 query57 1292117211401140 query58 244 229 235 229 query59 3279308931883089 query60 281 259 252 252 query61 110 108 103 103 query62 851 696 685 685 query63 216 189 198 189 query64 4054694 693 693 query65 3311326532293229 query66 764 296 307 296 query67 16527 15479 15466 15466 query68 6099565 551 551 query69 510 253 255 253 query70 1205114511411141 query71 532 262 259 259 query72 6930419040604060 query73 796 355 363 355 query74 10418 892287938793 query75 4127266726472647 query76 4286107910171017 query77 680 282 268 268 query78 10252 945494129412 query79 1126604 594 594 query80 825 424 538 424 query81 495 226 221 221 query82 222 116 120 116 query83 185 143 144 143 query84 274 78 69 69 query85 1002293 296 293 query86 372 300 308 300 query87 4480446045904460 query88 4241220322352203 query89 425 295 302 295 query90 2061187 184 184 query91 138 104 107 104 query92 69 46 50 46 query93 3126544 545 544 query94 843 299 292 292 query95 350 250 249 249 query96 635 283 282 282 query97 2869269326672667 query98 212 194 200 194 query99 1549131413061306 Total cold run time: 307184 ms Total hot run time: 195817 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 t
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2558728877 TPC-H: Total hot run time: 39902 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 9056d853ea4c578b4e0d0787e616498a60fc2dd1, data reload: false -- Round 1 -- q1 17633 766473927392 q2 2079179 168 168 q3 10726 106811631068 q4 10557 753 755 753 q5 7664275527382738 q6 236 144 143 143 q7 978 626 590 590 q8 9428185919511859 q9 6713643764586437 q10 7003232323222322 q11 480 259 252 252 q12 424 226 223 223 q13 17775 292529292925 q14 240 210 202 202 q15 545 505 508 505 q16 666 594 577 577 q17 975 558 537 537 q18 7142669565326532 q19 13441101960 960 q20 441 185 178 178 q21 4057334132293229 q22 375 312 315 312 Total cold run time: 107481 ms Total hot run time: 39902 ms - Round 2, with runtime_filter_mode=off - q1 7258729572567256 q2 324 223 220 220 q3 2903284929382849 q4 2074182818541828 q5 5669568256435643 q6 224 138 142 138 q7 2239181317931793 q8 3409355135103510 q9 8772903890089008 q10 3579357135743571 q11 604 508 509 508 q12 841 582 597 582 q13 11704 323131193119 q14 307 290 288 288 q15 571 514 502 502 q16 685 648 662 648 q17 1872162716341627 q18 8234776377437743 q19 1708154415711544 q20 2059187818931878 q21 5620545554105410 q22 655 593 604 593 Total cold run time: 71311 ms Total hot run time: 60258 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2558697126 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
xy720 commented on code in PR #44905:
URL: https://github.com/apache/doris/pull/44905#discussion_r1891803847
##
fe/fe-core/src/main/java/org/apache/doris/analysis/AbstractBackupStmt.java:
##
@@ -120,6 +126,10 @@ public String getDbName() {
return labelName.getDbName();
}
+public boolean isBackupGlobal() {
Review Comment:
```suggestion
public boolean isBackupGlobal() {
```
##
fe/fe-core/src/main/java/org/apache/doris/backup/RestoreJob.java:
##
@@ -1263,6 +1298,154 @@ private void checkAndRestoreResources() {
}
}
+private void checkAndRestorePrivileges() {
+List users =
jobInfo.newBackupObjects.backupGlobalInfo.getUserList();
+List localUsers = Lists.newArrayList();
+
+for (User user : users) {
+
+if
(Env.getCurrentEnv().getAuth().doesUserExist(user.getUserIdentity())) {
+localUsers.add(user.getUserIdentity());
+continue;
+}
+try {
+
Env.getCurrentEnv().getAuth().createUserInternal(user.getUserIdentity(), null,
Review Comment:
Should drop it in cancelInternal
##
fe/fe-core/src/main/java/org/apache/doris/backup/RestoreJob.java:
##
@@ -1263,6 +1298,154 @@ private void checkAndRestoreResources() {
}
}
+private void checkAndRestorePrivileges() {
+List users =
jobInfo.newBackupObjects.backupGlobalInfo.getUserList();
+List localUsers = Lists.newArrayList();
+
+for (User user : users) {
+
+if
(Env.getCurrentEnv().getAuth().doesUserExist(user.getUserIdentity())) {
+localUsers.add(user.getUserIdentity());
+continue;
+}
+try {
+
Env.getCurrentEnv().getAuth().createUserInternal(user.getUserIdentity(), null,
+user.getPassword().getPassword(), true,
PasswordOptions.UNSET_OPTION,
+user.getComment(), UUID.randomUUID().toString(),
false);
+} catch (DdlException e) {
+LOG.error("restore user fail should not happen", e);
Review Comment:
set status and return here, and roll back in cancelInternal
##
fe/fe-core/src/main/java/org/apache/doris/backup/RestoreJob.java:
##
@@ -1263,6 +1298,154 @@ private void checkAndRestoreResources() {
}
}
+private void checkAndRestorePrivileges() {
Review Comment:
How to roll back?
##
fe/fe-core/src/main/java/org/apache/doris/backup/RestoreJob.java:
##
@@ -1263,6 +1298,154 @@ private void checkAndRestoreResources() {
}
}
+private void checkAndRestorePrivileges() {
+List users =
jobInfo.newBackupObjects.backupGlobalInfo.getUserList();
+List localUsers = Lists.newArrayList();
+
+for (User user : users) {
+
+if
(Env.getCurrentEnv().getAuth().doesUserExist(user.getUserIdentity())) {
+localUsers.add(user.getUserIdentity());
+continue;
+}
+try {
+
Env.getCurrentEnv().getAuth().createUserInternal(user.getUserIdentity(), null,
+user.getPassword().getPassword(), true,
PasswordOptions.UNSET_OPTION,
+user.getComment(), UUID.randomUUID().toString(),
false);
+} catch (DdlException e) {
+LOG.error("restore user fail should not happen", e);
+}
+}
+
+List userProperties =
jobInfo.newBackupObjects.backupGlobalInfo.getUserProperties();
+for (UserProperty userProperty : userProperties) {
+for (UserIdentity localIdentity : localUsers) {
+if
(localIdentity.getUser().equals(userProperty.getQualifiedUser())) {
+continue;
+}
+}
+try {
+List> properties = Lists.newArrayList();
+List> list = userProperty.fetchProperty();
+for (List row : list) {
+String key = row.get(0);
+String value = row.get(1);
+if (key.equals(UserProperty.PROP_RESOURCE_TAGS)) {
+continue;
+}
+
+if (key.equals(UserProperty.PROP_WORKLOAD_GROUP) &&
!reserveWorkloadGroup) {
+properties.add(Pair.of(key,
WorkloadGroupMgr.DEFAULT_GROUP_NAME));
+continue;
+}
+
+if (!value.equals("")) {
+properties.add(Pair.of(key, value));
+}
+
+}
+
Env.getCurrentEnv().getAuth().updateUserPropertyInternal(userProperty.getQualifiedUser(),
+properties, false /* is replay */);
+} catch (Exception e) {
+LOG.error("restore user property fail should not happen", e);
+
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
github-actions[bot] commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2544319760 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2540831904 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2537667920 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522619659 ClickBench: Total hot run time: 33.64 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false query1 0.030.030.02 query2 0.080.040.04 query3 0.230.070.06 query4 1.640.090.08 query5 0.420.400.41 query6 1.160.700.70 query7 0.030.020.02 query8 0.050.040.05 query9 0.550.500.49 query10 0.530.560.56 query11 0.170.130.13 query12 0.150.130.14 query13 0.630.620.59 query14 2.752.852.92 query15 0.950.870.85 query16 0.390.380.39 query17 1.091.071.08 query18 0.190.190.19 query19 1.991.892.06 query20 0.020.000.01 query21 15.36 0.660.65 query22 4.536.991.71 query23 18.27 1.391.39 query24 2.230.220.22 query25 0.150.090.08 query26 0.270.180.18 query27 0.080.080.08 query28 13.17 1.191.16 query29 12.68 3.423.39 query30 0.250.060.05 query31 2.860.430.42 query32 3.220.510.51 query33 3.203.043.15 query34 17.07 4.524.56 query35 4.584.624.62 query36 0.680.490.50 query37 0.200.160.16 query38 0.160.150.15 query39 0.040.040.04 query40 0.170.130.13 query41 0.100.050.06 query42 0.070.060.06 query43 0.050.050.05 Total cold run time: 112.44 s Total hot run time: 33.64 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522607392 TPC-DS: Total hot run time: 197467 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 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false query1 1513987 947 947 query2 6242207720772077 query3 10962 449841094109 query4 67220 28588 23654 23654 query5 5022464 461 461 query6 418 191 190 190 query7 5533312 295 295 query8 324 242 237 237 query9 8850271627152715 query10 444 242 235 235 query11 17335 15298 16011 15298 query12 155 107 114 107 query13 1504424 408 408 query14 9919673079206730 query15 211 187 200 187 query16 7135485 491 485 query17 1439587 616 587 query18 1891327 310 310 query19 230 161 166 161 query20 120 118 112 112 query21 230 116 105 105 query22 4588458946404589 query23 34834 34590 35614 34590 query24 5452255725792557 query25 498 390 394 390 query26 641 150 155 150 query27 1868294 287 287 query28 4861248925012489 query29 670 412 405 405 query30 211 153 150 150 query31 1035865 856 856 query32 63 53 52 52 query33 399 305 291 291 query34 962 520 554 520 query35 913 803 788 788 query36 1095961 973 961 query37 125 71 77 71 query38 4562436143814361 query39 1497148215141482 query40 211 100 101 100 query41 46 69 45 45 query42 111 100 101 100 query43 543 524 521 521 query44 1181816 823 816 query45 194 173 172 172 query46 1190711 731 711 query47 2039196519431943 query48 433 313 328 313 query49 731 394 399 394 query50 850 403 379 379 query51 7473706570357035 query52 100 87 83 83 query53 262 185 180 180 query54 516 401 390 390 query55 79 72 80 72 query56 249 231 234 231 query57 1250109211291092 query58 224 221 216 216 query59 3314299430032994 query60 259 242 251 242 query61 111 106 109 106 query62 798 665 689 665 query63 207 189 187 187 query64 1387683 642 642 query65 3336323232423232 query66 700 296 362 296 query67 15861 15586 15580 15580 query68 4184576 548 548 query69 431 265 251 251 query70 1206112711391127 query71 363 252 246 246 query72 6221409341564093 query73 761 369 360 360 query74 10223 903690199019 query75 3401269227172692 query76 1850113410761076 query77 498 271 302 271 query78 10352 947494689468 query79 2135613 621 613 query80 1392434 444 434 query81 512 233 227 227 query82 1281122 120 120 query83 184 142 143 142 query84 276 83 72 72 query85 1014312 308 308 query86 422 291 303 291 query87 4687462846534628 query88 3817221521902190 query89 428 306 292 292 query90 1996186 191 186 query91 140 126 106 106 query92 72 51 50 50 query93 3036554 538 538 query94 906 284 288 284 query95 398 246 246 246 query96 639 278 280 278 query97 2813267126892671 query98 225 192 189 189 query99 1609132613151315 Total cold run time: 322098 ms Total hot run time: 197467 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522564376 TPC-H: Total hot run time: 40320 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false -- Round 1 -- q1 17713 756273507350 q2 2088182 192 182 q3 10610 116211731162 q4 10591 771 780 771 q5 7606278127402740 q6 241 149 145 145 q7 1013638 601 601 q8 9259189119721891 q9 6716652665546526 q10 7011234323522343 q11 454 256 246 246 q12 425 224 219 219 q13 17785 304330043004 q14 241 222 207 207 q15 606 544 516 516 q16 669 598 583 583 q17 988 566 495 495 q18 7485663566676635 q19 1348981 964 964 q20 480 182 180 180 q21 4023339132433243 q22 377 317 318 317 Total cold run time: 107729 ms Total hot run time: 40320 ms - Round 2, with runtime_filter_mode=off - q1 7290726972557255 q2 333 229 231 229 q3 2899294229502942 q4 2083180619001806 q5 5654565256785652 q6 227 140 147 140 q7 2258179518131795 q8 3434356136033561 q9 8863906790969067 q10 3624360235523552 q11 602 518 506 506 q12 816 637 630 630 q13 11612 324232173217 q14 309 289 283 283 q15 597 534 526 526 q16 690 660 636 636 q17 1863164415991599 q18 8506775374327432 q19 1733160115921592 q20 2128195918681868 q21 5754557854045404 q22 651 553 559 553 Total cold run time: 71926 ms Total hot run time: 60245 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522345434 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522185400 ClickBench: Total hot run time: 33.2 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false query1 0.030.040.03 query2 0.080.040.05 query3 0.230.060.05 query4 1.650.090.10 query5 0.450.400.41 query6 1.130.670.67 query7 0.020.020.02 query8 0.050.040.05 query9 0.540.490.51 query10 0.560.550.56 query11 0.170.120.12 query12 0.150.120.12 query13 0.600.600.59 query14 2.712.812.77 query15 0.920.830.84 query16 0.370.380.37 query17 1.071.061.05 query18 0.180.180.18 query19 1.941.802.00 query20 0.020.010.01 query21 15.36 0.670.66 query22 4.147.951.88 query23 18.28 1.401.36 query24 2.110.220.22 query25 0.150.080.09 query26 0.270.180.18 query27 0.080.090.08 query28 13.24 1.161.14 query29 12.64 3.333.33 query30 0.240.050.06 query31 2.860.390.39 query32 3.280.480.49 query33 3.033.033.04 query34 17.13 4.524.49 query35 4.594.534.56 query36 0.660.480.47 query37 0.190.160.15 query38 0.160.150.15 query39 0.050.040.05 query40 0.180.130.13 query41 0.090.050.05 query42 0.060.050.05 query43 0.050.040.04 Total cold run time: 111.71 s Total hot run time: 33.2 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522180239 TPC-DS: Total hot run time: 197587 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 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false query1 1510970 980 970 query2 6227212720792079 query3 11003 438844084388 query4 67158 29043 23733 23733 query5 4917470 468 468 query6 415 188 178 178 query7 5540323 298 298 query8 327 245 250 245 query9 8628276527242724 query10 447 250 265 250 query11 17376 15332 15949 15332 query12 153 99 100 99 query13 1487433 418 418 query14 10965 732976367329 query15 209 184 200 184 query16 7093460 494 460 query17 1266609 609 609 query18 1668323 321 321 query19 213 158 164 158 query20 120 114 114 114 query21 213 112 105 105 query22 4912469744004400 query23 34727 34311 34651 34311 query24 5588270424762476 query25 484 403 385 385 query26 641 157 154 154 query27 1706298 298 298 query28 4501251524712471 query29 667 414 400 400 query30 206 160 151 151 query31 1022847 821 821 query32 68 53 54 53 query33 436 291 306 291 query34 949 537 563 537 query35 906 778 771 771 query36 1115958 965 958 query37 123 77 81 77 query38 4584437544164375 query39 1558147314801473 query40 204 99 98 98 query41 43 41 41 41 query42 112 102 100 100 query43 544 504 506 504 query44 1209837 839 837 query45 202 168 176 168 query46 1179733 713 713 query47 2022192019401920 query48 414 309 310 309 query49 730 395 393 393 query50 848 400 395 395 query51 7411727770057005 query52 107 87 90 87 query53 260 181 181 181 query54 512 399 388 388 query55 78 76 76 76 query56 251 242 236 236 query57 1261113110741074 query58 236 233 230 230 query59 3205294829352935 query60 305 273 263 263 query61 135 128 139 128 query62 782 660 675 660 query63 212 183 190 183 query64 1365672 657 657 query65 3325325432103210 query66 709 297 299 297 query67 16115 15519 15551 15519 query68 4157570 567 567 query69 420 309 247 247 query70 1205113211211121 query71 328 255 250 250 query72 6348409340214021 query73 776 360 361 360 query74 10270 894690108946 query75 3411269327192693 query76 1866115510721072 query77 478 278 278 278 query78 10461 952694079407 query79 1261607 603 603 query80 834 492 440 440 query81 473 226 232 226 query82 1319118 116 116 query83 237 148 143 143 query84 282 76 69 69 query85 861 308 293 293 query86 331 302 298 298 query87 4592467245854585 query88 3503222922072207 query89 425 292 298 292 query90 2012193 186 186 query91 141 104 114 104 query92 69 51 52 51 query93 1542535 550 535 query94 791 294 294 294 query95 360 254 246 246 query96 615 285 273 273 query97 2913266826862668 query98 223 206 196 196 query99 1595134613291329 Total cold run time: 319003 ms Total hot run time: 197587 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522168901 TPC-H: Total hot run time: 39716 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false -- Round 1 -- q1 17963 744773037303 q2 2076180 169 169 q3 10662 109411971094 q4 10565 720 762 720 q5 7574272926662666 q6 238 147 147 147 q7 1004649 598 598 q8 9281185118961851 q9 6704642065166420 q10 6970228623512286 q11 471 262 257 257 q12 436 221 218 218 q13 17773 300330623003 q14 248 208 207 207 q15 577 534 519 519 q16 655 592 578 578 q17 974 531 571 531 q18 7393668166106610 q19 1334984 923 923 q20 464 182 186 182 q21 4025331531203120 q22 374 314 315 314 Total cold run time: 107761 ms Total hot run time: 39716 ms - Round 2, with runtime_filter_mode=off - q1 7206726872287228 q2 326 229 232 229 q3 2879282929572829 q4 2054181718501817 q5 5662569856625662 q6 235 144 147 144 q7 2254181318231813 q8 3404356334773477 q9 8924905891329058 q10 3595351435743514 q11 604 503 514 503 q12 812 611 634 611 q13 12807 335532753275 q14 300 278 268 268 q15 559 527 522 522 q16 711 634 655 634 q17 1860167416321632 q18 8289778076657665 q19 1714153115901531 q20 2127191718671867 q21 5580559054975497 q22 616 561 562 561 Total cold run time: 72518 ms Total hot run time: 60337 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522097035 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522092588 TPC-H: Total hot run time: 40316 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 707a31de28b873c0de959f9a44baa3eb90a9610d, data reload: false -- Round 1 -- q1 17681 773073797379 q2 2092183 179 179 q3 10656 109811991098 q4 10593 798 797 797 q5 7629272127202720 q6 245 151 151 151 q7 1011637 606 606 q8 9486188419271884 q9 7072659565356535 q10 6956229323692293 q11 461 255 260 255 q12 437 223 225 223 q13 17796 304930373037 q14 232 211 207 207 q15 586 525 532 525 q16 650 585 567 567 q17 984 497 481 481 q18 7375666067146660 q19 1335109610521052 q20 468 188 179 179 q21 4006317932943179 q22 377 311 309 309 Total cold run time: 108128 ms Total hot run time: 40316 ms - Round 2, with runtime_filter_mode=off - q1 7341735273167316 q2 320 226 230 226 q3 2936299630222996 q4 2052188018481848 q5 5640566456675664 q6 231 146 148 146 q7 2302185018401840 q8 3369360535483548 q9 8924899289928992 q10 3608356235503550 q11 610 503 496 496 q12 846 678 660 660 q13 11300 324232573242 q14 327 278 278 278 q15 591 539 539 539 q16 695 669 627 627 q17 1870164216051605 q18 8264776576527652 q19 1714166316361636 q20 2122185518771855 q21 5637543854335433 q22 640 558 545 545 Total cold run time: 71339 ms Total hot run time: 60694 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on code in PR #44905:
URL: https://github.com/apache/doris/pull/44905#discussion_r1872509802
##
fe/fe-common/src/main/java/org/apache/doris/common/FeMetaVersion.java:
##
@@ -103,8 +103,11 @@ public final class FeMetaVersion {
public static final int VERSION_140 = 140;
+// For backup global info
+public static final int VERSION_141 = 141;
+
// note: when increment meta version, should assign the latest version to
VERSION_CURRENT
-public static final int VERSION_CURRENT = VERSION_140;
+public static final int VERSION_CURRENT = VERSION_141;
Review Comment:
BackupMeta has changed, upgrade the fe meta verison to compatible with old
versions.
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522019967 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2522014078 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
yiguolei commented on code in PR #44905:
URL: https://github.com/apache/doris/pull/44905#discussion_r1872457472
##
fe/fe-common/src/main/java/org/apache/doris/common/FeMetaVersion.java:
##
@@ -103,8 +103,11 @@ public final class FeMetaVersion {
public static final int VERSION_140 = 140;
+// For backup global info
+public static final int VERSION_141 = 141;
+
// note: when increment meta version, should assign the latest version to
VERSION_CURRENT
-public static final int VERSION_CURRENT = VERSION_140;
+public static final int VERSION_CURRENT = VERSION_141;
Review Comment:
changed fe meta version， it is very dangerous
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2521099470 ClickBench: Total hot run time: 33.78 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4c147d25dfa7c816d24e0a4007ad8e11dab28850, data reload: false query1 0.030.030.02 query2 0.090.050.05 query3 0.230.050.06 query4 1.660.080.08 query5 0.420.400.42 query6 1.150.660.66 query7 0.020.010.02 query8 0.050.050.05 query9 0.560.510.51 query10 0.580.560.55 query11 0.150.120.12 query12 0.160.120.12 query13 0.610.600.61 query14 2.732.732.88 query15 0.920.840.83 query16 0.380.360.38 query17 1.071.051.05 query18 0.180.190.19 query19 1.941.842.05 query20 0.010.010.02 query21 15.36 0.670.66 query22 4.136.282.41 query23 18.17 1.371.39 query24 2.090.230.22 query25 0.150.090.08 query26 0.260.180.18 query27 0.080.080.09 query28 13.31 1.171.15 query29 12.67 3.363.35 query30 0.240.060.06 query31 2.870.410.40 query32 3.220.480.50 query33 3.143.073.00 query34 17.13 4.494.51 query35 4.544.534.60 query36 0.660.480.49 query37 0.180.160.15 query38 0.160.150.15 query39 0.050.040.04 query40 0.170.150.13 query41 0.100.050.05 query42 0.060.050.06 query43 0.050.040.05 Total cold run time: 111.73 s Total hot run time: 33.78 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2521089121 TPC-DS: Total hot run time: 197896 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 4c147d25dfa7c816d24e0a4007ad8e11dab28850, data reload: false query1 1477976 970 970 query2 6222207820762076 query3 10981 437843224322 query4 66864 28800 23541 23541 query5 4946471 454 454 query6 416 187 187 187 query7 5487323 311 311 query8 332 226 228 226 query9 8615273427132713 query10 427 251 244 244 query11 17175 15281 15990 15281 query12 149 104 101 101 query13 1447455 426 426 query14 10607 725175747251 query15 215 190 194 190 query16 7090485 484 484 query17 1221595 592 592 query18 1780330 315 315 query19 208 165 157 157 query20 132 128 116 116 query21 207 118 103 103 query22 4894471744744474 query23 34952 34577 35301 34577 query24 5406252025592520 query25 485 397 398 397 query26 651 152 159 152 query27 1977281 298 281 query28 4321249924392439 query29 666 434 430 430 query30 208 155 150 150 query31 1017812 827 812 query32 68 54 53 53 query33 408 289 286 286 query34 949 521 533 521 query35 871 783 779 779 query36 1086956 982 956 query37 126 74 74 74 query38 4411447743624362 query39 1550147014851470 query40 206 103 106 103 query41 46 44 45 44 query42 111 95 96 95 query43 531 492 493 492 query44 1207830 812 812 query45 192 169 171 169 query46 1182735 743 735 query47 2060195619891956 query48 421 311 317 311 query49 733 404 407 404 query50 846 404 383 383 query51 7462709470777077 query52 99 90 90 90 query53 251 177 179 177 query54 507 409 391 391 query55 78 76 76 76 query56 244 226 225 225 query57 1251110111651101 query58 218 206 212 206 query59 3160307430693069 query60 269 240 249 240 query61 109 106 104 104 query62 773 676 685 676 query63 217 186 188 186 query64 1374702 650 650 query65 3275323231973197 query66 700 302 301 301 query67 16060 15737 15856 15737 query68 4215565 564 564 query69 434 254 252 252 query70 1199113711261126 query71 362 249 256 249 query72 6210404140884041 query73 750 362 358 358 query74 10272 897790678977 query75 3403267726412641 query76 1838109510861086 query77 473 280 279 279 query78 10436 956294549454 query79 2158601 626 601 query80 1370416 434 416 query81 507 228 222 222 query82 1278117 116 116 query83 172 149 148 148 query84 284 72 69 69 query85 997 309 309 309 query86 417 293 296 293 query87 4689456546554565 query88 3626220821962196 query89 420 297 290 290 query90 1971186 182 182 query91 144 108 104 104 query92 68 55 49 49 query93 2891537 533 533 query94 867 292 287 287 query95 349 244 249 244 query96 706 277 287 277 query97 2852266926682668 query98 217 196 192 192 query99 1648132813081308 Total cold run time: 320849 ms Total hot run time: 197896 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 t
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2521066316 TPC-H: Total hot run time: 39877 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4c147d25dfa7c816d24e0a4007ad8e11dab28850, data reload: false -- Round 1 -- q1 17957 837072537253 q2 2068173 170 170 q3 10846 108111721081 q4 10567 796 702 702 q5 7612273426792679 q6 247 151 155 151 q7 1010652 610 610 q8 9248180619111806 q9 6700646965206469 q10 6974234023162316 q11 462 259 250 250 q12 431 230 219 219 q13 17771 300530853005 q14 252 218 210 210 q15 570 542 533 533 q16 659 593 585 585 q17 983 508 576 508 q18 7283659967686599 q19 1338100910021002 q20 476 188 190 188 q21 4047338932203220 q22 378 324 321 321 Total cold run time: 107879 ms Total hot run time: 39877 ms - Round 2, with runtime_filter_mode=off - q1 7276720872287208 q2 329 238 233 233 q3 2879294629712946 q4 2075187718491849 q5 5938565056645650 q6 229 142 149 142 q7 2227182918331829 q8 3382348035433480 q9 8974897290818972 q10 3589356335423542 q11 604 519 494 494 q12 801 600 622 600 q13 11335 326032193219 q14 306 275 283 275 q15 569 531 530 530 q16 717 644 645 644 q17 1872165315981598 q18 8377795977177717 q19 1710149915381499 q20 2109186218861862 q21 5649558755675567 q22 652 569 593 569 Total cold run time: 71599 ms Total hot run time: 60425 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2520916783 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2519252716 ClickBench: Total hot run time: 33.32 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4deab8c3de336d6a7a5b03bf8742684af2a04833, data reload: false query1 0.030.030.03 query2 0.080.050.04 query3 0.230.050.05 query4 1.660.090.08 query5 0.420.400.40 query6 1.130.680.66 query7 0.020.020.02 query8 0.060.040.05 query9 0.550.490.50 query10 0.540.560.56 query11 0.160.120.13 query12 0.160.130.13 query13 0.620.600.60 query14 2.812.722.73 query15 0.900.850.83 query16 0.380.400.38 query17 1.001.031.07 query18 0.200.180.20 query19 1.861.721.93 query20 0.020.020.01 query21 15.35 0.660.66 query22 4.346.782.11 query23 18.20 1.381.30 query24 2.120.240.22 query25 0.150.080.09 query26 0.280.180.19 query27 0.080.080.08 query28 13.24 1.161.15 query29 12.65 3.373.38 query30 0.240.060.06 query31 2.880.400.40 query32 3.230.480.50 query33 2.973.073.06 query34 17.04 4.524.48 query35 4.524.524.49 query36 0.660.490.49 query37 0.190.160.16 query38 0.160.150.15 query39 0.040.040.04 query40 0.170.130.13 query41 0.100.050.06 query42 0.060.060.05 query43 0.050.050.04 Total cold run time: 111.55 s Total hot run time: 33.32 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2519244927 TPC-DS: Total hot run time: 196804 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 4deab8c3de336d6a7a5b03bf8742684af2a04833, data reload: false query1 1535971 955 955 query2 6252208020472047 query3 10980 427043124270 query4 67348 28150 23576 23576 query5 4986462 455 455 query6 390 186 178 178 query7 5507315 300 300 query8 330 239 240 239 query9 8325273627362736 query10 415 258 250 250 query11 16839 15313 15923 15313 query12 158 106 108 106 query13 1454432 410 410 query14 10808 701672817016 query15 218 187 190 187 query16 6779492 444 444 query17 1088640 577 577 query18 1010298 297 297 query19 200 159 161 159 query20 122 119 112 112 query21 210 122 104 104 query22 4867455045114511 query23 35231 34362 34624 34362 query24 5499255626412556 query25 483 408 385 385 query26 649 146 155 146 query27 2083288 293 288 query28 4603250024902490 query29 670 417 420 417 query30 211 156 153 153 query31 997 844 850 844 query32 68 54 84 54 query33 443 317 298 298 query34 940 524 552 524 query35 880 762 785 762 query36 1098969 973 969 query37 128 77 70 70 query38 4469441643524352 query39 1549149514891489 query40 202 98 98 98 query41 43 44 44 44 query42 116 97 99 97 query43 541 477 510 477 query44 1196831 829 829 query45 186 170 172 170 query46 1194707 777 707 query47 2049191819001900 query48 411 313 312 312 query49 741 382 402 382 query50 834 394 400 394 query51 7379713570027002 query52 100 84 88 84 query53 267 177 176 176 query54 511 410 391 391 query55 77 77 79 77 query56 256 235 232 232 query57 1230111910971097 query58 218 204 213 204 query59 3243299128822882 query60 268 240 264 240 query61 108 134 101 101 query62 775 698 659 659 query63 208 184 189 184 query64 1427664 633 633 query65 3282321132183211 query66 710 305 295 295 query67 15997 15514 15769 15514 query68 3870587 570 570 query69 434 258 252 252 query70 1220112811881128 query71 373 249 245 245 query72 6163409540054005 query73 773 369 360 360 query74 10293 897691558976 query75 3408265827112658 query76 1881104011191040 query77 487 268 366 268 query78 10537 946794269426 query79 1171598 600 598 query80 814 419 450 419 query81 485 295 236 236 query82 1357121 120 120 query83 253 146 156 146 query84 278 72 68 68 query85 863 296 310 296 query86 328 301 309 301 query87 4718451145194511 query88 3395223222182218 query89 420 296 290 290 query90 1990187 188 187 query91 137 100 104 100 query92 66 54 52 52 query93 1278543 556 543 query94 744 287 282 282 query95 353 254 251 251 query96 616 296 279 279 query97 2841268027012680 query98 221 199 192 192 query99 1894131413341314 Total cold run time: 317052 ms Total hot run time: 196804 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2519230570 TPC-H: Total hot run time: 39926 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4deab8c3de336d6a7a5b03bf8742684af2a04833, data reload: false -- Round 1 -- q1 18018 818573407340 q2 2080177 168 168 q3 10734 108811911088 q4 10326 753 752 752 q5 7578269625782578 q6 242 149 146 146 q7 994 658 602 602 q8 9240182818611828 q9 6600651665026502 q10 6966231123302311 q11 456 246 252 246 q12 428 221 218 218 q13 17759 301830263018 q14 236 211 217 211 q15 581 528 526 526 q16 633 582 587 582 q17 967 571 650 571 q18 7334664367036643 q19 13441005948 948 q20 470 182 177 177 q21 4017336331573157 q22 397 314 329 314 Total cold run time: 107400 ms Total hot run time: 39926 ms - Round 2, with runtime_filter_mode=off - q1 7321720072747200 q2 323 224 221 221 q3 2924285029042850 q4 2022180218031802 q5 5614561655835583 q6 226 140 142 140 q7 2256184718111811 q8 3394349434493449 q9 8912892489648924 q10 3558349935163499 q11 602 513 495 495 q12 808 609 624 609 q13 11252 319132183191 q14 317 265 264 264 q15 587 536 520 520 q16 690 642 647 642 q17 1840163516061606 q18 8135771377917713 q19 1643155115071507 q20 2115188818721872 q21 5644545853495349 q22 623 595 568 568 Total cold run time: 70806 ms Total hot run time: 59815 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2519092660 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2518976459 ClickBench: Total hot run time: 33.85 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 9b3b17ab5cf3f87b1eb2d138231bba5470bcef21, data reload: false query1 0.030.030.03 query2 0.080.050.04 query3 0.230.060.06 query4 1.640.080.09 query5 0.420.410.40 query6 1.150.670.65 query7 0.020.010.02 query8 0.060.040.04 query9 0.550.500.51 query10 0.540.560.54 query11 0.160.120.11 query12 0.160.130.13 query13 0.600.600.59 query14 2.742.742.78 query15 0.940.840.83 query16 0.380.380.37 query17 1.061.091.06 query18 0.200.190.19 query19 1.871.792.00 query20 0.010.010.01 query21 15.36 0.660.65 query22 3.727.082.56 query23 18.27 1.391.38 query24 2.160.220.22 query25 0.160.090.10 query26 0.280.180.18 query27 0.090.080.07 query28 13.28 1.171.15 query29 12.61 3.423.37 query30 0.240.060.06 query31 2.870.390.40 query32 3.240.490.47 query33 3.023.043.06 query34 16.84 4.484.45 query35 4.564.544.60 query36 0.660.470.48 query37 0.190.150.16 query38 0.160.150.15 query39 0.050.040.04 query40 0.170.130.13 query41 0.090.040.05 query42 0.060.040.05 query43 0.050.040.04 Total cold run time: 110.97 s Total hot run time: 33.85 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2518970841 TPC-DS: Total hot run time: 198024 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 9b3b17ab5cf3f87b1eb2d138231bba5470bcef21, data reload: false query1 1535963 946 946 query2 6210207120352035 query3 10988 452344374437 query4 66601 29096 23759 23759 query5 5021472 441 441 query6 400 178 172 172 query7 5474303 306 303 query8 324 236 238 236 query9 8930273127092709 query10 439 238 242 238 query11 17233 15383 15983 15383 query12 157 97 103 97 query13 1447422 386 386 query14 9742832276207620 query15 209 187 196 187 query16 7148496 481 481 query17 1208581 606 581 query18 1843323 328 323 query19 202 154 162 154 query20 122 115 116 115 query21 211 108 105 105 query22 4871463643974397 query23 35089 34544 34506 34506 query24 5498251725162516 query25 479 390 390 390 query26 636 148 148 148 query27 1896291 282 282 query28 4286251424802480 query29 674 412 433 412 query30 201 157 150 150 query31 1015835 853 835 query32 65 52 50 50 query33 433 293 300 293 query34 936 545 544 544 query35 876 753 777 753 query36 11041004959 959 query37 123 71 72 71 query38 4532440145434401 query39 1542161314541454 query40 211 100 98 98 query41 44 41 42 41 query42 110 95 100 95 query43 536 489 506 489 query44 1196824 846 824 query45 183 175 165 165 query46 1178722 746 722 query47 2005191519241915 query48 415 327 316 316 query49 735 386 379 379 query50 833 389 391 389 query51 7290725471167116 query52 94 87 89 87 query53 258 183 175 175 query54 499 395 409 395 query55 76 75 77 75 query56 244 234 238 234 query57 1220110911101109 query58 212 202 204 202 query59 3219287928582858 query60 256 237 236 236 query61 104 109 109 109 query62 755 673 661 661 query63 209 185 198 185 query64 1357689 628 628 query65 3252323932323232 query66 635 299 295 295 query67 16024 15761 15647 15647 query68 4079569 560 560 query69 436 271 245 245 query70 1248116511341134 query71 320 245 253 245 query72 6398397640783976 query73 757 370 372 370 query74 10224 903589948994 query75 3396267126492649 query76 20261090999 999 query77 480 273 266 266 query78 10467 950095029500 query79 1451610 593 593 query80 860 428 429 428 query81 495 224 232 224 query82 1053127 120 120 query83 162 152 148 148 query84 282 72 70 70 query85 817 289 290 289 query86 319 302 300 300 query87 4700453345774533 query88 3554224121992199 query89 422 299 289 289 query90 2035185 187 185 query91 132 103 103 103 query92 66 49 54 49 query93 1654549 552 549 query94 769 289 296 289 query95 344 251 252 251 query96 613 277 284 277 query97 2829268327002683 query98 213 194 196 194 query99 1586131712871287 Total cold run time: 317037 ms Total hot run time: 198024 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] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2518958404 TPC-H: Total hot run time: 40581 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 9b3b17ab5cf3f87b1eb2d138231bba5470bcef21, data reload: false -- Round 1 -- q1 17996 881675887588 q2 2078181 175 175 q3 10652 114611841146 q4 10496 775 760 760 q5 7592284727552755 q6 235 150 151 150 q7 1010640 610 610 q8 9469190519201905 q9 6623646964996469 q10 6999232723342327 q11 475 266 262 262 q12 410 228 225 225 q13 17780 303630273027 q14 252 214 210 210 q15 569 543 531 531 q16 669 605 575 575 q17 979 579 598 579 q18 7241672866316631 q19 13571062981 981 q20 471 181 187 181 q21 3976324531863186 q22 392 322 308 308 Total cold run time: 107721 ms Total hot run time: 40581 ms - Round 2, with runtime_filter_mode=off - q1 7286721471977197 q2 327 227 231 227 q3 2833297729312931 q4 2118188818601860 q5 5612567256445644 q6 229 144 149 144 q7 2229178518291785 q8 3344350435373504 q9 8819900089698969 q10 3577359535443544 q11 598 512 505 505 q12 796 607 616 607 q13 12257 327232183218 q14 302 289 268 268 q15 576 519 519 519 q16 673 660 650 650 q17 1831163816261626 q18 8355763577937635 q19 1668147614671467 q20 2147187418701870 q21 5659555353335333 q22 651 576 572 572 Total cold run time: 71887 ms Total hot run time: 60075 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2518908917 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-251303 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2516713979 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2517039743 ClickBench: Total hot run time: 33.54 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit c03b5179e3beaae38ade25d1e89298d73708775b, data reload: false query1 0.030.030.02 query2 0.080.050.05 query3 0.230.050.05 query4 1.650.080.08 query5 0.410.420.41 query6 1.140.690.67 query7 0.020.010.02 query8 0.050.050.05 query9 0.550.510.50 query10 0.560.560.55 query11 0.170.120.12 query12 0.150.130.12 query13 0.610.610.60 query14 2.722.762.71 query15 0.930.860.83 query16 0.370.370.37 query17 1.061.001.06 query18 0.190.190.19 query19 1.991.902.11 query20 0.020.020.02 query21 15.37 0.660.67 query22 4.576.352.05 query23 18.21 1.381.28 query24 2.190.220.22 query25 0.160.080.08 query26 0.260.180.18 query27 0.080.070.08 query28 13.21 1.171.16 query29 12.66 3.443.43 query30 0.240.050.06 query31 2.880.410.40 query32 3.220.480.48 query33 3.022.983.05 query34 16.73 4.574.55 query35 4.624.594.61 query36 0.680.520.49 query37 0.190.160.16 query38 0.150.160.15 query39 0.050.040.03 query40 0.170.130.13 query41 0.090.060.05 query42 0.060.050.06 query43 0.050.050.05 Total cold run time: 111.79 s Total hot run time: 33.54 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2517026405 TPC-DS: Total hot run time: 198747 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 c03b5179e3beaae38ade25d1e89298d73708775b, data reload: false query1 1305973 923 923 query2 6244205519871987 query3 3 469846954695 query4 33204 23545 23463 23463 query5 3524475 449 449 query6 272 185 187 185 query7 3991309 306 306 query8 297 239 238 238 query9 9555272627212721 query10 473 246 248 246 query11 17986 15449 15336 15336 query12 162 102 107 102 query13 1554414 412 412 query14 9700725479587254 query15 265 220 198 198 query16 7832486 510 486 query17 1640585 573 573 query18 1543310 305 305 query19 363 154 150 150 query20 128 111 113 111 query21 204 106 105 105 query22 4786442143994399 query23 36428 34822 34840 34822 query24 11124 271225512551 query25 619 400 393 393 query26 1444157 153 153 query27 2557281 284 281 query28 7461251424892489 query29 885 442 417 417 query30 239 158 155 155 query31 1051858 834 834 query32 97 57 57 57 query33 775 309 294 294 query34 1253526 539 526 query35 899 760 745 745 query36 1139982 990 982 query37 140 77 74 74 query38 4428445944124412 query39 1554149614691469 query40 276 105 105 105 query41 48 42 45 42 query42 109 103 103 103 query43 536 512 505 505 query44 1395852 826 826 query45 204 174 172 172 query46 1185744 744 744 query47 2055195319181918 query48 436 331 337 331 query49 998 431 420 420 query50 844 417 410 410 query51 7433732972977297 query52 106 90 93 90 query53 265 183 186 183 query54 1435424 448 424 query55 87 82 87 82 query56 271 239 238 238 query57 1330116211251125 query58 233 229 213 213 query59 3292301831093018 query60 271 240 245 240 query61 121 113 110 110 query62 850 669 672 669 query63 213 199 198 198 query64 4928660 706 660 query65 3280319832143198 query66 1099314 329 314 query67 16109 15801 15706 15706 query68 5464571 551 551 query69 406 256 262 256 query70 1200113910631063 query71 319 247 252 247 query72 6213412440674067 query73 756 366 366 366 query74 10256 897390618973 query75 3417267427162674 query76 3243111011061106 query77 378 280 281 280 query78 10510 949394759475 query79 1693632 605 605 query80 1074433 443 433 query81 543 237 238 237 query82 938 128 119 119 query83 243 146 143 143 query84 235 67 72 67 query85 1373297 309 297 query86 391 303 297 297 query87 4669449246564492 query88 3535222821892189 query89 436 293 286 286 query90 1960191 232 191 query91 144 101 108 101 query92 61 50 53 50 query93 1887551 554 551 query94 761 296 301 296 query95 356 258 250 250 query96 619 281 275 275 query97 2850271026592659 query98 221 205 196 196 query99 1567132313161316 Total cold run time: 305361 ms Total hot run time: 198747 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
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2516994911 TPC-H: Total hot run time: 39965 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit c03b5179e3beaae38ade25d1e89298d73708775b, data reload: false -- Round 1 -- q1 17983 772172877287 q2 2063174 169 169 q3 10894 111012021110 q4 10318 691 737 691 q5 7593276726522652 q6 238 150 147 147 q7 1012645 602 602 q8 9247185918971859 q9 6718653264776477 q10 7001230623382306 q11 470 260 259 259 q12 438 229 220 220 q13 17797 306730753067 q14 257 218 212 212 q15 581 540 521 521 q16 687 588 585 585 q17 989 582 522 522 q18 7331667266936672 q19 13621031953 953 q20 459 177 177 177 q21 4121319231693169 q22 374 308 316 308 Total cold run time: 107933 ms Total hot run time: 39965 ms - Round 2, with runtime_filter_mode=off - q1 7308724372617243 q2 333 231 229 229 q3 2904290829992908 q4 2107189318981893 q5 5655566656985666 q6 224 141 141 141 q7 2249184418131813 q8 3436353035723530 q9 8890912990489048 q10 3635357835683568 q11 630 503 523 503 q12 858 637 620 620 q13 11554 329832383238 q14 313 272 270 270 q15 582 544 528 528 q16 715 636 642 636 q17 1855161815891589 q18 8507776776947694 q19 1691151716371517 q20 2148186918941869 q21 5669559655435543 q22 644 567 643 567 Total cold run time: 71907 ms Total hot run time: 60613 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
github-actions[bot] commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2516087367 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
github-actions[bot] commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2516087394 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2514106589 ClickBench: Total hot run time: 33.88 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit cd4478055df98f21c5eb2e8a11a889d669eb7aa0, data reload: false query1 0.030.030.03 query2 0.080.050.05 query3 0.230.050.06 query4 1.650.080.08 query5 0.430.400.40 query6 1.160.680.66 query7 0.020.020.01 query8 0.050.050.05 query9 0.560.490.49 query10 0.560.550.57 query11 0.160.120.13 query12 0.150.120.12 query13 0.620.600.60 query14 2.732.742.77 query15 0.930.860.84 query16 0.380.390.39 query17 1.071.061.06 query18 0.190.190.20 query19 1.841.792.04 query20 0.020.020.01 query21 15.36 0.690.68 query22 4.645.822.39 query23 18.24 1.461.36 query24 2.090.230.23 query25 0.140.080.08 query26 0.260.180.18 query27 0.090.080.08 query28 13.26 1.191.15 query29 12.63 3.403.32 query30 0.240.060.05 query31 2.850.400.40 query32 3.260.480.49 query33 3.103.073.12 query34 16.97 4.534.53 query35 4.714.574.63 query36 0.680.490.47 query37 0.200.160.15 query38 0.150.170.15 query39 0.050.040.03 query40 0.160.130.14 query41 0.100.050.05 query42 0.060.060.05 query43 0.050.050.05 Total cold run time: 112.15 s Total hot run time: 33.88 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2514092728 TPC-DS: Total hot run time: 197345 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 cd4478055df98f21c5eb2e8a11a889d669eb7aa0, data reload: false query1 1248966 991 966 query2 6233203119981998 query3 11120 449546764495 query4 67319 29634 23599 23599 query5 4984495 471 471 query6 420 188 179 179 query7 5656310 299 299 query8 328 242 243 242 query9 9159270726912691 query10 468 249 257 249 query11 17880 15498 15811 15498 query12 159 107 112 107 query13 1548425 435 425 query14 10371 702467196719 query15 208 187 192 187 query16 7099496 439 439 query17 1212577 561 561 query18 1787307 308 307 query19 212 155 153 153 query20 119 108 111 108 query21 207 100 101 100 query22 4866468844864486 query23 34997 34400 34687 34400 query24 5504260624902490 query25 485 380 395 380 query26 650 154 154 154 query27 1824285 295 285 query28 4511250624812481 query29 682 425 449 425 query30 205 153 150 150 query31 1039854 844 844 query32 67 62 56 56 query33 437 317 298 298 query34 940 519 532 519 query35 898 756 759 756 query36 1102967 962 962 query37 123 71 79 71 query38 4565441943924392 query39 1529150315171503 query40 199 100 102 100 query41 45 41 40 40 query42 113 98 98 98 query43 535 485 505 485 query44 1200839 821 821 query45 191 176 167 167 query46 1173739 731 731 query47 2055194919261926 query48 421 319 318 318 query49 727 395 430 395 query50 857 403 399 399 query51 7339719971397139 query52 95 85 89 85 query53 256 182 182 182 query54 516 409 391 391 query55 74 78 76 76 query56 253 234 236 234 query57 1301115611251125 query58 221 219 211 211 query59 3096309329382938 query60 271 280 268 268 query61 110 106 107 106 query62 806 674 645 645 query63 214 187 190 187 query64 1382668 639 639 query65 3297317132123171 query66 692 327 286 286 query67 15930 15795 15544 15544 query68 3548569 561 561 query69 418 257 257 257 query70 1109116011451145 query71 351 249 249 249 query72 6408435541564156 query73 754 358 364 358 query74 10096 900690359006 query75 3406264927192649 query76 1769109911271099 query77 495 279 294 279 query78 10466 953594059405 query79 1124596 593 593 query80 812 429 443 429 query81 504 231 232 231 query82 202 128 118 118 query83 167 144 144 144 query84 281 158 66 66 query85 855 299 315 299 query86 365 270 301 270 query87 4631458346214583 query88 3561220421752175 query89 418 306 294 294 query90 2015192 185 185 query91 138 103 104 103 query92 66 48 49 48 query93 1137532 540 532 query94 783 292 299 292 query95 342 265 245 245 query96 618 289 276 276 query97 2846266626942666 query98 212 193 205 193 query99 1618132912871287 Total cold run time: 317045 ms Total hot run time: 197345 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 t
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2514055245 TPC-H: Total hot run time: 40176 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit cd4478055df98f21c5eb2e8a11a889d669eb7aa0, data reload: false -- Round 1 -- q1 17968 805872897289 q2 2049185 174 174 q3 10839 108312131083 q4 10544 747 728 728 q5 7648272927622729 q6 239 149 148 148 q7 1004642 604 604 q8 9265192119151915 q9 6708655665376537 q10 7066230123072301 q11 474 264 246 246 q12 419 221 225 221 q13 17775 309930283028 q14 248 216 215 215 q15 584 546 518 518 q16 663 583 600 583 q17 976 576 577 576 q18 7500658965966589 q19 1370109010131013 q20 471 181 181 181 q21 4002323231793179 q22 380 322 319 319 Total cold run time: 108192 ms Total hot run time: 40176 ms - Round 2, with runtime_filter_mode=off - q1 7251720872277208 q2 334 232 237 232 q3 2891291728932893 q4 2121181219031812 q5 5675565856445644 q6 229 146 143 143 q7 2228184018151815 q8 3422356635273527 q9 8910905290529052 q10 3616357435433543 q11 614 513 523 513 q12 828 595 633 595 q13 9978325232633252 q14 299 262 270 262 q15 606 524 525 524 q16 696 656 661 656 q17 1896165515971597 q18 8284774376547654 q19 1691154416081544 q20 2125189319091893 q21 5601544555225445 q22 663 566 601 566 Total cold run time: 69958 ms Total hot run time: 60370 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
justfortaste commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2513905264 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](backup) backup and restore privileges catalogs workloadgroup [doris]
doris-robot commented on PR #44905: URL: https://github.com/apache/doris/pull/44905#issuecomment-2513693983 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
