doris
doris copied to clipboard
[fix](array) fix array_except/union for left const return only one row result
Proposed changes
backport : https://github.com/apache/doris/pull/36776
Issue Number: close #xxx
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.
run buildall
clang-tidy review says "All clean, LGTM! :+1:"
TeamCity be ut coverage result: Function Coverage: 37.87% (8112/21418) Line Coverage: 29.53% (66413/224873) Region Coverage: 29.00% (34225/118014) Branch Coverage: 24.86% (17565/70654) Coverage Report: http://coverage.selectdb-in.cc/coverage/13c999f7af0538da71198389ae3cdfa753ba00ee_13c999f7af0538da71198389ae3cdfa753ba00ee/report/index.html
TPC-H: Total hot run time: 50009 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false
------ Round 1 ----------------------------------
q1 17524 4347 4318 4318
q2 2074 155 162 155
q3 10808 1984 1980 1980
q4 10499 1245 1358 1245
q5 8835 4121 3955 3955
q6 236 127 128 127
q7 2066 1621 1597 1597
q8 9280 2739 2714 2714
q9 10875 10467 10352 10352
q10 8643 3480 3533 3480
q11 415 247 241 241
q12 473 307 308 307
q13 18370 3968 4034 3968
q14 352 331 321 321
q15 517 459 457 457
q16 697 568 569 568
q17 1139 974 955 955
q18 7330 6856 6867 6856
q19 1788 1648 1613 1613
q20 520 306 308 306
q21 4416 4071 4057 4057
q22 534 453 437 437
Total cold run time: 117391 ms
Total hot run time: 50009 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4323 4341 4367 4341
q2 314 227 221 221
q3 4174 4158 4139 4139
q4 2740 2749 2766 2749
q5 7152 7054 7036 7036
q6 240 121 124 121
q7 3236 2868 2835 2835
q8 4364 4482 4501 4482
q9 17324 17229 17161 17161
q10 4229 4227 4282 4227
q11 732 680 675 675
q12 1048 842 872 842
q13 7306 3733 3711 3711
q14 459 437 422 422
q15 507 462 456 456
q16 734 680 668 668
q17 3832 3841 3887 3841
q18 8879 8848 8859 8848
q19 1717 1705 1690 1690
q20 2339 2129 2103 2103
q21 8482 8485 8559 8485
q22 1045 991 1001 991
Total cold run time: 85176 ms
Total hot run time: 80044 ms
TPC-DS: Total hot run time: 203833 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 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false
query1 950 389 380 380
query2 6529 2804 2663 2663
query3 6920 209 204 204
query4 20119 18102 17938 17938
query5 19741 6532 6491 6491
query6 282 215 222 215
query7 4162 307 311 307
query8 415 434 441 434
query9 3134 2691 2626 2626
query10 414 309 301 301
query11 11340 10708 10690 10690
query12 117 83 77 77
query13 5588 691 707 691
query14 17613 13272 13503 13272
query15 392 252 238 238
query16 6486 298 277 277
query17 1714 1457 874 874
query18 2330 408 408 408
query19 218 153 154 153
query20 77 80 79 79
query21 189 98 96 96
query22 5215 4901 4997 4901
query23 32453 32095 32083 32083
query24 7003 6547 6481 6481
query25 533 422 451 422
query26 530 163 161 161
query27 1883 302 296 296
query28 6148 2396 2337 2337
query29 2998 2819 2770 2770
query30 250 165 172 165
query31 908 740 734 734
query32 73 66 63 63
query33 417 269 255 255
query34 838 482 474 474
query35 1152 949 935 935
query36 1307 1075 1248 1075
query37 91 63 65 63
query38 3058 2900 2897 2897
query39 1378 1338 1331 1331
query40 203 95 97 95
query41 46 44 44 44
query42 86 84 82 82
query43 712 714 660 660
query44 1148 721 725 721
query45 247 234 241 234
query46 1231 968 987 968
query47 1805 1943 1687 1687
query48 1015 713 712 712
query49 625 376 377 376
query50 870 658 611 611
query51 4754 4658 4711 4658
query52 102 83 83 83
query53 448 337 323 323
query54 2660 2462 2477 2462
query55 98 75 84 75
query56 243 203 203 203
query57 1161 1119 1123 1119
query58 222 203 209 203
query59 4104 3903 3757 3757
query60 206 204 216 204
query61 98 93 95 93
query62 841 504 479 479
query63 491 340 346 340
query64 2594 1538 1502 1502
query65 3592 3584 3580 3580
query66 826 390 385 385
query67 15488 15606 15548 15548
query68 10443 661 654 654
query69 575 365 343 343
query70 2069 1648 1273 1273
query71 410 312 315 312
query72 6513 3497 3509 3497
query73 736 323 319 319
query74 6247 5884 5833 5833
query75 5418 3662 3727 3662
query76 7013 1136 1200 1136
query77 1190 258 254 254
query78 12901 11777 11704 11704
query79 7876 652 634 634
query80 949 400 399 399
query81 476 244 230 230
query82 850 96 94 94
query83 177 136 131 131
query84 264 71 68 68
query85 895 319 319 319
query86 349 298 296 296
query87 3200 3021 3054 3021
query88 4555 2305 2319 2305
query89 457 287 289 287
query90 1910 203 210 203
query91 167 137 150 137
query92 60 54 54 54
query93 6657 548 577 548
query94 696 209 208 208
query95 1125 1073 1047 1047
query96 646 323 338 323
query97 6611 6442 6447 6442
query98 186 176 166 166
query99 3001 873 954 873
Total cold run time: 315503 ms
Total hot run time: 203833 ms
ClickBench: Total hot run time: 31.38 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false
query1 0.03 0.03 0.02
query2 0.07 0.03 0.02
query3 0.25 0.04 0.04
query4 1.80 0.06 0.07
query5 0.53 0.52 0.52
query6 1.26 0.62 0.62
query7 0.02 0.01 0.01
query8 0.03 0.03 0.02
query9 0.54 0.51 0.48
query10 0.53 0.52 0.54
query11 0.12 0.08 0.08
query12 0.12 0.09 0.09
query13 0.62 0.61 0.60
query14 0.79 0.79 0.80
query15 0.76 0.76 0.78
query16 0.37 0.39 0.37
query17 0.99 0.96 1.00
query18 0.21 0.27 0.23
query19 1.93 1.85 1.87
query20 0.01 0.01 0.01
query21 15.47 0.54 0.53
query22 2.31 1.92 1.47
query23 17.02 0.97 1.10
query24 4.67 2.13 1.71
query25 0.34 0.13 0.04
query26 0.73 0.15 0.17
query27 0.05 0.05 0.04
query28 6.64 0.75 0.77
query29 12.62 2.31 2.28
query30 0.63 0.53 0.53
query31 2.82 0.38 0.37
query32 3.39 0.50 0.50
query33 3.04 3.07 3.07
query34 15.28 4.83 4.85
query35 4.89 4.84 4.86
query36 1.06 1.02 1.03
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.13 0.14
query41 0.06 0.01 0.01
query42 0.02 0.02 0.01
query43 0.02 0.01 0.02
Total cold run time: 102.31 s
Total hot run time: 31.38 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.4 seconds inserted 10000000 Rows, about 467K ops/s
run buildall
clang-tidy review says "All clean, LGTM! :+1:"
TPC-H: Total hot run time: 50148 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false
------ Round 1 ----------------------------------
q1 17634 4447 4381 4381
q2 2097 159 150 150
q3 10472 1898 1960 1898
q4 10375 1242 1323 1242
q5 8553 3908 3892 3892
q6 238 163 127 127
q7 2027 1607 1564 1564
q8 9516 2726 2695 2695
q9 13900 10617 10460 10460
q10 8649 3509 3462 3462
q11 421 248 247 247
q12 471 308 313 308
q13 18363 3969 4033 3969
q14 363 323 335 323
q15 506 465 458 458
q16 667 565 568 565
q17 1129 957 963 957
q18 7340 7020 7057 7020
q19 1800 1679 1600 1600
q20 543 322 315 315
q21 4474 4083 4075 4075
q22 527 440 448 440
Total cold run time: 120065 ms
Total hot run time: 50148 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4282 4301 4311 4301
q2 322 226 224 224
q3 4139 4120 4112 4112
q4 2753 2734 2732 2732
q5 7236 7178 7112 7112
q6 240 118 122 118
q7 3229 2870 2848 2848
q8 4328 4424 4441 4424
q9 17409 17016 17149 17016
q10 4240 4240 4295 4240
q11 743 666 676 666
q12 1025 854 849 849
q13 6924 3742 3741 3741
q14 438 424 427 424
q15 518 456 463 456
q16 723 680 680 680
q17 3748 3814 3876 3814
q18 8767 8861 8881 8861
q19 1750 1622 1656 1622
q20 2360 2165 2207 2165
q21 8349 8402 8396 8396
q22 1069 956 941 941
Total cold run time: 84592 ms
Total hot run time: 79742 ms
TPC-DS: Total hot run time: 204015 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 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false
query1 937 419 377 377
query2 6525 2891 2781 2781
query3 6927 208 197 197
query4 20231 17967 18040 17967
query5 19732 6507 6560 6507
query6 306 218 236 218
query7 4285 320 311 311
query8 417 401 373 373
query9 3136 2710 2625 2625
query10 426 311 299 299
query11 11287 10694 10656 10656
query12 122 77 77 77
query13 5600 690 695 690
query14 18092 13444 13421 13421
query15 364 244 248 244
query16 6445 299 263 263
query17 1663 1460 892 892
query18 2292 424 417 417
query19 212 157 156 156
query20 82 79 77 77
query21 188 96 98 96
query22 5153 4946 4907 4907
query23 32526 31848 31745 31745
query24 6871 6596 6538 6538
query25 543 426 436 426
query26 530 165 166 165
query27 1845 299 298 298
query28 6177 2351 2312 2312
query29 2856 2761 2852 2761
query30 243 167 177 167
query31 892 735 787 735
query32 69 63 63 63
query33 391 264 258 258
query34 843 477 477 477
query35 1158 919 923 919
query36 1191 1162 1322 1162
query37 89 61 61 61
query38 3058 2933 2917 2917
query39 1380 1315 1336 1315
query40 205 100 98 98
query41 46 44 45 44
query42 90 81 79 79
query43 737 668 714 668
query44 1147 716 720 716
query45 250 235 233 233
query46 1240 954 998 954
query47 2052 1674 1768 1674
query48 1016 743 744 743
query49 620 375 386 375
query50 890 652 622 622
query51 4763 4679 4643 4643
query52 97 74 84 74
query53 455 329 323 323
query54 2661 2460 2487 2460
query55 89 80 76 76
query56 240 227 216 216
query57 1218 1066 1126 1066
query58 220 208 211 208
query59 4276 3817 4099 3817
query60 220 189 201 189
query61 99 109 95 95
query62 839 479 470 470
query63 489 348 350 348
query64 2492 1560 1500 1500
query65 3641 3555 3530 3530
query66 759 368 390 368
query67 15885 18722 15680 15680
query68 6268 634 635 634
query69 587 373 369 369
query70 1571 1532 1360 1360
query71 426 327 320 320
query72 6611 3508 3508 3508
query73 729 329 320 320
query74 6343 5830 5863 5830
query75 4516 3750 3656 3656
query76 4075 1135 1211 1135
query77 550 275 254 254
query78 12799 11583 12302 11583
query79 6761 649 649 649
query80 2524 399 414 399
query81 533 236 230 230
query82 733 98 97 97
query83 232 135 132 132
query84 261 73 79 73
query85 1418 324 332 324
query86 365 296 331 296
query87 3199 3031 3029 3029
query88 4640 2360 2346 2346
query89 341 296 300 296
query90 1683 217 212 212
query91 178 140 151 140
query92 59 51 52 51
query93 1434 570 600 570
query94 889 211 210 210
query95 1112 1067 1069 1067
query96 636 326 344 326
query97 6546 6412 6488 6412
query98 184 172 169 169
query99 2950 880 879 879
Total cold run time: 302973 ms
Total hot run time: 204015 ms
ClickBench: Total hot run time: 30.75 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false
query1 0.02 0.02 0.01
query2 0.07 0.02 0.03
query3 0.26 0.05 0.04
query4 1.78 0.06 0.06
query5 0.54 0.52 0.52
query6 1.23 0.62 0.62
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.53 0.50 0.48
query10 0.54 0.53 0.54
query11 0.12 0.08 0.09
query12 0.11 0.09 0.09
query13 0.63 0.62 0.61
query14 0.78 0.79 0.77
query15 0.77 0.77 0.76
query16 0.36 0.39 0.36
query17 1.01 1.03 0.99
query18 0.25 0.22 0.26
query19 1.94 1.81 1.85
query20 0.02 0.01 0.01
query21 15.46 0.57 0.54
query22 2.29 2.08 1.62
query23 16.39 0.95 0.98
query24 7.01 1.05 1.02
query25 0.32 0.10 0.06
query26 0.82 0.16 0.17
query27 0.05 0.05 0.03
query28 6.21 0.77 0.76
query29 12.62 2.28 2.30
query30 0.55 0.54 0.52
query31 2.81 0.40 0.37
query32 3.37 0.50 0.49
query33 3.13 3.10 3.05
query34 15.25 4.79 4.79
query35 4.88 4.85 4.84
query36 1.03 1.02 1.01
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.01 0.01 0.02
query40 0.16 0.14 0.14
query41 0.06 0.01 0.01
query42 0.02 0.02 0.02
query43 0.02 0.01 0.02
Total cold run time: 103.57 s
Total hot run time: 30.75 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.6 seconds inserted 10000000 Rows, about 462K ops/s
TeamCity be ut coverage result: Function Coverage: 37.88% (8113/21417) Line Coverage: 29.56% (66457/224855) Region Coverage: 29.02% (34248/118005) Branch Coverage: 24.90% (17591/70652) Coverage Report: http://coverage.selectdb-in.cc/coverage/85458b9272b7dde38dc59f05754beb229ddfe97c_85458b9272b7dde38dc59f05754beb229ddfe97c/report/index.html
run external
PR approved by at least one committer and no changes requested.
PR approved by anyone and no changes requested.
run buildall
clang-tidy review says "All clean, LGTM! :+1:"
TPC-H: Total hot run time: 49717 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false
------ Round 1 ----------------------------------
q1 17949 4388 4364 4364
q2 2064 165 145 145
q3 10271 1896 1952 1896
q4 10361 1230 1323 1230
q5 8472 3927 3827 3827
q6 230 130 169 130
q7 2066 1627 1634 1627
q8 9608 2732 2694 2694
q9 13589 10286 10184 10184
q10 8663 3529 3507 3507
q11 412 257 249 249
q12 473 304 322 304
q13 18342 3969 4041 3969
q14 370 350 326 326
q15 520 465 464 464
q16 663 578 559 559
q17 1121 912 914 912
q18 7227 6939 6797 6797
q19 1803 1659 1653 1653
q20 532 305 306 305
q21 4430 4152 4124 4124
q22 532 455 451 451
Total cold run time: 119698 ms
Total hot run time: 49717 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4336 4312 4298 4298
q2 321 228 222 222
q3 4192 4137 4178 4137
q4 2731 2760 2741 2741
q5 7072 7038 7012 7012
q6 244 122 123 122
q7 3201 2791 2846 2791
q8 4337 4453 4457 4453
q9 16914 16817 16716 16716
q10 4219 4242 4264 4242
q11 770 681 693 681
q12 1036 850 856 850
q13 6280 3748 3725 3725
q14 451 420 425 420
q15 508 463 457 457
q16 755 695 689 689
q17 3855 3823 3761 3761
q18 8791 8822 8724 8724
q19 1726 1674 1654 1654
q20 2376 2154 2153 2153
q21 8539 8459 8418 8418
q22 1081 975 998 975
Total cold run time: 83735 ms
Total hot run time: 79241 ms
TeamCity be ut coverage result: Function Coverage: 37.88% (8113/21417) Line Coverage: 29.55% (66451/224870) Region Coverage: 29.02% (34245/118017) Branch Coverage: 24.89% (17590/70662) Coverage Report: http://coverage.selectdb-in.cc/coverage/718e8ebfa893c5101d5852cc5b057f38c5a91c95_718e8ebfa893c5101d5852cc5b057f38c5a91c95/report/index.html
TPC-DS: Total hot run time: 203038 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 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false
query1 925 421 379 379
query2 6550 2857 2770 2770
query3 6921 204 204 204
query4 21333 18097 17972 17972
query5 19746 6564 6563 6563
query6 301 222 236 222
query7 4294 304 310 304
query8 424 464 416 416
query9 3158 2685 2607 2607
query10 428 300 296 296
query11 11332 10629 10567 10567
query12 123 75 76 75
query13 5598 673 698 673
query14 17989 13362 13378 13362
query15 359 240 245 240
query16 6426 283 266 266
query17 1700 1443 878 878
query18 2313 421 422 421
query19 201 150 149 149
query20 82 79 79 79
query21 189 102 96 96
query22 5171 4984 4906 4906
query23 32624 31814 31934 31814
query24 6872 6540 6473 6473
query25 529 449 405 405
query26 512 170 163 163
query27 1805 306 303 303
query28 6160 2350 2300 2300
query29 2876 2776 2692 2692
query30 240 161 167 161
query31 915 726 733 726
query32 73 63 63 63
query33 404 251 257 251
query34 865 471 482 471
query35 1119 934 917 917
query36 1295 1258 1301 1258
query37 92 60 61 60
query38 3148 2973 2948 2948
query39 1370 1328 1318 1318
query40 211 91 95 91
query41 46 43 45 43
query42 81 81 85 81
query43 782 663 715 663
query44 1163 730 739 730
query45 249 240 237 237
query46 1222 973 995 973
query47 2100 1719 1800 1719
query48 1012 717 727 717
query49 629 386 382 382
query50 855 571 610 571
query51 4807 4635 4617 4617
query52 88 94 76 76
query53 453 325 341 325
query54 2656 2470 2491 2470
query55 89 79 85 79
query56 234 225 209 209
query57 1142 1084 1094 1084
query58 222 194 188 188
query59 3948 3592 3944 3592
query60 209 199 195 195
query61 97 99 95 95
query62 830 521 525 521
query63 489 350 355 350
query64 2222 1527 1460 1460
query65 3653 3545 3539 3539
query66 800 376 368 368
query67 15402 15300 18284 15300
query68 9336 683 689 683
query69 559 347 332 332
query70 1570 1429 1283 1283
query71 393 304 320 304
query72 6472 3481 3470 3470
query73 749 326 327 326
query74 6265 5837 5837 5837
query75 5331 3635 3706 3635
query76 5881 1115 1153 1115
query77 1003 258 256 256
query78 12566 11683 11657 11657
query79 8835 662 643 643
query80 1059 403 404 403
query81 490 242 229 229
query82 841 96 100 96
query83 168 141 131 131
query84 261 71 69 69
query85 868 317 315 315
query86 330 333 309 309
query87 3279 3002 3034 3002
query88 4559 2306 2312 2306
query89 467 290 285 285
query90 1918 222 211 211
query91 181 141 142 141
query92 61 53 51 51
query93 6805 589 610 589
query94 704 209 213 209
query95 1104 1072 1040 1040
query96 640 330 327 327
query97 6469 6350 6333 6333
query98 184 180 168 168
query99 3001 840 986 840
Total cold run time: 314502 ms
Total hot run time: 203038 ms
ClickBench: Total hot run time: 30.6 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.02 0.02
query3 0.24 0.04 0.04
query4 1.81 0.07 0.07
query5 0.54 0.52 0.52
query6 1.23 0.72 0.61
query7 0.02 0.01 0.01
query8 0.03 0.02 0.03
query9 0.54 0.50 0.48
query10 0.53 0.53 0.54
query11 0.12 0.09 0.09
query12 0.11 0.08 0.09
query13 0.61 0.62 0.60
query14 0.77 0.81 0.77
query15 0.79 0.77 0.76
query16 0.37 0.37 0.37
query17 1.00 1.02 1.00
query18 0.22 0.25 0.24
query19 1.84 1.78 1.86
query20 0.02 0.01 0.01
query21 15.47 0.57 0.55
query22 2.06 2.11 1.91
query23 17.13 0.94 0.90
query24 8.34 0.86 0.60
query25 0.39 0.11 0.07
query26 0.82 0.14 0.15
query27 0.04 0.04 0.05
query28 5.41 0.80 0.73
query29 12.60 2.31 2.27
query30 0.60 0.53 0.53
query31 2.80 0.38 0.38
query32 3.38 0.51 0.49
query33 3.08 3.08 3.09
query34 15.25 4.82 4.79
query35 4.86 4.83 4.84
query36 1.04 1.01 1.01
query37 0.06 0.05 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.15
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.02 0.02 0.01
Total cold run time: 104.55 s
Total hot run time: 30.6 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.5 seconds inserted 10000000 Rows, about 465K ops/s
run external