doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Featrue](default value) Add UUID default value #34211
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-H: Total hot run time: 49948 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit cda716e5922da043023c30b8cc6166d749fdc4a9, data reload: false
------ Round 1 ----------------------------------
q1 17556 4376 4337 4337
q2 2025 152 143 143
q3 10286 1885 1854 1854
q4 10108 1256 1332 1256
q5 8403 3965 3907 3907
q6 228 128 125 125
q7 2020 1592 1617 1592
q8 9283 2708 2702 2702
q9 10720 10812 10655 10655
q10 8631 3507 3510 3507
q11 430 232 235 232
q12 475 305 308 305
q13 18342 3952 4041 3952
q14 354 322 322 322
q15 520 457 442 442
q16 672 575 573 573
q17 1117 962 960 960
q18 7219 6810 6975 6810
q19 1715 1612 1574 1574
q20 504 292 311 292
q21 4434 4027 4086 4027
q22 506 381 403 381
Total cold run time: 115548 ms
Total hot run time: 49948 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4299 4254 4295 4254
q2 312 222 215 215
q3 4185 4165 4118 4118
q4 2740 2755 2753 2753
q5 7164 7029 7067 7029
q6 238 119 120 119
q7 3251 2823 2843 2823
q8 4348 4436 4439 4436
q9 16756 16714 16666 16666
q10 4241 4261 4268 4261
q11 769 677 686 677
q12 1029 858 866 858
q13 4344 3747 3732 3732
q14 446 413 416 413
q15 490 463 448 448
q16 732 676 684 676
q17 3868 3903 3800 3800
q18 8865 8737 8727 8727
q19 1704 1684 1650 1650
q20 2345 2134 2089 2089
q21 8527 8549 8466 8466
q22 1013 892 918 892
Total cold run time: 81666 ms
Total hot run time: 79102 ms
TPC-DS: Total hot run time: 201991 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 cda716e5922da043023c30b8cc6166d749fdc4a9, data reload: false
query1 937 384 372 372
query2 6539 2837 2494 2494
query3 6918 196 195 195
query4 21034 18009 18033 18009
query5 19743 6540 6487 6487
query6 287 227 234 227
query7 4156 297 312 297
query8 291 258 253 253
query9 3092 2671 2611 2611
query10 425 291 299 291
query11 11367 10755 10832 10755
query12 125 75 72 72
query13 5585 707 671 671
query14 17883 13625 13339 13339
query15 383 220 222 220
query16 6467 269 255 255
query17 1719 1460 862 862
query18 2344 404 401 401
query19 195 137 148 137
query20 79 77 75 75
query21 188 91 92 91
query22 5268 4950 5038 4950
query23 32424 31770 31911 31770
query24 6956 6435 6420 6420
query25 498 425 411 411
query26 521 161 155 155
query27 1907 288 291 288
query28 6209 2337 2291 2291
query29 2901 2758 2859 2758
query30 238 162 160 160
query31 905 753 752 752
query32 66 56 60 56
query33 379 240 251 240
query34 840 461 480 461
query35 1133 917 822 822
query36 1327 1111 1260 1111
query37 92 61 62 61
query38 3084 2914 2866 2866
query39 1361 1309 1319 1309
query40 202 86 96 86
query41 37 35 34 34
query42 85 81 78 78
query43 801 696 705 696
query44 1113 726 728 726
query45 241 224 227 224
query46 1214 940 962 940
query47 1863 1673 1708 1673
query48 1016 721 714 714
query49 620 368 369 368
query50 870 609 585 585
query51 4743 4632 4678 4632
query52 88 91 80 80
query53 448 326 333 326
query54 2636 2441 2445 2441
query55 88 79 87 79
query56 202 206 216 206
query57 1140 1084 1197 1084
query58 210 194 188 188
query59 4122 3950 4333 3950
query60 198 204 193 193
query61 83 79 80 79
query62 830 455 464 455
query63 471 332 335 332
query64 2257 1482 1383 1383
query65 3646 3541 3576 3541
query66 837 360 373 360
query67 15800 15028 14871 14871
query68 11158 659 659 659
query69 575 343 337 337
query70 1958 1573 1404 1404
query71 412 307 314 307
query72 6537 3366 3400 3366
query73 1129 321 318 318
query74 6380 5834 5854 5834
query75 5558 3743 3726 3726
query76 6930 1154 1136 1136
query77 1176 264 250 250
query78 12666 11679 11936 11679
query79 7361 635 631 631
query80 918 385 387 385
query81 459 229 235 229
query82 814 99 95 95
query83 167 134 134 134
query84 257 71 68 68
query85 876 293 288 288
query86 315 276 284 276
query87 3242 3065 2975 2975
query88 4232 2270 2273 2270
query89 375 296 277 277
query90 1855 209 207 207
query91 164 138 133 133
query92 57 52 50 50
query93 6153 617 591 591
query94 645 203 202 202
query95 1120 1047 1071 1047
query96 647 315 320 315
query97 6451 6445 6452 6445
query98 178 172 167 167
query99 2945 871 955 871
Total cold run time: 315437 ms
Total hot run time: 201991 ms
TeamCity be ut coverage result: Function Coverage: 37.80% (8071/21351) Line Coverage: 29.46% (65925/223772) Region Coverage: 28.94% (33943/117285) Branch Coverage: 24.81% (17426/70250) Coverage Report: http://coverage.selectdb-in.cc/coverage/cda716e5922da043023c30b8cc6166d749fdc4a9_cda716e5922da043023c30b8cc6166d749fdc4a9/report/index.html
ClickBench: Total hot run time: 30.68 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit cda716e5922da043023c30b8cc6166d749fdc4a9, data reload: false
query1 0.02 0.02 0.02
query2 0.07 0.03 0.02
query3 0.24 0.06 0.05
query4 1.77 0.08 0.09
query5 0.55 0.53 0.53
query6 1.25 0.63 0.62
query7 0.02 0.01 0.01
query8 0.03 0.03 0.03
query9 0.52 0.50 0.47
query10 0.54 0.53 0.52
query11 0.12 0.09 0.09
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.79 0.78 0.78
query15 0.78 0.76 0.76
query16 0.36 0.39 0.36
query17 1.04 1.01 1.01
query18 0.22 0.26 0.25
query19 1.91 1.82 1.87
query20 0.02 0.01 0.01
query21 15.49 0.56 0.55
query22 2.11 2.39 1.52
query23 17.29 1.16 0.98
query24 5.68 1.24 1.12
query25 0.39 0.09 0.06
query26 0.66 0.14 0.16
query27 0.05 0.04 0.03
query28 7.08 0.76 0.72
query29 12.69 2.15 2.23
query30 0.58 0.50 0.52
query31 2.82 0.39 0.38
query32 3.37 0.50 0.48
query33 3.05 3.06 3.05
query34 15.24 4.77 4.77
query35 4.85 4.85 4.86
query36 1.07 1.02 1.01
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.01
query40 0.17 0.13 0.14
query41 0.06 0.02 0.01
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 103.8 s
Total hot run time: 30.68 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit cda716e5922da043023c30b8cc6166d749fdc4a9 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.4 seconds inserted 10000000 Rows, about 467K ops/s
TPC-H: Total hot run time: 49626 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit e67329ae29f96a071279447add1ce2f91dd6cf39, data reload: false
------ Round 1 ----------------------------------
q1 17642 4380 4333 4333
q2 2026 153 146 146
q3 10304 1908 1950 1908
q4 10100 1231 1333 1231
q5 8602 3910 3914 3910
q6 226 123 123 123
q7 2059 1606 1568 1568
q8 9565 2725 2727 2725
q9 12760 10236 10338 10236
q10 8628 3563 3491 3491
q11 419 239 242 239
q12 463 300 296 296
q13 18332 3966 4049 3966
q14 348 326 328 326
q15 521 455 445 445
q16 655 574 579 574
q17 1139 934 957 934
q18 7272 6916 6927 6916
q19 1698 1575 1510 1510
q20 536 301 294 294
q21 4416 4075 4062 4062
q22 499 393 399 393
Total cold run time: 118210 ms
Total hot run time: 49626 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4365 4298 4273 4273
q2 322 225 215 215
q3 4181 4165 4118 4118
q4 2751 2750 2754 2750
q5 7217 7117 7208 7117
q6 234 117 115 115
q7 3242 2872 2848 2848
q8 4384 4467 4512 4467
q9 16867 16793 16744 16744
q10 4220 4265 4240 4240
q11 764 694 678 678
q12 1015 865 871 865
q13 7091 3737 3752 3737
q14 458 420 427 420
q15 499 459 452 452
q16 729 682 687 682
q17 3902 3802 3865 3802
q18 8738 8835 8831 8831
q19 1710 1660 1599 1599
q20 2419 2176 2112 2112
q21 8488 8494 8465 8465
q22 1006 940 939 939
Total cold run time: 84602 ms
Total hot run time: 79469 ms
TPC-DS: Total hot run time: 202625 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 e67329ae29f96a071279447add1ce2f91dd6cf39, data reload: false
query1 902 383 381 381
query2 6546 2678 2552 2552
query3 6920 202 196 196
query4 20045 18165 18140 18140
query5 19733 6533 6508 6508
query6 292 213 217 213
query7 4153 301 299 299
query8 279 259 252 252
query9 3109 2704 2606 2606
query10 416 306 307 306
query11 11425 10692 10704 10692
query12 121 77 65 65
query13 5572 674 687 674
query14 17817 13492 13448 13448
query15 367 205 236 205
query16 6455 283 255 255
query17 1714 1463 862 862
query18 2312 412 415 412
query19 211 145 146 145
query20 71 78 74 74
query21 193 92 86 86
query22 5278 5190 5149 5149
query23 32583 32062 31781 31781
query24 6994 6517 6531 6517
query25 521 437 415 415
query26 527 165 152 152
query27 1866 296 291 291
query28 6109 2357 2328 2328
query29 2894 2647 2940 2647
query30 238 163 160 160
query31 924 726 732 726
query32 64 60 56 56
query33 406 259 245 245
query34 842 471 479 471
query35 1104 933 887 887
query36 1206 1214 1233 1214
query37 97 63 59 59
query38 3054 2965 2929 2929
query39 1364 1325 1338 1325
query40 197 95 100 95
query41 43 35 34 34
query42 87 84 84 84
query43 751 611 754 611
query44 1163 723 722 722
query45 239 229 227 227
query46 1220 942 963 942
query47 1864 1875 1764 1764
query48 1011 731 711 711
query49 631 369 375 369
query50 859 608 643 608
query51 4835 4624 4641 4624
query52 85 73 74 73
query53 440 317 313 313
query54 2628 2471 2481 2471
query55 86 73 83 73
query56 219 213 211 211
query57 1198 1133 1103 1103
query58 216 229 190 190
query59 3897 4102 3653 3653
query60 207 203 189 189
query61 89 86 85 85
query62 842 461 474 461
query63 474 341 335 335
query64 2356 1457 1516 1457
query65 3650 3573 3540 3540
query66 779 376 384 376
query67 15699 15027 14960 14960
query68 9750 663 658 658
query69 563 346 346 346
query70 1638 1566 1507 1507
query71 421 289 314 289
query72 6414 3440 3421 3421
query73 741 320 321 320
query74 6389 5881 5833 5833
query75 5321 3701 3661 3661
query76 6123 1132 1218 1132
query77 1028 250 244 244
query78 12601 11898 11599 11599
query79 9527 630 633 630
query80 1420 393 388 388
query81 490 226 231 226
query82 1579 103 102 102
query83 171 136 130 130
query84 255 69 68 68
query85 862 316 298 298
query86 338 294 310 294
query87 3281 3038 3015 3015
query88 4703 2243 2265 2243
query89 475 326 269 269
query90 1934 207 195 195
query91 164 130 128 128
query92 54 52 58 52
query93 6638 572 587 572
query94 706 200 200 200
query95 1112 1053 1064 1053
query96 652 326 314 314
query97 6471 6361 6408 6361
query98 197 174 178 174
query99 2976 899 914 899
Total cold run time: 315483 ms
Total hot run time: 202625 ms
TeamCity be ut coverage result: Function Coverage: 37.79% (8069/21351) Line Coverage: 29.45% (65902/223762) Region Coverage: 28.92% (33924/117283) Branch Coverage: 24.79% (17414/70250) Coverage Report: http://coverage.selectdb-in.cc/coverage/e67329ae29f96a071279447add1ce2f91dd6cf39_e67329ae29f96a071279447add1ce2f91dd6cf39/report/index.html
ClickBench: Total hot run time: 30.46 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit e67329ae29f96a071279447add1ce2f91dd6cf39, data reload: false
query1 0.03 0.02 0.02
query2 0.07 0.03 0.02
query3 0.24 0.05 0.04
query4 1.80 0.06 0.06
query5 0.53 0.52 0.52
query6 1.24 0.63 0.62
query7 0.02 0.01 0.00
query8 0.03 0.03 0.02
query9 0.53 0.49 0.48
query10 0.54 0.55 0.53
query11 0.12 0.08 0.09
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.80 0.78 0.80
query15 0.78 0.76 0.76
query16 0.36 0.38 0.38
query17 1.03 1.01 1.00
query18 0.23 0.25 0.24
query19 1.94 1.75 1.87
query20 0.01 0.01 0.01
query21 15.45 0.55 0.55
query22 1.90 2.20 1.55
query23 17.11 0.99 1.04
query24 4.66 0.80 1.10
query25 0.40 0.08 0.07
query26 0.51 0.15 0.14
query27 0.05 0.05 0.04
query28 8.57 0.73 0.70
query29 12.72 2.33 2.36
query30 0.62 0.52 0.53
query31 2.81 0.39 0.37
query32 3.38 0.51 0.50
query33 3.08 3.02 3.04
query34 15.27 4.78 4.77
query35 4.87 4.84 4.86
query36 1.08 1.03 1.02
query37 0.06 0.05 0.04
query38 0.03 0.02 0.02
query39 0.01 0.01 0.01
query40 0.16 0.14 0.14
query41 0.06 0.01 0.01
query42 0.02 0.01 0.01
query43 0.02 0.02 0.01
Total cold run time: 103.88 s
Total hot run time: 30.46 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit e67329ae29f96a071279447add1ce2f91dd6cf39 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.1 seconds inserted 10000000 Rows, about 473K ops/s
