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/10 08:46:09 UTC
[PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
zddr opened a new pull request, #29790:
URL: https://github.com/apache/doris/pull/29790
## 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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886573885
<details>
<summary>ClickBench: <b>Total hot run time: 30.63 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 09eb2efeace11fe1934151476f8ba1fc806ba647, data reload: false
query1 0.06 0.06 0.06
query2 0.06 0.02 0.02
query3 0.25 0.12 0.10
query4 1.78 0.13 0.12
query5 0.52 0.52 0.52
query6 1.41 0.65 0.63
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.55 0.50 0.50
query10 0.56 0.55 0.56
query11 0.14 0.09 0.09
query12 0.11 0.09 0.09
query13 0.62 0.59 0.59
query14 0.80 0.78 0.79
query15 0.82 0.81 0.80
query16 0.36 0.36 0.35
query17 0.96 0.98 1.01
query18 0.25 0.25 0.25
query19 1.83 1.81 1.69
query20 0.01 0.01 0.01
query21 15.42 0.58 0.55
query22 2.40 2.81 2.10
query23 17.58 0.80 0.74
query24 16.00 0.61 0.58
query25 2.44 0.15 0.14
query26 0.13 0.14 0.14
query27 0.14 0.14 0.15
query28 7.00 0.86 0.83
query29 12.56 3.12 3.15
query30 0.55 0.48 0.49
query31 2.79 0.34 0.36
query32 3.39 0.49 0.49
query33 3.16 3.21 3.27
query34 15.73 4.14 4.17
query35 4.17 4.16 4.20
query36 1.09 1.04 1.04
query37 0.06 0.04 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.01
query40 0.16 0.13 0.14
query41 0.07 0.01 0.01
query42 0.03 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 116.1 s
Total hot run time: 30.63 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886560412
<details>
<summary>TPC-DS: <b>Total hot run time: 177699 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 09eb2efeace11fe1934151476f8ba1fc806ba647, data reload: false
query1 937 348 334 334
query2 6701 1850 1752 1752
query3 6720 214 208 208
query4 26614 22114 22063 22063
query5 5064 494 502 494
query6 290 184 193 184
query7 4610 280 271 271
query8 231 202 205 202
query9 9150 2772 2794 2772
query10 495 248 257 248
query11 16240 15358 15432 15358
query12 140 81 75 75
query13 1627 341 345 341
query14 11965 7328 7264 7264
query15 236 189 190 189
query16 6487 287 271 271
query17 1855 491 478 478
query18 1937 287 269 269
query19 262 150 151 150
query20 90 81 79 79
query21 188 88 98 88
query22 5037 4938 4880 4880
query23 31688 30959 30912 30912
query24 12459 2828 2861 2828
query25 568 346 333 333
query26 1733 149 153 149
query27 2922 273 272 272
query28 6976 1875 1860 1860
query29 2021 403 389 389
query30 283 145 148 145
query31 1004 751 777 751
query32 94 60 61 60
query33 753 279 277 277
query34 1044 436 437 436
query35 925 739 727 727
query36 1352 1208 1254 1208
query37 179 70 66 66
query38 3365 3317 3282 3282
query39 1336 1302 1285 1285
query40 321 92 96 92
query41 38 35 35 35
query42 100 99 93 93
query43 547 521 497 497
query44 1065 710 714 710
query45 212 185 185 185
query46 1055 664 668 664
query47 1590 1566 1477 1477
query48 390 315 318 315
query49 1272 308 318 308
query50 736 324 318 318
query51 5260 5153 5219 5153
query52 99 87 99 87
query53 221 156 149 149
query54 1433 580 606 580
query55 97 90 86 86
query56 225 195 203 195
query57 993 909 950 909
query58 236 222 221 221
query59 2632 2499 2395 2395
query60 243 242 227 227
query61 93 82 81 81
query62 586 389 387 387
query63 171 151 152 151
query64 5882 1722 1730 1722
query65 3339 3268 3247 3247
query66 1368 337 334 334
query67 15730 15140 15262 15140
query68 10417 555 535 535
query69 573 291 285 285
query70 1721 1559 1611 1559
query71 496 214 231 214
query72 4692 2845 2892 2845
query73 2114 321 312 312
query74 6870 6368 6378 6368
query75 4756 2286 2290 2286
query76 6296 894 1192 894
query77 670 286 294 286
query78 9708 8678 8742 8678
query79 1029 516 499 499
query80 540 362 367 362
query81 452 218 210 210
query82 223 91 97 91
query83 165 136 140 136
query84 268 59 62 59
query85 951 284 284 284
query86 401 384 360 360
query87 3551 3406 3388 3388
query88 2823 2270 2255 2255
query89 329 259 275 259
query90 1854 206 202 202
query91 167 132 139 132
query92 60 56 59 56
query93 1008 443 493 443
query94 768 192 196 192
query95 476 433 426 426
query96 628 323 324 323
query97 4291 4223 4165 4165
query98 213 187 185 185
query99 1013 702 741 702
Total cold run time: 291035 ms
Total hot run time: 177699 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886250073
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 06188a475425cdcbbb323a1205a0996bdd6162bc with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.6 seconds inserted 10000000 Rows, about 684K ops/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-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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1888437306
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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #29790:
URL: https://github.com/apache/doris/pull/29790
--
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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886520457
<details>
<summary>TPC-H: <b>Total hot run time: 38611 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 09eb2efeace11fe1934151476f8ba1fc806ba647, data reload: false
------ Round 1 ----------------------------------
q1 18075 4982 5007 4982
q2 2032 142 138 138
q3 10684 1101 1193 1101
q4 10252 784 837 784
q5 7772 3170 3135 3135
q6 201 123 127 123
q7 887 508 490 490
q8 9261 1978 1989 1978
q9 7283 6453 6447 6447
q10 8284 3067 3055 3055
q11 420 223 204 204
q12 372 199 200 199
q13 18120 3401 3431 3401
q14 244 229 216 216
q15 554 521 508 508
q16 435 377 384 377
q17 955 496 524 496
q18 7255 6705 6686 6686
q19 1585 1311 1415 1311
q20 542 330 306 306
q21 2801 2374 2395 2374
q22 353 300 305 300
Total cold run time: 108367 ms
Total hot run time: 38611 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4916 4987 4964 4964
q2 312 208 203 203
q3 3333 3297 3309 3297
q4 2252 2280 2273 2273
q5 5810 5798 5798 5798
q6 193 118 120 118
q7 2299 1854 1859 1854
q8 3447 3550 3558 3550
q9 8860 8817 8798 8798
q10 3764 3835 3837 3835
q11 553 434 445 434
q12 785 608 598 598
q13 5573 3244 3222 3222
q14 287 276 277 276
q15 563 518 497 497
q16 520 454 466 454
q17 2062 2043 2027 2027
q18 8716 8407 8274 8274
q19 1640 1621 1619 1619
q20 2185 1937 1940 1937
q21 6017 5792 5771 5771
q22 550 468 453 453
Total cold run time: 64637 ms
Total hot run time: 60252 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886241568
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.88 seconds
stream load tsv: 576 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 21.9 seconds inserted 10000000 Rows, about 456K ops/s
storage size: 17184130604 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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886243408
<details>
<summary>TPC-DS: <b>Total hot run time: 178416 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 06188a475425cdcbbb323a1205a0996bdd6162bc, data reload: false
query1 940 340 337 337
query2 6701 1865 1961 1865
query3 6701 211 208 208
query4 27244 22150 22191 22150
query5 4828 546 517 517
query6 268 185 185 185
query7 4616 290 280 280
query8 234 196 202 196
query9 9140 2810 2763 2763
query10 563 268 253 253
query11 16065 15291 15502 15291
query12 139 80 79 79
query13 1629 345 356 345
query14 12098 7313 7269 7269
query15 250 193 189 189
query16 6606 293 272 272
query17 1931 508 489 489
query18 1957 275 274 274
query19 299 149 141 141
query20 85 86 81 81
query21 193 91 89 89
query22 5247 4787 4809 4787
query23 31989 30993 31039 30993
query24 12437 2845 2784 2784
query25 596 338 344 338
query26 1767 165 154 154
query27 2870 284 281 281
query28 7136 1875 1873 1873
query29 2077 391 400 391
query30 286 145 146 145
query31 985 758 780 758
query32 90 68 63 63
query33 760 301 273 273
query34 1047 439 454 439
query35 872 737 722 722
query36 1352 1245 1250 1245
query37 186 68 68 68
query38 3424 3281 3290 3281
query39 1379 1283 1280 1280
query40 290 90 94 90
query41 38 36 35 35
query42 103 94 99 94
query43 565 523 498 498
query44 1108 711 726 711
query45 203 189 204 189
query46 1053 671 664 664
query47 1690 1589 1543 1543
query48 394 324 319 319
query49 1287 323 306 306
query50 776 331 335 331
query51 5288 5219 5173 5173
query52 105 91 88 88
query53 214 148 155 148
query54 1410 582 599 582
query55 95 103 85 85
query56 222 202 200 200
query57 1057 960 957 957
query58 245 214 220 214
query59 2768 2667 2627 2627
query60 254 254 236 236
query61 101 82 82 82
query62 646 422 432 422
query63 168 160 158 158
query64 5739 1714 1747 1714
query65 3355 3279 3273 3273
query66 1372 339 328 328
query67 15515 15515 15269 15269
query68 11894 546 569 546
query69 561 279 282 279
query70 1686 1504 1609 1504
query71 508 228 218 218
query72 4960 2859 2861 2859
query73 2504 319 315 315
query74 7052 6392 6553 6392
query75 5256 2281 2299 2281
query76 6358 891 1060 891
query77 936 278 297 278
query78 9835 8701 8677 8677
query79 1033 500 514 500
query80 617 350 372 350
query81 446 208 223 208
query82 202 95 88 88
query83 178 136 134 134
query84 275 59 56 56
query85 1029 289 281 281
query86 383 349 378 349
query87 3576 3404 3392 3392
query88 3039 2237 2245 2237
query89 326 264 254 254
query90 2079 204 199 199
query91 165 133 139 133
query92 64 58 56 56
query93 1153 438 434 434
query94 811 190 192 190
query95 475 419 427 419
query96 625 321 318 318
query97 4300 4184 4190 4184
query98 206 192 187 187
query99 1000 749 723 723
Total cold run time: 296580 ms
Total hot run time: 178416 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886577847
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 09eb2efeace11fe1934151476f8ba1fc806ba647 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.7 seconds inserted 10000000 Rows, about 729K ops/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-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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886568243
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.51 seconds
stream load tsv: 557 seconds loaded 74807831229 Bytes, about 128 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: 21.4 seconds inserted 10000000 Rows, about 467K ops/s
storage size: 17188622613 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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886247935
<details>
<summary>ClickBench: <b>Total hot run time: 30.98 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 06188a475425cdcbbb323a1205a0996bdd6162bc, data reload: false
query1 0.06 0.06 0.05
query2 0.05 0.02 0.02
query3 0.25 0.11 0.10
query4 1.78 0.13 0.12
query5 0.53 0.52 0.52
query6 1.40 0.65 0.62
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.56 0.49 0.49
query10 0.55 0.55 0.55
query11 0.14 0.09 0.09
query12 0.12 0.10 0.09
query13 0.61 0.59 0.60
query14 0.76 0.80 0.80
query15 0.83 0.81 0.79
query16 0.34 0.35 0.35
query17 0.99 0.96 0.98
query18 0.26 0.25 0.26
query19 1.83 1.77 1.78
query20 0.01 0.02 0.02
query21 15.41 0.55 0.57
query22 2.64 2.38 2.19
query23 17.20 0.74 0.83
query24 7.36 0.77 0.85
query25 1.77 0.14 0.15
query26 0.13 0.13 0.14
query27 0.14 0.14 0.14
query28 9.15 0.81 0.80
query29 12.56 3.30 3.20
query30 0.57 0.48 0.45
query31 2.77 0.37 0.36
query32 3.38 0.49 0.49
query33 3.25 3.23 3.23
query34 15.78 4.20 4.13
query35 4.18 4.15 4.18
query36 1.11 1.07 1.04
query37 0.07 0.05 0.06
query38 0.03 0.03 0.03
query39 0.03 0.01 0.01
query40 0.17 0.13 0.13
query41 0.07 0.02 0.01
query42 0.03 0.01 0.02
query43 0.03 0.03 0.02
Total cold run time: 108.96 s
Total hot run time: 30.98 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886432447
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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886219144
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] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1886235445
<details>
<summary>TPC-H: <b>Total hot run time: 38944 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 06188a475425cdcbbb323a1205a0996bdd6162bc, data reload: false
------ Round 1 ----------------------------------
q1 17897 4955 4973 4955
q2 2052 145 139 139
q3 10860 1148 1175 1148
q4 10834 773 851 773
q5 8085 3302 3225 3225
q6 207 128 128 128
q7 931 521 524 521
q8 9450 1991 2006 1991
q9 8122 6595 6470 6470
q10 8260 3119 3084 3084
q11 418 211 214 211
q12 361 195 197 195
q13 18090 3433 3414 3414
q14 240 209 215 209
q15 561 526 517 517
q16 435 380 381 380
q17 940 515 538 515
q18 7441 6767 6708 6708
q19 1592 1370 1441 1370
q20 470 315 292 292
q21 2774 2401 2437 2401
q22 348 303 298 298
Total cold run time: 110368 ms
Total hot run time: 38944 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4986 4919 4917 4917
q2 334 201 203 201
q3 3348 3304 3340 3304
q4 2264 2371 2267 2267
q5 5802 5805 5820 5805
q6 193 119 119 119
q7 2319 1863 1895 1863
q8 3469 3550 3585 3550
q9 8961 8836 8866 8836
q10 3751 3811 3841 3811
q11 545 417 442 417
q12 782 612 601 601
q13 3880 3262 3218 3218
q14 286 265 264 264
q15 576 513 505 505
q16 513 463 450 450
q17 2039 2045 2011 2011
q18 8871 8394 8387 8387
q19 1608 1599 1571 1571
q20 2180 1931 1922 1922
q21 6029 5655 5708 5655
q22 583 449 477 449
Total cold run time: 63319 ms
Total hot run time: 60123 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](auth)Not allowed to operate internal_schema database [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29790:
URL: https://github.com/apache/doris/pull/29790#issuecomment-1888437283
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