You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhangstar333 (via GitHub)" <gi...@apache.org> on 2024/10/11 08:01:40 UTC
[PR] [Bug](udf) get data address should after resize operator [doris]
zhangstar333 opened a new pull request, #41709:
URL: https://github.com/apache/doris/pull/41709
## Proposed changes
when get column data address, it's should be after the column resize operator.
<!--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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408450479
<details>
<summary>TPC-DS: <b>Total hot run time: 211826 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 e25841ced13b12bf1db5327e6de7bcf8a9f3032e, data reload: false
query1 934 387 432 387
query2 6553 2233 2038 2038
query3 6933 205 199 199
query4 23104 21526 21408 21408
query5 19764 6592 6595 6592
query6 293 221 229 221
query7 4287 299 303 299
query8 247 241 240 240
query9 3120 2693 2622 2622
query10 429 309 298 298
query11 15845 15202 15131 15131
query12 121 75 72 72
query13 1027 439 434 434
query14 17594 13350 13222 13222
query15 370 218 225 218
query16 6451 277 256 256
query17 1753 909 917 909
query18 896 312 312 312
query19 205 153 155 153
query20 99 95 97 95
query21 189 98 95 95
query22 5097 4972 5057 4972
query23 34175 33589 33534 33534
query24 7910 6294 6369 6294
query25 533 425 435 425
query26 1278 161 162 161
query27 2454 297 295 295
query28 6123 2266 2239 2239
query29 2835 2649 2724 2649
query30 243 169 163 163
query31 932 717 743 717
query32 70 62 59 59
query33 451 248 264 248
query34 862 489 489 489
query35 1181 963 874 874
query36 1245 1185 1149 1149
query37 168 59 58 58
query38 3056 2931 2908 2908
query39 1396 1315 1339 1315
query40 310 92 94 92
query41 40 39 37 37
query42 84 84 84 84
query43 655 554 582 554
query44 1158 736 732 732
query45 250 229 234 229
query46 1227 990 971 971
query47 1892 1787 1784 1784
query48 500 429 417 417
query49 656 377 368 368
query50 876 602 613 602
query51 4759 4728 4624 4624
query52 92 88 85 85
query53 242 190 190 190
query54 2693 2481 2510 2481
query55 86 89 85 85
query56 227 211 203 203
query57 1357 1097 1097 1097
query58 222 218 216 216
query59 3447 3362 3306 3306
query60 224 215 208 208
query61 98 94 95 94
query62 862 500 460 460
query63 197 175 179 175
query64 3595 1590 1502 1502
query65 3589 3525 3536 3525
query66 777 435 408 408
query67 15716 14730 18171 14730
query68 9670 649 669 649
query69 493 276 279 276
query70 1616 1456 1555 1456
query71 403 309 301 301
query72 6935 4922 4762 4762
query73 763 314 317 314
query74 6261 5834 5805 5805
query75 5397 3718 3633 3633
query76 5496 1170 1190 1170
query77 939 252 258 252
query78 12621 11808 11543 11543
query79 6950 648 615 615
query80 1106 387 402 387
query81 493 242 236 236
query82 873 103 97 97
query83 177 132 133 132
query84 259 71 69 69
query85 885 326 322 322
query86 336 292 294 292
query87 3182 3008 2993 2993
query88 4082 2326 2314 2314
query89 479 295 282 282
query90 1962 210 213 210
query91 156 151 126 126
query92 63 52 53 52
query93 6465 604 563 563
query94 705 204 212 204
query95 2006 2046 1981 1981
query96 644 326 327 326
query97 6514 6449 6387 6387
query98 233 205 202 202
query99 2955 918 866 866
Total cold run time: 317173 ms
Total hot run time: 211826 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410848405
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8 with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.8 seconds inserted 10000000 Rows, about 458K 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406841281
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Bug](udf) get data address should after resize operator [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408436961
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "xiaokang (via GitHub)" <gi...@apache.org>.
xiaokang merged PR #41709:
URL: https://github.com/apache/doris/pull/41709
--
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406807839
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408435335
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Bug](udf) get data address should after resize operator [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2412688290
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406898635
<details>
<summary>TPC-H: <b>Total hot run time: 49034 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 82253003b7f5c6c9cc8e2585292d16a3b025f934, data reload: false
------ Round 1 ----------------------------------
q1 17914 4369 4374 4369
q2 2061 152 139 139
q3 10270 1934 1920 1920
q4 10374 1227 1308 1227
q5 8394 4224 3928 3928
q6 231 124 124 124
q7 2010 1640 1614 1614
q8 9557 2744 2721 2721
q9 11472 9979 9743 9743
q10 8636 3580 3540 3540
q11 419 249 248 248
q12 469 300 312 300
q13 18365 3950 4044 3950
q14 353 323 316 316
q15 499 457 456 456
q16 537 449 454 449
q17 1124 958 913 913
q18 7300 6819 6784 6784
q19 1669 1585 1533 1533
q20 555 308 294 294
q21 4471 4130 4069 4069
q22 505 409 397 397
Total cold run time: 117185 ms
Total hot run time: 49034 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4306 4448 4463 4448
q2 325 227 224 224
q3 4184 4141 4161 4141
q4 2759 2759 2736 2736
q5 7244 7146 7146 7146
q6 238 116 119 116
q7 3245 2885 2868 2868
q8 4390 4451 4473 4451
q9 13740 13627 13670 13627
q10 4221 4266 4238 4238
q11 747 707 677 677
q12 1018 863 838 838
q13 6590 3801 3729 3729
q14 450 428 415 415
q15 497 471 462 462
q16 639 587 578 578
q17 3843 3821 3846 3821
q18 8726 8682 8822 8682
q19 1719 1676 1671 1671
q20 2383 2124 2103 2103
q21 8423 8439 8488 8439
q22 1031 955 954 954
Total cold run time: 80718 ms
Total hot run time: 76364 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406933932
<details>
<summary>ClickBench: <b>Total hot run time: 30.8 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 82253003b7f5c6c9cc8e2585292d16a3b025f934, data reload: false
query1 0.03 0.03 0.02
query2 0.08 0.03 0.03
query3 0.25 0.04 0.05
query4 1.79 0.08 0.07
query5 0.54 0.53 0.52
query6 1.28 0.61 0.62
query7 0.02 0.01 0.02
query8 0.04 0.03 0.02
query9 0.52 0.48 0.47
query10 0.53 0.55 0.54
query11 0.12 0.09 0.09
query12 0.12 0.09 0.10
query13 0.62 0.62 0.61
query14 0.79 0.78 0.80
query15 0.77 0.77 0.76
query16 0.36 0.36 0.38
query17 1.04 1.02 1.00
query18 0.23 0.25 0.23
query19 1.87 1.83 1.87
query20 0.02 0.01 0.01
query21 15.46 0.55 0.56
query22 2.00 2.36 1.57
query23 17.18 0.90 0.95
query24 5.73 1.98 1.22
query25 0.41 0.11 0.06
query26 0.66 0.15 0.14
query27 0.05 0.04 0.04
query28 6.44 0.73 0.71
query29 12.61 2.17 2.35
query30 0.60 0.56 0.55
query31 2.82 0.39 0.37
query32 3.38 0.50 0.49
query33 3.07 3.12 3.06
query34 15.25 4.81 4.79
query35 4.88 4.84 4.84
query36 1.04 1.02 1.01
query37 0.06 0.05 0.04
query38 0.04 0.03 0.02
query39 0.02 0.01 0.01
query40 0.16 0.14 0.14
query41 0.07 0.01 0.01
query42 0.02 0.01 0.01
query43 0.03 0.01 0.02
Total cold run time: 103 s
Total hot run time: 30.8 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410687769
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Bug](udf) get data address should after resize operator [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408430790
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408453329
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit e25841ced13b12bf1db5327e6de7bcf8a9f3032e with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.6 seconds inserted 10000000 Rows, about 462K 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410754086
<details>
<summary>TPC-H: <b>Total hot run time: 49167 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 6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8, data reload: false
------ Round 1 ----------------------------------
q1 17635 4377 4343 4343
q2 2078 155 147 147
q3 10266 1875 1908 1875
q4 10340 1273 1318 1273
q5 8515 3866 3937 3866
q6 229 121 124 121
q7 2032 1623 1613 1613
q8 9273 2717 2699 2699
q9 10543 10092 9950 9950
q10 8621 3539 3513 3513
q11 433 236 253 236
q12 465 293 300 293
q13 18352 4004 4048 4004
q14 348 323 332 323
q15 512 459 469 459
q16 549 462 459 459
q17 1114 977 928 928
q18 7134 6810 6867 6810
q19 1664 1577 1529 1529
q20 506 296 296 296
q21 4388 4182 4038 4038
q22 492 399 392 392
Total cold run time: 115489 ms
Total hot run time: 49167 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4377 4283 4324 4283
q2 319 227 212 212
q3 4187 4143 4150 4143
q4 2753 2754 2740 2740
q5 7196 7158 7052 7052
q6 235 119 119 119
q7 3236 2891 2802 2802
q8 4357 4435 4475 4435
q9 14139 14012 13886 13886
q10 4277 4233 4249 4233
q11 765 687 691 687
q12 1017 870 849 849
q13 6171 3766 3742 3742
q14 461 420 421 420
q15 517 461 457 457
q16 628 607 585 585
q17 3788 3803 3790 3790
q18 8797 8678 8829 8678
q19 1719 1659 1670 1659
q20 2377 2177 2164 2164
q21 8431 8332 8478 8332
q22 1042 937 926 926
Total cold run time: 80789 ms
Total hot run time: 76194 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408452442
<details>
<summary>ClickBench: <b>Total hot run time: 30.96 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 e25841ced13b12bf1db5327e6de7bcf8a9f3032e, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.25 0.04 0.05
query4 1.80 0.05 0.06
query5 0.54 0.53 0.53
query6 1.26 0.62 0.63
query7 0.01 0.01 0.01
query8 0.03 0.03 0.03
query9 0.53 0.48 0.48
query10 0.54 0.53 0.53
query11 0.12 0.09 0.08
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.80 0.79 0.78
query15 0.79 0.77 0.75
query16 0.36 0.35 0.36
query17 0.98 1.00 0.96
query18 0.22 0.26 0.26
query19 1.93 1.85 1.84
query20 0.01 0.00 0.01
query21 15.46 0.53 0.55
query22 2.03 2.33 1.97
query23 17.63 0.98 0.96
query24 8.42 1.05 0.77
query25 0.38 0.06 0.04
query26 0.93 0.15 0.16
query27 0.04 0.04 0.03
query28 5.02 0.77 0.72
query29 12.72 2.39 2.34
query30 0.61 0.55 0.53
query31 2.82 0.38 0.37
query32 3.40 0.51 0.49
query33 3.03 3.07 3.09
query34 15.28 4.81 4.82
query35 4.87 4.86 4.87
query36 1.04 1.01 1.02
query37 0.06 0.05 0.05
query38 0.04 0.03 0.02
query39 0.02 0.01 0.02
query40 0.16 0.14 0.14
query41 0.06 0.01 0.01
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.06 s
Total hot run time: 30.96 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408446484
<details>
<summary>TPC-H: <b>Total hot run time: 49421 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 e25841ced13b12bf1db5327e6de7bcf8a9f3032e, data reload: false
------ Round 1 ----------------------------------
q1 17631 4432 4438 4432
q2 2048 151 143 143
q3 10446 1898 1909 1898
q4 10331 1271 1350 1271
q5 8625 3886 3928 3886
q6 232 124 125 124
q7 2042 1614 1600 1600
q8 9273 2743 2694 2694
q9 10497 10091 10143 10091
q10 8649 3516 3525 3516
q11 418 250 247 247
q12 468 303 296 296
q13 18353 3960 4027 3960
q14 346 327 331 327
q15 506 467 465 465
q16 539 449 448 448
q17 1136 978 928 928
q18 7146 6843 6870 6843
q19 1691 1506 1486 1486
q20 531 301 307 301
q21 4407 4158 4084 4084
q22 500 381 404 381
Total cold run time: 115815 ms
Total hot run time: 49421 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4330 4320 4317 4317
q2 321 226 224 224
q3 4203 4151 4140 4140
q4 2738 2735 2718 2718
q5 7234 7159 7186 7159
q6 236 121 116 116
q7 3246 2819 2843 2819
q8 4368 4414 4412 4412
q9 14349 13919 13906 13906
q10 4234 4273 4305 4273
q11 741 677 679 677
q12 1031 863 834 834
q13 6946 3700 3733 3700
q14 454 429 418 418
q15 499 463 452 452
q16 629 578 584 578
q17 3756 3840 3843 3840
q18 8731 8834 8725 8725
q19 1720 1642 1682 1642
q20 2325 2114 2112 2112
q21 8535 8476 8420 8420
q22 1039 965 936 936
Total cold run time: 81665 ms
Total hot run time: 76418 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410814776
<details>
<summary>TPC-DS: <b>Total hot run time: 213057 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 6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8, data reload: false
query1 928 396 406 396
query2 6626 2247 2231 2231
query3 6929 206 203 203
query4 23975 21856 22130 21856
query5 19842 6651 6660 6651
query6 311 238 276 238
query7 4290 324 323 323
query8 280 270 278 270
query9 3250 2762 2669 2669
query10 444 337 326 326
query11 15899 15200 14933 14933
query12 124 77 69 69
query13 1033 478 432 432
query14 19405 13475 13863 13475
query15 366 217 222 217
query16 6459 281 263 263
query17 1909 938 924 924
query18 893 322 316 316
query19 219 167 160 160
query20 101 98 96 96
query21 192 96 96 96
query22 5166 5057 4924 4924
query23 34271 33414 33313 33313
query24 6697 6278 6301 6278
query25 530 418 414 414
query26 792 166 163 163
query27 2322 293 286 286
query28 6119 2261 2231 2231
query29 3058 2684 2841 2684
query30 251 169 165 165
query31 914 746 786 746
query32 70 62 63 62
query33 440 264 265 264
query34 853 471 478 471
query35 1198 975 898 898
query36 1279 1144 1148 1144
query37 95 58 60 58
query38 3074 2897 2961 2897
query39 1374 1338 1314 1314
query40 209 97 95 95
query41 40 38 40 38
query42 83 92 77 77
query43 561 653 585 585
query44 1189 717 733 717
query45 250 237 229 229
query46 1223 975 980 975
query47 1975 1760 1846 1760
query48 494 412 408 408
query49 613 378 372 372
query50 881 596 606 596
query51 4820 4625 4698 4625
query52 102 78 81 78
query53 240 189 193 189
query54 2682 2483 2476 2476
query55 95 83 83 83
query56 235 213 209 209
query57 1197 1168 1126 1126
query58 228 216 196 196
query59 3471 3210 3013 3013
query60 242 199 212 199
query61 98 93 94 93
query62 757 458 510 458
query63 209 174 174 174
query64 3147 1558 1465 1465
query65 3613 3553 3607 3553
query66 734 398 393 393
query67 15659 16383 15528 15528
query68 11032 629 665 629
query69 495 286 263 263
query70 1859 1278 1425 1278
query71 427 315 307 307
query72 6773 4877 4896 4877
query73 834 324 326 324
query74 6262 5788 5805 5788
query75 5383 3659 3660 3659
query76 6465 1125 1201 1125
query77 1095 255 244 244
query78 12853 11734 12283 11734
query79 4903 624 645 624
query80 1250 373 402 373
query81 489 236 245 236
query82 1632 94 104 94
query83 167 141 142 141
query84 258 77 70 70
query85 893 319 320 319
query86 319 288 332 288
query87 3199 3009 3070 3009
query88 4300 2298 2309 2298
query89 361 272 277 272
query90 2111 211 218 211
query91 159 138 140 138
query92 60 53 49 49
query93 5469 546 573 546
query94 739 212 209 209
query95 2052 1994 2033 1994
query96 658 324 321 321
query97 6516 6400 6403 6400
query98 223 194 202 194
query99 2997 877 902 877
Total cold run time: 319258 ms
Total hot run time: 213057 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410841729
<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 6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8, data reload: false
query1 0.02 0.02 0.03
query2 0.07 0.03 0.02
query3 0.24 0.04 0.05
query4 1.80 0.07 0.06
query5 0.54 0.52 0.51
query6 1.23 0.60 0.72
query7 0.01 0.01 0.01
query8 0.03 0.03 0.02
query9 0.52 0.49 0.49
query10 0.52 0.54 0.53
query11 0.11 0.09 0.08
query12 0.12 0.09 0.09
query13 0.62 0.61 0.61
query14 0.80 0.79 0.81
query15 0.77 0.76 0.76
query16 0.36 0.36 0.36
query17 1.04 0.99 1.00
query18 0.25 0.21 0.28
query19 1.83 1.80 1.84
query20 0.01 0.00 0.00
query21 15.45 0.56 0.55
query22 2.16 2.16 1.44
query23 17.50 1.05 0.94
query24 6.51 1.44 1.00
query25 0.38 0.10 0.05
query26 0.77 0.16 0.16
query27 0.04 0.05 0.04
query28 6.16 0.73 0.71
query29 12.66 2.31 2.35
query30 0.63 0.48 0.51
query31 2.81 0.38 0.36
query32 3.39 0.50 0.49
query33 3.06 3.07 3.07
query34 15.22 4.80 4.81
query35 4.86 4.86 4.88
query36 1.05 1.01 1.02
query37 0.06 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.15
query41 0.06 0.02 0.01
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 103.92 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406913441
TeamCity be ut coverage result:
Function Coverage: 37.81% (8147/21549)
Line Coverage: 29.54% (67063/226991)
Region Coverage: 29.01% (34564/119129)
Branch Coverage: 24.93% (17808/71442)
Coverage Report: http://coverage.selectdb-in.cc/coverage/82253003b7f5c6c9cc8e2585292d16a3b025f934_82253003b7f5c6c9cc8e2585292d16a3b025f934/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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406939874
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 82253003b7f5c6c9cc8e2585292d16a3b025f934 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.3 seconds inserted 10000000 Rows, about 469K 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406806548
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2406923499
<details>
<summary>TPC-DS: <b>Total hot run time: 213919 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 82253003b7f5c6c9cc8e2585292d16a3b025f934, data reload: false
query1 954 391 413 391
query2 6536 2096 2042 2042
query3 6924 202 201 201
query4 23313 22059 21493 21493
query5 19754 6564 6592 6564
query6 290 224 237 224
query7 4153 300 310 300
query8 272 234 261 234
query9 3061 2656 2593 2593
query10 420 410 310 310
query11 15881 15163 15299 15163
query12 130 76 72 72
query13 1038 467 466 466
query14 18629 13850 13441 13441
query15 358 228 227 227
query16 6527 279 268 268
query17 2019 947 919 919
query18 891 315 317 315
query19 214 158 144 144
query20 101 92 101 92
query21 186 95 96 95
query22 5294 5035 5128 5035
query23 34310 33579 33442 33442
query24 6787 6289 6312 6289
query25 527 442 441 441
query26 1013 164 162 162
query27 2374 297 291 291
query28 6087 2291 2251 2251
query29 2804 2806 2667 2667
query30 242 168 171 168
query31 912 745 738 738
query32 74 61 58 58
query33 435 257 255 255
query34 855 486 468 468
query35 1127 903 923 903
query36 1387 1400 1336 1336
query37 88 60 59 59
query38 3100 2933 2902 2902
query39 1383 1336 1339 1336
query40 216 93 97 93
query41 40 36 36 36
query42 85 81 91 81
query43 631 608 593 593
query44 1191 720 721 720
query45 238 229 227 227
query46 1225 966 960 960
query47 1970 1726 1826 1726
query48 515 400 405 400
query49 631 372 377 372
query50 857 640 560 560
query51 4734 4672 4726 4672
query52 98 93 84 84
query53 229 190 184 184
query54 2663 2455 2496 2455
query55 81 86 78 78
query56 228 194 201 194
query57 1293 1159 1166 1159
query58 220 211 217 211
query59 3513 3420 3374 3374
query60 208 208 203 203
query61 98 94 96 94
query62 805 492 478 478
query63 202 180 174 174
query64 3149 1578 1380 1380
query65 3665 3531 3561 3531
query66 803 424 436 424
query67 15866 16382 17181 16382
query68 9427 653 660 653
query69 505 275 263 263
query70 1720 1322 1538 1322
query71 410 304 312 304
query72 6856 4791 4790 4790
query73 753 326 324 324
query74 6234 5808 5894 5808
query75 4896 3712 3627 3627
query76 4994 1168 1197 1168
query77 710 264 274 264
query78 12638 11667 11596 11596
query79 7267 631 631 631
query80 2178 408 376 376
query81 496 242 243 242
query82 1677 96 97 96
query83 169 137 134 134
query84 257 68 69 68
query85 1124 326 320 320
query86 352 291 311 291
query87 3250 2999 3030 2999
query88 4871 2319 2339 2319
query89 421 286 290 286
query90 1989 213 215 213
query91 157 127 136 127
query92 61 57 51 51
query93 5960 566 541 541
query94 865 209 210 209
query95 1889 1955 1965 1955
query96 647 329 321 321
query97 6532 6396 6345 6345
query98 228 206 208 206
query99 2858 870 974 870
Total cold run time: 318295 ms
Total hot run time: 213919 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] [Bug](udf) get data address should after resize operator [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410671288
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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2408447243
TeamCity be ut coverage result:
Function Coverage: 37.83% (8151/21549)
Line Coverage: 29.56% (67099/226998)
Region Coverage: 29.03% (34587/119136)
Branch Coverage: 24.95% (17824/71448)
Coverage Report: http://coverage.selectdb-in.cc/coverage/e25841ced13b12bf1db5327e6de7bcf8a9f3032e_e25841ced13b12bf1db5327e6de7bcf8a9f3032e/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] [Bug](udf) get data address should after resize operator [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41709:
URL: https://github.com/apache/doris/pull/41709#issuecomment-2410828375
TeamCity be ut coverage result:
Function Coverage: 37.82% (8149/21549)
Line Coverage: 29.56% (67091/227001)
Region Coverage: 29.03% (34584/119139)
Branch Coverage: 24.94% (17822/71450)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8_6c1e30aec94c6ca42eccb9c2c5e67437e281ddd8/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