doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[enhancement](testutil) Add math function ut test case
Proposed changes
Further comments
If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
PR approved by at least one committer and no changes requested.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TeamCity be ut coverage result: Function Coverage: 36.41% (8986/24677) Line Coverage: 27.93% (73402/262832) Region Coverage: 27.37% (38017/138898) Branch Coverage: 23.96% (19299/80534) Coverage Report: http://coverage.selectdb-in.cc/coverage/3d9524710490154b83d3111068db1ae7233c8a8e_3d9524710490154b83d3111068db1ae7233c8a8e/report/index.html
TPC-H: Total hot run time: 41591 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 3d9524710490154b83d3111068db1ae7233c8a8e, data reload: false
------ Round 1 ----------------------------------
q1 17607 4450 4276 4276
q2 2021 191 200 191
q3 10453 1154 1094 1094
q4 10183 795 868 795
q5 7510 2693 2725 2693
q6 223 139 131 131
q7 1003 619 609 609
q8 9215 2127 2089 2089
q9 9412 6687 6646 6646
q10 9714 3891 3929 3891
q11 442 241 247 241
q12 419 249 224 224
q13 17266 3227 3278 3227
q14 260 222 219 219
q15 505 480 465 465
q16 474 398 388 388
q17 1003 587 641 587
q18 8314 7913 7822 7822
q19 7643 1368 1375 1368
q20 649 328 334 328
q21 5312 4015 3974 3974
q22 397 341 333 333
Total cold run time: 120025 ms
Total hot run time: 41591 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4615 4517 4462 4462
q2 366 271 259 259
q3 3228 2866 2772 2772
q4 1876 1679 1654 1654
q5 5519 5530 5491 5491
q6 224 127 123 123
q7 2194 1875 1851 1851
q8 3258 3388 3370 3370
q9 8604 8719 8755 8719
q10 4040 3757 3675 3675
q11 594 493 497 493
q12 800 645 636 636
q13 16048 3110 3109 3109
q14 303 265 286 265
q15 507 477 492 477
q16 489 416 454 416
q17 1806 1499 1520 1499
q18 8267 7429 7228 7228
q19 1772 1510 1536 1510
q20 3023 1832 1755 1755
q21 6915 4760 4688 4688
q22 583 531 511 511
Total cold run time: 75031 ms
Total hot run time: 54963 ms
TPC-DS: Total hot run time: 169453 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 3d9524710490154b83d3111068db1ae7233c8a8e, data reload: false
query1 914 379 376 376
query2 6449 2415 2140 2140
query3 6643 206 207 206
query4 19956 17443 17318 17318
query5 4125 446 455 446
query6 241 164 166 164
query7 4576 298 290 290
query8 318 281 286 281
query9 8457 2421 2408 2408
query10 448 295 275 275
query11 10538 10175 10220 10175
query12 137 85 86 85
query13 1650 373 362 362
query14 10016 7693 6829 6829
query15 227 187 184 184
query16 7673 264 261 261
query17 1687 517 506 506
query18 1800 270 264 264
query19 201 156 148 148
query20 89 82 82 82
query21 207 131 128 128
query22 4305 4074 4005 4005
query23 33652 33086 33090 33086
query24 10884 2789 2792 2789
query25 622 350 391 350
query26 1230 151 151 151
query27 2934 314 310 310
query28 7406 2065 2060 2060
query29 885 629 607 607
query30 268 148 149 148
query31 925 763 722 722
query32 94 50 52 50
query33 747 281 274 274
query34 918 467 464 464
query35 738 609 621 609
query36 1094 943 922 922
query37 157 72 71 71
query38 2863 2764 2761 2761
query39 885 791 804 791
query40 208 126 128 126
query41 55 54 55 54
query42 118 98 101 98
query43 617 546 524 524
query44 1213 735 737 735
query45 197 166 168 166
query46 1081 738 716 716
query47 1891 1818 1784 1784
query48 371 302 289 289
query49 1007 422 428 422
query50 789 391 387 387
query51 6800 6918 6673 6673
query52 102 88 97 88
query53 360 290 294 290
query54 840 443 435 435
query55 76 74 72 72
query56 274 259 261 259
query57 1134 1044 1013 1013
query58 267 248 240 240
query59 3355 2978 3067 2978
query60 286 266 262 262
query61 90 88 121 88
query62 630 440 452 440
query63 319 291 288 288
query64 8870 2189 1722 1722
query65 3201 3100 3303 3100
query66 1215 333 360 333
query67 15183 15118 15013 15013
query68 4565 535 522 522
query69 619 433 393 393
query70 1155 1107 1123 1107
query71 422 290 283 283
query72 7167 2749 2534 2534
query73 755 323 322 322
query74 5834 5528 5534 5528
query75 3349 2657 2695 2657
query76 2192 982 911 911
query77 641 300 286 286
query78 10167 9958 9697 9697
query79 1431 514 508 508
query80 1771 462 459 459
query81 557 221 222 221
query82 781 103 97 97
query83 296 172 166 166
query84 258 86 82 82
query85 1075 289 349 289
query86 373 289 294 289
query87 3289 3144 3097 3097
query88 3263 2320 2312 2312
query89 485 389 389 389
query90 1810 187 190 187
query91 122 98 96 96
query92 61 47 48 47
query93 1503 512 496 496
query94 1157 187 180 180
query95 395 311 304 304
query96 582 263 263 263
query97 3172 2976 3042 2976
query98 259 218 225 218
query99 1106 849 844 844
Total cold run time: 268120 ms
Total hot run time: 169453 ms
ClickBench: Total hot run time: 31.99 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 3d9524710490154b83d3111068db1ae7233c8a8e, data reload: false
query1 0.04 0.04 0.03
query2 0.07 0.04 0.04
query3 0.22 0.06 0.05
query4 1.67 0.07 0.08
query5 0.50 0.49 0.50
query6 1.13 0.72 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.54 0.48 0.48
query10 0.54 0.55 0.53
query11 0.15 0.12 0.12
query12 0.15 0.12 0.11
query13 0.60 0.58 0.60
query14 0.77 0.81 0.79
query15 0.84 0.84 0.81
query16 0.35 0.37 0.35
query17 0.97 1.05 1.00
query18 0.23 0.25 0.22
query19 1.77 1.79 1.71
query20 0.02 0.01 0.01
query21 15.46 0.68 0.67
query22 4.27 6.08 3.12
query23 18.32 1.38 1.35
query24 1.32 0.43 0.23
query25 0.14 0.09 0.08
query26 0.28 0.17 0.18
query27 0.07 0.07 0.08
query28 13.25 1.01 0.98
query29 13.30 3.43 3.41
query30 0.24 0.06 0.05
query31 2.87 0.39 0.38
query32 3.29 0.47 0.46
query33 2.84 2.92 2.95
query34 17.21 4.48 4.40
query35 4.49 4.50 4.71
query36 0.66 0.49 0.46
query37 0.17 0.15 0.16
query38 0.16 0.15 0.15
query39 0.04 0.04 0.03
query40 0.16 0.14 0.13
query41 0.09 0.05 0.04
query42 0.04 0.04 0.04
query43 0.04 0.04 0.04
Total cold run time: 109.34 s
Total hot run time: 31.99 s