You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/01/25 07:57:24 UTC
[PR] [chore](Nereids) enable nereids if update from doris 1.x [doris]
morrySnow opened a new pull request, #30369:
URL: https://github.com/apache/doris/pull/30369
## 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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #30369:
URL: https://github.com/apache/doris/pull/30369
--
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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1909631666
<details>
<summary>TPC-H: <b>Total hot run time: 38764 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 8b7e1c59b8342a56a748df6467bff6afb0c7e493, data reload: false
------ Round 1 ----------------------------------
q1 18246 5335 5362 5335
q2 2798 141 137 137
q3 11240 1172 1134 1134
q4 10226 796 851 796
q5 7711 3139 3155 3139
q6 206 119 117 117
q7 865 488 475 475
q8 9234 1912 1965 1912
q9 7276 6362 6347 6347
q10 8199 3006 3059 3006
q11 420 206 208 206
q12 356 190 193 190
q13 17980 3389 3392 3389
q14 243 211 222 211
q15 530 510 487 487
q16 429 370 375 370
q17 937 551 515 515
q18 7473 7008 6742 6742
q19 1549 1394 1319 1319
q20 561 313 280 280
q21 2771 2348 2413 2348
q22 342 313 309 309
Total cold run time: 109592 ms
Total hot run time: 38764 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5480 5269 5304 5269
q2 327 218 213 213
q3 3333 3219 3178 3178
q4 2068 2013 2033 2013
q5 5998 5881 6042 5881
q6 193 118 117 117
q7 2314 1901 1865 1865
q8 3215 3364 3393 3364
q9 8878 8814 8776 8776
q10 3936 3872 3829 3829
q11 573 442 466 442
q12 828 649 628 628
q13 16927 3201 3180 3180
q14 279 268 262 262
q15 553 515 510 510
q16 505 459 466 459
q17 2587 1843 1834 1834
q18 9588 11599 9553 9553
q19 24542 1597 1533 1533
q20 4576 1936 1930 1930
q21 15411 5401 5311 5311
q22 2556 537 581 537
Total cold run time: 114667 ms
Total hot run time: 60684 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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1909655538
<details>
<summary>ClickBench: <b>Total hot run time: 30.52 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 8b7e1c59b8342a56a748df6467bff6afb0c7e493, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.02 0.02
query3 0.22 0.05 0.05
query4 1.70 0.06 0.06
query5 0.54 0.52 0.52
query6 1.29 0.65 0.63
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.54 0.49 0.49
query10 0.56 0.56 0.55
query11 0.12 0.09 0.09
query12 0.12 0.09 0.09
query13 0.62 0.61 0.60
query14 0.78 0.82 0.78
query15 0.80 0.77 0.79
query16 0.36 0.38 0.39
query17 0.99 0.99 1.02
query18 0.23 0.27 0.24
query19 1.86 1.72 1.81
query20 0.01 0.01 0.01
query21 15.42 0.57 0.58
query22 2.91 2.44 2.04
query23 17.20 0.88 0.74
query24 2.58 1.14 0.53
query25 0.39 0.22 0.21
query26 0.46 0.12 0.12
query27 0.06 0.05 0.05
query28 11.71 0.75 0.77
query29 12.52 3.14 3.23
query30 0.58 0.45 0.52
query31 2.77 0.34 0.35
query32 3.39 0.48 0.48
query33 3.25 3.26 3.25
query34 15.79 4.33 4.23
query35 4.31 4.25 4.27
query36 1.11 1.08 1.07
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.75 s
Total hot run time: 30.52 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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1911444633
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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1909660132
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 8b7e1c59b8342a56a748df6467bff6afb0c7e493 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: 15.0 seconds inserted 10000000 Rows, about 666K 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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1909647928
<details>
<summary>TPC-DS: <b>Total hot run time: 186521 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 8b7e1c59b8342a56a748df6467bff6afb0c7e493, data reload: false
query1 936 335 333 333
query2 6545 1890 1939 1890
query3 6697 201 200 200
query4 32398 22202 22118 22118
query5 4444 374 436 374
query6 258 147 153 147
query7 4609 268 255 255
query8 226 179 182 179
query9 8264 2592 2575 2575
query10 418 225 233 225
query11 17105 15444 15565 15444
query12 126 69 62 62
query13 1683 372 372 372
query14 10503 7016 7022 7016
query15 219 176 184 176
query16 5790 259 248 248
query17 954 466 461 461
query18 1796 247 252 247
query19 174 129 128 128
query20 69 75 69 69
query21 188 138 136 136
query22 5000 4826 4830 4826
query23 31646 30871 30775 30775
query24 12648 2867 2798 2798
query25 556 309 310 309
query26 1819 138 140 138
query27 3232 283 279 279
query28 7347 1831 1827 1827
query29 2168 632 633 632
query30 282 131 140 131
query31 942 731 744 731
query32 86 56 53 53
query33 703 206 208 206
query34 1169 458 448 448
query35 873 742 765 742
query36 1381 1140 1143 1140
query37 171 57 56 56
query38 3353 3227 3261 3227
query39 1339 1274 1251 1251
query40 342 83 84 83
query41 37 35 34 34
query42 85 80 78 78
query43 521 468 488 468
query44 1120 687 693 687
query45 190 173 173 173
query46 1060 659 641 641
query47 1677 1566 1579 1566
query48 386 319 308 308
query49 1216 290 287 287
query50 671 300 312 300
query51 5237 5202 5211 5202
query52 97 75 88 75
query53 329 255 254 254
query54 242 182 182 182
query55 85 72 76 72
query56 166 169 165 165
query57 1003 926 938 926
query58 184 158 153 153
query59 2944 2565 2710 2565
query60 208 179 177 177
query61 84 81 81 81
query62 629 372 343 343
query63 278 252 253 252
query64 6166 1771 1764 1764
query65 3336 3276 3229 3229
query66 1434 320 318 318
query67 15994 15162 15496 15162
query68 10748 530 533 530
query69 576 300 291 291
query70 1646 1551 1477 1477
query71 10420 10196 10197 10196
query72 4757 2822 2798 2798
query73 2152 314 314 314
query74 7456 6497 6427 6427
query75 4437 2267 2322 2267
query76 6275 1051 1064 1051
query77 639 228 227 227
query78 9022 8849 8583 8583
query79 2224 492 500 492
query80 590 327 309 309
query81 446 205 204 204
query82 202 79 80 79
query83 139 115 113 113
query84 273 66 66 66
query85 1085 335 340 335
query86 387 391 391 391
query87 3490 3340 3378 3340
query88 3944 2206 2200 2200
query89 439 357 349 349
query90 1959 184 185 184
query91 149 122 128 122
query92 50 44 44 44
query93 4179 422 418 418
query94 1335 161 155 155
query95 504 469 447 447
query96 636 317 324 317
query97 4261 4154 4159 4154
query98 192 192 182 182
query99 1034 696 690 690
Total cold run time: 309484 ms
Total hot run time: 186521 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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1911444607
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] [chore](Nereids) enable nereids if update from doris 1.x [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #30369:
URL: https://github.com/apache/doris/pull/30369#issuecomment-1909575246
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