doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[fix](decimal) round result of decimal divide
Proposed changes
Issue Number: close #xxx
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.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TPC-DS: Total hot run time: 171561 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 cf1b955dd27e85f5eb222f2b467a2a14057edc9c, data reload: false
query1 924 370 366 366
query2 6321 2599 2474 2474
query3 6649 214 208 208
query4 19680 17813 17714 17714
query5 3906 432 420 420
query6 246 160 159 159
query7 4677 302 317 302
query8 232 197 186 186
query9 8763 2441 2419 2419
query10 429 280 255 255
query11 11087 10581 10624 10581
query12 121 80 88 80
query13 1657 376 366 366
query14 8532 7935 7900 7900
query15 272 176 181 176
query16 8200 281 292 281
query17 1734 573 539 539
query18 2048 282 277 277
query19 266 161 171 161
query20 88 91 79 79
query21 195 128 121 121
query22 4204 4053 4082 4053
query23 33745 33027 32929 32929
query24 10604 2833 2920 2833
query25 609 373 375 373
query26 1121 160 165 160
query27 2413 311 313 311
query28 7162 2058 2020 2020
query29 849 620 596 596
query30 220 171 171 171
query31 976 732 752 732
query32 83 51 51 51
query33 749 259 269 259
query34 1010 472 476 472
query35 711 622 599 599
query36 1060 905 922 905
query37 139 74 68 68
query38 2881 2794 2806 2794
query39 859 788 799 788
query40 196 146 124 124
query41 43 45 43 43
query42 101 101 98 98
query43 567 557 548 548
query44 1244 732 723 723
query45 178 154 158 154
query46 1079 700 725 700
query47 1886 1818 1767 1767
query48 362 291 295 291
query49 884 374 397 374
query50 752 385 393 385
query51 6946 6903 6741 6741
query52 102 92 87 87
query53 365 283 293 283
query54 861 422 413 413
query55 75 74 74 74
query56 264 240 246 240
query57 1144 1084 1038 1038
query58 252 205 205 205
query59 3365 3220 3267 3220
query60 278 261 266 261
query61 90 89 87 87
query62 652 437 457 437
query63 314 289 284 284
query64 8799 2212 1765 1765
query65 3131 3068 3106 3068
query66 809 318 323 318
query67 15493 14902 15093 14902
query68 6263 542 543 542
query69 511 277 270 270
query70 1211 1044 1131 1044
query71 498 269 278 269
query72 8003 3831 2530 2530
query73 808 320 322 320
query74 6062 5637 5542 5542
query75 4243 2621 2663 2621
query76 4345 1012 1019 1012
query77 687 267 271 267
query78 10335 10008 9781 9781
query79 2827 521 504 504
query80 1483 435 440 435
query81 559 250 239 239
query82 844 105 94 94
query83 202 175 225 175
query84 264 80 91 80
query85 1361 278 270 270
query86 460 326 308 308
query87 3344 3089 3127 3089
query88 3921 2344 2351 2344
query89 480 377 366 366
query90 1943 193 188 188
query91 146 96 97 96
query92 63 48 51 48
query93 2306 501 498 498
query94 1116 185 188 185
query95 399 314 305 305
query96 580 266 267 266
query97 3203 3085 2983 2983
query98 234 209 219 209
query99 1229 892 873 873
Total cold run time: 275584 ms
Total hot run time: 171561 ms
ClickBench: Total hot run time: 30.63 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit cf1b955dd27e85f5eb222f2b467a2a14057edc9c, data reload: false
query1 0.04 0.03 0.03
query2 0.09 0.04 0.04
query3 0.23 0.06 0.05
query4 1.70 0.10 0.08
query5 0.50 0.49 0.50
query6 1.12 0.73 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.48 0.48
query10 0.55 0.55 0.53
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.59 0.59 0.60
query14 0.77 0.78 0.77
query15 0.82 0.82 0.82
query16 0.36 0.35 0.36
query17 0.93 0.93 0.93
query18 0.22 0.24 0.23
query19 1.78 1.71 1.66
query20 0.02 0.01 0.01
query21 15.73 0.66 0.65
query22 4.24 7.47 1.91
query23 18.30 1.39 1.24
query24 1.85 0.25 0.21
query25 0.14 0.08 0.08
query26 0.27 0.16 0.17
query27 0.09 0.07 0.07
query28 13.37 1.11 1.09
query29 13.13 3.29 3.29
query30 0.23 0.05 0.06
query31 2.87 0.39 0.39
query32 3.27 0.48 0.47
query33 2.87 2.92 2.91
query34 17.21 4.45 4.43
query35 4.43 4.76 4.56
query36 0.64 0.47 0.46
query37 0.17 0.15 0.16
query38 0.14 0.14 0.14
query39 0.04 0.04 0.03
query40 0.16 0.15 0.15
query41 0.09 0.05 0.05
query42 0.06 0.04 0.05
query43 0.03 0.03 0.04
Total cold run time: 109.96 s
Total hot run time: 30.63 s
PR approved by at least one committer and no changes requested.