doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[fix](json function) fix failed when json_exists_path use not null input
Proposed changes
BE has not implemented the code for "return type not nullable."
CREATE TABLE test_json (
id INT not null,
j JSON not null
)
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES("replication_num" = "1");
INSERT INTO test_json VALUES(26, '{"k1":"v1", "k2": 200}');
SELECT id, j, json_exists_path(j, '$.k1') FROM test_json ORDER BY id;
ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.6)[INTERNAL_ERROR]Function jsonb_exists_path get failed, expr is VectorizedFnCall[jsonb_exists_path](arguments=j, String,return=UInt8) and return type is UInt8.
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}
TeamCity be ut coverage result: Function Coverage: 35.60% (8933/25096) Line Coverage: 27.22% (73669/270621) Region Coverage: 26.41% (38051/144088) Branch Coverage: 23.19% (19391/83634) Coverage Report: http://coverage.selectdb-in.cc/coverage/39e687719127de64df1d647877137d0edf26fe6b_39e687719127de64df1d647877137d0edf26fe6b/report/index.html
TPC-DS: Total hot run time: 187589 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 39e687719127de64df1d647877137d0edf26fe6b, data reload: false
query1 913 366 350 350
query2 6566 2313 2379 2313
query3 6646 216 217 216
query4 23630 22108 21996 21996
query5 3902 442 422 422
query6 248 176 172 172
query7 4682 313 301 301
query8 253 192 198 192
query9 8618 2396 2374 2374
query10 423 256 269 256
query11 15299 14797 14891 14797
query12 139 90 87 87
query13 1690 384 371 371
query14 10342 6974 7029 6974
query15 251 170 160 160
query16 8114 255 260 255
query17 1694 553 556 553
query18 2085 268 273 268
query19 233 144 148 144
query20 88 83 82 82
query21 189 133 123 123
query22 5059 4840 4834 4834
query23 33661 33026 32979 32979
query24 10754 2965 2911 2911
query25 612 381 359 359
query26 1366 152 152 152
query27 3031 320 315 315
query28 7735 2008 1990 1990
query29 870 595 614 595
query30 248 150 149 149
query31 937 755 743 743
query32 84 51 53 51
query33 728 252 243 243
query34 1034 482 487 482
query35 821 664 664 664
query36 1045 896 894 894
query37 122 66 67 66
query38 3154 2999 3059 2999
query39 1571 1513 1524 1513
query40 232 130 125 125
query41 40 37 37 37
query42 108 97 96 96
query43 575 532 563 532
query44 1266 735 745 735
query45 264 272 247 247
query46 1076 736 701 701
query47 1922 1816 1814 1814
query48 368 295 297 295
query49 885 403 381 381
query50 764 384 385 384
query51 6802 6713 6827 6713
query52 103 94 90 90
query53 354 276 281 276
query54 292 231 229 229
query55 77 72 75 72
query56 251 219 222 219
query57 1203 1108 1115 1108
query58 223 200 196 196
query59 3336 3011 3172 3011
query60 255 235 234 234
query61 93 88 86 86
query62 638 447 462 447
query63 302 277 279 277
query64 8555 7205 7227 7205
query65 3118 3054 3071 3054
query66 1365 330 336 330
query67 15779 14924 15204 14924
query68 5273 530 541 530
query69 490 299 303 299
query70 1173 1085 1142 1085
query71 397 269 282 269
query72 7171 2607 2406 2406
query73 703 321 320 320
query74 6602 6157 6121 6121
query75 3350 2688 2695 2688
query76 3160 1043 995 995
query77 391 274 269 269
query78 10968 10257 10280 10257
query79 2838 533 539 533
query80 1931 448 435 435
query81 556 225 232 225
query82 787 92 95 92
query83 276 173 168 168
query84 267 92 83 83
query85 2156 266 262 262
query86 517 284 302 284
query87 3279 3055 3030 3030
query88 4490 2327 2401 2327
query89 465 375 380 375
query90 2027 191 189 189
query91 124 95 96 95
query92 64 50 47 47
query93 4066 502 507 502
query94 1214 183 181 181
query95 1101 1094 1093 1093
query96 625 267 265 265
query97 3177 2947 2988 2947
query98 259 223 214 214
query99 1227 845 840 840
Total cold run time: 290207 ms
Total hot run time: 187589 ms
TPC-H: Total hot run time: 40257 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 9e7f5bbc3db7a9fe53b4663dc5c0f5430552c57a, data reload: false
------ Round 1 ----------------------------------
q1 17602 4518 4356 4356
q2 3033 215 223 215
q3 11754 1214 1237 1214
q4 10370 811 726 726
q5 7720 2782 2665 2665
q6 215 134 136 134
q7 1046 635 619 619
q8 9332 2133 2095 2095
q9 8899 6656 6582 6582
q10 8869 3751 3722 3722
q11 441 250 241 241
q12 421 222 226 222
q13 18859 2934 3096 2934
q14 279 239 236 236
q15 501 476 472 472
q16 524 379 392 379
q17 967 730 792 730
q18 8109 7489 7380 7380
q19 4163 1544 1496 1496
q20 650 320 310 310
q21 5042 3258 3310 3258
q22 340 275 271 271
Total cold run time: 119136 ms
Total hot run time: 40257 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4304 4181 4186 4181
q2 379 266 256 256
q3 3002 2806 2749 2749
q4 1884 1613 1629 1613
q5 5320 5328 5336 5328
q6 208 124 125 124
q7 2267 1866 1872 1866
q8 3220 3347 3378 3347
q9 8605 8550 8548 8548
q10 3910 3722 3754 3722
q11 584 488 487 487
q12 759 620 586 586
q13 17457 3007 2969 2969
q14 316 287 266 266
q15 513 483 470 470
q16 492 420 414 414
q17 1790 1484 1470 1470
q18 7656 7429 7559 7429
q19 1650 1525 1494 1494
q20 2003 1748 1797 1748
q21 4998 4935 4812 4812
q22 564 483 482 482
Total cold run time: 71881 ms
Total hot run time: 54361 ms
TeamCity be ut coverage result: Function Coverage: 35.60% (8933/25096) Line Coverage: 27.22% (73665/270621) Region Coverage: 26.41% (38060/144088) Branch Coverage: 23.19% (19395/83634) Coverage Report: http://coverage.selectdb-in.cc/coverage/9e7f5bbc3db7a9fe53b4663dc5c0f5430552c57a_9e7f5bbc3db7a9fe53b4663dc5c0f5430552c57a/report/index.html
TPC-DS: Total hot run time: 186644 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 9e7f5bbc3db7a9fe53b4663dc5c0f5430552c57a, data reload: false
query1 912 363 348 348
query2 6452 2354 2149 2149
query3 6673 215 217 215
query4 23245 21152 21300 21152
query5 4162 435 426 426
query6 285 183 182 182
query7 4592 286 282 282
query8 248 204 187 187
query9 8558 2358 2314 2314
query10 438 246 269 246
query11 14648 14162 14174 14162
query12 135 88 87 87
query13 1629 352 376 352
query14 9596 8429 7586 7586
query15 269 168 175 168
query16 8179 253 262 253
query17 1854 554 564 554
query18 2114 277 258 258
query19 313 147 147 147
query20 90 84 84 84
query21 193 129 125 125
query22 5012 4864 4830 4830
query23 33859 33028 33046 33028
query24 11048 2944 2906 2906
query25 646 391 376 376
query26 1412 161 149 149
query27 2937 319 331 319
query28 7302 2015 2012 2012
query29 944 630 611 611
query30 297 154 157 154
query31 953 740 736 736
query32 98 61 64 61
query33 758 254 255 254
query34 1002 476 481 476
query35 836 669 661 661
query36 1060 900 908 900
query37 138 69 70 69
query38 3136 3001 2936 2936
query39 1574 1590 1540 1540
query40 287 130 130 130
query41 45 42 41 41
query42 105 100 99 99
query43 567 516 536 516
query44 1252 731 750 731
query45 277 263 280 263
query46 1088 729 753 729
query47 1927 1836 1862 1836
query48 370 293 299 293
query49 1122 434 413 413
query50 775 386 393 386
query51 6817 6767 6751 6751
query52 107 95 94 94
query53 351 283 286 283
query54 331 243 242 242
query55 82 75 73 73
query56 248 235 229 229
query57 1199 1153 1142 1142
query58 227 203 199 199
query59 3316 2986 3050 2986
query60 266 250 240 240
query61 111 104 104 104
query62 660 453 439 439
query63 308 283 358 283
query64 8831 7177 7124 7124
query65 3160 3043 3062 3043
query66 1401 335 329 329
query67 15756 14959 15052 14959
query68 9804 549 532 532
query69 582 307 304 304
query70 1390 1151 1069 1069
query71 503 268 265 265
query72 8213 2571 2372 2372
query73 1637 323 324 323
query74 6468 6048 6091 6048
query75 4828 2667 2687 2667
query76 5390 997 1021 997
query77 641 269 264 264
query78 10858 10354 10359 10354
query79 9556 518 518 518
query80 1809 436 426 426
query81 503 223 221 221
query82 170 92 94 92
query83 230 166 165 165
query84 263 85 81 81
query85 1184 288 253 253
query86 331 317 288 288
query87 3306 3098 3096 3096
query88 4664 2338 2333 2333
query89 498 370 372 370
query90 2462 182 179 179
query91 123 93 95 93
query92 64 46 45 45
query93 4671 510 503 503
query94 1604 182 191 182
query95 1090 1099 1092 1092
query96 611 262 265 262
query97 3107 2943 2971 2943
query98 228 224 215 215
query99 1045 840 876 840
Total cold run time: 306416 ms
Total hot run time: 186644 ms
PR approved by at least one committer and no changes requested.
The code seems ugly, we better impl json_exists_path in other function not in json_extract
TeamCity be ut coverage result: Function Coverage: 35.67% (8967/25142) Line Coverage: 27.28% (73983/271195) Region Coverage: 26.48% (38226/144380) Branch Coverage: 23.22% (19462/83820) Coverage Report: http://coverage.selectdb-in.cc/coverage/88ea0c0b55e72f5d9f53aa3abca32a86760cd992_88ea0c0b55e72f5d9f53aa3abca32a86760cd992/report/index.html
TPC-DS: Total hot run time: 187020 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 88ea0c0b55e72f5d9f53aa3abca32a86760cd992, data reload: false
query1 904 357 345 345
query2 6280 2316 2359 2316
query3 6646 208 211 208
query4 26145 21809 21802 21802
query5 3807 431 423 423
query6 254 188 174 174
query7 4548 308 304 304
query8 241 186 194 186
query9 8432 2419 2456 2419
query10 423 262 261 261
query11 15358 14737 14854 14737
query12 124 88 92 88
query13 1603 373 371 371
query14 9604 7677 7394 7394
query15 268 167 166 166
query16 8190 260 263 260
query17 1770 587 558 558
query18 2104 287 275 275
query19 329 155 159 155
query20 89 83 85 83
query21 202 130 126 126
query22 4997 4806 4857 4806
query23 33998 33306 33106 33106
query24 10582 2846 2839 2839
query25 626 381 390 381
query26 1148 157 154 154
query27 2555 313 316 313
query28 6988 2035 2039 2035
query29 866 682 618 618
query30 249 150 146 146
query31 964 711 707 707
query32 88 51 51 51
query33 729 245 247 245
query34 1030 476 479 476
query35 781 654 658 654
query36 1093 898 918 898
query37 128 69 64 64
query38 3148 3038 3056 3038
query39 1594 1538 1526 1526
query40 197 128 126 126
query41 39 38 37 37
query42 102 96 97 96
query43 585 559 549 549
query44 1197 733 734 733
query45 259 233 263 233
query46 1071 721 730 721
query47 1933 1873 1851 1851
query48 380 286 290 286
query49 829 396 396 396
query50 770 386 381 381
query51 6711 6636 6630 6630
query52 107 98 91 91
query53 351 281 288 281
query54 302 234 238 234
query55 80 79 73 73
query56 242 218 217 217
query57 1191 1149 1146 1146
query58 231 203 203 203
query59 3708 3260 3381 3260
query60 255 235 244 235
query61 90 86 89 86
query62 648 454 455 454
query63 315 285 280 280
query64 8590 7197 7259 7197
query65 3073 3064 3045 3045
query66 831 331 329 329
query67 15735 14842 15072 14842
query68 9408 543 551 543
query69 596 309 309 309
query70 1408 1047 1127 1047
query71 518 278 276 276
query72 8251 2563 2339 2339
query73 1591 321 326 321
query74 6605 6005 6125 6005
query75 5158 2678 2626 2626
query76 5622 992 1042 992
query77 793 268 277 268
query78 11095 10167 10151 10151
query79 11711 524 522 522
query80 1429 439 431 431
query81 501 218 219 218
query82 231 93 90 90
query83 201 165 171 165
query84 269 84 82 82
query85 1099 265 266 265
query86 346 319 297 297
query87 3375 3062 3077 3062
query88 5154 2337 2333 2333
query89 524 379 377 377
query90 2393 184 185 184
query91 124 97 98 97
query92 62 51 50 50
query93 7164 505 492 492
query94 1565 180 183 180
query95 411 299 314 299
query96 618 263 265 263
query97 3116 2948 2976 2948
query98 233 217 218 217
query99 1127 905 851 851
Total cold run time: 311405 ms
Total hot run time: 187020 ms
TPC-H: Total hot run time: 40608 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit c52138757287a3d733053004fc8419352baede92, data reload: false
------ Round 1 ----------------------------------
q1 17599 4367 4254 4254
q2 2017 191 196 191
q3 10471 1222 1133 1133
q4 10157 747 810 747
q5 7478 2698 2595 2595
q6 217 131 130 130
q7 1034 600 575 575
q8 9225 2140 2088 2088
q9 9147 6658 6544 6544
q10 9033 3726 3770 3726
q11 482 241 228 228
q12 454 221 214 214
q13 17773 2972 2986 2972
q14 250 222 217 217
q15 503 476 473 473
q16 505 395 376 376
q17 971 709 702 702
q18 8000 7337 7290 7290
q19 1656 1572 1558 1558
q20 653 319 304 304
q21 5210 4022 4091 4022
q22 351 270 269 269
Total cold run time: 113186 ms
Total hot run time: 40608 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4269 4211 4185 4185
q2 370 273 265 265
q3 3026 2761 2729 2729
q4 1885 1596 1596 1596
q5 5307 5294 5290 5290
q6 216 126 125 125
q7 2267 1882 1852 1852
q8 3241 3371 3396 3371
q9 8527 8455 8515 8455
q10 3915 3743 3741 3741
q11 586 488 481 481
q12 758 568 581 568
q13 16642 2975 2986 2975
q14 297 274 254 254
q15 517 474 475 474
q16 467 429 415 415
q17 1757 1492 1448 1448
q18 7722 7689 7434 7434
q19 1863 1565 1546 1546
q20 1953 1754 1786 1754
q21 4976 4851 4945 4851
q22 577 490 491 490
Total cold run time: 71138 ms
Total hot run time: 54299 ms
TeamCity be ut coverage result: Function Coverage: 35.60% (8967/25189) Line Coverage: 27.27% (73992/271325) Region Coverage: 26.49% (38216/144241) Branch Coverage: 23.30% (19468/83556) Coverage Report: http://coverage.selectdb-in.cc/coverage/c52138757287a3d733053004fc8419352baede92_c52138757287a3d733053004fc8419352baede92/report/index.html
TPC-DS: Total hot run time: 186093 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 c52138757287a3d733053004fc8419352baede92, data reload: false
query1 914 358 346 346
query2 6631 2450 2474 2450
query3 6662 213 211 211
query4 23017 21173 21095 21095
query5 4172 432 418 418
query6 258 177 173 173
query7 4593 289 288 288
query8 246 193 200 193
query9 8463 2345 2328 2328
query10 442 251 272 251
query11 14788 14250 14120 14120
query12 134 87 90 87
query13 1643 367 375 367
query14 10513 8200 7709 7709
query15 251 171 183 171
query16 8154 262 249 249
query17 1880 565 530 530
query18 2107 270 266 266
query19 266 150 148 148
query20 95 102 82 82
query21 202 130 126 126
query22 5037 4957 4812 4812
query23 33958 33095 33136 33095
query24 10429 2839 2847 2839
query25 591 388 385 385
query26 697 166 152 152
query27 2135 310 325 310
query28 5907 2066 2042 2042
query29 863 630 607 607
query30 296 154 156 154
query31 995 739 743 739
query32 89 54 57 54
query33 653 260 252 252
query34 882 476 487 476
query35 797 659 659 659
query36 1103 956 917 917
query37 106 68 70 68
query38 3175 3025 2959 2959
query39 1612 1571 1582 1571
query40 204 136 132 132
query41 45 42 43 42
query42 108 100 98 98
query43 590 553 543 543
query44 1116 724 736 724
query45 277 233 260 233
query46 1072 774 717 717
query47 1966 1845 1873 1845
query48 364 302 298 298
query49 1041 409 408 408
query50 787 377 397 377
query51 6813 6662 6592 6592
query52 105 92 97 92
query53 354 279 278 278
query54 318 263 250 250
query55 86 78 74 74
query56 252 230 225 225
query57 1197 1101 1144 1101
query58 227 207 208 207
query59 3571 3418 3168 3168
query60 267 241 242 241
query61 109 104 108 104
query62 639 467 440 440
query63 309 276 280 276
query64 8520 7395 7186 7186
query65 3125 3082 3080 3080
query66 822 340 336 336
query67 16039 15271 14974 14974
query68 10295 550 566 550
query69 602 306 301 301
query70 1414 1077 1151 1077
query71 508 272 270 270
query72 8648 2509 2334 2334
query73 1622 318 317 317
query74 6542 6146 6071 6071
query75 5158 2648 2605 2605
query76 5708 991 1028 991
query77 696 265 262 262
query78 11114 10179 10175 10175
query79 11005 517 513 513
query80 2165 437 436 436
query81 504 222 225 222
query82 237 96 90 90
query83 230 166 168 166
query84 270 87 86 86
query85 991 272 322 272
query86 348 306 292 292
query87 3284 3083 3080 3080
query88 5444 2321 2333 2321
query89 527 376 367 367
query90 2470 184 187 184
query91 128 99 96 96
query92 61 47 48 47
query93 6901 504 495 495
query94 1581 183 179 179
query95 397 297 300 297
query96 585 271 266 266
query97 3149 2997 2941 2941
query98 250 218 213 213
query99 1085 837 845 837
Total cold run time: 308998 ms
Total hot run time: 186093 ms
TeamCity be ut coverage result: Function Coverage: 35.60% (8968/25189) Line Coverage: 27.27% (73989/271319) Region Coverage: 26.50% (38225/144238) Branch Coverage: 23.30% (19467/83554) Coverage Report: http://coverage.selectdb-in.cc/coverage/aead4e072bfdd8d8cb2c02150d636eac2c270188_aead4e072bfdd8d8cb2c02150d636eac2c270188/report/index.html
TPC-H: Total hot run time: 41714 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit aead4e072bfdd8d8cb2c02150d636eac2c270188, data reload: false
------ Round 1 ----------------------------------
q1 17614 4385 4281 4281
q2 2030 180 182 180
q3 10506 1197 1206 1197
q4 10192 775 723 723
q5 7502 2696 2739 2696
q6 225 132 133 132
q7 1037 613 605 605
q8 9238 2181 2094 2094
q9 9891 6743 6811 6743
q10 9300 3820 3959 3820
q11 450 241 243 241
q12 526 220 225 220
q13 17226 3174 3232 3174
q14 271 237 228 228
q15 517 468 469 468
q16 494 399 381 381
q17 982 684 763 684
q18 8338 7660 7697 7660
q19 5240 1538 1544 1538
q20 645 323 310 310
q21 5288 4132 4052 4052
q22 359 292 287 287
Total cold run time: 117871 ms
Total hot run time: 41714 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4640 4423 4388 4388
q2 370 272 282 272
q3 3181 2953 2973 2953
q4 1866 1615 1603 1603
q5 5475 5500 5499 5499
q6 216 124 125 124
q7 2392 1980 1990 1980
q8 3294 3425 3449 3425
q9 8743 8826 8869 8826
q10 4000 3695 3845 3695
q11 592 510 492 492
q12 804 622 622 622
q13 17156 3171 3224 3171
q14 293 283 268 268
q15 518 480 482 480
q16 499 426 430 426
q17 1770 1510 1484 1484
q18 7704 7542 7413 7413
q19 1663 1546 1550 1546
q20 1978 1785 1752 1752
q21 11712 4932 4893 4893
q22 572 508 519 508
Total cold run time: 79438 ms
Total hot run time: 55820 ms
TPC-DS: Total hot run time: 185653 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 aead4e072bfdd8d8cb2c02150d636eac2c270188, data reload: false
query1 909 360 355 355
query2 6966 2427 2468 2427
query3 6645 207 207 207
query4 23156 21341 21143 21143
query5 4141 415 413 413
query6 260 176 172 172
query7 4594 290 283 283
query8 251 186 181 181
query9 8507 2345 2336 2336
query10 437 248 257 248
query11 14809 14071 14160 14071
query12 142 96 88 88
query13 1659 368 383 368
query14 8809 8516 7702 7702
query15 242 172 186 172
query16 8085 265 264 264
query17 1741 573 561 561
query18 2141 287 285 285
query19 271 153 156 153
query20 95 94 89 89
query21 200 132 129 129
query22 5074 4824 4879 4824
query23 34515 32935 33145 32935
query24 6430 2888 2832 2832
query25 585 383 380 380
query26 693 156 149 149
query27 1957 321 339 321
query28 3834 2080 2054 2054
query29 862 641 620 620
query30 248 154 156 154
query31 970 756 727 727
query32 93 56 54 54
query33 504 249 252 249
query34 876 475 496 475
query35 776 693 677 677
query36 1047 919 888 888
query37 105 67 77 67
query38 3141 2972 3039 2972
query39 1622 1548 1550 1548
query40 198 130 128 128
query41 45 41 44 41
query42 103 101 98 98
query43 596 570 543 543
query44 1057 720 730 720
query45 277 259 263 259
query46 1064 699 733 699
query47 1981 1834 1847 1834
query48 367 310 294 294
query49 878 398 404 398
query50 782 382 369 369
query51 6782 6635 6674 6635
query52 101 89 89 89
query53 355 282 274 274
query54 259 249 253 249
query55 80 76 76 76
query56 244 217 221 217
query57 1196 1125 1129 1125
query58 216 199 209 199
query59 3529 3236 3285 3236
query60 272 235 240 235
query61 94 88 88 88
query62 632 454 458 454
query63 305 278 283 278
query64 8302 7242 7156 7156
query65 3098 3029 3092 3029
query66 793 336 339 336
query67 15651 14752 15431 14752
query68 9648 551 546 546
query69 620 303 311 303
query70 1393 1146 1057 1057
query71 460 271 278 271
query72 8648 2576 2329 2329
query73 1579 324 322 322
query74 6570 6124 6130 6124
query75 4618 2624 2625 2624
query76 5432 1038 947 947
query77 694 276 268 268
query78 11146 10164 10075 10075
query79 11581 518 519 518
query80 2189 437 467 437
query81 514 222 223 222
query82 250 93 95 93
query83 208 170 167 167
query84 269 87 83 83
query85 945 263 277 263
query86 348 295 270 270
query87 3285 3115 3045 3045
query88 5263 2329 2317 2317
query89 526 383 370 370
query90 2395 183 184 183
query91 123 97 98 97
query92 64 48 51 48
query93 6817 517 511 511
query94 1548 189 183 183
query95 412 309 313 309
query96 601 264 262 262
query97 3129 2940 2945 2940
query98 235 230 223 223
query99 1107 905 862 862
Total cold run time: 299266 ms
Total hot run time: 185653 ms
TeamCity be ut coverage result: Function Coverage: 35.68% (8984/25181) Line Coverage: 27.33% (74224/271565) Region Coverage: 26.56% (38365/144425) Branch Coverage: 23.38% (19569/83684) Coverage Report: http://coverage.selectdb-in.cc/coverage/f6c868032ec7c2fb6dd771952d8c24aec631f8e2_f6c868032ec7c2fb6dd771952d8c24aec631f8e2/report/index.html
TPC-H: Total hot run time: 41924 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f6c868032ec7c2fb6dd771952d8c24aec631f8e2, data reload: false
------ Round 1 ----------------------------------
q1 17606 4325 4219 4219
q2 2005 181 187 181
q3 10488 1243 1242 1242
q4 10179 817 843 817
q5 7477 2766 2726 2726
q6 218 133 136 133
q7 1033 602 629 602
q8 9230 2146 2098 2098
q9 9744 6694 6704 6694
q10 8998 3871 3940 3871
q11 464 247 243 243
q12 469 225 236 225
q13 17239 3363 3184 3184
q14 270 214 220 214
q15 524 497 474 474
q16 515 420 397 397
q17 1008 694 673 673
q18 8220 7732 7731 7731
q19 2376 1539 1533 1533
q20 639 327 340 327
q21 5215 4154 4058 4058
q22 367 282 287 282
Total cold run time: 114284 ms
Total hot run time: 41924 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4518 4340 4414 4340
q2 395 292 277 277
q3 3151 2931 2934 2931
q4 1958 1773 1677 1677
q5 5314 5478 5484 5478
q6 227 133 130 130
q7 2335 1951 1953 1951
q8 3238 3452 3467 3452
q9 8574 8602 8645 8602
q10 4103 3747 3689 3689
q11 596 495 501 495
q12 774 648 592 592
q13 16977 3157 3155 3155
q14 287 278 266 266
q15 519 488 483 483
q16 506 426 457 426
q17 1846 1523 1492 1492
q18 7860 7641 7245 7245
q19 3497 1558 1563 1558
q20 2064 1738 1750 1738
q21 14705 4989 4812 4812
q22 579 504 483 483
Total cold run time: 84023 ms
Total hot run time: 55272 ms