You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Nitin-Kashyap (via GitHub)" <gi...@apache.org> on 2023/12/15 05:03:42 UTC
[PR] [ut](meta) added unit test for frontend service impl [doris]
Nitin-Kashyap opened a new pull request, #28455:
URL: https://github.com/apache/doris/pull/28455
## Proposed changes
added unit test for frontend service impl
--
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1877743182
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1888554310
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "Nitin-Kashyap (via GitHub)" <gi...@apache.org>.
Nitin-Kashyap commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1858906811
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1888554365
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1877777917
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 9ef5c35e11d6c9fdb8e2dce693d1b28c0e9a693a, data reload: false
------ Round 1 ----------------------------------
q1 17688 5128 5132 5128
q2 2013 150 142 142
q3 10558 1088 1109 1088
q4 10191 739 795 739
q5 7792 2918 2855 2855
q6 217 132 130 130
q7 968 508 495 495
q8 9285 2009 2018 2009
q9 6786 6362 6351 6351
q10 8228 2993 3018 2993
q11 422 218 217 217
q12 382 229 226 226
q13 18013 3608 3628 3608
q14 236 218 211 211
q15 555 529 528 528
q16 454 379 397 379
q17 970 508 457 457
q18 7328 6633 6615 6615
q19 1595 1335 1387 1335
q20 678 344 318 318
q21 2781 2358 2435 2358
q22 369 323 336 323
Total cold run time: 107509 ms
Total hot run time: 38505 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5117 5041 5101 5041
q2 333 233 232 232
q3 3282 3296 3263 3263
q4 2115 1972 2013 1972
q5 5796 5756 5768 5756
q6 214 123 122 122
q7 2326 1935 1905 1905
q8 3365 3449 3471 3449
q9 8901 8830 8784 8784
q10 3781 3809 3852 3809
q11 566 492 496 492
q12 801 611 654 611
q13 6629 3213 3205 3205
q14 299 262 288 262
q15 572 531 521 521
q16 553 490 486 486
q17 1911 1751 1765 1751
q18 8762 8350 8315 8315
q19 1620 1583 1576 1576
q20 2217 1947 1954 1947
q21 5611 5226 5209 5209
q22 541 443 428 428
Total cold run time: 65312 ms
Total hot run time: 59136 ms
```
--
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1858913090
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 699b755ae2d7bb11095852c896daa1a966d51633, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4691 4476 4558 4476
q2 365 149 199 149
q3 1455 1232 1245 1232
q4 1120 907 914 907
q5 3142 3142 3119 3119
q6 250 129 125 125
q7 998 481 481 481
q8 2193 2200 2202 2200
q9 6688 6657 6667 6657
q10 3207 3266 3235 3235
q11 323 204 195 195
q12 351 210 208 208
q13 4542 3864 3805 3805
q14 242 213 226 213
q15 561 517 518 517
q16 442 392 381 381
q17 1022 588 494 494
q18 7242 6896 7867 6896
q19 1527 1460 1406 1406
q20 510 317 277 277
q21 3093 2672 2646 2646
q22 357 282 285 282
Total cold run time: 44321 ms
Total hot run time: 39901 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4409 4400 4379 4379
q2 263 163 165 163
q3 3537 3517 3523 3517
q4 2379 2360 2377 2360
q5 5721 5734 5756 5734
q6 241 124 121 121
q7 2384 1873 1856 1856
q8 3519 3518 3524 3518
q9 8984 8965 8943 8943
q10 3912 4005 3999 3999
q11 519 369 391 369
q12 761 590 611 590
q13 4302 3596 3554 3554
q14 283 258 256 256
q15 571 529 522 522
q16 520 463 469 463
q17 1880 1848 1857 1848
q18 8575 8243 8251 8243
q19 1701 1758 1764 1758
q20 2259 1961 1938 1938
q21 6516 6168 6165 6165
q22 510 419 428 419
Total cold run time: 63746 ms
Total hot run time: 60715 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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1877784331
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 9ef5c35e11d6c9fdb8e2dce693d1b28c0e9a693a, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5436 5072 5145 5072
q2 385 155 186 155
q3 1465 1224 1142 1142
q4 1067 913 776 776
q5 3154 3127 3118 3118
q6 222 132 131 131
q7 961 538 514 514
q8 2145 2273 2314 2273
q9 6708 6677 6677 6677
q10 3197 3128 3103 3103
q11 360 220 208 208
q12 385 229 225 225
q13 4400 3631 3635 3631
q14 247 212 214 212
q15 577 524 522 522
q16 467 423 397 397
q17 1051 459 512 459
q18 7104 6791 6755 6755
q19 1630 1553 1425 1425
q20 550 323 348 323
q21 2904 2466 2436 2436
q22 401 311 344 311
Total cold run time: 44816 ms
Total hot run time: 39865 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5090 5005 5042 5005
q2 333 232 231 231
q3 3383 3342 3334 3334
q4 2159 2059 2035 2035
q5 5957 5943 5968 5943
q6 225 126 126 126
q7 2389 1915 1935 1915
q8 3555 3657 3662 3657
q9 9037 9011 8968 8968
q10 3857 3892 3916 3892
q11 562 492 465 465
q12 800 633 644 633
q13 3900 3216 3184 3184
q14 313 276 263 263
q15 593 535 523 523
q16 551 491 490 490
q17 2021 1785 1776 1776
q18 8692 8394 8336 8336
q19 1733 1697 1696 1696
q20 2261 1983 1991 1983
q21 5790 5267 5282 5267
q22 570 536 474 474
Total cold run time: 63771 ms
Total hot run time: 60196 ms
```
--
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #28455:
URL: https://github.com/apache/doris/pull/28455
--
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] [ut](meta) added unit test for frontend service impl [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1877798396
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.4 seconds
stream load tsv: 566 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.1 seconds inserted 10000000 Rows, about 355K ops/s
storage size: 17187892287 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [ut](meta) added unit test for frontend service impl [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28455:
URL: https://github.com/apache/doris/pull/28455#issuecomment-1877790629
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 9ef5c35e11d6c9fdb8e2dce693d1b28c0e9a693a, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 913 342 330 330
query2 6419 1863 1943 1863
query3 6649 205 201 201
query4 26389 22484 22507 22484
query5 4753 541 547 541
query6 280 181 179 179
query7 4571 262 258 258
query8 216 198 208 198
query9 8244 2522 2533 2522
query10 477 267 246 246
query11 16256 15577 15465 15465
query12 131 78 76 76
query13 1621 318 320 318
query14 11100 7088 7070 7070
query15 211 186 191 186
query16 6262 266 259 259
query17 1848 492 493 492
query18 1842 265 270 265
query19 190 139 136 136
query20 79 72 77 72
query21 188 95 95 95
query22 4909 4733 4752 4733
query23 31972 31320 31424 31320
query24 11669 2789 2827 2789
query25 603 347 337 337
query26 1675 137 134 134
query27 2921 265 276 265
query28 6948 1851 1854 1851
query29 1717 378 375 375
query30 280 145 147 145
query31 980 773 747 747
query32 93 55 56 55
query33 732 277 254 254
query34 878 446 444 444
query35 856 768 785 768
query36 1309 1169 1155 1155
query37 104 67 65 65
query38 3443 3325 3251 3251
query39 1360 1294 1299 1294
query40 303 88 85 85
query41 36 35 34 34
query42 87 86 83 83
query43 508 485 478 478
query44 1046 682 705 682
query45 202 184 182 182
query46 1059 645 626 626
query47 1686 1565 1561 1561
query48 328 254 247 247
query49 1157 316 326 316
query50 733 326 319 319
query51 5471 5469 5272 5272
query52 86 86 79 79
query53 212 143 144 143
query54 1343 548 550 548
query55 95 72 85 72
query56 183 188 179 179
query57 1059 979 916 916
query58 232 196 200 196
query59 2811 2746 2694 2694
query60 229 200 212 200
query61 89 86 87 86
query62 645 458 460 458
query63 172 142 145 142
query64 5957 1731 1672 1672
query65 3310 3235 3244 3235
query66 1192 345 332 332
query67 15596 15603 15234 15234
query68 12459 509 529 509
query69 495 272 243 243
query70 1691 1507 1518 1507
query71 498 217 223 217
query72 5716 3595 3576 3576
query73 2751 314 310 310
query74 7094 6372 6496 6372
query75 5098 2315 2252 2252
query76 6223 1080 1133 1080
query77 667 253 275 253
query78 9188 8567 8679 8567
query79 1042 505 493 493
query80 553 349 350 349
query81 475 212 207 207
query82 203 91 89 89
query83 164 144 137 137
query84 251 56 55 55
query85 963 279 273 273
query86 374 364 381 364
query87 3576 3381 3343 3343
query88 3093 2267 2254 2254
query89 330 258 257 257
query90 1866 198 194 194
query91 119 93 90 90
query92 58 56 51 51
query93 1406 430 473 430
query94 864 188 192 188
query95 465 411 405 405
query96 610 320 317 317
query97 4251 4150 4188 4150
query98 210 198 189 189
query99 1088 810 819 810
Total cold run time: 290756 ms
Total hot run time: 178840 ms
```
--
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