doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[enhancement](plsql) add regression for failure path
Proposed changes
Issue Number: close #xxx
add regression for exception scenarios.
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.
TPC-DS: Total hot run time: 185588 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 4ca9589667ca41cdf33aa141c2f14ef2389ee723, data reload: false
query1 894 357 351 351
query2 7803 2293 2549 2293
query3 6651 216 224 216
query4 23554 21125 21221 21125
query5 4195 427 440 427
query6 304 179 181 179
query7 4585 299 303 299
query8 255 193 197 193
query9 8632 2363 2335 2335
query10 453 252 272 252
query11 14741 14200 14176 14176
query12 139 89 86 86
query13 1624 350 356 350
query14 9809 6681 7527 6681
query15 220 174 174 174
query16 7841 261 260 260
query17 1856 576 575 575
query18 2000 274 270 270
query19 200 151 150 150
query20 95 86 86 86
query21 192 129 130 129
query22 4945 4881 4828 4828
query23 33711 33323 33420 33323
query24 11946 2982 2985 2982
query25 667 371 368 368
query26 1812 158 150 150
query27 3053 316 321 316
query28 7586 2023 1995 1995
query29 1068 598 588 588
query30 290 149 153 149
query31 940 740 703 703
query32 91 51 54 51
query33 739 251 242 242
query34 1069 477 486 477
query35 812 685 683 683
query36 1064 906 854 854
query37 145 67 70 67
query38 3145 3039 3016 3016
query39 1588 1542 1557 1542
query40 271 127 125 125
query41 43 39 39 39
query42 104 99 102 99
query43 591 578 545 545
query44 1281 745 763 745
query45 284 277 272 272
query46 1086 735 755 735
query47 1947 1829 1848 1829
query48 382 290 293 290
query49 1198 387 402 387
query50 771 404 389 389
query51 6964 6658 6695 6658
query52 110 94 94 94
query53 352 287 287 287
query54 302 240 244 240
query55 81 73 72 72
query56 261 221 221 221
query57 1199 1105 1133 1105
query58 225 201 203 201
query59 3542 3135 3209 3135
query60 279 254 229 229
query61 91 87 114 87
query62 637 455 457 455
query63 305 282 291 282
query64 9566 7123 7180 7123
query65 3144 3094 3016 3016
query66 1350 337 344 337
query67 15360 15289 14985 14985
query68 5248 532 533 532
query69 482 325 308 308
query70 1148 1105 1065 1065
query71 402 279 274 274
query72 7718 2738 2560 2560
query73 715 326 325 325
query74 6516 6111 6062 6062
query75 3437 2659 2692 2659
query76 3142 989 962 962
query77 449 279 277 277
query78 11113 10231 10224 10224
query79 8798 542 517 517
query80 1932 451 447 447
query81 541 227 221 221
query82 1466 92 94 92
query83 276 172 169 169
query84 267 82 86 82
query85 2149 274 260 260
query86 503 316 260 260
query87 3313 3089 3083 3083
query88 5176 2325 2335 2325
query89 525 393 375 375
query90 1980 184 188 184
query91 125 96 96 96
query92 63 48 50 48
query93 6131 521 505 505
query94 1276 187 183 183
query95 397 308 306 306
query96 621 280 273 273
query97 3110 2939 2936 2936
query98 229 219 225 219
query99 1227 862 836 836
Total cold run time: 302915 ms
Total hot run time: 185588 ms
TPC-H: Total hot run time: 41805 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2d6c8808aa9900c43b7284824485bf4825a891e2, data reload: false
------ Round 1 ----------------------------------
q1 17611 4336 4205 4205
q2 2024 187 190 187
q3 10465 1210 1173 1173
q4 10188 760 859 760
q5 7510 2713 2696 2696
q6 224 133 135 133
q7 1066 627 615 615
q8 9239 2143 2077 2077
q9 9410 6748 6722 6722
q10 9181 3819 3932 3819
q11 460 247 253 247
q12 432 225 242 225
q13 17632 3281 3120 3120
q14 264 234 212 212
q15 515 479 483 479
q16 523 412 401 401
q17 984 705 686 686
q18 8136 7689 7690 7689
q19 4013 1574 1543 1543
q20 632 312 327 312
q21 5195 4227 4269 4227
q22 369 277 295 277
Total cold run time: 116073 ms
Total hot run time: 41805 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4546 4369 4458 4369
q2 376 274 273 273
q3 3156 2941 2884 2884
q4 1975 1660 1748 1660
q5 5331 5440 5494 5440
q6 221 126 125 125
q7 2307 1987 1965 1965
q8 3240 3406 3400 3400
q9 8729 8715 8728 8715
q10 4036 3836 3697 3697
q11 577 479 481 479
q12 764 617 605 605
q13 16020 3155 3092 3092
q14 282 270 275 270
q15 522 493 480 480
q16 490 447 419 419
q17 1813 1493 1516 1493
q18 8148 7495 7372 7372
q19 1650 1545 1466 1466
q20 2037 1769 1738 1738
q21 13897 4848 4960 4848
q22 598 505 479 479
Total cold run time: 80715 ms
Total hot run time: 55269 ms
TPC-DS: Total hot run time: 186238 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 2d6c8808aa9900c43b7284824485bf4825a891e2, data reload: false
query1 927 366 365 365
query2 6632 2468 2303 2303
query3 6632 206 211 206
query4 23168 21120 21080 21080
query5 4139 431 439 431
query6 266 181 172 172
query7 4594 296 287 287
query8 241 185 196 185
query9 8586 2397 2382 2382
query10 433 252 288 252
query11 14960 14159 14176 14159
query12 143 98 94 94
query13 1666 378 384 378
query14 9224 7636 7577 7577
query15 222 172 175 172
query16 7770 261 269 261
query17 1646 608 564 564
query18 1961 288 276 276
query19 203 155 158 155
query20 95 85 89 85
query21 194 130 126 126
query22 5037 4759 4855 4759
query23 33463 33296 33380 33296
query24 5968 2877 2915 2877
query25 470 371 358 358
query26 693 156 149 149
query27 1852 315 334 315
query28 3693 2091 2045 2045
query29 813 599 609 599
query30 248 151 152 151
query31 956 745 721 721
query32 58 51 54 51
query33 473 256 250 250
query34 873 470 474 470
query35 775 682 664 664
query36 1016 936 895 895
query37 106 68 68 68
query38 3144 3004 3003 3003
query39 1620 1548 1529 1529
query40 206 129 129 129
query41 41 38 40 38
query42 104 97 97 97
query43 550 536 516 516
query44 1093 731 755 731
query45 273 246 248 246
query46 1062 736 706 706
query47 1933 1879 1856 1856
query48 368 313 300 300
query49 776 404 411 404
query50 786 393 387 387
query51 6766 6566 6674 6566
query52 105 91 92 91
query53 348 280 284 280
query54 267 234 237 234
query55 83 73 72 72
query56 245 224 220 220
query57 1200 1134 1137 1134
query58 215 200 199 199
query59 3445 3230 3248 3230
query60 264 238 240 238
query61 89 88 86 86
query62 562 468 458 458
query63 312 281 276 276
query64 7580 7234 7149 7149
query65 3101 3034 3069 3034
query66 787 331 339 331
query67 15590 14945 15197 14945
query68 5243 528 537 528
query69 490 308 303 303
query70 1136 1081 1064 1064
query71 396 272 270 270
query72 7340 2579 2356 2356
query73 690 329 319 319
query74 6488 6111 6054 6054
query75 3350 2666 2624 2624
query76 2842 1093 1012 1012
query77 414 269 270 269
query78 11231 10282 10301 10282
query79 8126 534 528 528
query80 2193 452 433 433
query81 514 230 217 217
query82 1498 98 114 98
query83 299 168 170 168
query84 271 89 90 89
query85 1567 272 270 270
query86 518 294 305 294
query87 3261 3114 3071 3071
query88 5280 2327 2353 2327
query89 522 381 376 376
query90 2055 185 185 185
query91 129 102 97 97
query92 66 52 47 47
query93 6935 527 516 516
query94 1237 191 190 190
query95 401 305 301 301
query96 616 273 262 262
query97 3174 2926 2925 2925
query98 240 219 221 219
query99 1218 881 884 881
Total cold run time: 282851 ms
Total hot run time: 186238 ms
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}