You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HappenLee (via GitHub)" <gi...@apache.org> on 2024/03/11 16:12:23 UTC
[PR] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
HappenLee opened a new pull request, #32078:
URL: https://github.com/apache/doris/pull/32078
## Proposed changes
<!--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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992900750
<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 6ae2c12a3668795a6e14430bfb8a4ae29007f8c1, data reload: false
query1 0.04 0.04 0.03
query2 0.05 0.03 0.03
query3 0.22 0.07 0.06
query4 1.68 0.09 0.10
query5 0.53 0.48 0.50
query6 1.20 0.63 0.63
query7 0.02 0.01 0.02
query8 0.03 0.03 0.03
query9 0.55 0.49 0.50
query10 0.55 0.55 0.54
query11 0.12 0.08 0.09
query12 0.11 0.10 0.09
query13 0.57 0.56 0.57
query14 0.76 0.74 0.75
query15 0.81 0.77 0.77
query16 0.39 0.38 0.40
query17 1.02 0.98 0.94
query18 0.20 0.24 0.23
query19 1.91 1.70 1.69
query20 0.02 0.01 0.01
query21 15.46 0.57 0.57
query22 2.42 1.78 2.05
query23 17.31 0.72 0.77
query24 3.63 2.31 1.51
query25 0.18 0.16 0.03
query26 0.75 0.13 0.12
query27 0.02 0.03 0.03
query28 9.85 0.87 0.84
query29 12.56 3.10 3.23
query30 0.63 0.62 0.59
query31 2.81 0.34 0.32
query32 3.43 0.44 0.44
query33 2.77 2.83 2.79
query34 16.18 4.29 4.25
query35 4.30 4.35 4.37
query36 1.09 1.01 1.02
query37 0.07 0.06 0.05
query38 0.04 0.04 0.04
query39 0.03 0.02 0.01
query40 0.17 0.14 0.14
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.02
Total cold run time: 104.62 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992852403
TeamCity be ut coverage result:
Function Coverage: 34.96% (8555/24468)
Line Coverage: 26.80% (69476/259275)
Region Coverage: 26.04% (36045/138420)
Branch Coverage: 23.00% (18414/80050)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6ae2c12a3668795a6e14430bfb8a4ae29007f8c1_6ae2c12a3668795a6e14430bfb8a4ae29007f8c1/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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1989027488
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 16ec24632ca471103e981c8f3bbcd0a612e42a33 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 17.4 seconds inserted 10000000 Rows, about 574K 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992860891
<details>
<summary>TPC-H: <b>Total hot run time: 36630 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 6ae2c12a3668795a6e14430bfb8a4ae29007f8c1, data reload: false
------ Round 1 ----------------------------------
q1 17686 4196 4090 4090
q2 2020 150 145 145
q3 10575 955 896 896
q4 4645 714 691 691
q5 7579 2761 2720 2720
q6 186 123 124 123
q7 1207 834 804 804
q8 9491 2015 2045 2015
q9 7300 6457 6479 6457
q10 8179 2500 2520 2500
q11 429 222 216 216
q12 770 313 289 289
q13 17980 2997 2960 2960
q14 288 247 260 247
q15 502 442 465 442
q16 504 391 406 391
q17 954 538 625 538
q18 6663 5882 5882 5882
q19 1566 1432 1364 1364
q20 538 284 273 273
q21 7348 3293 3317 3293
q22 800 300 294 294
Total cold run time: 107210 ms
Total hot run time: 36630 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4132 4091 4100 4091
q2 317 218 226 218
q3 2975 2835 2860 2835
q4 1841 1569 1558 1558
q5 5183 5239 5247 5239
q6 206 116 115 115
q7 2246 1860 1826 1826
q8 3167 3301 3297 3297
q9 8551 8508 8527 8508
q10 6115 3679 3618 3618
q11 532 442 442 442
q12 720 538 557 538
q13 12554 2885 2870 2870
q14 274 238 254 238
q15 490 456 430 430
q16 438 412 399 399
q17 1725 1452 1473 1452
q18 7634 7297 7018 7018
q19 5537 1514 1538 1514
q20 1913 1711 1716 1711
q21 4808 4724 4667 4667
q22 519 453 448 448
Total cold run time: 71877 ms
Total hot run time: 53032 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990659117
TeamCity be ut coverage result:
Function Coverage: 34.98% (8555/24457)
Line Coverage: 26.80% (69459/259144)
Region Coverage: 26.05% (36035/138356)
Branch Coverage: 23.00% (18402/80014)
Coverage Report: http://coverage.selectdb-in.cc/coverage/ceafcb8c301342a50649d5ef5974a013fc4a6cee_ceafcb8c301342a50649d5ef5974a013fc4a6cee/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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991587781
<details>
<summary>TPC-H: <b>Total hot run time: 37143 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
------ Round 1 ----------------------------------
q1 17612 4315 4338 4315
q2 2572 156 146 146
q3 11673 923 927 923
q4 5203 717 747 717
q5 7844 2831 2886 2831
q6 197 124 129 124
q7 1225 864 834 834
q8 9884 2094 2057 2057
q9 7385 6529 6482 6482
q10 8186 2535 2505 2505
q11 419 215 219 215
q12 755 299 296 296
q13 17954 3051 3015 3015
q14 270 244 254 244
q15 506 456 441 441
q16 464 392 407 392
q17 956 593 552 552
q18 6746 5917 5884 5884
q19 1559 1428 1476 1428
q20 543 300 287 287
q21 7418 3163 3187 3163
q22 790 300 292 292
Total cold run time: 110161 ms
Total hot run time: 37143 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4099 4110 4058 4058
q2 318 226 224 224
q3 3005 2787 2828 2787
q4 1842 1549 1542 1542
q5 5246 5220 5227 5220
q6 191 116 124 116
q7 2215 1827 1803 1803
q8 3157 3278 3274 3274
q9 8554 8526 8552 8526
q10 6107 3703 3688 3688
q11 536 444 440 440
q12 706 548 537 537
q13 9903 2866 2872 2866
q14 285 238 241 238
q15 486 441 449 441
q16 449 418 398 398
q17 1733 1486 1454 1454
q18 7585 7304 7048 7048
q19 5142 1507 1546 1507
q20 1935 1705 1714 1705
q21 4835 4790 4661 4661
q22 527 456 442 442
Total cold run time: 68856 ms
Total hot run time: 52975 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991621022
<details>
<summary>ClickBench: <b>Total hot run time: 30.78 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.23 0.06 0.06
query4 1.67 0.10 0.09
query5 0.49 0.48 0.47
query6 1.20 0.64 0.63
query7 0.01 0.01 0.02
query8 0.04 0.03 0.03
query9 0.54 0.48 0.49
query10 0.55 0.55 0.54
query11 0.12 0.09 0.10
query12 0.11 0.10 0.09
query13 0.58 0.57 0.57
query14 0.76 0.77 0.74
query15 0.79 0.78 0.79
query16 0.40 0.40 0.39
query17 0.94 0.99 0.98
query18 0.18 0.26 0.25
query19 1.80 1.67 1.69
query20 0.01 0.01 0.01
query21 15.40 0.58 0.57
query22 2.96 3.16 1.87
query23 17.16 0.86 0.69
query24 3.73 1.50 1.29
query25 0.10 0.19 0.10
query26 0.78 0.13 0.12
query27 0.03 0.02 0.02
query28 10.97 0.85 0.83
query29 12.68 3.28 3.25
query30 0.64 0.59 0.57
query31 2.81 0.34 0.34
query32 3.38 0.44 0.45
query33 2.79 2.82 2.86
query34 16.10 4.34 4.39
query35 4.34 4.32 4.34
query36 1.05 1.00 1.00
query37 0.07 0.06 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.17 0.13 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.88 s
Total hot run time: 30.78 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991610838
<details>
<summary>TPC-DS: <b>Total hot run time: 187236 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
query1 925 364 338 338
query2 7408 1994 1969 1969
query3 6713 212 205 205
query4 30910 20643 20597 20597
query5 4393 391 411 391
query6 267 176 179 176
query7 4616 293 292 292
query8 226 165 170 165
query9 9937 2292 2284 2284
query10 455 248 242 242
query11 14686 14154 14125 14125
query12 130 89 86 86
query13 1625 424 434 424
query14 10813 10489 10907 10489
query15 275 212 191 191
query16 8038 256 265 256
query17 1939 551 529 529
query18 2050 276 270 270
query19 217 165 148 148
query20 89 83 81 81
query21 192 128 123 123
query22 4629 4446 4393 4393
query23 31765 31109 31293 31109
query24 11501 2836 2813 2813
query25 648 385 387 385
query26 1830 153 150 150
query27 3129 364 358 358
query28 8064 1884 1892 1884
query29 1032 626 633 626
query30 316 149 149 149
query31 954 701 724 701
query32 100 61 54 54
query33 778 263 254 254
query34 1061 464 475 464
query35 858 588 606 588
query36 1009 865 856 856
query37 154 74 76 74
query38 3288 3194 3135 3135
query39 1454 1376 1420 1376
query40 285 113 112 112
query41 53 47 47 47
query42 99 116 95 95
query43 505 448 460 448
query44 1313 702 715 702
query45 267 243 267 243
query46 1079 706 689 689
query47 1665 1600 1605 1600
query48 470 365 366 365
query49 1218 343 341 341
query50 758 376 377 376
query51 6649 6627 6654 6627
query52 107 94 90 90
query53 341 283 275 275
query54 331 245 241 241
query55 82 88 79 79
query56 244 238 231 231
query57 1098 1009 1003 1003
query58 237 205 211 205
query59 2774 2752 2654 2654
query60 283 273 252 252
query61 124 114 113 113
query62 595 385 403 385
query63 298 276 270 270
query64 6810 4053 3890 3890
query65 3109 3026 2993 2993
query66 1402 337 331 331
query67 15058 14533 14320 14320
query68 9707 561 544 544
query69 665 395 386 386
query70 1388 1106 1115 1106
query71 516 279 276 276
query72 6931 2647 2490 2490
query73 1590 323 325 323
query74 8238 6618 6581 6581
query75 10241 8219 8194 8194
query76 5851 966 913 913
query77 669 255 245 245
query78 10256 9578 9590 9578
query79 10153 530 518 518
query80 2420 381 370 370
query81 485 212 210 210
query82 355 205 195 195
query83 244 139 135 135
query84 287 78 77 77
query85 1253 369 320 320
query86 351 310 301 301
query87 3456 3242 3216 3216
query88 4870 2340 2329 2329
query89 468 363 363 363
query90 2420 173 169 169
query91 178 128 126 126
query92 61 47 47 47
query93 5613 528 502 502
query94 1566 178 175 175
query95 446 330 321 321
query96 600 278 269 269
query97 4376 4260 4286 4260
query98 226 209 210 209
query99 940 765 761 761
Total cold run time: 322548 ms
Total hot run time: 187236 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991169329
<details>
<summary>ClickBench: <b>Total hot run time: 30.83 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.02 0.02
query3 0.23 0.07 0.06
query4 1.67 0.09 0.10
query5 0.51 0.50 0.51
query6 1.18 0.63 0.62
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.52 0.51 0.49
query10 0.55 0.54 0.54
query11 0.12 0.09 0.09
query12 0.10 0.09 0.09
query13 0.56 0.58 0.57
query14 0.74 0.75 0.76
query15 0.79 0.77 0.81
query16 0.37 0.38 0.37
query17 0.98 1.00 1.00
query18 0.21 0.25 0.23
query19 1.74 1.76 1.74
query20 0.02 0.01 0.01
query21 15.43 0.58 0.57
query22 2.48 1.70 1.65
query23 17.00 0.81 0.75
query24 3.28 1.52 2.32
query25 0.18 0.11 0.12
query26 0.81 0.13 0.13
query27 0.03 0.04 0.03
query28 10.31 0.90 0.85
query29 12.50 3.19 3.25
query30 0.64 0.59 0.53
query31 2.81 0.35 0.33
query32 3.40 0.43 0.44
query33 2.81 2.80 2.85
query34 15.99 4.35 4.32
query35 4.37 4.33 4.31
query36 1.07 1.01 1.02
query37 0.08 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.17 0.14 0.14
query41 0.07 0.02 0.01
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 104 s
Total hot run time: 30.83 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991122216
<details>
<summary>TPC-H: <b>Total hot run time: 37132 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
------ Round 1 ----------------------------------
q1 17998 4342 4216 4216
q2 2450 153 147 147
q3 11929 938 949 938
q4 4749 727 695 695
q5 7759 2900 2883 2883
q6 186 136 137 136
q7 1227 834 797 797
q8 9509 2085 2010 2010
q9 7335 6554 6469 6469
q10 8125 2542 2546 2542
q11 429 222 224 222
q12 789 304 308 304
q13 17972 2980 3016 2980
q14 268 252 244 244
q15 498 458 462 458
q16 483 396 394 394
q17 955 558 561 558
q18 6371 5935 5849 5849
q19 1574 1476 1481 1476
q20 543 276 283 276
q21 7398 3246 3289 3246
q22 843 292 307 292
Total cold run time: 109390 ms
Total hot run time: 37132 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4110 4063 4079 4063
q2 321 232 228 228
q3 3011 2811 2818 2811
q4 1896 1594 1508 1508
q5 5186 5236 5262 5236
q6 190 115 116 115
q7 2225 1821 1830 1821
q8 3150 3302 3272 3272
q9 8580 8564 8577 8564
q10 6384 3734 3652 3652
q11 525 440 445 440
q12 718 548 567 548
q13 3604 2857 2896 2857
q14 270 241 256 241
q15 496 454 456 454
q16 443 414 396 396
q17 1717 1491 1455 1455
q18 7647 7356 7041 7041
q19 1788 1504 1557 1504
q20 1889 1731 1744 1731
q21 4770 4771 4585 4585
q22 533 454 449 449
Total cold run time: 59453 ms
Total hot run time: 52971 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991151076
<details>
<summary>TPC-DS: <b>Total hot run time: 186896 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 072eb7f6d7497db23454ca6d8949bd8395ac7184, data reload: false
query1 911 347 351 347
query2 7412 1973 1966 1966
query3 6702 214 216 214
query4 31200 20960 20639 20639
query5 4387 494 422 422
query6 276 186 180 180
query7 4653 293 291 291
query8 232 165 170 165
query9 9953 2324 2280 2280
query10 451 265 231 231
query11 17221 14129 14182 14129
query12 129 84 84 84
query13 1635 439 422 422
query14 11133 10184 11014 10184
query15 270 221 205 205
query16 7862 265 260 260
query17 1945 565 532 532
query18 1726 294 290 290
query19 210 163 159 159
query20 92 88 85 85
query21 226 130 129 129
query22 4712 4629 4495 4495
query23 31834 31204 31176 31176
query24 11543 2807 2806 2806
query25 673 371 375 371
query26 1854 159 155 155
query27 3060 352 356 352
query28 8075 1935 1908 1908
query29 1035 671 635 635
query30 325 146 148 146
query31 937 721 711 711
query32 96 59 54 54
query33 773 265 255 255
query34 1086 476 467 467
query35 836 621 604 604
query36 1009 886 872 872
query37 173 78 76 76
query38 3286 3131 3163 3131
query39 1401 1386 1379 1379
query40 304 113 109 109
query41 52 47 49 47
query42 101 96 101 96
query43 504 458 463 458
query44 1124 726 696 696
query45 287 268 261 261
query46 1085 688 686 686
query47 1665 1631 1607 1607
query48 451 370 363 363
query49 1238 345 329 329
query50 770 384 400 384
query51 6654 6589 6568 6568
query52 116 90 87 87
query53 341 273 277 273
query54 327 246 236 236
query55 81 79 75 75
query56 277 242 246 242
query57 1112 1015 1009 1009
query58 230 207 201 201
query59 2799 2635 2485 2485
query60 266 248 259 248
query61 111 113 113 113
query62 609 428 410 410
query63 294 265 268 265
query64 6633 3898 3709 3709
query65 3091 3011 3013 3011
query66 1324 327 318 318
query67 15244 14580 14409 14409
query68 9120 546 542 542
query69 645 374 371 371
query70 1249 1189 1064 1064
query71 518 280 273 273
query72 6325 2682 2500 2500
query73 1531 329 324 324
query74 8438 6585 6544 6544
query75 9492 8091 8036 8036
query76 5319 965 906 906
query77 631 254 259 254
query78 10433 9868 9700 9700
query79 11191 536 516 516
query80 1876 374 397 374
query81 492 215 210 210
query82 495 200 202 200
query83 203 146 144 144
query84 282 77 75 75
query85 1382 321 313 313
query86 387 313 313 313
query87 3605 3236 3300 3236
query88 4711 2342 2361 2342
query89 497 361 371 361
query90 2012 175 186 175
query91 167 133 128 128
query92 54 47 46 46
query93 7053 511 493 493
query94 1251 173 175 173
query95 422 337 323 323
query96 608 271 269 269
query97 4423 4241 4295 4241
query98 239 214 203 203
query99 1069 789 745 745
Total cold run time: 324544 ms
Total hot run time: 186896 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 merged PR #32078:
URL: https://github.com/apache/doris/pull/32078
--
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990680889
<details>
<summary>TPC-DS: <b>Total hot run time: 186732 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 ceafcb8c301342a50649d5ef5974a013fc4a6cee, data reload: false
query1 924 363 340 340
query2 7405 2066 1969 1969
query3 6706 210 214 210
query4 31092 20664 20601 20601
query5 4369 410 558 410
query6 266 191 178 178
query7 4623 306 290 290
query8 235 179 174 174
query9 9906 2328 2277 2277
query10 451 233 234 233
query11 17217 14131 14089 14089
query12 129 92 83 83
query13 1651 421 413 413
query14 11825 10681 11080 10681
query15 252 211 203 203
query16 8090 260 266 260
query17 1954 557 532 532
query18 2114 289 273 273
query19 259 164 162 162
query20 88 82 81 81
query21 208 132 129 129
query22 4574 4430 4427 4427
query23 31758 31074 31221 31074
query24 10695 2794 2832 2794
query25 623 371 382 371
query26 1352 157 161 157
query27 2989 355 356 355
query28 8018 1914 1868 1868
query29 906 644 618 618
query30 325 149 149 149
query31 971 716 726 716
query32 94 57 56 56
query33 762 255 251 251
query34 1065 463 468 463
query35 825 610 608 608
query36 982 850 876 850
query37 126 77 78 77
query38 3260 3123 3201 3123
query39 1409 1410 1393 1393
query40 210 116 107 107
query41 51 46 49 46
query42 100 95 123 95
query43 506 442 451 442
query44 1292 688 694 688
query45 270 233 253 233
query46 1076 696 678 678
query47 1645 1588 1569 1569
query48 453 364 358 358
query49 1139 334 338 334
query50 747 381 386 381
query51 6732 6516 6627 6516
query52 103 109 91 91
query53 351 273 289 273
query54 302 243 287 243
query55 86 77 80 77
query56 252 238 236 236
query57 1076 1032 999 999
query58 233 222 203 203
query59 2932 2729 2642 2642
query60 292 261 254 254
query61 119 116 116 116
query62 611 399 419 399
query63 301 311 289 289
query64 6361 3967 3869 3869
query65 3121 3016 3012 3012
query66 1410 320 316 316
query67 14961 14260 14176 14176
query68 8752 526 527 526
query69 639 374 382 374
query70 1282 1168 1096 1096
query71 518 280 276 276
query72 6442 2656 2534 2534
query73 751 323 327 323
query74 6809 6559 6584 6559
query75 9611 7914 8205 7914
query76 5401 906 980 906
query77 657 257 257 257
query78 10377 9692 9622 9622
query79 9873 516 510 510
query80 1513 374 383 374
query81 500 221 206 206
query82 831 196 203 196
query83 217 143 133 133
query84 285 79 72 72
query85 1466 331 306 306
query86 423 314 297 297
query87 3455 3244 3196 3196
query88 4797 2331 2365 2331
query89 521 358 360 358
query90 2067 183 173 173
query91 166 129 130 129
query92 62 44 45 44
query93 6951 502 483 483
query94 1170 176 173 173
query95 430 329 324 324
query96 594 276 270 270
query97 4390 4257 4252 4252
query98 231 209 200 200
query99 1261 755 738 738
Total cold run time: 319672 ms
Total hot run time: 186732 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990720713
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ceafcb8c301342a50649d5ef5974a013fc4a6cee with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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: 16.3 seconds inserted 10000000 Rows, about 613K 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1988982542
<details>
<summary>TPC-H: <b>Total hot run time: 38322 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 16ec24632ca471103e981c8f3bbcd0a612e42a33, data reload: false
------ Round 1 ----------------------------------
q1 17671 4082 4073 4073
q2 2019 147 142 142
q3 10560 974 946 946
q4 4662 956 965 956
q5 7602 2879 3027 2879
q6 179 127 130 127
q7 1327 836 829 829
q8 9500 2064 2099 2064
q9 7419 6548 6486 6486
q10 8227 2597 2571 2571
q11 421 214 212 212
q12 769 322 309 309
q13 17962 2991 2974 2974
q14 287 258 272 258
q15 500 455 456 455
q16 468 401 407 401
q17 941 879 875 875
q18 6816 5998 5963 5963
q19 1574 1526 1523 1523
q20 559 311 287 287
q21 7524 3693 3714 3693
q22 796 302 299 299
Total cold run time: 107783 ms
Total hot run time: 38322 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4016 4005 3997 3997
q2 317 236 222 222
q3 2985 2952 2907 2907
q4 1858 1835 1805 1805
q5 5236 5278 5286 5278
q6 204 119 121 119
q7 2278 1858 1845 1845
q8 3206 3290 3281 3281
q9 8547 8554 8518 8518
q10 6122 3724 3727 3724
q11 526 426 432 426
q12 723 525 558 525
q13 13743 2825 2847 2825
q14 276 250 253 250
q15 483 456 453 453
q16 455 418 417 417
q17 1707 1647 1674 1647
q18 7881 7456 7434 7434
q19 1645 1612 1603 1603
q20 1878 1688 1723 1688
q21 4937 4794 4885 4794
q22 516 419 430 419
Total cold run time: 69539 ms
Total hot run time: 54177 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992751369
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991622770
TeamCity be ut coverage result:
Function Coverage: 34.96% (8555/24468)
Line Coverage: 26.80% (69477/259277)
Region Coverage: 26.04% (36045/138423)
Branch Coverage: 23.00% (18412/80050)
Coverage Report: http://coverage.selectdb-in.cc/coverage/072eb7f6d7497db23454ca6d8949bd8395ac7184_072eb7f6d7497db23454ca6d8949bd8395ac7184/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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1993153990
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991518149
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992907651
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 6ae2c12a3668795a6e14430bfb8a4ae29007f8c1 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: 15.5 seconds inserted 10000000 Rows, about 645K 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991179201
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 072eb7f6d7497db23454ca6d8949bd8395ac7184 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: 17.1 seconds inserted 10000000 Rows, about 584K 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991188147
TeamCity be ut coverage result:
Function Coverage: 34.98% (8554/24457)
Line Coverage: 26.80% (69457/259157)
Region Coverage: 26.04% (36035/138361)
Branch Coverage: 23.00% (18403/80020)
Coverage Report: http://coverage.selectdb-in.cc/coverage/072eb7f6d7497db23454ca6d8949bd8395ac7184_072eb7f6d7497db23454ca6d8949bd8395ac7184/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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990540222
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991047563
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1988964575
TeamCity be ut coverage result:
Function Coverage: 34.98% (8555/24457)
Line Coverage: 26.80% (69447/259139)
Region Coverage: 26.04% (36027/138348)
Branch Coverage: 23.00% (18399/80010)
Coverage Report: http://coverage.selectdb-in.cc/coverage/16ec24632ca471103e981c8f3bbcd0a612e42a33_16ec24632ca471103e981c8f3bbcd0a612e42a33/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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1991626985
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 072eb7f6d7497db23454ca6d8949bd8395ac7184 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 15.9 seconds inserted 10000000 Rows, about 628K 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1989010895
<details>
<summary>TPC-DS: <b>Total hot run time: 185788 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 16ec24632ca471103e981c8f3bbcd0a612e42a33, data reload: false
query1 927 361 341 341
query2 7387 2034 1933 1933
query3 6702 226 210 210
query4 23620 20871 20956 20871
query5 4355 2084 457 457
query6 266 180 174 174
query7 4611 322 308 308
query8 244 185 160 160
query9 8476 2259 2245 2245
query10 449 239 242 239
query11 14971 14604 14494 14494
query12 138 87 85 85
query13 1636 436 428 428
query14 10606 9513 9691 9513
query15 238 201 204 201
query16 7767 275 278 275
query17 1868 595 553 553
query18 1983 294 290 290
query19 201 161 161 161
query20 95 89 91 89
query21 195 129 127 127
query22 4572 4447 4432 4432
query23 31342 30907 30726 30726
query24 11272 3031 3018 3018
query25 665 391 395 391
query26 1292 161 172 161
query27 2884 361 353 353
query28 6495 1839 1824 1824
query29 1013 598 595 595
query30 308 151 150 150
query31 922 729 737 729
query32 101 60 58 58
query33 744 272 263 263
query34 1015 463 474 463
query35 852 629 621 621
query36 925 836 817 817
query37 154 76 79 76
query38 3230 3162 3199 3162
query39 1415 1360 1380 1360
query40 206 118 141 118
query41 66 66 62 62
query42 110 97 101 97
query43 451 416 413 413
query44 1085 713 710 710
query45 263 264 254 254
query46 1059 796 772 772
query47 1628 1547 1543 1543
query48 422 364 360 360
query49 1135 342 340 340
query50 779 383 390 383
query51 6861 6745 6642 6642
query52 104 105 96 96
query53 354 290 288 288
query54 310 237 253 237
query55 86 86 78 78
query56 237 220 241 220
query57 1076 984 1009 984
query58 256 218 215 215
query59 2566 2486 2339 2339
query60 269 258 287 258
query61 112 112 109 109
query62 622 403 401 401
query63 308 318 273 273
query64 5278 3385 3060 3060
query65 3078 3007 2979 2979
query66 973 315 311 311
query67 14831 14575 14192 14192
query68 9153 569 583 569
query69 634 404 394 394
query70 1286 1079 1072 1072
query71 521 280 276 276
query72 6409 2660 2538 2538
query73 1295 323 330 323
query74 6856 6567 6490 6490
query75 9579 8015 7994 7994
query76 5433 1078 1158 1078
query77 666 258 255 255
query78 10494 9693 9638 9638
query79 8735 530 533 530
query80 1591 450 383 383
query81 502 216 208 208
query82 552 199 198 198
query83 218 150 143 143
query84 288 78 81 78
query85 1312 337 334 334
query86 362 278 281 278
query87 3417 3228 3233 3228
query88 3774 2408 2397 2397
query89 548 378 374 374
query90 1992 180 175 175
query91 179 127 125 125
query92 59 52 52 52
query93 6550 547 536 536
query94 1197 190 192 190
query95 461 349 358 349
query96 603 263 266 263
query97 4391 4251 4279 4251
query98 226 214 213 213
query99 1225 769 795 769
Total cold run time: 300969 ms
Total hot run time: 185788 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990705910
<details>
<summary>ClickBench: <b>Total hot run time: 29.43 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 ceafcb8c301342a50649d5ef5974a013fc4a6cee, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.03
query3 0.23 0.06 0.06
query4 1.65 0.10 0.09
query5 0.50 0.50 0.49
query6 1.21 0.63 0.63
query7 0.02 0.01 0.01
query8 0.04 0.02 0.03
query9 0.56 0.49 0.49
query10 0.54 0.55 0.55
query11 0.12 0.09 0.10
query12 0.12 0.09 0.08
query13 0.57 0.58 0.56
query14 0.73 0.75 0.75
query15 0.79 0.79 0.77
query16 0.41 0.38 0.40
query17 1.05 1.04 0.98
query18 0.21 0.24 0.22
query19 1.77 1.74 1.70
query20 0.01 0.00 0.00
query21 15.41 0.57 0.55
query22 2.30 1.79 2.03
query23 17.08 0.78 0.71
query24 3.18 0.25 0.90
query25 0.06 0.07 0.03
query26 0.64 0.14 0.13
query27 0.03 0.02 0.04
query28 11.88 0.85 0.87
query29 12.51 3.18 3.15
query30 0.65 0.61 0.57
query31 2.80 0.35 0.32
query32 3.36 0.45 0.43
query33 2.83 2.78 2.80
query34 16.23 4.30 4.32
query35 4.30 4.35 4.33
query36 1.07 1.00 1.00
query37 0.07 0.06 0.05
query38 0.04 0.03 0.04
query39 0.03 0.02 0.02
query40 0.16 0.14 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.4 s
Total hot run time: 29.43 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1993153905
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1989021681
<details>
<summary>ClickBench: <b>Total hot run time: 30.48 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 16ec24632ca471103e981c8f3bbcd0a612e42a33, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.68 0.10 0.10
query5 0.52 0.52 0.49
query6 1.24 0.68 0.69
query7 0.02 0.02 0.02
query8 0.04 0.03 0.02
query9 0.56 0.51 0.52
query10 0.57 0.57 0.57
query11 0.14 0.10 0.10
query12 0.12 0.10 0.10
query13 0.57 0.57 0.57
query14 0.75 0.76 0.76
query15 0.82 0.81 0.82
query16 0.38 0.37 0.39
query17 0.99 1.00 1.00
query18 0.27 0.26 0.24
query19 1.83 1.69 1.72
query20 0.01 0.01 0.01
query21 15.41 0.62 0.62
query22 3.25 3.56 2.21
query23 17.40 1.03 0.91
query24 2.20 0.30 0.59
query25 0.25 0.09 0.05
query26 0.18 0.14 0.15
query27 0.04 0.03 0.03
query28 12.16 0.83 0.82
query29 12.71 3.32 3.20
query30 0.61 0.58 0.58
query31 2.80 0.35 0.35
query32 3.37 0.44 0.43
query33 2.82 2.82 2.84
query34 15.49 4.28 4.34
query35 4.28 4.29 4.33
query36 1.08 1.01 1.02
query37 0.07 0.05 0.06
query38 0.06 0.03 0.03
query39 0.03 0.02 0.02
query40 0.17 0.13 0.15
query41 0.07 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.02
Total cold run time: 105.35 s
Total hot run time: 30.48 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1988817227
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1988817450
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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1990622575
<details>
<summary>TPC-H: <b>Total hot run time: 36863 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 ceafcb8c301342a50649d5ef5974a013fc4a6cee, data reload: false
------ Round 1 ----------------------------------
q1 17763 4375 4234 4234
q2 3010 160 149 149
q3 11235 935 953 935
q4 5013 712 716 712
q5 8380 2818 2833 2818
q6 186 126 131 126
q7 1260 846 815 815
q8 9701 2062 2075 2062
q9 7366 6490 6370 6370
q10 8127 2464 2503 2464
q11 426 218 217 217
q12 788 302 293 293
q13 17956 3011 2998 2998
q14 277 245 259 245
q15 494 446 457 446
q16 465 409 389 389
q17 942 550 551 550
q18 6604 5910 5839 5839
q19 1575 1390 1465 1390
q20 546 280 283 280
q21 7362 3214 3263 3214
q22 792 345 317 317
Total cold run time: 110268 ms
Total hot run time: 36863 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4103 4083 4068 4068
q2 324 230 232 230
q3 2958 3005 2817 2817
q4 1850 1514 1569 1514
q5 5192 5215 5231 5215
q6 191 118 117 117
q7 2232 1821 1884 1821
q8 3172 3292 3293 3292
q9 8536 8547 8544 8544
q10 6128 3642 3620 3620
q11 532 436 439 436
q12 735 538 559 538
q13 6908 2865 2872 2865
q14 262 248 250 248
q15 480 440 437 437
q16 429 403 384 384
q17 1712 1477 1465 1465
q18 7809 7287 7147 7147
q19 4365 1483 1523 1483
q20 1901 1697 1714 1697
q21 4849 4856 4615 4615
q22 543 460 441 441
Total cold run time: 65211 ms
Total hot run time: 52994 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] [Opt](exec) use libbase64 to replace base64 code in doris [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32078:
URL: https://github.com/apache/doris/pull/32078#issuecomment-1992888789
<details>
<summary>TPC-DS: <b>Total hot run time: 187179 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 6ae2c12a3668795a6e14430bfb8a4ae29007f8c1, data reload: false
query1 922 364 351 351
query2 7364 2097 1977 1977
query3 6695 214 207 207
query4 31558 20576 20669 20576
query5 4399 382 488 382
query6 251 179 173 173
query7 4622 317 290 290
query8 229 182 173 173
query9 9883 2301 2297 2297
query10 446 225 229 225
query11 17334 14237 14108 14108
query12 130 116 80 80
query13 1636 428 420 420
query14 11301 11113 10575 10575
query15 255 210 194 194
query16 8052 266 263 263
query17 1936 584 539 539
query18 2098 293 279 279
query19 250 157 153 153
query20 93 88 80 80
query21 201 133 130 130
query22 4664 4502 4512 4502
query23 32088 31100 31306 31100
query24 10735 2851 2804 2804
query25 607 371 371 371
query26 1237 153 157 153
query27 3011 354 354 354
query28 8091 1873 1907 1873
query29 906 646 634 634
query30 309 159 155 155
query31 965 732 737 732
query32 101 59 54 54
query33 769 257 249 249
query34 1097 475 485 475
query35 825 613 613 613
query36 1027 880 893 880
query37 126 74 77 74
query38 3350 3133 3125 3125
query39 1435 1406 1371 1371
query40 210 114 107 107
query41 53 44 45 44
query42 99 92 91 91
query43 481 449 466 449
query44 1258 723 693 693
query45 273 247 248 247
query46 1070 682 669 669
query47 1686 1584 1608 1584
query48 429 357 360 357
query49 1127 324 332 324
query50 758 374 367 367
query51 6795 6798 6852 6798
query52 108 94 87 87
query53 330 276 273 273
query54 283 230 242 230
query55 86 82 83 82
query56 241 244 206 206
query57 1102 1001 1013 1001
query58 222 189 211 189
query59 2887 2696 2705 2696
query60 279 233 246 233
query61 106 110 107 107
query62 612 381 422 381
query63 304 274 277 274
query64 5641 3772 3807 3772
query65 3040 3040 3013 3013
query66 837 337 328 328
query67 14760 14387 14130 14130
query68 5372 537 522 522
query69 563 378 379 378
query70 1259 1215 1146 1146
query71 440 282 291 282
query72 6411 2800 2622 2622
query73 694 329 319 319
query74 7737 6558 6565 6558
query75 8743 8067 8114 8067
query76 3481 1027 938 938
query77 428 271 262 262
query78 10328 9626 9469 9469
query79 8262 524 534 524
query80 2210 457 397 397
query81 567 215 215 215
query82 1309 208 211 208
query83 283 153 148 148
query84 290 83 83 83
query85 1930 329 311 311
query86 493 280 290 280
query87 3511 3212 3223 3212
query88 5208 2385 2351 2351
query89 469 368 358 358
query90 2002 174 176 174
query91 159 127 129 127
query92 59 44 45 44
query93 5743 507 488 488
query94 1260 180 170 170
query95 435 327 321 321
query96 621 268 277 268
query97 4397 4251 4254 4251
query98 222 214 215 214
query99 1144 749 757 749
Total cold run time: 312105 ms
Total hot run time: 187179 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