You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/01/04 08:31:36 UTC
[PR] [fix](auth)remove the key when priv is empty [doris]
zddr opened a new pull request, #29522:
URL: https://github.com/apache/doris/pull/29522
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878578406
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1882909429
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878043885
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.42 seconds
stream load tsv: 579 seconds loaded 74807831229 Bytes, about 123 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.3 seconds inserted 10000000 Rows, about 353K ops/s
storage size: 17188873742 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1876903218
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.82 seconds
stream load tsv: 575 seconds loaded 74807831229 Bytes, about 124 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.3 seconds inserted 10000000 Rows, about 353K ops/s
storage size: 17183982426 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878042790
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 0df0405a7f0ae7ac87ede3f9ec22c4ad1b5ddf12, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 930 344 334 334
query2 6414 1926 1908 1908
query3 6648 211 206 206
query4 27334 22455 22395 22395
query5 4146 541 510 510
query6 268 187 184 184
query7 4576 269 274 269
query8 228 200 194 194
query9 8307 2558 2593 2558
query10 517 224 233 224
query11 16178 15309 15367 15309
query12 134 75 74 74
query13 1650 314 310 310
query14 12043 7093 7152 7093
query15 215 184 188 184
query16 6355 266 266 266
query17 1860 500 499 499
query18 1954 277 271 271
query19 191 133 128 128
query20 80 72 74 72
query21 183 94 94 94
query22 5097 4938 5058 4938
query23 32036 31148 31347 31148
query24 11903 2798 2839 2798
query25 604 338 342 338
query26 1777 141 143 141
query27 2854 272 271 271
query28 6911 1866 1859 1859
query29 2093 379 413 379
query30 296 148 149 148
query31 969 771 776 771
query32 85 55 55 55
query33 750 262 262 262
query34 908 455 441 441
query35 891 747 750 747
query36 1300 1229 1206 1206
query37 184 66 68 66
query38 3380 3295 3227 3227
query39 1327 1286 1279 1279
query40 304 89 86 86
query41 37 43 34 34
query42 93 82 95 82
query43 527 510 495 495
query44 1034 690 697 690
query45 196 189 187 187
query46 1074 663 645 645
query47 1642 1604 1603 1603
query48 342 257 248 248
query49 1207 313 319 313
query50 775 324 350 324
query51 5382 5271 5276 5271
query52 99 83 83 83
query53 207 150 155 150
query54 1422 544 557 544
query55 97 91 89 89
query56 195 193 194 193
query57 991 954 960 954
query58 224 199 198 198
query59 2827 2617 2621 2617
query60 230 200 221 200
query61 89 85 85 85
query62 656 465 457 457
query63 165 147 148 147
query64 5835 1749 1731 1731
query65 3302 3254 3247 3247
query66 1382 351 338 338
query67 15825 15386 15253 15253
query68 10966 506 515 506
query69 530 248 261 248
query70 1691 1497 1467 1467
query71 487 215 227 215
query72 5626 3566 3609 3566
query73 2142 319 312 312
query74 7007 6570 6554 6554
query75 4745 2265 2274 2265
query76 6253 1072 1136 1072
query77 654 252 256 252
query78 9172 8766 8621 8621
query79 1016 508 495 495
query80 551 362 356 356
query81 465 215 208 208
query82 199 95 91 91
query83 162 141 135 135
query84 244 55 53 53
query85 937 288 279 279
query86 400 365 367 365
query87 3590 3386 3412 3386
query88 2832 2265 2241 2241
query89 351 269 263 263
query90 1876 197 200 197
query91 120 91 91 91
query92 61 52 50 50
query93 1151 442 422 422
query94 855 179 184 179
query95 455 421 401 401
query96 618 324 319 319
query97 4300 4145 4162 4145
query98 210 209 192 192
query99 1152 810 871 810
Total cold run time: 290553 ms
Total hot run time: 179176 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878216730
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit a0c541fa5146463d6d2c8eaac91fca6356f1b9c2, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5438 5118 5139 5118
q2 381 162 175 162
q3 1462 1192 1163 1163
q4 1091 873 803 803
q5 3129 3050 3085 3050
q6 226 137 133 133
q7 1001 555 515 515
q8 2167 2228 2217 2217
q9 6699 6673 6683 6673
q10 3204 3140 3142 3140
q11 355 232 219 219
q12 380 238 232 232
q13 4401 3649 3606 3606
q14 245 212 215 212
q15 583 543 537 537
q16 450 405 389 389
q17 1057 496 559 496
q18 7097 6744 6765 6744
q19 1654 1532 1461 1461
q20 571 326 312 312
q21 2855 2498 2517 2498
q22 376 314 331 314
Total cold run time: 44822 ms
Total hot run time: 39994 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5132 5124 5131 5124
q2 338 232 226 226
q3 3385 3323 3306 3306
q4 2155 2055 2063 2055
q5 5935 5914 5928 5914
q6 224 126 126 126
q7 2403 1919 1985 1919
q8 3554 3660 3712 3660
q9 9055 9011 8983 8983
q10 3848 3905 3912 3905
q11 575 469 491 469
q12 788 665 660 660
q13 3891 3205 3165 3165
q14 293 269 282 269
q15 596 526 530 526
q16 534 485 507 485
q17 2039 1826 1800 1800
q18 8822 8421 8298 8298
q19 1749 1698 1709 1698
q20 2257 1973 1965 1965
q21 5757 5290 5280 5280
q22 581 513 472 472
Total cold run time: 63911 ms
Total hot run time: 60305 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878475762
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit f12f00bef571cc3401e30fe4895ec7f8217f3749, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5504 5149 5138 5138
q2 383 171 178 171
q3 1456 1209 1150 1150
q4 1075 812 730 730
q5 3107 3032 3104 3032
q6 223 133 133 133
q7 955 530 530 530
q8 2142 2288 2216 2216
q9 6678 6654 6655 6654
q10 3200 3114 3149 3114
q11 340 205 203 203
q12 389 233 229 229
q13 4398 3643 3650 3643
q14 252 234 224 224
q15 582 529 530 529
q16 444 403 433 403
q17 1044 539 549 539
q18 7070 6772 6768 6768
q19 1637 1503 1466 1466
q20 566 327 350 327
q21 2874 2468 2443 2443
q22 403 321 329 321
Total cold run time: 44722 ms
Total hot run time: 39963 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5215 5091 5089 5089
q2 335 236 235 235
q3 3365 3340 3311 3311
q4 2145 1993 2003 1993
q5 5937 5910 5944 5910
q6 219 125 125 125
q7 2395 1913 1931 1913
q8 3593 3654 3644 3644
q9 8980 8953 8972 8953
q10 3842 3886 3913 3886
q11 580 466 483 466
q12 787 657 626 626
q13 3885 3196 3203 3196
q14 319 283 263 263
q15 590 536 524 524
q16 567 487 501 487
q17 2028 1842 1830 1830
q18 8859 8871 8381 8381
q19 1741 1674 1691 1674
q20 2268 1984 1976 1976
q21 5614 5411 5330 5330
q22 585 505 524 505
Total cold run time: 63849 ms
Total hot run time: 60317 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878634999
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.61 seconds
stream load tsv: 565 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.2 seconds inserted 10000000 Rows, about 367K ops/s
storage size: 17183543936 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1876903127
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 896677feb939b470a4c47246b6f7624aa4381f58, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 865 346 347 346
query2 4180 2079 1979 1979
query3 4364 206 198 198
query4 27137 22392 22456 22392
query5 2820 569 531 531
query6 239 183 177 177
query7 3282 274 260 260
query8 231 226 198 198
query9 6437 2554 2647 2554
query10 532 238 227 227
query11 16197 15651 15687 15651
query12 135 76 73 73
query13 1041 320 306 306
query14 9881 7129 7037 7037
query15 223 195 188 188
query16 5139 265 258 258
query17 1429 509 483 483
query18 1508 275 260 260
query19 174 126 130 126
query20 79 72 74 72
query21 174 98 96 96
query22 4882 4861 4713 4713
query23 32079 31471 31317 31317
query24 11838 2793 2824 2793
query25 612 346 327 327
query26 1781 136 136 136
query27 2813 268 276 268
query28 7355 1872 1858 1858
query29 2617 383 380 380
query30 293 153 144 144
query31 1110 753 786 753
query32 94 60 54 54
query33 773 274 257 257
query34 1119 443 431 431
query35 933 819 803 803
query36 1296 1300 1279 1279
query37 173 68 71 68
query38 3367 3269 3246 3246
query39 1326 1294 1294 1294
query40 285 93 91 91
query41 39 35 35 35
query42 88 86 87 86
query43 519 506 508 506
query44 1048 687 711 687
query45 212 195 178 178
query46 1070 648 636 636
query47 1651 1642 1605 1605
query48 334 251 256 251
query49 1269 306 314 306
query50 800 354 326 326
query51 5320 5221 5347 5221
query52 101 81 92 81
query53 213 147 152 147
query54 2270 565 562 562
query55 97 80 85 80
query56 199 187 183 183
query57 998 924 901 901
query58 220 195 200 195
query59 2816 2708 2691 2691
query60 225 203 208 203
query61 81 80 80 80
query62 650 461 454 454
query63 164 144 147 144
query64 5753 1761 1730 1730
query65 3312 3253 3240 3240
query66 1380 337 337 337
query67 15861 15225 15134 15134
query68 14789 521 495 495
query69 461 249 245 245
query70 2394 1438 1540 1438
query71 434 224 192 192
query72 5326 3504 3518 3504
query73 4176 317 308 308
query74 7482 6454 6418 6418
query75 4990 2278 2291 2278
query76 5454 1117 1095 1095
query77 713 249 272 249
query78 9121 8686 8569 8569
query79 2116 492 497 492
query80 614 346 343 343
query81 468 208 211 208
query82 206 95 91 91
query83 182 139 139 139
query84 252 53 53 53
query85 888 265 259 259
query86 390 386 410 386
query87 3544 3371 3397 3371
query88 2944 2254 2254 2254
query89 330 259 257 257
query90 1958 201 199 199
query91 117 99 89 89
query92 58 51 51 51
query93 1349 421 479 421
query94 807 180 182 180
query95 447 413 405 405
query96 628 318 321 318
query97 4319 4163 4160 4160
query98 214 203 191 191
query99 1056 839 811 811
Total cold run time: 285730 ms
Total hot run time: 179092 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #29522:
URL: https://github.com/apache/doris/pull/29522
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878035592
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 0df0405a7f0ae7ac87ede3f9ec22c4ad1b5ddf12, data reload: false
------ Round 1 ----------------------------------
q1 17686 5129 5079 5079
q2 2034 152 140 140
q3 10537 1109 1096 1096
q4 10180 729 808 729
q5 7781 2916 2823 2823
q6 217 131 130 130
q7 917 553 488 488
q8 9241 2009 2009 2009
q9 6829 6345 6379 6345
q10 8301 3045 2990 2990
q11 446 211 208 208
q12 387 226 230 226
q13 17989 3650 3615 3615
q14 236 213 208 208
q15 561 528 504 504
q16 440 398 394 394
q17 945 479 494 479
q18 7260 6670 6613 6613
q19 1565 1324 1370 1324
q20 682 320 340 320
q21 2797 2371 2367 2367
q22 376 313 329 313
Total cold run time: 107407 ms
Total hot run time: 38400 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5114 5058 5061 5058
q2 338 230 233 230
q3 3294 3266 3252 3252
q4 2095 2013 2032 2013
q5 5770 5756 5767 5756
q6 215 126 123 123
q7 2327 1885 1917 1885
q8 3329 3426 3431 3426
q9 8795 8789 8695 8695
q10 3751 3839 3843 3839
q11 571 485 462 462
q12 784 615 643 615
q13 6856 3211 3151 3151
q14 292 278 268 268
q15 570 523 515 515
q16 553 480 488 480
q17 1918 1733 1724 1724
q18 8714 8313 8213 8213
q19 1612 1603 1551 1551
q20 2187 1947 1956 1947
q21 5584 5224 5282 5224
q22 538 485 466 466
Total cold run time: 65207 ms
Total hot run time: 58893 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878079021
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 60527feb72b29d01cb7313ab340b826c55766125, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5461 5161 5089 5089
q2 379 164 159 159
q3 1448 1206 1198 1198
q4 1080 809 778 778
q5 3129 3095 3130 3095
q6 223 133 134 133
q7 967 541 520 520
q8 2150 2307 2241 2241
q9 6671 6644 6647 6644
q10 3174 3144 3134 3134
q11 349 235 209 209
q12 380 241 232 232
q13 4406 3626 3592 3592
q14 249 221 217 217
q15 581 536 518 518
q16 444 390 410 390
q17 1046 498 546 498
q18 7075 6791 6794 6791
q19 1643 1518 1603 1518
q20 605 329 341 329
q21 2875 2482 2468 2468
q22 409 303 341 303
Total cold run time: 44744 ms
Total hot run time: 40056 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5087 5044 5050 5044
q2 338 232 243 232
q3 3357 3318 3318 3318
q4 2150 2075 2037 2037
q5 5927 5904 5910 5904
q6 223 127 126 126
q7 2393 1959 1914 1914
q8 3551 3708 3670 3670
q9 9051 8971 9023 8971
q10 3864 3930 3903 3903
q11 586 473 499 473
q12 810 625 655 625
q13 3866 3155 3184 3155
q14 289 260 264 260
q15 591 532 534 532
q16 550 502 500 500
q17 2003 1801 1874 1801
q18 8829 8463 8581 8463
q19 1731 1684 1701 1684
q20 2271 1994 1972 1972
q21 5741 5303 5262 5262
q22 564 543 527 527
Total cold run time: 63772 ms
Total hot run time: 60373 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878203265
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit a0c541fa5146463d6d2c8eaac91fca6356f1b9c2, data reload: false
------ Round 1 ----------------------------------
q1 17952 5181 5080 5080
q2 2018 152 139 139
q3 10637 1056 1067 1056
q4 10211 777 798 777
q5 7760 2939 2955 2939
q6 210 131 135 131
q7 896 545 491 491
q8 9276 1966 1994 1966
q9 6862 6334 6316 6316
q10 8243 3076 3025 3025
q11 429 218 202 202
q12 381 226 225 225
q13 18004 3619 3589 3589
q14 239 208 206 206
q15 555 522 512 512
q16 478 391 379 379
q17 972 547 500 500
q18 7268 6661 6616 6616
q19 1591 1319 1400 1319
q20 671 314 345 314
q21 2763 2379 2382 2379
q22 380 315 319 315
Total cold run time: 107796 ms
Total hot run time: 38476 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5084 5064 5065 5064
q2 339 228 227 227
q3 3275 3275 3250 3250
q4 2111 1988 2011 1988
q5 5741 5720 5739 5720
q6 215 124 124 124
q7 2323 1882 1885 1882
q8 3348 3406 3409 3406
q9 8759 8714 8720 8714
q10 3762 3795 3801 3795
q11 586 482 471 471
q12 790 617 617 617
q13 9927 3204 3212 3204
q14 286 264 258 258
q15 569 520 518 518
q16 524 502 497 497
q17 1907 1745 1776 1745
q18 8572 8331 8267 8267
q19 1594 1548 1777 1548
q20 2187 1958 1983 1958
q21 5533 5171 5198 5171
q22 508 449 450 449
Total cold run time: 67940 ms
Total hot run time: 58873 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878446730
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit f12f00bef571cc3401e30fe4895ec7f8217f3749, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 946 355 335 335
query2 6411 1979 1871 1871
query3 6660 207 198 198
query4 26502 22532 22492 22492
query5 3898 546 504 504
query6 272 178 183 178
query7 4583 265 257 257
query8 228 201 207 201
query9 8285 2606 2526 2526
query10 450 224 220 220
query11 16278 15529 15585 15529
query12 131 76 75 75
query13 1631 308 326 308
query14 11584 7140 7074 7074
query15 213 185 189 185
query16 6256 261 264 261
query17 1854 492 493 492
query18 1871 266 262 262
query19 180 128 130 128
query20 81 75 75 75
query21 186 99 93 93
query22 4814 4648 4763 4648
query23 32067 31742 31393 31393
query24 12220 2859 2825 2825
query25 598 334 335 334
query26 1775 137 140 137
query27 2909 270 269 269
query28 7010 1870 1875 1870
query29 2150 383 386 383
query30 292 140 146 140
query31 957 773 752 752
query32 87 58 56 56
query33 731 251 264 251
query34 910 454 444 444
query35 906 764 790 764
query36 1261 1272 1132 1132
query37 190 66 70 66
query38 3411 3325 3295 3295
query39 1313 1278 1271 1271
query40 303 90 93 90
query41 37 37 38 37
query42 87 81 78 78
query43 515 497 495 495
query44 1065 702 705 702
query45 195 190 185 185
query46 1071 639 634 634
query47 1685 1480 1535 1480
query48 330 256 252 252
query49 1225 307 313 307
query50 748 318 361 318
query51 5401 5296 5245 5245
query52 92 85 77 77
query53 212 139 147 139
query54 1409 542 560 542
query55 91 84 84 84
query56 201 190 190 190
query57 1000 916 965 916
query58 216 191 201 191
query59 2792 2698 2556 2556
query60 240 201 225 201
query61 87 82 85 82
query62 636 455 445 445
query63 157 144 137 137
query64 5860 1788 1669 1669
query65 3354 3257 3270 3257
query66 1385 339 338 338
query67 15801 15592 15471 15471
query68 12142 499 517 499
query69 522 253 256 253
query70 1652 1578 1530 1530
query71 490 195 193 193
query72 5606 3532 3540 3532
query73 2758 315 320 315
query74 6950 6376 6430 6376
query75 5002 2270 2282 2270
query76 6219 1059 1083 1059
query77 657 246 258 246
query78 9089 8653 8509 8509
query79 2200 492 487 487
query80 684 341 352 341
query81 452 211 204 204
query82 210 96 97 96
query83 163 133 130 130
query84 247 54 52 52
query85 946 279 270 270
query86 402 387 379 379
query87 3545 3399 3296 3296
query88 3419 2256 2232 2232
query89 348 254 256 254
query90 1947 194 190 190
query91 114 94 91 91
query92 59 53 51 51
query93 2408 437 481 437
query94 818 175 176 175
query95 459 423 417 417
query96 617 321 325 321
query97 4286 4166 4183 4166
query98 220 194 190 190
query99 1121 837 776 776
Total cold run time: 294048 ms
Total hot run time: 178749 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878035874
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 0df0405a7f0ae7ac87ede3f9ec22c4ad1b5ddf12, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5573 5107 5107 5107
q2 383 174 158 158
q3 1471 1174 1158 1158
q4 1088 905 798 798
q5 3136 3155 3082 3082
q6 221 132 132 132
q7 967 563 515 515
q8 2157 2231 2196 2196
q9 6660 6692 6619 6619
q10 3172 3085 3158 3085
q11 339 221 237 221
q12 383 233 234 233
q13 4389 3615 3626 3615
q14 244 216 209 209
q15 579 537 541 537
q16 443 394 391 391
q17 1049 526 458 458
q18 7074 6693 6764 6693
q19 1650 1499 1565 1499
q20 597 345 343 343
q21 2894 2433 2533 2433
q22 401 332 325 325
Total cold run time: 44870 ms
Total hot run time: 39807 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5107 5032 5039 5032
q2 336 223 238 223
q3 3376 3355 3314 3314
q4 2150 2038 2029 2029
q5 5962 5932 5928 5928
q6 222 126 129 126
q7 2397 1944 1957 1944
q8 3566 3614 3672 3614
q9 9031 8980 8986 8980
q10 3886 3900 3955 3900
q11 578 508 472 472
q12 787 641 649 641
q13 3886 3175 3156 3156
q14 303 288 268 268
q15 602 530 524 524
q16 569 483 501 483
q17 2052 1790 1814 1790
q18 8799 8348 8374 8348
q19 1740 1691 1700 1691
q20 2270 2005 1954 1954
q21 5683 5370 5341 5341
q22 553 476 562 476
Total cold run time: 63855 ms
Total hot run time: 60234 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878427166
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.28 seconds
stream load tsv: 564 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.6 seconds inserted 10000000 Rows, about 362K ops/s
storage size: 17183962563 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878625417
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 5e031d6e656e8c6cdfc2835394241cde0a8c795a, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5488 5075 5147 5075
q2 385 157 142 142
q3 1461 1224 1114 1114
q4 1077 864 846 846
q5 3154 3156 3091 3091
q6 219 133 136 133
q7 965 577 520 520
q8 2147 2254 2299 2254
q9 6700 6631 6624 6624
q10 3167 3104 3112 3104
q11 351 216 211 211
q12 380 230 237 230
q13 4399 3666 3611 3611
q14 258 220 223 220
q15 581 540 537 537
q16 459 408 424 408
q17 1041 500 557 500
q18 7074 6771 7089 6771
q19 1655 1470 1422 1422
q20 590 327 365 327
q21 2905 2428 2511 2428
q22 405 337 342 337
Total cold run time: 44861 ms
Total hot run time: 39905 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5102 5063 5055 5055
q2 340 256 232 232
q3 3370 3349 3338 3338
q4 2166 2079 2064 2064
q5 5937 5925 5930 5925
q6 223 128 130 128
q7 2417 1919 1944 1919
q8 3569 3669 3692 3669
q9 9031 8964 8996 8964
q10 3836 3937 3902 3902
q11 581 482 480 480
q12 830 653 636 636
q13 3895 3197 3191 3191
q14 293 285 282 282
q15 584 520 527 520
q16 564 484 503 484
q17 2051 1820 1841 1820
q18 8810 8357 8304 8304
q19 1726 1608 1657 1608
q20 2256 1997 1969 1969
q21 5810 5369 5475 5369
q22 581 460 473 460
Total cold run time: 63972 ms
Total hot run time: 60319 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1876924890
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 896677feb939b470a4c47246b6f7624aa4381f58, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5412 5144 5111 5111
q2 386 167 160 160
q3 1476 1191 1086 1086
q4 1076 839 825 825
q5 3212 3153 3156 3153
q6 221 131 133 131
q7 984 574 511 511
q8 2168 2283 2258 2258
q9 6697 6660 6650 6650
q10 3164 3121 3164 3121
q11 332 236 213 213
q12 384 234 236 234
q13 4400 3609 3676 3609
q14 262 218 220 218
q15 579 539 520 520
q16 448 420 400 400
q17 1067 526 514 514
q18 7040 6741 6818 6741
q19 1647 1501 1474 1474
q20 558 342 368 342
q21 2937 2520 2596 2520
q22 396 331 319 319
Total cold run time: 44846 ms
Total hot run time: 40110 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5110 5096 5028 5028
q2 339 230 242 230
q3 3356 3341 3352 3341
q4 2167 2057 2042 2042
q5 5949 5928 5932 5928
q6 232 125 129 125
q7 2401 1889 1946 1889
q8 3580 3672 3685 3672
q9 9080 8953 9029 8953
q10 3877 3921 3915 3915
q11 583 484 499 484
q12 813 662 624 624
q13 3879 3214 3212 3212
q14 317 265 283 265
q15 601 525 536 525
q16 544 484 495 484
q17 2073 1822 1843 1822
q18 8733 8340 8429 8340
q19 1744 1709 1677 1677
q20 2258 1981 1954 1954
q21 5791 5299 5250 5250
q22 577 470 492 470
Total cold run time: 64004 ms
Total hot run time: 60230 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878076844
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 60527feb72b29d01cb7313ab340b826c55766125, data reload: false
------ Round 1 ----------------------------------
q1 17741 5089 5034 5034
q2 2025 152 144 144
q3 10552 1060 1058 1058
q4 10184 802 834 802
q5 7764 2926 2920 2920
q6 210 132 133 132
q7 927 503 492 492
q8 9274 1984 2002 1984
q9 6853 6377 6337 6337
q10 8236 3070 2990 2990
q11 419 206 215 206
q12 388 237 232 232
q13 18129 3632 3620 3620
q14 238 220 211 211
q15 559 525 508 508
q16 440 406 389 389
q17 939 551 466 466
q18 7234 6652 6625 6625
q19 1580 1348 1381 1348
q20 721 343 317 317
q21 2761 2345 2404 2345
q22 362 329 325 325
Total cold run time: 107536 ms
Total hot run time: 38485 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5123 5053 5107 5053
q2 332 241 230 230
q3 3268 3275 3238 3238
q4 2103 2013 2024 2013
q5 5735 5722 5736 5722
q6 211 125 126 125
q7 2297 1869 1883 1869
q8 3348 3422 3430 3422
q9 8770 8775 8668 8668
q10 3778 3788 3817 3788
q11 577 473 480 473
q12 787 632 632 632
q13 7297 3213 3185 3185
q14 299 269 280 269
q15 567 513 520 513
q16 535 477 492 477
q17 1948 1739 1754 1739
q18 8678 8224 8244 8224
q19 1625 1558 1595 1558
q20 2188 1946 1923 1923
q21 5529 5243 5282 5243
q22 528 508 465 465
Total cold run time: 65523 ms
Total hot run time: 58829 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878227567
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.65 seconds
stream load tsv: 569 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 27.7 seconds inserted 10000000 Rows, about 361K ops/s
storage size: 17183780168 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878431258
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit f12f00bef571cc3401e30fe4895ec7f8217f3749, data reload: false
------ Round 1 ----------------------------------
q1 18424 5534 5119 5119
q2 2039 155 145 145
q3 10621 1085 1141 1085
q4 10267 767 844 767
q5 7836 2976 2866 2866
q6 217 133 134 133
q7 933 508 540 508
q8 9293 2047 2002 2002
q9 6871 6449 6386 6386
q10 8256 3026 3044 3026
q11 422 232 204 204
q12 392 225 228 225
q13 18018 3648 3620 3620
q14 251 223 219 219
q15 555 532 520 520
q16 455 395 392 392
q17 966 475 486 475
q18 7519 6712 6662 6662
q19 1598 1334 1410 1334
q20 694 319 327 319
q21 2833 2406 2438 2406
q22 369 312 327 312
Total cold run time: 108829 ms
Total hot run time: 38725 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5242 5138 5122 5122
q2 347 225 250 225
q3 3319 3298 3280 3280
q4 2112 2039 2019 2019
q5 5812 5779 5772 5772
q6 216 125 126 125
q7 2338 1922 1896 1896
q8 3381 3457 3473 3457
q9 8802 8655 8722 8655
q10 3778 3851 3863 3851
q11 564 476 488 476
q12 803 635 624 624
q13 5304 3229 3179 3179
q14 312 264 271 264
q15 590 529 514 514
q16 574 500 535 500
q17 1938 1786 1790 1786
q18 8695 8347 8350 8347
q19 1645 1610 1627 1610
q20 2179 1991 1931 1931
q21 5520 5272 5303 5272
q22 578 517 469 469
Total cold run time: 64049 ms
Total hot run time: 59374 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878059917
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878186737
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1876886670
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 896677feb939b470a4c47246b6f7624aa4381f58, data reload: false
------ Round 1 ----------------------------------
q1 17722 5279 5275 5275
q2 2042 154 152 152
q3 10537 1177 1214 1177
q4 10185 819 917 819
q5 7822 3105 3079 3079
q6 236 136 132 132
q7 961 511 533 511
q8 9330 2227 2225 2225
q9 7319 6708 6606 6606
q10 8325 3162 3132 3132
q11 462 218 210 210
q12 415 234 236 234
q13 18008 3669 3632 3632
q14 245 219 212 212
q15 575 524 513 513
q16 520 402 414 402
q17 1036 454 472 454
q18 7514 6857 6741 6741
q19 1774 1550 1523 1523
q20 686 320 339 320
q21 3021 2487 2608 2487
q22 395 310 319 310
Total cold run time: 109130 ms
Total hot run time: 40146 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5368 5334 5264 5264
q2 354 241 240 240
q3 3403 3379 3349 3349
q4 2245 2121 2122 2121
q5 6018 6010 5986 5986
q6 236 129 126 126
q7 2389 1952 1966 1952
q8 3608 3677 3696 3677
q9 8965 8875 8887 8875
q10 3908 3989 3937 3937
q11 594 475 484 475
q12 836 638 633 633
q13 15161 3168 3197 3168
q14 308 263 269 263
q15 583 523 516 516
q16 560 499 507 499
q17 2115 1865 1875 1865
q18 8921 8514 8394 8394
q19 1824 1817 1814 1814
q20 2236 1956 1939 1939
q21 5882 5484 5372 5372
q22 574 491 465 465
Total cold run time: 76088 ms
Total hot run time: 60930 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1876856382
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878009532
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878082520
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 60527feb72b29d01cb7313ab340b826c55766125, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 926 340 328 328
query2 6416 1939 1847 1847
query3 6645 206 202 202
query4 28265 22377 22203 22203
query5 3897 495 507 495
query6 268 198 182 182
query7 4583 277 263 263
query8 224 204 192 192
query9 8218 2618 2573 2573
query10 411 256 260 256
query11 16135 15454 15554 15454
query12 138 76 75 75
query13 1628 319 315 315
query14 11372 7083 7184 7083
query15 216 183 190 183
query16 6133 265 260 260
query17 1820 530 485 485
query18 1803 269 267 267
query19 185 138 137 137
query20 77 76 75 75
query21 185 97 97 97
query22 5238 4841 4943 4841
query23 32194 30969 31196 30969
query24 12090 2785 2783 2783
query25 603 360 345 345
query26 1829 134 143 134
query27 2912 270 269 269
query28 7041 1872 1867 1867
query29 2194 387 387 387
query30 292 135 145 135
query31 983 776 757 757
query32 86 56 54 54
query33 740 243 251 243
query34 916 439 434 434
query35 914 779 800 779
query36 1235 1191 1193 1191
query37 181 64 67 64
query38 3380 3281 3290 3281
query39 1323 1298 1247 1247
query40 294 85 85 85
query41 40 35 37 35
query42 90 82 80 80
query43 512 489 471 471
query44 1091 693 716 693
query45 203 180 179 179
query46 1061 639 639 639
query47 1636 1573 1582 1573
query48 331 263 254 254
query49 1231 319 310 310
query50 745 321 369 321
query51 5364 5207 5276 5207
query52 102 81 91 81
query53 208 148 143 143
query54 1411 559 555 555
query55 105 87 83 83
query56 184 190 192 190
query57 1077 947 926 926
query58 227 193 192 192
query59 2842 2722 2721 2721
query60 234 209 221 209
query61 90 89 90 89
query62 640 488 456 456
query63 163 142 151 142
query64 5940 1720 1755 1720
query65 3306 3243 3236 3236
query66 1396 330 328 328
query67 15703 15453 15182 15182
query68 10407 509 525 509
query69 509 249 245 245
query70 1643 1445 1484 1445
query71 483 221 228 221
query72 5427 3608 3620 3608
query73 2118 313 309 309
query74 7004 6480 6422 6422
query75 4727 2266 2267 2266
query76 6256 1119 1034 1034
query77 654 245 252 245
query78 9139 8788 8565 8565
query79 1021 509 530 509
query80 546 347 347 347
query81 484 204 208 204
query82 216 91 85 85
query83 160 135 138 135
query84 248 54 53 53
query85 929 283 279 279
query86 392 404 398 398
query87 3528 3372 3394 3372
query88 2916 2265 2253 2253
query89 325 270 241 241
query90 1883 190 200 190
query91 120 91 91 91
query92 67 52 51 51
query93 1103 482 478 478
query94 793 184 180 180
query95 456 408 404 404
query96 627 318 320 318
query97 4260 4136 4179 4136
query98 203 191 186 186
query99 1110 846 787 787
Total cold run time: 289676 ms
Total hot run time: 178418 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878085680
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.67 seconds
stream load tsv: 567 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.3 seconds inserted 10000000 Rows, about 366K ops/s
storage size: 17184130608 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878216004
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit a0c541fa5146463d6d2c8eaac91fca6356f1b9c2, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 925 334 332 332
query2 6444 2009 1892 1892
query3 6644 211 208 208
query4 26698 22382 22350 22350
query5 4350 541 495 495
query6 266 185 177 177
query7 4591 265 269 265
query8 226 195 188 188
query9 8177 2538 2501 2501
query10 542 277 231 231
query11 16143 15547 15455 15455
query12 132 73 79 73
query13 1622 316 313 313
query14 11603 7055 6983 6983
query15 218 182 193 182
query16 6341 264 261 261
query17 1850 491 481 481
query18 1947 273 266 266
query19 192 132 132 132
query20 84 72 75 72
query21 184 91 95 91
query22 4771 4754 4527 4527
query23 32082 30970 30990 30970
query24 11894 2852 2786 2786
query25 582 337 334 334
query26 1767 133 139 133
query27 2884 277 267 267
query28 7127 1860 1855 1855
query29 2136 382 371 371
query30 294 139 144 139
query31 997 782 747 747
query32 88 51 54 51
query33 732 254 253 253
query34 917 448 441 441
query35 916 728 773 728
query36 1317 1149 1132 1132
query37 181 67 66 66
query38 3355 3337 3265 3265
query39 1319 1284 1255 1255
query40 309 93 80 80
query41 38 36 33 33
query42 87 89 79 79
query43 508 465 496 465
query44 1076 702 699 699
query45 202 193 179 179
query46 1073 623 629 623
query47 1631 1479 1495 1479
query48 330 255 261 255
query49 1206 304 308 304
query50 730 322 331 322
query51 5350 5221 5216 5216
query52 92 91 85 85
query53 208 149 150 149
query54 1366 552 569 552
query55 86 80 85 80
query56 177 195 179 179
query57 988 1011 965 965
query58 227 196 205 196
query59 2915 2717 2801 2717
query60 241 215 207 207
query61 87 96 84 84
query62 683 470 472 470
query63 164 148 153 148
query64 5881 1720 1657 1657
query65 3306 3221 3243 3221
query66 1653 346 328 328
query67 15598 14965 15204 14965
query68 10935 509 522 509
query69 519 246 257 246
query70 1640 1539 1554 1539
query71 492 205 208 205
query72 5653 3634 3525 3525
query73 2123 306 312 306
query74 6982 6499 6401 6401
query75 4818 2289 2284 2284
query76 6296 1039 1081 1039
query77 660 262 256 256
query78 9121 8626 8718 8626
query79 1034 507 502 502
query80 525 339 332 332
query81 458 208 207 207
query82 205 87 90 87
query83 160 137 141 137
query84 244 52 51 51
query85 922 275 265 265
query86 384 371 378 371
query87 3536 3372 3340 3340
query88 2824 2258 2247 2247
query89 321 261 254 254
query90 1901 196 196 196
query91 115 86 93 86
query92 60 50 53 50
query93 1200 495 461 461
query94 786 173 178 173
query95 446 409 401 401
query96 617 321 321 321
query97 4276 4118 4202 4118
query98 214 196 188 188
query99 1089 838 785 785
Total cold run time: 289306 ms
Total hot run time: 177513 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878241128
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878241166
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878618771
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 5e031d6e656e8c6cdfc2835394241cde0a8c795a, data reload: false
------ Round 1 ----------------------------------
q1 19365 8857 5155 5155
q2 2039 155 139 139
q3 10636 1087 1126 1087
q4 10307 784 788 784
q5 7821 3021 2977 2977
q6 212 133 136 133
q7 926 500 545 500
q8 9309 2071 2054 2054
q9 6872 6450 6434 6434
q10 8227 3093 3043 3043
q11 450 224 209 209
q12 404 235 240 235
q13 17999 3653 3629 3629
q14 255 214 214 214
q15 570 523 526 523
q16 457 399 394 394
q17 990 480 502 480
q18 7236 6725 6723 6723
q19 1599 1357 1319 1319
q20 689 315 326 315
q21 2841 2402 2414 2402
q22 389 324 343 324
Total cold run time: 109593 ms
Total hot run time: 39073 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5200 5102 5146 5102
q2 334 232 239 232
q3 3322 3300 3293 3293
q4 2134 2072 2051 2051
q5 5881 5810 5810 5810
q6 216 123 129 123
q7 2357 1912 1926 1912
q8 3393 3471 3500 3471
q9 8910 8801 8780 8780
q10 3798 3857 3862 3857
q11 585 474 483 474
q12 792 643 654 643
q13 5252 3195 3197 3195
q14 290 271 285 271
q15 584 526 527 526
q16 539 491 498 491
q17 1930 1791 1729 1729
q18 8636 8360 8341 8341
q19 1636 1586 1621 1586
q20 2208 1967 1966 1966
q21 5663 5300 5212 5212
q22 553 479 504 479
Total cold run time: 64213 ms
Total hot run time: 59544 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878377044
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](auth)remove the key when priv is empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29522:
URL: https://github.com/apache/doris/pull/29522#issuecomment-1878631757
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 5e031d6e656e8c6cdfc2835394241cde0a8c795a, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 930 340 337 337
query2 6413 1956 1905 1905
query3 6651 201 197 197
query4 26860 22482 22329 22329
query5 3881 510 576 510
query6 253 178 179 178
query7 4589 276 266 266
query8 237 205 197 197
query9 8199 2570 2585 2570
query10 421 235 254 235
query11 16130 15465 15371 15371
query12 149 74 73 73
query13 1635 326 337 326
query14 11918 7104 7064 7064
query15 225 189 182 182
query16 6206 268 264 264
query17 1839 495 483 483
query18 1896 275 263 263
query19 178 131 136 131
query20 77 73 71 71
query21 185 97 93 93
query22 4959 4801 4694 4694
query23 32115 31147 30965 30965
query24 11900 2811 2834 2811
query25 584 341 341 341
query26 1814 146 142 142
query27 2854 273 284 273
query28 7180 1913 1899 1899
query29 2158 383 397 383
query30 287 141 145 141
query31 982 743 744 743
query32 91 57 57 57
query33 730 256 251 251
query34 945 445 451 445
query35 904 770 794 770
query36 1353 1289 1200 1200
query37 188 75 72 72
query38 3369 3288 3269 3269
query39 1308 1292 1278 1278
query40 305 85 83 83
query41 38 39 34 34
query42 89 92 84 84
query43 522 491 501 491
query44 1103 704 712 704
query45 191 190 176 176
query46 1076 631 644 631
query47 1629 1565 1555 1555
query48 343 268 276 268
query49 1219 304 310 304
query50 787 340 336 336
query51 5379 5193 5285 5193
query52 89 89 82 82
query53 213 146 141 141
query54 1351 552 570 552
query55 86 81 77 77
query56 188 190 185 185
query57 1046 893 954 893
query58 223 199 189 189
query59 2883 2657 2646 2646
query60 220 223 208 208
query61 86 83 85 83
query62 669 456 456 456
query63 166 153 144 144
query64 5818 1717 1686 1686
query65 3359 3223 3276 3223
query66 1402 335 336 335
query67 15657 15124 15335 15124
query68 10841 537 531 531
query69 523 249 251 249
query70 1729 1543 1462 1462
query71 490 191 211 191
query72 5615 3544 3553 3544
query73 2152 302 302 302
query74 6876 6398 6361 6361
query75 4815 2251 2245 2245
query76 6296 1115 1084 1084
query77 660 245 252 245
query78 9047 8805 8578 8578
query79 1013 495 500 495
query80 528 334 334 334
query81 463 203 201 201
query82 202 93 86 86
query83 158 139 132 132
query84 244 54 54 54
query85 924 268 265 265
query86 459 412 405 405
query87 3531 3351 3382 3351
query88 2925 2227 2227 2227
query89 321 263 251 251
query90 1873 190 190 190
query91 115 88 90 88
query92 56 55 52 52
query93 1490 436 430 430
query94 869 182 180 180
query95 449 410 410 410
query96 621 309 310 309
query97 4287 4189 4196 4189
query98 204 198 188 188
query99 1112 839 834 834
Total cold run time: 289618 ms
Total hot run time: 178125 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org