doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Improve](Variant) support bloom filter for variant subcolumns
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
![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.71% (8548/23936) Line Coverage: 27.53% (69358/251910) Region Coverage: 26.68% (35966/134795) Branch Coverage: 23.50% (18391/78274) Coverage Report: http://coverage.selectdb-in.cc/coverage/8c2ca9775c83d791a076cb37b9a1155a62497e2e_8c2ca9775c83d791a076cb37b9a1155a62497e2e/report/index.html
TPC-H: Total hot run time: 41818 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
------ Round 1 ----------------------------------
q1 19099 5310 5178 5178
q2 2559 147 141 141
q3 11432 1031 1058 1031
q4 4984 1038 1036 1036
q5 8034 3304 3244 3244
q6 195 137 136 136
q7 1265 795 794 794
q8 9335 2068 2067 2067
q9 7500 6650 6607 6607
q10 8329 2666 2641 2641
q11 440 216 222 216
q12 734 329 339 329
q13 17939 3632 3621 3621
q14 295 257 263 257
q15 604 506 512 506
q16 479 410 416 410
q17 937 867 858 858
q18 7350 6774 6625 6625
q19 1571 1508 1504 1504
q20 486 287 280 280
q21 6335 4066 3998 3998
q22 408 349 339 339
Total cold run time: 110310 ms
Total hot run time: 41818 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4860 4868 4810 4810
q2 304 190 191 190
q3 3609 3613 3592 3592
q4 2576 2589 2576 2576
q5 5797 5768 5792 5768
q6 216 128 134 128
q7 2275 1693 1690 1690
q8 3084 3129 3133 3129
q9 8746 8742 8743 8742
q10 4165 4246 4260 4246
q11 532 378 376 376
q12 789 551 552 551
q13 4164 3426 3414 3414
q14 267 247 243 243
q15 635 509 510 509
q16 483 464 430 430
q17 1703 1633 1639 1633
q18 8372 7665 7670 7665
q19 1648 1650 1652 1650
q20 2137 1858 1837 1837
q21 6692 6318 6276 6276
q22 597 528 519 519
Total cold run time: 63651 ms
Total hot run time: 59974 ms
TPC-DS: Total hot run time: 176852 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 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
query1 919 360 352 352
query2 6516 1659 1644 1644
query3 6696 209 202 202
query4 23283 21073 21088 21073
query5 4250 390 384 384
query6 264 173 168 168
query7 4602 298 302 298
query8 247 198 203 198
query9 8461 2832 2828 2828
query10 431 249 232 232
query11 15039 14628 14532 14532
query12 142 83 85 83
query13 1693 422 424 422
query14 9116 7670 7778 7670
query15 215 186 189 186
query16 7490 252 243 243
query17 1401 536 514 514
query18 1939 282 258 258
query19 199 146 150 146
query20 85 85 83 83
query21 194 131 126 126
query22 4781 4701 4720 4701
query23 32694 31496 31519 31496
query24 12760 3372 3381 3372
query25 640 364 349 349
query26 1892 158 164 158
query27 3031 315 316 315
query28 6637 1855 1831 1831
query29 1181 623 613 613
query30 285 139 149 139
query31 932 757 768 757
query32 100 61 57 57
query33 723 233 243 233
query34 1065 508 504 504
query35 952 853 821 821
query36 981 917 884 884
query37 190 64 62 62
query38 3299 3201 3218 3201
query39 1389 1344 1311 1311
query40 286 109 106 106
query41 38 37 35 35
query42 104 104 100 100
query43 472 447 448 447
query44 1079 683 709 683
query45 199 182 185 182
query46 1052 776 774 774
query47 1659 1557 1581 1557
query48 417 347 353 347
query49 1216 306 298 298
query50 768 373 377 373
query51 4518 4259 4319 4259
query52 111 96 95 95
query53 397 306 299 299
query54 296 227 225 225
query55 86 77 77 77
query56 237 215 204 204
query57 1068 950 983 950
query58 224 201 204 201
query59 2211 2130 2115 2115
query60 242 224 213 213
query61 85 90 82 82
query62 594 364 381 364
query63 328 290 298 290
query64 6371 3005 3095 3005
query65 3308 3246 3253 3246
query66 1340 333 321 321
query67 14484 14426 14327 14327
query68 5213 561 567 561
query69 512 350 355 350
query70 1239 1224 1228 1224
query71 442 259 250 250
query72 6362 2780 2623 2623
query73 692 313 312 312
query74 6986 6480 6474 6474
query75 3231 2594 2552 2552
query76 3308 1136 1207 1136
query77 357 248 233 233
query78 9500 8815 8807 8807
query79 989 529 513 513
query80 517 356 355 355
query81 443 207 206 206
query82 160 85 83 83
query83 142 123 120 120
query84 228 82 80 80
query85 1028 348 338 338
query86 313 304 307 304
query87 3456 3335 3221 3221
query88 2768 2314 2290 2290
query89 442 378 357 357
query90 2010 165 165 165
query91 154 123 127 123
query92 57 51 53 51
query93 1020 513 506 506
query94 1119 176 181 176
query95 429 335 339 335
query96 581 262 265 262
query97 4425 4285 4279 4279
query98 229 199 193 193
query99 1083 752 758 752
Total cold run time: 269339 ms
Total hot run time: 176852 ms
TeamCity be ut coverage result: Function Coverage: 35.71% (8548/23938) Line Coverage: 27.53% (69370/251993) Region Coverage: 26.68% (35968/134837) Branch Coverage: 23.49% (18389/78296) Coverage Report: http://coverage.selectdb-in.cc/coverage/5d6383b4e5c45128580f241b5f1f6db617fceb0d_5d6383b4e5c45128580f241b5f1f6db617fceb0d/report/index.html
ClickBench: Total hot run time: 30.77 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.23 0.07 0.07
query4 1.64 0.09 0.09
query5 0.48 0.47 0.49
query6 1.40 0.61 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.53 0.46 0.45
query10 0.49 0.50 0.47
query11 0.12 0.09 0.10
query12 0.13 0.10 0.10
query13 0.60 0.60 0.58
query14 0.78 0.76 0.80
query15 0.82 0.80 0.80
query16 0.32 0.35 0.34
query17 0.91 0.91 0.92
query18 0.19 0.18 0.18
query19 1.73 1.72 1.69
query20 0.02 0.01 0.01
query21 15.40 0.68 0.61
query22 2.84 4.39 2.02
query23 17.37 1.09 1.02
query24 2.14 0.44 0.37
query25 0.60 0.06 0.07
query26 0.16 0.13 0.14
query27 0.05 0.05 0.08
query28 11.96 0.84 0.83
query29 12.68 3.31 3.37
query30 0.53 0.50 0.48
query31 2.78 0.36 0.36
query32 3.34 0.48 0.48
query33 3.12 3.18 3.14
query34 15.35 4.47 4.48
query35 4.51 4.49 4.50
query36 1.08 0.97 0.96
query37 0.08 0.06 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.18 0.15 0.15
query41 0.08 0.02 0.02
query42 0.03 0.01 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.9 s
Total hot run time: 30.77 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 15.9 seconds inserted 10000000 Rows, about 628K ops/s
TPC-H: Total hot run time: 38465 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
------ Round 1 ----------------------------------
q1 18371 4159 4156 4156
q2 2635 148 152 148
q3 11813 960 990 960
q4 5028 994 986 986
q5 7859 2974 3089 2974
q6 185 125 126 125
q7 1306 801 788 788
q8 9403 2041 2048 2041
q9 7199 6291 6274 6274
q10 8216 2492 2516 2492
q11 409 202 199 199
q12 821 323 320 320
q13 17962 3263 3217 3217
q14 279 259 245 245
q15 537 503 500 500
q16 474 396 422 396
q17 959 889 830 830
q18 6580 6074 6123 6074
q19 1577 1519 1521 1519
q20 573 288 280 280
q21 6617 3646 3650 3646
q22 826 301 295 295
Total cold run time: 109629 ms
Total hot run time: 38465 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4001 4009 3983 3983
q2 304 217 219 217
q3 2970 2947 2938 2938
q4 1877 1868 1873 1868
q5 5183 5131 5139 5131
q6 197 117 115 115
q7 2143 1701 1684 1684
q8 3133 3198 3202 3198
q9 8252 8233 8253 8233
q10 6215 3669 3634 3634
q11 507 428 430 428
q12 689 545 538 538
q13 3771 3057 3070 3057
q14 281 258 264 258
q15 528 491 492 491
q16 518 458 467 458
q17 1687 1676 1671 1671
q18 7866 7657 7538 7538
q19 1679 1630 1631 1630
q20 2096 1912 1920 1912
q21 4763 4651 4665 4651
q22 513 440 443 440
Total cold run time: 59173 ms
Total hot run time: 54073 ms
TeamCity be ut coverage result: Function Coverage: 35.69% (8548/23952) Line Coverage: 27.49% (69372/252399) Region Coverage: 26.64% (35963/134990) Branch Coverage: 23.45% (18383/78390) Coverage Report: http://coverage.selectdb-in.cc/coverage/5d6383b4e5c45128580f241b5f1f6db617fceb0d_5d6383b4e5c45128580f241b5f1f6db617fceb0d/report/index.html
TPC-DS: Total hot run time: 169389 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 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
query1 939 341 336 336
query2 6532 1761 1702 1702
query3 6710 212 210 210
query4 23604 20540 20562 20540
query5 4290 369 361 361
query6 257 168 168 168
query7 4623 302 304 302
query8 264 196 207 196
query9 8491 2240 2231 2231
query10 413 224 214 214
query11 14633 14150 14156 14150
query12 136 85 80 80
query13 1643 423 437 423
query14 8422 6756 6411 6411
query15 202 172 175 172
query16 7088 261 253 253
query17 1046 521 506 506
query18 1897 275 261 261
query19 189 154 143 143
query20 87 84 81 81
query21 200 116 127 116
query22 4756 4617 4551 4551
query23 30552 29991 29882 29882
query24 11222 3142 3108 3108
query25 627 350 354 350
query26 1662 165 163 163
query27 3026 319 309 309
query28 7028 1794 1804 1794
query29 1104 554 562 554
query30 278 131 140 131
query31 862 687 683 683
query32 97 61 54 54
query33 703 226 229 226
query34 1028 481 494 481
query35 865 731 738 731
query36 991 879 868 868
query37 127 61 60 60
query38 3115 3016 2978 2978
query39 1321 1259 1253 1253
query40 275 102 102 102
query41 38 37 37 37
query42 102 101 98 98
query43 461 444 424 424
query44 1073 687 699 687
query45 190 180 173 173
query46 1061 811 799 799
query47 1513 1458 1427 1427
query48 428 343 345 343
query49 1128 295 306 295
query50 772 380 382 380
query51 4390 4242 4253 4242
query52 103 91 89 89
query53 338 266 268 266
query54 303 222 222 222
query55 86 83 79 79
query56 223 208 206 206
query57 960 866 887 866
query58 215 200 198 198
query59 2187 2097 2098 2097
query60 230 209 214 209
query61 86 90 85 85
query62 612 375 359 359
query63 285 261 261 261
query64 6617 3027 3133 3027
query65 3240 3206 3202 3202
query66 1429 328 321 321
query67 14524 14192 14060 14060
query68 5012 561 562 561
query69 544 375 390 375
query70 1227 1214 1161 1161
query71 357 250 249 249
query72 6269 2798 2653 2653
query73 725 316 325 316
query74 6406 5967 5975 5967
query75 3055 2449 2439 2439
query76 2783 1054 1146 1054
query77 357 242 235 235
query78 8961 8502 8503 8502
query79 1317 528 549 528
query80 977 369 351 351
query81 480 201 206 201
query82 949 91 85 85
query83 222 126 122 122
query84 275 83 82 82
query85 1319 345 338 338
query86 364 290 298 290
query87 3295 3047 3062 3047
query88 2793 2343 2326 2326
query89 403 375 327 327
query90 1841 170 164 164
query91 152 122 123 122
query92 56 49 49 49
query93 1215 511 498 498
query94 1232 179 183 179
query95 446 337 349 337
query96 582 260 267 260
query97 4262 4141 4131 4131
query98 214 221 204 204
query99 1078 663 650 650
Total cold run time: 263067 ms
Total hot run time: 169389 ms
ClickBench: Total hot run time: 32.78 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.69 0.10 0.10
query5 0.53 0.52 0.52
query6 1.20 0.69 0.66
query7 0.02 0.02 0.01
query8 0.03 0.03 0.02
query9 0.56 0.55 0.51
query10 0.56 0.56 0.56
query11 0.14 0.10 0.10
query12 0.13 0.10 0.11
query13 0.62 0.60 0.61
query14 0.78 0.80 0.79
query15 0.83 0.82 0.81
query16 0.37 0.38 0.38
query17 0.95 0.96 0.99
query18 0.26 0.25 0.24
query19 1.83 1.72 1.70
query20 0.01 0.01 0.01
query21 15.41 0.66 0.61
query22 2.68 3.99 3.16
query23 17.48 0.98 0.98
query24 2.08 0.50 0.21
query25 0.49 0.14 0.06
query26 0.16 0.16 0.16
query27 0.05 0.04 0.04
query28 12.24 0.87 0.84
query29 12.70 3.21 3.46
query30 0.58 0.53 0.51
query31 2.79 0.35 0.35
query32 3.37 0.49 0.48
query33 3.18 3.23 3.24
query34 15.35 4.75 4.73
query35 4.74 4.72 4.74
query36 1.14 1.07 1.08
query37 0.07 0.05 0.05
query38 0.04 0.02 0.03
query39 0.03 0.01 0.02
query40 0.16 0.13 0.13
query41 0.08 0.01 0.01
query42 0.03 0.01 0.02
query43 0.03 0.01 0.02
Total cold run time: 105.71 s
Total hot run time: 32.78 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 5d6383b4e5c45128580f241b5f1f6db617fceb0d with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 18.8 seconds inserted 10000000 Rows, about 531K ops/s
TPC-H: Total hot run time: 37994 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7c2b3b56950333b67dc62b6c2999bde9827bedc1, data reload: false
------ Round 1 ----------------------------------
q1 17690 4077 4044 4044
q2 2026 146 143 143
q3 10562 962 953 953
q4 4656 965 971 965
q5 7597 2843 3030 2843
q6 179 125 125 125
q7 1310 833 818 818
q8 9503 2001 2085 2001
q9 7351 6471 6439 6439
q10 8225 2588 2572 2572
q11 431 227 227 227
q12 784 318 313 313
q13 17973 2947 2939 2939
q14 281 248 259 248
q15 489 450 442 442
q16 495 403 403 403
q17 944 883 855 855
q18 6844 5954 5893 5893
q19 1584 1526 1529 1526
q20 550 280 278 278
q21 7510 3732 3667 3667
q22 792 309 300 300
Total cold run time: 107776 ms
Total hot run time: 37994 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4042 4002 4009 4002
q2 324 230 232 230
q3 2934 2964 2933 2933
q4 1896 1850 1800 1800
q5 5257 5235 5250 5235
q6 200 123 119 119
q7 2239 1827 1840 1827
q8 3223 3321 3292 3292
q9 8574 8507 8441 8441
q10 6176 3731 3748 3731
q11 549 445 448 445
q12 694 536 535 535
q13 12154 2791 2760 2760
q14 278 257 252 252
q15 466 443 433 433
q16 445 414 418 414
q17 1692 1679 1652 1652
q18 7902 7485 7332 7332
q19 1712 1607 1605 1605
q20 1895 1688 1722 1688
q21 4857 4813 4914 4813
q22 540 487 455 455
Total cold run time: 68049 ms
Total hot run time: 53994 ms
TeamCity be ut coverage result: Function Coverage: 35.37% (8555/24188) Line Coverage: 27.15% (69507/256049) Region Coverage: 26.37% (36075/136820) Branch Coverage: 23.21% (18436/79440) Coverage Report: http://coverage.selectdb-in.cc/coverage/7c2b3b56950333b67dc62b6c2999bde9827bedc1_7c2b3b56950333b67dc62b6c2999bde9827bedc1/report/index.html
TPC-DS: Total hot run time: 186839 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 7c2b3b56950333b67dc62b6c2999bde9827bedc1, data reload: false
query1 912 367 350 350
query2 7452 2149 2042 2042
query3 6713 214 215 214
query4 26984 21281 21242 21242
query5 4269 528 463 463
query6 276 189 180 180
query7 4623 341 316 316
query8 232 167 165 165
query9 8498 2299 2285 2285
query10 447 237 246 237
query11 15026 14255 14280 14255
query12 135 87 86 86
query13 1649 429 447 429
query14 10813 9990 9932 9932
query15 242 192 197 192
query16 8136 277 277 277
query17 1747 606 581 581
query18 2111 297 284 284
query19 207 178 170 170
query20 104 92 94 92
query21 196 133 128 128
query22 4642 4492 4376 4376
query23 31666 30539 31002 30539
query24 10822 3014 3065 3014
query25 658 407 393 393
query26 1327 171 172 171
query27 2731 371 371 371
query28 6338 1923 1882 1882
query29 977 634 608 608
query30 309 152 155 152
query31 949 758 749 749
query32 109 65 63 63
query33 770 272 254 254
query34 970 483 497 483
query35 853 652 625 625
query36 945 841 808 808
query37 157 79 77 77
query38 3236 3100 3098 3098
query39 1397 1414 1386 1386
query40 212 123 121 121
query41 58 61 57 57
query42 104 106 113 106
query43 449 420 402 402
query44 1095 737 741 737
query45 296 260 254 254
query46 1066 822 765 765
query47 1628 1554 1564 1554
query48 440 356 353 353
query49 1153 352 356 352
query50 792 391 398 391
query51 6700 6555 6674 6555
query52 111 98 94 94
query53 350 293 291 291
query54 295 253 259 253
query55 91 81 87 81
query56 262 231 249 231
query57 1069 1004 1012 1004
query58 263 230 234 230
query59 2653 2385 2413 2385
query60 272 253 278 253
query61 116 115 115 115
query62 669 442 412 412
query63 312 283 283 283
query64 5172 3257 3095 3095
query65 3044 3008 2989 2989
query66 850 321 337 321
query67 15284 14409 14351 14351
query68 16642 567 583 567
query69 746 405 385 385
query70 1815 1090 1125 1090
query71 662 289 274 274
query72 10180 2633 2502 2502
query73 3828 350 344 344
query74 7136 6772 6818 6772
query75 12316 8163 8092 8092
query76 7592 1062 1174 1062
query77 1197 255 261 255
query78 10260 9553 9496 9496
query79 8675 543 540 540
query80 1266 396 399 396
query81 535 219 213 213
query82 341 200 201 200
query83 388 145 149 145
query84 289 79 79 79
query85 1235 347 331 331
query86 372 289 311 289
query87 3477 3225 3144 3144
query88 2984 2315 2323 2315
query89 519 371 376 371
query90 2551 186 173 173
query91 166 130 129 129
query92 62 59 51 51
query93 3652 544 534 534
query94 1641 195 188 188
query95 468 348 354 348
query96 601 269 263 263
query97 4452 4303 4323 4303
query98 222 221 217 217
query99 1114 767 769 767
Total cold run time: 321818 ms
Total hot run time: 186839 ms
ClickBench: Total hot run time: 30.76 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7c2b3b56950333b67dc62b6c2999bde9827bedc1, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.23 0.06 0.06
query4 1.67 0.10 0.10
query5 0.51 0.50 0.52
query6 1.33 0.66 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.58 0.52 0.53
query10 0.56 0.56 0.58
query11 0.14 0.10 0.10
query12 0.12 0.10 0.10
query13 0.58 0.57 0.56
query14 0.74 0.76 0.76
query15 0.82 0.80 0.78
query16 0.37 0.36 0.38
query17 0.96 0.96 0.98
query18 0.27 0.27 0.26
query19 1.82 1.75 1.76
query20 0.02 0.01 0.01
query21 15.41 0.63 0.62
query22 3.49 3.83 2.40
query23 17.66 1.05 0.95
query24 2.29 0.28 0.32
query25 0.27 0.04 0.06
query26 0.18 0.14 0.13
query27 0.04 0.04 0.03
query28 12.39 0.83 0.84
query29 12.65 3.31 3.29
query30 0.63 0.57 0.58
query31 2.79 0.35 0.35
query32 3.37 0.44 0.43
query33 2.99 2.85 2.95
query34 15.58 4.30 4.29
query35 4.29 4.30 4.33
query36 1.09 1.02 1.01
query37 0.07 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.01 0.02
query40 0.16 0.13 0.14
query41 0.07 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 106.42 s
Total hot run time: 30.76 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 7c2b3b56950333b67dc62b6c2999bde9827bedc1 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 16.7 seconds inserted 10000000 Rows, about 598K ops/s
PR approved by at least one committer and no changes requested.