You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "hello-stephen (via GitHub)" <gi...@apache.org> on 2024/06/06 09:57:16 UTC
[PR] [test](cloud_p0) prepare java udf for some cases [doris]
hello-stephen opened a new pull request, #35991:
URL: https://github.com/apache/doris/pull/35991
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2252734289
run cloud_p0
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2253690692
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2254195716
<details>
<summary>ClickBench: <b>Total hot run time: 30.57 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 817028acf4ecdacd54c8c1f0f5708e20aea46914, data reload: false
query1 0.04 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.06
query4 1.68 0.09 0.09
query5 0.51 0.49 0.50
query6 1.14 0.73 0.73
query7 0.02 0.02 0.02
query8 0.05 0.04 0.04
query9 0.55 0.50 0.49
query10 0.54 0.54 0.55
query11 0.14 0.11 0.12
query12 0.15 0.12 0.12
query13 0.60 0.58 0.58
query14 0.76 0.77 0.77
query15 0.85 0.80 0.82
query16 0.38 0.37 0.37
query17 0.96 1.01 1.04
query18 0.22 0.23 0.22
query19 1.88 1.74 1.67
query20 0.01 0.01 0.02
query21 15.42 0.77 0.66
query22 4.29 7.70 1.80
query23 18.27 1.34 1.27
query24 2.05 0.22 0.21
query25 0.16 0.09 0.09
query26 0.29 0.20 0.21
query27 0.44 0.22 0.22
query28 13.36 1.03 0.99
query29 12.63 3.35 3.34
query30 0.26 0.06 0.06
query31 2.87 0.39 0.40
query32 3.26 0.48 0.48
query33 2.88 2.95 2.88
query34 17.08 4.34 4.35
query35 4.39 4.38 4.39
query36 0.64 0.48 0.49
query37 0.19 0.15 0.16
query38 0.15 0.15 0.15
query39 0.04 0.03 0.04
query40 0.15 0.12 0.13
query41 0.09 0.06 0.06
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.8 s
Total hot run time: 30.57 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen merged PR #35991:
URL: https://github.com/apache/doris/pull/35991
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2151889186
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2154955859
run compile
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2227301127
run cloud_p0
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2254850105
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2253704447
<details>
<summary>TPC-H: <b>Total hot run time: 39289 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 d8fe97a2baeed79ff5f631accaf8f323c314bab1, data reload: false
------ Round 1 ----------------------------------
q1 17743 4360 4305 4305
q2 2007 207 196 196
q3 10437 1156 1112 1112
q4 10148 712 693 693
q5 7609 2692 2671 2671
q6 234 138 137 137
q7 950 590 603 590
q8 9218 1867 1911 1867
q9 8698 6537 6538 6537
q10 8875 3763 3803 3763
q11 457 246 247 246
q12 475 219 215 215
q13 17772 2979 2976 2976
q14 269 227 248 227
q15 535 475 474 474
q16 484 387 384 384
q17 948 698 697 697
q18 8036 7487 7333 7333
q19 5801 1052 1053 1052
q20 652 343 335 335
q21 5007 3304 3199 3199
q22 346 291 280 280
Total cold run time: 116701 ms
Total hot run time: 39289 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4456 4329 4301 4301
q2 383 272 268 268
q3 2984 2824 2877 2824
q4 2025 1735 1656 1656
q5 5658 5561 5523 5523
q6 224 127 126 126
q7 2192 1816 1859 1816
q8 3329 3388 3427 3388
q9 8765 8720 8857 8720
q10 4095 3906 3826 3826
q11 601 490 488 488
q12 774 614 630 614
q13 17126 3168 3218 3168
q14 328 284 287 284
q15 517 505 484 484
q16 491 432 428 428
q17 1799 1526 1493 1493
q18 8093 7975 7832 7832
q19 1740 1631 1637 1631
q20 2109 1932 1915 1915
q21 6690 5027 4943 4943
q22 619 507 527 507
Total cold run time: 74998 ms
Total hot run time: 56235 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2253709504
<details>
<summary>ClickBench: <b>Total hot run time: 30.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 d8fe97a2baeed79ff5f631accaf8f323c314bab1, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.05 0.04
query3 0.22 0.05 0.05
query4 1.67 0.07 0.06
query5 0.49 0.48 0.48
query6 1.13 0.74 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.54 0.50 0.49
query10 0.54 0.54 0.55
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.60 0.58 0.59
query14 0.77 0.78 0.76
query15 0.87 0.81 0.82
query16 0.36 0.36 0.37
query17 1.04 0.99 0.98
query18 0.23 0.22 0.21
query19 1.81 1.84 1.84
query20 0.02 0.01 0.01
query21 15.40 0.76 0.65
query22 4.21 7.71 1.61
query23 18.29 1.44 1.33
query24 1.90 0.29 0.22
query25 0.15 0.08 0.09
query26 0.30 0.21 0.21
query27 0.46 0.23 0.23
query28 13.23 1.02 1.01
query29 12.62 3.28 3.23
query30 0.26 0.06 0.06
query31 2.86 0.38 0.39
query32 3.26 0.48 0.47
query33 2.86 2.88 2.92
query34 16.95 4.37 4.38
query35 4.47 4.45 4.41
query36 0.65 0.46 0.50
query37 0.18 0.17 0.15
query38 0.16 0.15 0.16
query39 0.05 0.03 0.03
query40 0.16 0.13 0.12
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.41 s
Total hot run time: 30.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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2254192006
<details>
<summary>TPC-H: <b>Total hot run time: 39375 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 817028acf4ecdacd54c8c1f0f5708e20aea46914, data reload: false
------ Round 1 ----------------------------------
q1 17625 4342 4302 4302
q2 2009 202 203 202
q3 10432 1235 1186 1186
q4 10137 775 699 699
q5 7549 2684 2639 2639
q6 218 139 140 139
q7 946 601 597 597
q8 9235 1937 1906 1906
q9 8844 6566 6488 6488
q10 8931 3810 3800 3800
q11 468 248 254 248
q12 521 231 228 228
q13 17770 3023 2989 2989
q14 287 235 243 235
q15 521 476 468 468
q16 507 405 381 381
q17 971 677 635 635
q18 7986 7399 7373 7373
q19 6103 1035 988 988
q20 666 329 321 321
q21 5037 3262 3333 3262
q22 353 296 289 289
Total cold run time: 117116 ms
Total hot run time: 39375 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4510 4265 4280 4265
q2 368 259 263 259
q3 3003 2832 2936 2832
q4 1950 1738 1646 1646
q5 5723 5536 5545 5536
q6 225 132 132 132
q7 2141 1826 1842 1826
q8 3359 3387 3391 3387
q9 8807 8761 8872 8761
q10 4154 3914 3761 3761
q11 595 496 501 496
q12 790 657 597 597
q13 15976 3232 3194 3194
q14 317 294 297 294
q15 531 502 493 493
q16 504 426 416 416
q17 1791 1543 1505 1505
q18 8109 7835 7773 7773
q19 1694 1478 1601 1478
q20 2172 1923 1889 1889
q21 5102 4979 5000 4979
q22 601 497 514 497
Total cold run time: 72422 ms
Total hot run time: 56016 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2151883097
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2253707855
<details>
<summary>TPC-DS: <b>Total hot run time: 173549 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 d8fe97a2baeed79ff5f631accaf8f323c314bab1, data reload: false
query1 914 368 370 368
query2 6472 1948 1891 1891
query3 6635 204 211 204
query4 28267 17389 17340 17340
query5 3664 486 500 486
query6 272 182 164 164
query7 4576 297 284 284
query8 237 193 199 193
query9 8452 2483 2435 2435
query10 439 275 270 270
query11 11833 10082 11020 10082
query12 134 90 88 88
query13 1642 381 378 378
query14 9691 7900 7748 7748
query15 219 167 167 167
query16 7335 487 449 449
query17 1606 610 535 535
query18 1825 285 286 285
query19 185 143 147 143
query20 94 85 83 83
query21 209 104 102 102
query22 4298 4112 4052 4052
query23 34131 34054 33787 33787
query24 10978 2924 2936 2924
query25 624 406 388 388
query26 1139 152 154 152
query27 2197 273 275 273
query28 7412 2071 2078 2071
query29 833 428 423 423
query30 255 155 157 155
query31 956 764 754 754
query32 98 52 56 52
query33 768 344 319 319
query34 898 468 486 468
query35 862 747 769 747
query36 1085 963 978 963
query37 146 88 80 80
query38 2929 2874 2868 2868
query39 899 840 861 840
query40 209 114 114 114
query41 48 45 45 45
query42 123 97 94 94
query43 505 462 470 462
query44 1139 710 708 708
query45 206 174 180 174
query46 1102 720 722 720
query47 1869 1781 1759 1759
query48 361 286 282 282
query49 840 409 414 409
query50 787 398 407 398
query51 6808 6751 6620 6620
query52 102 88 90 88
query53 249 178 175 175
query54 884 439 435 435
query55 75 73 100 73
query56 284 272 278 272
query57 1132 1058 1026 1026
query58 273 272 279 272
query59 2806 2671 2567 2567
query60 326 278 283 278
query61 96 93 92 92
query62 800 633 634 633
query63 211 175 177 175
query64 9442 2236 1730 1730
query65 3180 3102 3095 3095
query66 765 335 332 332
query67 15298 14914 14800 14800
query68 6160 539 540 539
query69 621 412 332 332
query70 1221 1109 1118 1109
query71 502 271 263 263
query72 7603 5501 5900 5501
query73 786 327 324 324
query74 6224 5674 5626 5626
query75 3947 2678 2691 2678
query76 3713 955 938 938
query77 647 300 307 300
query78 9656 9045 9011 9011
query79 2847 515 497 497
query80 2436 476 487 476
query81 590 221 220 220
query82 761 136 133 133
query83 287 179 176 176
query84 277 86 78 78
query85 1339 362 295 295
query86 452 328 314 314
query87 3272 3101 3037 3037
query88 4681 2451 2477 2451
query89 393 278 280 278
query90 1786 189 193 189
query91 130 100 101 100
query92 62 51 52 51
query93 3680 524 520 520
query94 764 296 303 296
query95 359 260 257 257
query96 606 274 276 274
query97 3191 3023 3033 3023
query98 243 197 193 193
query99 1658 1291 1231 1231
Total cold run time: 286023 ms
Total hot run time: 173549 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2254194467
<details>
<summary>TPC-DS: <b>Total hot run time: 173171 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 817028acf4ecdacd54c8c1f0f5708e20aea46914, data reload: false
query1 913 369 359 359
query2 6434 1956 1830 1830
query3 6645 207 216 207
query4 28511 17624 17233 17233
query5 3692 479 487 479
query6 260 164 164 164
query7 4586 282 281 281
query8 234 191 188 188
query9 8682 2462 2450 2450
query10 437 287 266 266
query11 10824 10081 10105 10081
query12 123 88 86 86
query13 1628 375 384 375
query14 10123 7714 7802 7714
query15 239 172 173 172
query16 7160 500 494 494
query17 1599 614 541 541
query18 1768 280 274 274
query19 193 139 156 139
query20 90 82 83 82
query21 202 99 97 97
query22 4390 4222 3914 3914
query23 34268 33650 33593 33593
query24 10747 2904 2948 2904
query25 607 394 395 394
query26 713 150 158 150
query27 2224 275 276 275
query28 6098 2070 2079 2070
query29 740 431 431 431
query30 255 155 156 155
query31 962 728 741 728
query32 90 55 52 52
query33 680 348 329 329
query34 863 482 492 482
query35 842 759 760 759
query36 1112 974 920 920
query37 142 82 82 82
query38 2917 2982 2817 2817
query39 884 847 847 847
query40 208 122 116 116
query41 46 45 44 44
query42 111 96 105 96
query43 507 473 456 456
query44 1066 711 715 711
query45 216 176 176 176
query46 1078 708 717 708
query47 1892 1774 1761 1761
query48 364 300 283 283
query49 835 407 411 407
query50 792 401 402 401
query51 6724 6786 6725 6725
query52 99 92 91 91
query53 255 180 181 180
query54 883 458 438 438
query55 74 73 72 72
query56 282 268 268 268
query57 1132 1062 1044 1044
query58 254 267 276 267
query59 2907 2658 2665 2658
query60 300 289 276 276
query61 95 93 93 93
query62 781 646 641 641
query63 213 180 177 177
query64 9206 2274 1712 1712
query65 3155 3074 3169 3074
query66 776 333 329 329
query67 15491 15006 14776 14776
query68 5157 533 541 533
query69 600 423 309 309
query70 1184 1127 1112 1112
query71 433 273 272 272
query72 7136 5667 5666 5666
query73 790 328 326 326
query74 6053 5708 5631 5631
query75 3432 2660 2655 2655
query76 3107 956 877 877
query77 614 306 304 304
query78 9625 9354 8954 8954
query79 2950 532 518 518
query80 2098 474 534 474
query81 589 221 220 220
query82 1324 136 132 132
query83 342 179 183 179
query84 274 78 76 76
query85 1430 314 299 299
query86 465 319 308 308
query87 3237 3034 3065 3034
query88 4041 2462 2479 2462
query89 406 282 286 282
query90 1735 196 199 196
query91 127 98 103 98
query92 59 49 50 49
query93 3541 515 514 514
query94 829 309 297 297
query95 362 261 265 261
query96 600 270 283 270
query97 3196 3045 3020 3020
query98 225 196 203 196
query99 1748 1262 1253 1253
Total cold run time: 280328 ms
Total hot run time: 173171 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2151960435
<details>
<summary>TPC-H: <b>Total hot run time: 40000 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 1269b89bac325111ca9bc8a87057a26814bfcc97, data reload: false
------ Round 1 ----------------------------------
q1 18374 4992 4280 4280
q2 2032 193 193 193
q3 11159 1130 1141 1130
q4 11310 810 805 805
q5 7528 2716 2688 2688
q6 223 137 142 137
q7 972 630 607 607
q8 9800 2121 2111 2111
q9 9096 6615 6603 6603
q10 8876 3669 3699 3669
q11 472 239 232 232
q12 425 225 221 221
q13 17761 2966 2973 2966
q14 265 218 217 217
q15 538 474 469 469
q16 524 388 379 379
q17 971 648 660 648
q18 8014 7431 7432 7431
q19 4453 1407 1425 1407
q20 657 317 312 312
q21 4951 3169 3942 3169
q22 381 355 326 326
Total cold run time: 118782 ms
Total hot run time: 40000 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4399 4242 4275 4242
q2 367 266 273 266
q3 3024 2678 2745 2678
q4 1895 1616 1591 1591
q5 5251 5236 5270 5236
q6 218 125 128 125
q7 2088 1708 1737 1708
q8 3210 3364 3327 3327
q9 8321 8335 8307 8307
q10 3916 3666 3690 3666
q11 600 485 482 482
q12 780 583 615 583
q13 17412 2976 2964 2964
q14 279 269 262 262
q15 508 469 481 469
q16 488 402 401 401
q17 1796 1485 1461 1461
q18 7650 7418 7438 7418
q19 1687 1628 1673 1628
q20 1996 1813 1766 1766
q21 4815 4722 4669 4669
q22 598 539 526 526
Total cold run time: 71298 ms
Total hot run time: 53775 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2254182393
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2152014156
<details>
<summary>ClickBench: <b>Total hot run time: 30.26 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 1269b89bac325111ca9bc8a87057a26814bfcc97, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.04 0.05
query4 1.68 0.08 0.06
query5 0.50 0.48 0.50
query6 1.13 0.72 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.52 0.48 0.48
query10 0.55 0.54 0.54
query11 0.16 0.12 0.12
query12 0.15 0.12 0.12
query13 0.59 0.58 0.59
query14 0.78 0.76 0.79
query15 0.83 0.81 0.80
query16 0.36 0.37 0.35
query17 0.96 0.96 0.96
query18 0.23 0.25 0.25
query19 1.89 1.74 1.82
query20 0.02 0.01 0.01
query21 15.46 0.71 0.66
query22 4.10 7.53 1.82
query23 18.34 1.38 1.24
query24 2.07 0.22 0.21
query25 0.15 0.10 0.07
query26 0.26 0.18 0.17
query27 0.08 0.08 0.09
query28 13.30 1.01 0.99
query29 13.17 3.29 3.27
query30 0.24 0.08 0.05
query31 2.85 0.40 0.38
query32 3.28 0.48 0.46
query33 2.86 2.94 2.90
query34 16.98 4.38 4.41
query35 4.44 4.52 4.43
query36 0.65 0.46 0.47
query37 0.18 0.15 0.16
query38 0.16 0.15 0.14
query39 0.04 0.04 0.03
query40 0.16 0.13 0.15
query41 0.10 0.04 0.04
query42 0.05 0.05 0.04
query43 0.04 0.03 0.03
Total cold run time: 109.73 s
Total hot run time: 30.26 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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2252724017
run cloud_p0
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2241971972
run compile
--
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2151883211
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] [test](cloud_p0) prepare java udf for some cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35991:
URL: https://github.com/apache/doris/pull/35991#issuecomment-2151996127
<details>
<summary>TPC-DS: <b>Total hot run time: 171873 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 1269b89bac325111ca9bc8a87057a26814bfcc97, data reload: false
query1 938 438 364 364
query2 6468 2328 2355 2328
query3 6659 210 211 210
query4 19380 17269 17410 17269
query5 4128 455 453 453
query6 244 149 157 149
query7 4590 291 285 285
query8 346 294 295 294
query9 8522 2381 2372 2372
query10 452 290 286 286
query11 10468 10143 10072 10072
query12 141 85 83 83
query13 1635 355 352 352
query14 8626 7503 7562 7503
query15 222 188 184 184
query16 7795 266 255 255
query17 1866 529 507 507
query18 1946 262 270 262
query19 198 141 142 141
query20 89 82 83 82
query21 212 130 127 127
query22 4478 4348 4116 4116
query23 33592 32883 33101 32883
query24 10786 2823 2804 2804
query25 624 352 342 342
query26 1208 156 153 153
query27 3026 328 315 315
query28 7299 2025 2022 2022
query29 895 595 594 594
query30 266 150 150 150
query31 961 755 709 709
query32 92 53 54 53
query33 766 271 292 271
query34 982 469 458 458
query35 726 617 618 617
query36 1060 934 903 903
query37 143 67 68 67
query38 2854 2754 2753 2753
query39 844 812 810 810
query40 207 122 122 122
query41 53 49 45 45
query42 117 100 94 94
query43 599 540 557 540
query44 1193 710 736 710
query45 195 164 165 164
query46 1077 714 714 714
query47 1854 1763 1789 1763
query48 376 288 299 288
query49 1075 386 409 386
query50 781 374 382 374
query51 6849 6760 6700 6700
query52 105 89 91 89
query53 350 285 314 285
query54 865 434 430 430
query55 74 73 72 72
query56 270 250 247 247
query57 1150 1041 1068 1041
query58 264 244 240 240
query59 3450 3163 3117 3117
query60 296 265 266 265
query61 106 87 85 85
query62 651 429 434 429
query63 310 285 288 285
query64 9003 2183 1716 1716
query65 3196 3084 3091 3084
query66 920 329 331 329
query67 15501 14958 14839 14839
query68 4620 548 565 548
query69 458 296 295 295
query70 1145 1155 1090 1090
query71 375 269 269 269
query72 7217 5363 4568 4568
query73 741 324 325 324
query74 6047 5503 5494 5494
query75 3375 2630 2660 2630
query76 2310 990 914 914
query77 428 287 289 287
query78 10297 9844 9858 9844
query79 2418 515 515 515
query80 1073 463 454 454
query81 593 216 218 216
query82 712 103 103 103
query83 251 168 163 163
query84 242 84 85 84
query85 1977 264 263 263
query86 526 327 333 327
query87 3285 3091 3099 3091
query88 3639 2404 2339 2339
query89 483 388 375 375
query90 1793 184 182 182
query91 120 96 99 96
query92 65 47 47 47
query93 2217 501 500 500
query94 1237 188 180 180
query95 395 306 311 306
query96 595 265 270 265
query97 3179 3014 3055 3014
query98 212 201 191 191
query99 1282 848 852 848
Total cold run time: 269721 ms
Total hot run time: 171873 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