You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zzzxl1993 (via GitHub)" <gi...@apache.org> on 2024/02/01 10:08:50 UTC
[PR] [fix](chinese) fix the issue where the be crashes due to the missing … [doris]
zzzxl1993 opened a new pull request, #30712:
URL: https://github.com/apache/doris/pull/30712
…chinese dict
## 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921124876
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 9ae610053728702e33742354f2a976e5c850cf7c with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.4 seconds inserted 10000000 Rows, about 746K 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921316056
<details>
<summary>TPC-DS: <b>Total hot run time: 174493 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
query1 931 337 329 329
query2 6560 1901 1889 1889
query3 6698 213 206 206
query4 31782 21952 22020 21952
query5 4447 352 337 337
query6 250 153 151 151
query7 4628 262 264 262
query8 263 188 175 175
query9 8929 2260 2249 2249
query10 403 199 205 199
query11 18305 15334 15321 15321
query12 118 66 65 65
query13 1628 380 369 369
query14 9989 6953 6932 6932
query15 217 171 178 171
query16 7189 286 253 253
query17 1815 490 453 453
query18 1927 252 249 249
query19 171 130 130 130
query20 73 68 69 68
query21 188 133 122 122
query22 5016 4797 4805 4797
query23 31146 30302 30248 30248
query24 10154 2723 2749 2723
query25 533 311 303 303
query26 744 139 137 137
query27 2275 286 288 286
query28 5637 1862 1852 1852
query29 916 612 624 612
query30 280 129 133 129
query31 925 694 705 694
query32 94 55 48 48
query33 536 212 202 202
query34 840 451 466 451
query35 868 728 746 728
query36 1198 1190 1202 1190
query37 94 57 57 57
query38 3290 3156 3146 3146
query39 1290 1244 1231 1231
query40 193 87 81 81
query41 37 36 34 34
query42 87 85 81 81
query43 486 471 491 471
query44 1103 691 692 691
query45 193 187 170 170
query46 1055 625 637 625
query47 1584 1524 1512 1512
query48 381 314 312 312
query49 1119 277 281 277
query50 695 315 308 308
query51 5326 5100 5126 5100
query52 86 83 87 83
query53 324 247 258 247
query54 232 178 190 178
query55 80 79 76 76
query56 179 157 155 155
query57 957 909 895 895
query58 180 151 148 148
query59 2405 2242 2327 2242
query60 201 174 167 167
query61 92 82 84 82
query62 601 348 341 341
query63 269 245 263 245
query64 4651 3656 3499 3499
query65 3244 3212 3225 3212
query66 948 306 307 306
query67 14646 14166 14124 14124
query68 3930 507 510 507
query69 434 296 290 290
query70 1527 1540 1477 1477
query71 305 215 208 208
query72 5514 3070 2803 2803
query73 689 319 321 319
query74 6553 6204 6295 6204
query75 2951 2288 2257 2257
query76 2525 922 943 922
query77 363 230 238 230
query78 9176 8763 8478 8478
query79 3193 521 504 504
query80 2156 319 315 315
query81 512 191 191 191
query82 806 87 77 77
query83 245 115 119 115
query84 287 70 74 70
query85 2015 336 351 336
query86 517 356 368 356
query87 3484 3235 3211 3211
query88 4167 2254 2239 2239
query89 434 358 345 345
query90 1935 192 185 185
query91 142 115 118 115
query92 56 43 40 40
query93 4996 433 457 433
query94 1226 155 162 155
query95 509 454 449 449
query96 655 320 325 320
query97 4216 4122 4105 4105
query98 202 183 192 183
query99 1140 676 679 676
Total cold run time: 280561 ms
Total hot run time: 174493 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "qidaye (via GitHub)" <gi...@apache.org>.
qidaye merged PR #30712:
URL: https://github.com/apache/doris/pull/30712
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923688945
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 2cfa99d0f86f09b0b01916f98a79fdab5e784b25 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.0 seconds inserted 10000000 Rows, about 769K 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1920963547
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921118850
<details>
<summary>ClickBench: <b>Total hot run time: 30.11 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
query1 0.04 0.03 0.02
query2 0.06 0.02 0.02
query3 0.23 0.06 0.07
query4 1.68 0.10 0.10
query5 0.52 0.52 0.52
query6 1.23 0.64 0.67
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.49 0.50
query10 0.55 0.55 0.56
query11 0.12 0.08 0.08
query12 0.11 0.10 0.09
query13 0.60 0.61 0.60
query14 0.79 0.79 0.81
query15 0.78 0.77 0.77
query16 0.39 0.37 0.38
query17 1.03 1.00 1.02
query18 0.22 0.23 0.21
query19 1.86 1.82 1.79
query20 0.01 0.01 0.01
query21 15.40 0.57 0.55
query22 2.67 2.05 1.31
query23 17.71 1.14 0.73
query24 2.65 1.22 0.71
query25 0.34 0.28 0.11
query26 0.44 0.14 0.14
query27 0.05 0.04 0.06
query28 12.05 0.83 0.85
query29 12.53 3.21 3.28
query30 0.62 0.52 0.51
query31 2.78 0.34 0.35
query32 3.39 0.49 0.48
query33 3.23 3.19 3.22
query34 15.89 4.31 4.26
query35 4.36 4.24 4.25
query36 1.11 1.05 1.06
query37 0.07 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.46 s
Total hot run time: 30.11 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921325672
<details>
<summary>ClickBench: <b>Total hot run time: 30.13 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.03 0.02
query3 0.23 0.06 0.06
query4 1.68 0.09 0.10
query5 0.52 0.51 0.51
query6 1.18 0.65 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.49 0.51
query10 0.55 0.54 0.55
query11 0.11 0.09 0.08
query12 0.11 0.08 0.10
query13 0.59 0.61 0.60
query14 0.77 0.79 0.80
query15 0.78 0.77 0.77
query16 0.37 0.39 0.37
query17 1.00 1.01 1.02
query18 0.21 0.29 0.22
query19 1.88 1.75 1.76
query20 0.01 0.00 0.01
query21 15.42 0.60 0.57
query22 2.39 2.81 1.37
query23 17.29 0.88 0.74
query24 2.44 1.17 0.63
query25 0.31 0.15 0.18
query26 0.48 0.13 0.14
query27 0.06 0.05 0.06
query28 12.29 0.86 0.86
query29 12.51 3.13 3.18
query30 0.62 0.54 0.49
query31 2.79 0.35 0.36
query32 3.35 0.48 0.48
query33 3.25 3.22 3.20
query34 15.97 4.32 4.31
query35 4.32 4.31 4.27
query36 1.08 1.05 1.05
query37 0.06 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.01 0.02
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.66 s
Total hot run time: 30.13 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923563608
clang-tidy review says "All clean, LGTM! :+1:"
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923660229
<details>
<summary>TPC-H: <b>Total hot run time: 36954 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 2cfa99d0f86f09b0b01916f98a79fdab5e784b25, data reload: false
------ Round 1 ----------------------------------
q1 17662 4563 4470 4470
q2 2041 142 136 136
q3 10595 927 903 903
q4 4646 722 702 702
q5 7682 2743 2774 2743
q6 183 120 118 118
q7 1160 732 723 723
q8 9277 2045 2037 2037
q9 7256 6395 6408 6395
q10 8116 2410 2435 2410
q11 424 219 209 209
q12 739 273 263 263
q13 18007 3303 3300 3300
q14 276 241 247 241
q15 529 490 484 484
q16 504 409 406 406
q17 925 544 518 518
q18 6869 6043 5853 5853
q19 1567 1405 1340 1340
q20 597 337 318 318
q21 6941 3085 3100 3085
q22 806 302 300 300
Total cold run time: 106802 ms
Total hot run time: 36954 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4450 4433 4455 4433
q2 326 225 216 216
q3 2971 2870 2799 2799
q4 1876 1600 1631 1600
q5 5189 5211 5173 5173
q6 195 112 113 112
q7 2105 1707 1742 1707
q8 3069 3274 3258 3258
q9 8278 8357 8248 8248
q10 5898 3562 3557 3557
q11 552 462 469 462
q12 740 583 584 583
q13 13003 3088 3073 3073
q14 279 245 266 245
q15 531 484 492 484
q16 523 469 467 467
q17 1820 1679 1757 1679
q18 7992 7748 7582 7582
q19 6667 1532 1533 1532
q20 2139 1908 1901 1901
q21 4949 4603 4524 4524
q22 545 512 471 471
Total cold run time: 74097 ms
Total hot run time: 54106 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921113763
TeamCity be ut coverage result:
Function Coverage: 36.17% (8625/23846)
Line Coverage: 28.23% (70491/249716)
Region Coverage: 27.23% (36387/133613)
Branch Coverage: 24.03% (18641/77584)
Coverage Report: http://coverage.selectdb-in.cc/coverage/9ae610053728702e33742354f2a976e5c850cf7c_9ae610053728702e33742354f2a976e5c850cf7c/report/index.html
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921295292
<details>
<summary>TPC-H: <b>Total hot run time: 36795 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
------ Round 1 ----------------------------------
q1 17633 4926 4438 4438
q2 2050 142 132 132
q3 10600 897 891 891
q4 4676 697 788 697
q5 7701 2730 2884 2730
q6 182 120 121 120
q7 1135 723 712 712
q8 9276 1995 2022 1995
q9 7252 6335 6307 6307
q10 8103 2414 2442 2414
q11 410 199 202 199
q12 795 282 278 278
q13 17998 3309 3288 3288
q14 279 251 258 251
q15 527 494 503 494
q16 467 408 389 389
q17 937 552 499 499
q18 6804 6006 5863 5863
q19 1582 1493 1384 1384
q20 581 329 322 322
q21 6899 3105 3124 3105
q22 815 290 287 287
Total cold run time: 106702 ms
Total hot run time: 36795 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4454 4326 4388 4326
q2 328 234 240 234
q3 3003 2869 2789 2789
q4 1879 1713 1598 1598
q5 5135 5230 5211 5211
q6 191 114 115 114
q7 2151 1762 1769 1762
q8 3114 3216 3303 3216
q9 8389 8293 8326 8293
q10 5751 3612 3530 3530
q11 532 442 462 442
q12 727 576 550 550
q13 12815 3085 3059 3059
q14 287 251 256 251
q15 538 484 485 484
q16 519 464 469 464
q17 1851 1669 1680 1669
q18 7883 7742 7476 7476
q19 6394 1542 1542 1542
q20 2128 1918 1882 1882
q21 4751 4716 4594 4594
q22 572 456 448 448
Total cold run time: 73392 ms
Total hot run time: 53934 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923677063
<details>
<summary>TPC-DS: <b>Total hot run time: 174602 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 2cfa99d0f86f09b0b01916f98a79fdab5e784b25, data reload: false
query1 919 348 329 329
query2 6564 2025 1983 1983
query3 6692 214 212 212
query4 31684 22010 21991 21991
query5 4255 356 356 356
query6 256 164 171 164
query7 4594 284 286 284
query8 238 167 173 167
query9 9106 2263 2253 2253
query10 403 217 232 217
query11 18326 15262 15429 15262
query12 128 80 75 75
query13 1614 406 414 406
query14 9172 6743 6996 6743
query15 239 177 180 177
query16 8156 269 247 247
query17 2010 533 498 498
query18 2118 263 256 256
query19 365 136 138 136
query20 83 77 74 74
query21 199 120 119 119
query22 5097 4923 4993 4923
query23 30839 30053 29929 29929
query24 10862 2726 2736 2726
query25 538 343 339 339
query26 709 145 148 145
query27 2181 297 301 297
query28 5752 1836 1824 1824
query29 868 606 585 585
query30 276 131 139 131
query31 929 675 715 675
query32 92 52 49 49
query33 732 227 218 218
query34 1050 451 454 451
query35 919 752 761 752
query36 1081 949 968 949
query37 102 57 59 57
query38 3270 3130 3118 3118
query39 1309 1264 1249 1249
query40 185 94 89 89
query41 39 35 34 34
query42 103 89 92 89
query43 532 526 520 520
query44 1086 672 691 672
query45 189 180 177 177
query46 1066 663 658 658
query47 1585 1524 1514 1514
query48 426 348 356 348
query49 1042 281 293 281
query50 764 359 355 355
query51 5186 5123 5198 5123
query52 108 93 94 93
query53 348 259 270 259
query54 273 212 220 212
query55 78 80 79 79
query56 225 198 202 198
query57 957 875 981 875
query58 208 176 176 176
query59 2646 2388 2453 2388
query60 228 218 213 213
query61 83 84 83 83
query62 643 348 344 344
query63 294 262 258 258
query64 4865 3543 3482 3482
query65 3258 3214 3196 3196
query66 832 305 301 301
query67 14580 14246 14308 14246
query68 4273 507 520 507
query69 448 320 317 317
query70 1264 1258 1251 1251
query71 338 250 258 250
query72 6033 2832 2659 2659
query73 705 322 318 318
query74 6607 6237 6245 6237
query75 3012 2365 2333 2333
query76 2586 959 936 936
query77 357 231 225 225
query78 9174 8592 8645 8592
query79 2094 508 513 508
query80 1302 356 346 346
query81 536 199 190 190
query82 751 76 78 76
query83 227 126 126 126
query84 228 76 83 76
query85 2068 344 322 322
query86 494 285 303 285
query87 3363 3177 3255 3177
query88 3834 2323 2328 2323
query89 445 370 346 346
query90 2021 162 166 162
query91 151 124 120 120
query92 55 47 40 40
query93 2257 502 476 476
query94 1256 177 168 168
query95 470 370 7862 370
query96 583 269 272 269
query97 4222 4119 4111 4111
query98 213 199 198 198
query99 1094 659 693 659
Total cold run time: 278017 ms
Total hot run time: 174602 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923684507
<details>
<summary>ClickBench: <b>Total hot run time: 30.17 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 2cfa99d0f86f09b0b01916f98a79fdab5e784b25, data reload: false
query1 0.04 0.03 0.03
query2 0.05 0.02 0.02
query3 0.22 0.06 0.06
query4 1.67 0.10 0.10
query5 0.53 0.51 0.51
query6 1.18 0.63 0.63
query7 0.02 0.02 0.01
query8 0.04 0.02 0.02
query9 0.54 0.48 0.51
query10 0.56 0.56 0.54
query11 0.11 0.08 0.09
query12 0.11 0.09 0.09
query13 0.60 0.61 0.60
query14 0.80 0.81 0.78
query15 0.80 0.79 0.77
query16 0.39 0.39 0.39
query17 1.05 1.04 1.05
query18 0.22 0.24 0.26
query19 1.85 1.78 1.80
query20 0.01 0.01 0.01
query21 15.40 0.59 0.57
query22 2.58 1.97 1.88
query23 17.35 0.85 0.69
query24 2.94 1.16 0.21
query25 0.29 0.12 0.13
query26 0.55 0.13 0.14
query27 0.04 0.05 0.05
query28 12.05 0.82 0.83
query29 12.48 3.11 3.16
query30 0.70 0.55 0.55
query31 2.80 0.35 0.35
query32 3.41 0.47 0.48
query33 3.22 3.20 3.23
query34 15.77 4.27 4.36
query35 4.30 4.31 4.26
query36 1.12 1.06 1.04
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.12
query41 0.07 0.02 0.02
query42 0.03 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 106.2 s
Total hot run time: 30.17 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921106441
<details>
<summary>TPC-DS: <b>Total hot run time: 175978 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
query1 933 345 326 326
query2 6557 1903 1804 1804
query3 6696 210 203 203
query4 32208 22063 22359 22063
query5 4449 352 349 349
query6 244 158 162 158
query7 4619 264 262 262
query8 231 176 172 172
query9 9182 2271 2234 2234
query10 413 206 206 206
query11 16023 15383 15412 15383
query12 119 66 63 63
query13 1610 378 382 378
query14 9639 7507 7348 7348
query15 232 176 180 176
query16 7333 273 250 250
query17 1873 495 460 460
query18 1925 262 245 245
query19 199 138 136 136
query20 71 73 70 70
query21 204 137 127 127
query22 4965 4906 4835 4835
query23 31306 30437 30482 30437
query24 11726 2755 2731 2731
query25 504 310 304 304
query26 1563 136 132 132
query27 2393 282 280 280
query28 6897 1851 1839 1839
query29 1494 629 622 622
query30 284 132 139 132
query31 939 702 726 702
query32 88 62 49 49
query33 715 213 208 208
query34 1103 463 471 463
query35 865 751 767 751
query36 1306 1178 1232 1178
query37 176 61 59 59
query38 3310 3176 3177 3176
query39 1334 1268 1246 1246
query40 331 83 79 79
query41 36 35 35 35
query42 91 84 79 79
query43 537 502 481 481
query44 1189 681 700 681
query45 191 184 182 182
query46 1034 632 630 630
query47 1577 1521 1562 1521
query48 401 340 300 300
query49 1246 291 286 286
query50 674 306 311 306
query51 5298 5156 5228 5156
query52 89 86 76 76
query53 331 253 261 253
query54 259 175 185 175
query55 81 77 78 77
query56 186 162 155 155
query57 1017 857 922 857
query58 189 152 155 152
query59 2557 2431 2271 2271
query60 201 178 178 178
query61 92 85 83 83
query62 654 364 366 364
query63 278 252 272 252
query64 6396 3624 3529 3529
query65 3243 3254 3218 3218
query66 1394 317 312 312
query67 14609 14145 14288 14145
query68 3810 511 516 511
query69 437 296 314 296
query70 1536 1546 1568 1546
query71 296 221 230 221
query72 5259 3104 2890 2890
query73 696 328 324 324
query74 6621 6231 6296 6231
query75 2962 2348 2282 2282
query76 2495 926 952 926
query77 445 227 226 226
query78 9048 8657 8628 8628
query79 2510 487 505 487
query80 2095 320 320 320
query81 524 198 198 198
query82 686 83 77 77
query83 253 125 116 116
query84 277 74 77 74
query85 2525 335 325 325
query86 511 419 375 375
query87 3465 3261 3275 3261
query88 3975 2239 2243 2239
query89 434 366 356 356
query90 2092 186 185 185
query91 153 118 114 114
query92 54 42 42 42
query93 2713 436 451 436
query94 1472 156 156 156
query95 498 458 437 437
query96 638 324 331 324
query97 4260 4099 4143 4099
query98 208 185 197 185
query99 1091 701 717 701
Total cold run time: 283948 ms
Total hot run time: 175978 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921177520
run performance
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1920974243
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921087219
<details>
<summary>TPC-H: <b>Total hot run time: 37117 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 9ae610053728702e33742354f2a976e5c850cf7c, data reload: false
------ Round 1 ----------------------------------
q1 17926 7937 4559 4559
q2 2051 144 135 135
q3 10696 930 913 913
q4 4735 768 724 724
q5 7684 2805 2808 2805
q6 183 120 118 118
q7 1131 728 715 715
q8 9368 2044 2019 2019
q9 7290 6367 6354 6354
q10 8151 2479 2444 2444
q11 414 214 204 204
q12 691 292 285 285
q13 18011 3313 3278 3278
q14 276 248 237 237
q15 518 502 483 483
q16 471 425 403 403
q17 945 565 539 539
q18 6492 6025 5986 5986
q19 1594 1402 1223 1223
q20 593 352 341 341
q21 6701 3070 3054 3054
q22 796 305 298 298
Total cold run time: 106717 ms
Total hot run time: 37117 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4418 4456 4419 4419
q2 324 243 238 238
q3 2998 2849 2809 2809
q4 1822 1625 1671 1625
q5 5188 5318 5254 5254
q6 198 115 117 115
q7 2120 1800 1725 1725
q8 3100 3263 3289 3263
q9 8377 8315 8297 8297
q10 6079 3619 3600 3600
q11 535 461 452 452
q12 736 570 598 570
q13 3736 3134 3091 3091
q14 279 255 259 255
q15 548 491 493 491
q16 527 471 484 471
q17 1849 1709 1750 1709
q18 7978 7878 7550 7550
q19 9159 1587 1556 1556
q20 2130 1912 1886 1886
q21 4844 4651 4601 4601
q22 581 463 452 452
Total cold run time: 67526 ms
Total hot run time: 54429 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1921332219
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 9ae610053728702e33742354f2a976e5c850cf7c 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.2 seconds inserted 10000000 Rows, about 704K 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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923704983
TeamCity be ut coverage result:
Function Coverage: 36.16% (8626/23856)
Line Coverage: 28.22% (70532/249944)
Region Coverage: 27.24% (36403/133660)
Branch Coverage: 24.02% (18644/77610)
Coverage Report: http://coverage.selectdb-in.cc/coverage/2cfa99d0f86f09b0b01916f98a79fdab5e784b25_2cfa99d0f86f09b0b01916f98a79fdab5e784b25/report/index.html
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1920980769
clang-tidy review says "All clean, LGTM! :+1:"
--
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1923549491
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1920963834
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](chinese) fix the issue where the be crashes due to the missing … [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30712:
URL: https://github.com/apache/doris/pull/30712#issuecomment-1920974320
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