You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "sjyango (via GitHub)" <gi...@apache.org> on 2024/01/30 04:50:58 UTC
[PR] [feature](function) support tanh math function [doris]
sjyango opened a new pull request, #30555:
URL: https://github.com/apache/doris/pull/30555
## Proposed changes
Issue Number: close #30486
<!--Describe your changes.-->
support tanh math function.
<img width="342" alt="image" src="https://github.com/apache/doris/assets/114391101/8e3c761c-b6f2-4565-bd3f-25e6f149238d">
## 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916102034
<details>
<summary>TPC-DS: <b>Total hot run time: 172639 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 942cfd5e8928af60854446d545057c3593bda2fa, data reload: false
query1 926 333 322 322
query2 6560 1974 1839 1839
query3 6697 203 195 195
query4 26719 22088 22065 22065
query5 4451 350 357 350
query6 250 160 158 158
query7 4616 264 260 260
query8 244 172 180 172
query9 9047 2321 2318 2318
query10 421 206 222 206
query11 16728 15255 15307 15255
query12 111 69 60 60
query13 1668 366 369 366
query14 9278 6566 6609 6566
query15 222 172 176 172
query16 6489 256 250 250
query17 1899 477 472 472
query18 1917 252 249 249
query19 168 131 137 131
query20 70 73 61 61
query21 202 131 127 127
query22 4819 4752 4665 4665
query23 31204 30259 30375 30259
query24 12305 2770 2763 2763
query25 592 316 316 316
query26 1940 139 134 134
query27 2940 290 286 286
query28 7718 1848 1831 1831
query29 2182 619 627 619
query30 288 136 146 136
query31 896 686 700 686
query32 94 49 51 49
query33 711 217 206 206
query34 1050 453 476 453
query35 876 738 768 738
query36 1320 1245 1218 1218
query37 179 58 61 58
query38 3275 3187 3189 3187
query39 1317 1258 1237 1237
query40 329 89 83 83
query41 38 37 35 35
query42 92 85 82 82
query43 507 487 509 487
query44 1178 698 696 696
query45 190 178 178 178
query46 1026 661 642 642
query47 1575 1481 1485 1481
query48 391 310 305 305
query49 1276 279 282 279
query50 683 318 308 308
query51 5237 5155 5208 5155
query52 96 79 78 78
query53 328 257 268 257
query54 247 180 191 180
query55 80 77 71 71
query56 176 164 177 164
query57 1002 871 919 871
query58 181 154 152 152
query59 2344 2363 2324 2324
query60 198 173 188 173
query61 84 83 86 83
query62 618 351 361 351
query63 282 253 272 253
query64 5658 1746 1729 1729
query65 3286 3224 3206 3206
query66 1482 335 318 318
query67 14081 14287 14113 14113
query68 4068 474 470 470
query69 433 317 309 309
query70 1523 1464 1414 1414
query71 293 206 219 206
query72 3743 2879 2860 2860
query73 685 313 303 303
query74 6607 6190 6236 6190
query75 2789 2294 2294 2294
query76 2924 990 978 978
query77 419 237 232 232
query78 9099 8842 8480 8480
query79 2697 477 507 477
query80 2155 324 313 313
query81 522 197 199 197
query82 788 75 81 75
query83 256 117 125 117
query84 298 76 73 73
query85 2483 332 322 322
query86 486 397 398 397
query87 3527 3230 3305 3230
query88 3738 2183 2186 2183
query89 416 341 336 336
query90 1991 183 180 180
query91 146 114 119 114
query92 58 48 41 41
query93 2850 440 426 426
query94 1382 156 159 156
query95 505 465 453 453
query96 635 316 314 314
query97 4305 4116 4132 4116
query98 202 193 185 185
query99 1021 709 724 709
Total cold run time: 278098 ms
Total hot run time: 172639 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916102076
TeamCity be ut coverage result:
Function Coverage: 36.20% (8625/23827)
Line Coverage: 28.25% (70528/249624)
Region Coverage: 27.24% (36384/133546)
Branch Coverage: 24.05% (18648/77554)
Coverage Report: http://coverage.selectdb-in.cc/coverage/942cfd5e8928af60854446d545057c3593bda2fa_942cfd5e8928af60854446d545057c3593bda2fa/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] [feature](function) support tanh math function [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916787441
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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916155413
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916860257
<details>
<summary>ClickBench: <b>Total hot run time: 30.65 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
query1 0.04 0.03 0.02
query2 0.05 0.02 0.03
query3 0.22 0.06 0.06
query4 1.67 0.09 0.09
query5 0.53 0.51 0.51
query6 1.18 0.66 0.66
query7 0.02 0.01 0.02
query8 0.03 0.02 0.02
query9 0.55 0.50 0.50
query10 0.55 0.53 0.55
query11 0.12 0.08 0.09
query12 0.11 0.09 0.09
query13 0.60 0.62 0.61
query14 0.78 0.80 0.78
query15 0.78 0.76 0.79
query16 0.38 0.40 0.39
query17 1.03 1.00 1.02
query18 0.21 0.28 0.23
query19 1.84 1.84 1.83
query20 0.01 0.01 0.01
query21 15.71 0.58 0.57
query22 2.56 2.94 1.39
query23 17.44 0.73 0.73
query24 2.35 1.04 1.26
query25 0.35 0.16 0.14
query26 0.54 0.15 0.13
query27 0.06 0.05 0.05
query28 12.39 0.86 0.83
query29 12.51 3.07 3.27
query30 0.63 0.55 0.59
query31 2.79 0.34 0.34
query32 3.39 0.48 0.48
query33 3.21 3.23 3.22
query34 15.71 4.37 4.28
query35 4.39 4.36 4.33
query36 1.10 1.05 1.06
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.16 0.12 0.12
query41 0.06 0.01 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.22 s
Total hot run time: 30.65 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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916160725
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916848771
TeamCity be ut coverage result:
Function Coverage: 36.20% (8626/23831)
Line Coverage: 28.26% (70538/249587)
Region Coverage: 27.26% (36400/133529)
Branch Coverage: 24.04% (18640/77524)
Coverage Report: http://coverage.selectdb-in.cc/coverage/584f4a1e1c1779868f966a5f0fdfe51872ad7f0d_584f4a1e1c1779868f966a5f0fdfe51872ad7f0d/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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916209289
<details>
<summary>ClickBench: <b>Total hot run time: 31.11 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.65 0.10 0.11
query5 0.53 0.52 0.52
query6 1.22 0.64 0.63
query7 0.02 0.01 0.01
query8 0.03 0.02 0.02
query9 0.54 0.50 0.50
query10 0.56 0.53 0.56
query11 0.12 0.08 0.09
query12 0.12 0.08 0.09
query13 0.58 0.61 0.60
query14 0.78 0.80 0.79
query15 0.79 0.78 0.78
query16 0.38 0.39 0.38
query17 1.05 1.03 1.03
query18 0.22 0.26 0.26
query19 1.80 1.80 1.81
query20 0.01 0.01 0.02
query21 15.40 0.56 0.60
query22 2.56 2.58 2.11
query23 17.45 0.77 0.90
query24 2.48 0.81 1.04
query25 0.35 0.31 0.06
query26 0.17 0.14 0.13
query27 0.05 0.05 0.04
query28 12.04 0.88 0.87
query29 12.68 3.20 3.08
query30 0.64 0.55 0.52
query31 2.78 0.35 0.35
query32 3.34 0.47 0.48
query33 3.17 3.22 3.23
query34 15.96 4.31 4.32
query35 4.28 4.28 4.35
query36 1.09 1.05 1.09
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.01
query40 0.15 0.14 0.12
query41 0.08 0.02 0.01
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.57 s
Total hot run time: 31.11 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] [feature](function) support tanh math function [doris]
Posted by "sjyango (via GitHub)" <gi...@apache.org>.
sjyango commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916166721
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] [feature](function) support tanh math function [doris]
Posted by "sjyango (via GitHub)" <gi...@apache.org>.
sjyango commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916073959
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916196544
TeamCity be ut coverage result:
Function Coverage: 36.20% (8625/23827)
Line Coverage: 28.26% (70536/249624)
Region Coverage: 27.25% (36392/133546)
Branch Coverage: 24.05% (18648/77554)
Coverage Report: http://coverage.selectdb-in.cc/coverage/584f4a1e1c1779868f966a5f0fdfe51872ad7f0d_584f4a1e1c1779868f966a5f0fdfe51872ad7f0d/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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916202978
<details>
<summary>TPC-DS: <b>Total hot run time: 172848 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
query1 948 333 323 323
query2 6554 2070 2083 2070
query3 6726 202 193 193
query4 27029 22100 22145 22100
query5 4452 357 420 357
query6 264 156 156 156
query7 4609 267 254 254
query8 242 177 170 170
query9 9322 2325 2308 2308
query10 414 203 201 201
query11 17043 15433 15380 15380
query12 121 67 65 65
query13 1675 365 367 365
query14 9291 6463 6504 6463
query15 214 175 183 175
query16 6467 254 241 241
query17 1918 464 473 464
query18 1953 257 250 250
query19 178 135 134 134
query20 71 73 70 70
query21 202 136 132 132
query22 4886 4620 4635 4620
query23 30956 30226 30325 30226
query24 7057 2764 2775 2764
query25 476 314 307 307
query26 813 138 134 134
query27 2500 285 284 284
query28 4162 1878 1836 1836
query29 931 610 619 610
query30 209 134 140 134
query31 904 735 699 699
query32 96 55 52 52
query33 420 208 210 208
query34 821 452 460 452
query35 843 772 755 755
query36 1275 1215 1152 1152
query37 95 57 59 57
query38 3278 3161 3215 3161
query39 1334 1249 1260 1249
query40 210 82 86 82
query41 37 35 34 34
query42 87 82 82 82
query43 527 473 481 473
query44 1098 684 693 684
query45 195 181 174 174
query46 1033 654 653 653
query47 1619 1485 1510 1485
query48 387 311 308 308
query49 592 293 276 276
query50 682 305 303 303
query51 5201 5193 5173 5173
query52 89 84 80 80
query53 329 253 266 253
query54 252 184 184 184
query55 80 80 84 80
query56 179 164 172 164
query57 976 913 923 913
query58 183 154 161 154
query59 2426 2254 2324 2254
query60 208 171 179 171
query61 83 83 82 82
query62 464 352 361 352
query63 271 267 264 264
query64 3642 1732 1729 1729
query65 3307 3214 3212 3212
query66 1110 318 308 308
query67 14281 14101 14067 14067
query68 4072 491 497 491
query69 445 299 311 299
query70 1552 1481 1539 1481
query71 294 214 215 214
query72 3708 2814 2822 2814
query73 697 320 306 306
query74 6562 6246 6244 6244
query75 2804 2335 2311 2311
query76 2921 963 960 960
query77 377 230 224 224
query78 9112 8825 8519 8519
query79 2789 486 478 478
query80 2139 315 312 312
query81 514 198 207 198
query82 741 82 80 80
query83 284 115 113 113
query84 283 73 75 73
query85 1916 336 318 318
query86 521 413 355 355
query87 3394 3294 3333 3294
query88 3705 2201 2162 2162
query89 403 340 344 340
query90 2030 185 182 182
query91 148 117 120 117
query92 52 44 43 43
query93 2964 445 437 437
query94 1318 154 157 154
query95 522 457 454 454
query96 625 308 314 308
query97 4236 4137 4138 4137
query98 210 193 192 192
query99 1047 673 684 673
Total cold run time: 262682 ms
Total hot run time: 172848 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916212808
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.3 seconds inserted 10000000 Rows, about 751K 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916091352
<details>
<summary>TPC-H: <b>Total hot run time: 37011 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 942cfd5e8928af60854446d545057c3593bda2fa, data reload: false
------ Round 1 ----------------------------------
q1 18011 4621 4523 4523
q2 2342 144 136 136
q3 11327 946 946 946
q4 4992 809 711 711
q5 7865 2838 2774 2774
q6 185 122 120 120
q7 1177 744 738 738
q8 9574 2019 2034 2019
q9 7624 6342 6311 6311
q10 8111 2431 2451 2431
q11 419 211 204 204
q12 755 258 278 258
q13 17999 3311 3290 3290
q14 277 249 244 244
q15 530 492 483 483
q16 453 402 410 402
q17 927 488 524 488
q18 6613 6138 5872 5872
q19 1557 1388 1363 1363
q20 586 340 308 308
q21 6599 3110 3087 3087
q22 797 306 303 303
Total cold run time: 108720 ms
Total hot run time: 37011 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4482 4517 4515 4515
q2 328 239 229 229
q3 3010 2857 2805 2805
q4 1842 1717 1612 1612
q5 5212 5233 5256 5233
q6 192 115 115 115
q7 2180 1735 1743 1735
q8 3095 3292 3253 3253
q9 8360 8295 8293 8293
q10 6069 3560 3597 3560
q11 541 450 466 450
q12 765 568 565 565
q13 5349 3143 3123 3123
q14 272 260 266 260
q15 538 484 491 484
q16 510 461 458 458
q17 1797 1692 1699 1692
q18 7979 7640 7518 7518
q19 10670 1555 1548 1548
q20 2144 1910 1894 1894
q21 4880 4644 4536 4536
q22 549 488 454 454
Total cold run time: 70764 ms
Total hot run time: 54332 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916190685
<details>
<summary>TPC-H: <b>Total hot run time: 36503 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
------ Round 1 ----------------------------------
q1 17673 4488 4326 4326
q2 2030 142 140 140
q3 10587 961 915 915
q4 4648 671 698 671
q5 7668 2807 2813 2807
q6 186 119 122 119
q7 1116 709 708 708
q8 9310 1979 1986 1979
q9 7220 6260 6310 6260
q10 8106 2408 2380 2380
q11 421 211 204 204
q12 793 274 277 274
q13 18021 3324 3280 3280
q14 267 253 251 251
q15 541 503 487 487
q16 509 405 429 405
q17 928 493 529 493
q18 6755 5929 5866 5866
q19 1535 1374 1319 1319
q20 582 344 299 299
q21 6706 3128 3022 3022
q22 807 298 311 298
Total cold run time: 106409 ms
Total hot run time: 36503 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4491 4287 4452 4287
q2 334 244 238 238
q3 2958 2840 2868 2840
q4 1935 1592 1635 1592
q5 5221 5220 5247 5220
q6 190 114 114 114
q7 2199 1849 1801 1801
q8 3097 3191 3233 3191
q9 8378 8374 8253 8253
q10 5817 3550 3522 3522
q11 541 450 461 450
q12 733 552 633 552
q13 13041 3084 3092 3084
q14 281 263 254 254
q15 528 496 488 488
q16 513 462 487 462
q17 1857 1652 1705 1652
q18 7921 7808 7566 7566
q19 10936 1521 1488 1488
q20 2142 1924 1914 1914
q21 4783 4535 4600 4535
q22 533 444 441 441
Total cold run time: 78429 ms
Total hot run time: 53944 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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916279517
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916829529
<details>
<summary>TPC-H: <b>Total hot run time: 37245 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
------ Round 1 ----------------------------------
q1 17600 4510 4434 4434
q2 2068 146 137 137
q3 10598 919 902 902
q4 4799 784 763 763
q5 8110 2830 2899 2830
q6 192 125 121 121
q7 1156 743 728 728
q8 9799 2073 2068 2068
q9 7536 6514 6451 6451
q10 8114 2454 2404 2404
q11 424 235 204 204
q12 749 276 272 272
q13 18004 3307 3275 3275
q14 269 245 242 242
q15 527 492 486 486
q16 471 394 397 394
q17 947 532 537 532
q18 6774 6034 5980 5980
q19 1566 1359 1328 1328
q20 616 350 320 320
q21 6734 3070 3187 3070
q22 810 316 304 304
Total cold run time: 107863 ms
Total hot run time: 37245 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4432 4353 4327 4327
q2 333 225 226 225
q3 2999 2841 2900 2841
q4 1904 1657 1682 1657
q5 5164 5312 5230 5230
q6 190 112 112 112
q7 2129 1789 1767 1767
q8 3102 3229 3265 3229
q9 8378 8344 8321 8321
q10 5865 3535 3569 3535
q11 534 455 469 455
q12 729 590 593 590
q13 8193 3070 3087 3070
q14 276 252 266 252
q15 528 492 490 490
q16 494 467 474 467
q17 1809 1711 1692 1692
q18 7998 8019 7746 7746
q19 6421 1495 1559 1495
q20 2117 1918 1906 1906
q21 4800 4640 4579 4579
q22 584 445 439 439
Total cold run time: 68979 ms
Total hot run time: 54425 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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916078911
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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916079428
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916866121
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.4 seconds inserted 10000000 Rows, about 746K 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916107607
<details>
<summary>ClickBench: <b>Total hot run time: 30.75 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 942cfd5e8928af60854446d545057c3593bda2fa, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.22 0.06 0.06
query4 1.68 0.09 0.10
query5 0.53 0.51 0.52
query6 1.21 0.63 0.64
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.56 0.49 0.49
query10 0.56 0.55 0.54
query11 0.12 0.08 0.08
query12 0.11 0.09 0.09
query13 0.60 0.61 0.60
query14 0.78 0.82 0.79
query15 0.80 0.79 0.77
query16 0.38 0.39 0.37
query17 1.02 1.00 0.99
query18 0.21 0.28 0.22
query19 1.88 1.79 1.78
query20 0.02 0.01 0.01
query21 15.40 0.57 0.56
query22 2.45 3.12 1.36
query23 17.29 0.79 0.74
query24 2.43 1.20 1.18
query25 0.32 0.33 0.10
query26 0.56 0.14 0.15
query27 0.05 0.05 0.04
query28 11.43 0.84 0.84
query29 12.50 3.22 3.22
query30 0.64 0.55 0.57
query31 2.79 0.35 0.35
query32 3.36 0.48 0.49
query33 3.19 3.22 3.23
query34 15.81 4.35 4.37
query35 4.39 4.23 4.36
query36 1.10 1.06 1.05
query37 0.07 0.05 0.04
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 104.94 s
Total hot run time: 30.75 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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916110592
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 942cfd5e8928af60854446d545057c3593bda2fa with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.7 seconds inserted 10000000 Rows, about 729K 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] [feature](function) support tanh math function [doris]
Posted by "sjyango (via GitHub)" <gi...@apache.org>.
sjyango commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916153414
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] [feature](function) support tanh math function [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916279568
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] [feature](function) support tanh math function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30555:
URL: https://github.com/apache/doris/pull/30555#issuecomment-1916849057
<details>
<summary>TPC-DS: <b>Total hot run time: 173425 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 584f4a1e1c1779868f966a5f0fdfe51872ad7f0d, data reload: false
query1 935 339 327 327
query2 6557 2133 1969 1969
query3 6698 211 207 207
query4 27452 22088 22013 22013
query5 4446 363 358 358
query6 265 168 158 158
query7 4612 260 261 260
query8 243 177 183 177
query9 9129 2240 2227 2227
query10 409 199 198 198
query11 16739 15399 15306 15306
query12 114 68 61 61
query13 1679 364 381 364
query14 9273 6519 6514 6514
query15 206 180 172 172
query16 6257 259 253 253
query17 1848 472 457 457
query18 1814 258 258 258
query19 173 133 138 133
query20 72 70 67 67
query21 201 133 131 131
query22 5184 4974 5041 4974
query23 31291 30373 30209 30209
query24 12407 2770 2765 2765
query25 598 307 299 299
query26 2052 132 137 132
query27 3165 283 276 276
query28 7898 1821 1808 1808
query29 2227 629 603 603
query30 290 134 142 134
query31 901 717 712 712
query32 94 52 55 52
query33 702 216 213 213
query34 1193 451 451 451
query35 864 747 774 747
query36 1272 1102 1119 1102
query37 180 55 61 55
query38 3257 3153 3137 3137
query39 1323 1232 1252 1232
query40 325 90 86 86
query41 37 37 35 35
query42 89 80 85 80
query43 520 501 492 492
query44 1171 680 687 680
query45 188 178 173 173
query46 1050 640 647 640
query47 1541 1525 1493 1493
query48 389 307 307 307
query49 1271 294 279 279
query50 672 313 317 313
query51 5281 5121 5161 5121
query52 86 74 75 74
query53 314 260 251 251
query54 248 191 191 191
query55 85 74 75 74
query56 178 158 163 158
query57 952 920 974 920
query58 191 153 152 152
query59 2563 2335 2335 2335
query60 198 173 190 173
query61 82 84 85 84
query62 607 354 356 354
query63 274 263 268 263
query64 5713 1792 1748 1748
query65 3303 3235 3195 3195
query66 1487 318 327 318
query67 14814 14546 14580 14546
query68 3756 483 487 483
query69 438 317 297 297
query70 1525 1548 1462 1462
query71 298 221 225 221
query72 3643 2822 2873 2822
query73 702 313 318 313
query74 6515 6224 6275 6224
query75 2794 2335 2330 2330
query76 2898 967 931 931
query77 438 231 233 231
query78 9060 8747 8593 8593
query79 2568 505 499 499
query80 1528 341 312 312
query81 517 199 197 197
query82 835 81 80 80
query83 221 118 126 118
query84 239 76 69 69
query85 1623 348 346 346
query86 508 391 382 382
query87 3464 3232 3260 3232
query88 3474 2281 2268 2268
query89 410 341 351 341
query90 2175 187 187 187
query91 148 117 119 117
query92 58 47 43 43
query93 1889 437 404 404
query94 1506 157 158 157
query95 495 462 440 440
query96 632 328 346 328
query97 4284 4108 4092 4092
query98 206 198 185 185
query99 1239 679 675 675
Total cold run time: 277735 ms
Total hot run time: 173425 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