You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "LuGuangming (via GitHub)" <gi...@apache.org> on 2024/01/20 12:12:46 UTC
[PR] [Fix][Enhancement] When build fe, support user custom defined privite… [doris]
LuGuangming opened a new pull request, #30169:
URL: https://github.com/apache/doris/pull/30169
… settings.xml
## Proposed changes
Issue Number: close #30168
<!--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][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30169:
URL: https://github.com/apache/doris/pull/30169#issuecomment-1902087136
<details>
<summary>ClickBench: <b>Total hot run time: 31.06 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 cd825718cd91e0713f9963b741995ec952837b46, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.24 0.05 0.04
query4 1.83 0.07 0.07
query5 0.52 0.52 0.52
query6 1.24 0.62 0.61
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.51 0.47 0.49
query10 0.53 0.54 0.53
query11 0.11 0.09 0.08
query12 0.12 0.10 0.09
query13 0.62 0.61 0.62
query14 0.80 0.79 0.79
query15 0.77 0.76 0.76
query16 0.36 0.37 0.37
query17 0.98 1.00 1.00
query18 0.22 0.28 0.23
query19 1.90 1.84 1.82
query20 0.01 0.01 0.01
query21 15.49 0.57 0.56
query22 1.87 2.31 1.57
query23 17.16 1.03 1.09
query24 8.73 1.58 1.06
query25 2.33 0.16 0.15
query26 0.16 0.13 0.15
query27 0.15 0.16 0.15
query28 4.63 0.73 0.75
query29 12.62 2.33 2.30
query30 0.56 0.52 0.54
query31 2.82 0.40 0.38
query32 3.41 0.50 0.49
query33 3.08 3.10 3.06
query34 15.28 4.80 4.79
query35 4.87 4.83 4.81
query36 1.05 1.02 1.03
query37 0.06 0.05 0.05
query38 0.04 0.02 0.02
query39 0.02 0.01 0.01
query40 0.15 0.13 0.14
query41 0.06 0.01 0.02
query42 0.02 0.01 0.01
query43 0.02 0.02 0.01
Total cold run time: 105.48 s
Total hot run time: 31.06 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] [Fix][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "LuGuangming (via GitHub)" <gi...@apache.org>.
LuGuangming commented on PR #30169:
URL: https://github.com/apache/doris/pull/30169#issuecomment-1902079293
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][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30169:
URL: https://github.com/apache/doris/pull/30169#issuecomment-1902087758
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit cd825718cd91e0713f9963b741995ec952837b46 with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 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: 21.3 seconds inserted 10000000 Rows, about 469K 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] [Fix][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #30169:
URL: https://github.com/apache/doris/pull/30169
--
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][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30169:
URL: https://github.com/apache/doris/pull/30169#issuecomment-1902083469
<details>
<summary>TPC-H: <b>Total hot run time: 49922 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 cd825718cd91e0713f9963b741995ec952837b46, data reload: false
------ Round 1 ----------------------------------
q1 17952 4380 4313 4313
q2 2025 145 139 139
q3 10290 1920 1868 1868
q4 10332 1267 1290 1267
q5 8403 3954 3902 3902
q6 226 124 122 122
q7 2007 1589 1625 1589
q8 9509 2695 2685 2685
q9 10554 10635 10460 10460
q10 8630 3491 3451 3451
q11 419 243 241 241
q12 453 291 307 291
q13 18330 3977 4029 3977
q14 355 330 316 316
q15 500 448 467 448
q16 680 592 596 592
q17 1128 948 948 948
q18 7340 6958 7052 6958
q19 1667 1565 1542 1542
q20 521 323 317 317
q21 4453 4126 4106 4106
q22 521 405 390 390
Total cold run time: 116295 ms
Total hot run time: 49922 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4375 4387 4409 4387
q2 324 220 229 220
q3 4232 4186 4201 4186
q4 2778 2751 2769 2751
q5 7344 7273 7194 7194
q6 242 120 118 118
q7 3309 2822 2860 2822
q8 4423 4696 4674 4674
q9 17241 17349 17107 17107
q10 4251 4306 4296 4296
q11 790 682 703 682
q12 1017 835 841 835
q13 7861 3752 3745 3745
q14 441 431 427 427
q15 498 453 450 450
q16 747 707 700 700
q17 3857 3904 3839 3839
q18 8747 8744 8838 8744
q19 1719 1702 1651 1651
q20 2394 2179 2137 2137
q21 8534 8572 8685 8572
q22 1023 955 971 955
Total cold run time: 86147 ms
Total hot run time: 80492 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] [Fix][Enhancement] When build fe, support user custom defined privite… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30169:
URL: https://github.com/apache/doris/pull/30169#issuecomment-1902086111
<details>
<summary>TPC-DS: <b>Total hot run time: 237102 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 cd825718cd91e0713f9963b741995ec952837b46, data reload: false
query1 910 389 389 389
query2 6535 2034 2096 2034
query3 6922 200 196 196
query4 19917 18000 17871 17871
query5 19745 6312 6321 6312
query6 289 210 224 210
query7 4152 300 304 300
query8 256 266 237 237
query9 3120 2674 2622 2622
query10 430 295 302 295
query11 11162 10737 10609 10609
query12 129 68 71 68
query13 5658 663 635 635
query14 17758 13367 13485 13367
query15 387 244 225 225
query16 6458 271 260 260
query17 3202 886 887 886
query18 2251 401 398 398
query19 205 147 149 147
query20 79 78 72 72
query21 184 97 98 97
query22 5317 4899 4998 4899
query23 32380 31941 31968 31941
query24 6885 6452 6468 6452
query25 535 427 429 427
query26 501 161 159 159
query27 1783 307 304 304
query28 6063 2248 2218 2218
query29 2905 2753 2851 2753
query30 241 175 165 165
query31 891 730 732 730
query32 63 58 61 58
query33 393 245 260 245
query34 846 469 469 469
query35 1137 929 933 929
query36 1475 1558 1439 1439
query37 88 60 58 58
query38 3066 2903 2924 2903
query39 1364 1316 1317 1316
query40 211 100 100 100
query41 34 32 31 31
query42 87 84 80 80
query43 630 580 587 580
query44 1131 716 707 707
query45 239 229 227 227
query46 1232 975 948 948
query47 2031 1772 2004 1772
query48 973 665 653 653
query49 608 367 379 367
query50 857 597 601 597
query51 5689 5509 5513 5509
query52 91 86 75 75
query53 443 320 312 312
query54 2425 2259 2242 2242
query55 86 76 83 76
query56 225 207 200 200
query57 1187 1103 1222 1103
query58 200 189 201 189
query59 3435 3462 3297 3297
query60 202 189 221 189
query61 90 85 89 85
query62 732 473 520 473
query63 470 342 335 335
query64 1994 1304 1247 1247
query65 3682 3627 3628 3627
query66 828 385 364 364
query67 15663 15345 15334 15334
query68 6274 640 648 640
query69 548 349 343 343
query70 1843 1828 1649 1649
query71 373 303 319 303
query72 4420 3492 3374 3374
query73 712 316 314 314
query74 6275 5802 5923 5802
query75 4339 3474 3507 3474
query76 4099 1190 1169 1169
query77 535 245 250 245
query78 30895 52913 46678 46678
query79 15611 655 631 631
query80 5050 389 384 384
query81 560 230 230 230
query82 1096 110 93 93
query83 405 139 133 133
query84 281 69 67 67
query85 2604 279 275 275
query86 465 366 379 366
query87 3250 3042 2986 2986
query88 6767 2321 2310 2310
query89 426 282 307 282
query90 2507 206 210 206
query91 159 116 116 116
query92 68 51 52 51
query93 5958 557 581 557
query94 1818 208 206 206
query95 1117 1079 1065 1065
query96 659 323 325 323
query97 6491 6393 6448 6393
query98 189 185 167 167
query99 3873 856 981 856
Total cold run time: 340824 ms
Total hot run time: 237102 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