doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Featrue](default value) Add UUID default value
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}
TeamCity be ut coverage result: Function Coverage: 35.52% (8926/25130) Line Coverage: 27.14% (73455/270656) Region Coverage: 26.33% (37951/144132) Branch Coverage: 23.11% (19327/83616) Coverage Report: http://coverage.selectdb-in.cc/coverage/12c1e7ab02fb53c828ee5ca5ab0c5c12e5d8779f_12c1e7ab02fb53c828ee5ca5ab0c5c12e5d8779f/report/index.html
TPC-DS: Total hot run time: 185008 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 12c1e7ab02fb53c828ee5ca5ab0c5c12e5d8779f, data reload: false
query1 915 356 356 356
query2 6447 2290 2436 2290
query3 6656 202 203 202
query4 23116 21133 21231 21133
query5 4181 426 413 413
query6 289 207 176 176
query7 4602 289 287 287
query8 251 193 191 191
query9 8565 2337 2307 2307
query10 431 243 237 237
query11 14609 14196 14173 14173
query12 137 88 83 83
query13 1652 366 383 366
query14 10606 6631 7865 6631
query15 283 169 174 169
query16 8154 254 256 254
query17 1860 557 538 538
query18 2107 274 273 273
query19 199 148 148 148
query20 91 86 94 86
query21 199 123 122 122
query22 5112 4856 4792 4792
query23 33883 33501 33206 33206
query24 10856 2986 2949 2949
query25 607 370 372 370
query26 1195 150 150 150
query27 3021 329 329 329
query28 7553 2004 1994 1994
query29 871 616 594 594
query30 293 149 158 149
query31 934 733 736 733
query32 95 60 55 55
query33 749 249 238 238
query34 1087 484 491 484
query35 808 684 665 665
query36 1093 918 908 908
query37 138 66 65 65
query38 3067 2993 2994 2993
query39 1573 1531 1537 1531
query40 198 132 122 122
query41 44 39 39 39
query42 103 96 97 96
query43 567 524 530 524
query44 1240 735 742 735
query45 290 269 263 263
query46 1092 741 718 718
query47 1941 1859 1872 1859
query48 363 310 291 291
query49 1090 403 426 403
query50 766 381 388 381
query51 6663 6514 6588 6514
query52 105 90 91 90
query53 357 282 277 277
query54 308 233 238 233
query55 88 72 70 70
query56 233 224 222 222
query57 1218 1127 1123 1123
query58 224 199 198 198
query59 3363 3213 3107 3107
query60 253 237 228 228
query61 93 87 87 87
query62 644 432 444 432
query63 303 275 277 275
query64 8608 7160 7170 7160
query65 3125 3035 3067 3035
query66 1388 341 341 341
query67 15417 14877 15015 14877
query68 5224 544 553 544
query69 485 320 302 302
query70 1179 1069 1122 1069
query71 387 271 264 264
query72 7578 2745 2542 2542
query73 707 326 331 326
query74 6499 6202 6030 6030
query75 3449 2659 2690 2659
query76 3247 1023 1023 1023
query77 413 270 262 262
query78 11041 10236 10108 10108
query79 8509 519 529 519
query80 1927 459 453 453
query81 536 227 221 221
query82 1578 94 103 94
query83 320 168 165 165
query84 277 91 90 90
query85 1679 326 319 319
query86 465 319 312 312
query87 3253 3143 3071 3071
query88 5430 2344 2428 2344
query89 560 375 372 372
query90 1992 182 184 182
query91 121 96 97 96
query92 54 47 48 47
query93 6736 532 515 515
query94 1252 187 180 180
query95 388 302 314 302
query96 597 266 261 261
query97 3199 2909 2930 2909
query98 238 218 213 213
query99 1287 874 877 874
Total cold run time: 298976 ms
Total hot run time: 185008 ms
TeamCity be ut coverage result: Function Coverage: 35.52% (8926/25130) Line Coverage: 27.14% (73450/270656) Region Coverage: 26.32% (37940/144132) Branch Coverage: 23.12% (19330/83616) Coverage Report: http://coverage.selectdb-in.cc/coverage/79bfa779114f35c0011be912780b80c64df66944_79bfa779114f35c0011be912780b80c64df66944/report/index.html
TPC-H: Total hot run time: 41001 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 79bfa779114f35c0011be912780b80c64df66944, data reload: false
------ Round 1 ----------------------------------
q1 17599 4281 4241 4241
q2 2022 186 185 185
q3 10463 1191 1182 1182
q4 10205 858 780 780
q5 7515 2792 2700 2700
q6 219 131 134 131
q7 1036 627 616 616
q8 9218 2155 2092 2092
q9 10674 6837 6762 6762
q10 9517 3879 3853 3853
q11 440 242 244 242
q12 457 218 225 218
q13 17405 3195 3154 3154
q14 268 217 234 217
q15 503 468 471 468
q16 468 430 404 404
q17 958 621 735 621
q18 8404 7693 7771 7693
q19 4116 1542 1533 1533
q20 632 316 309 309
q21 5219 3330 4137 3330
q22 343 273 270 270
Total cold run time: 117681 ms
Total hot run time: 41001 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4557 4416 4376 4376
q2 367 259 276 259
q3 3143 2936 2935 2935
q4 2003 1628 1576 1576
q5 5424 5501 5489 5489
q6 208 119 117 117
q7 2303 1958 1957 1957
q8 3303 3436 3454 3436
q9 8878 8898 8972 8898
q10 4072 3714 3833 3714
q11 583 492 486 486
q12 793 631 608 608
q13 17149 3134 3112 3112
q14 326 283 281 281
q15 534 489 471 471
q16 485 446 429 429
q17 1840 1523 1452 1452
q18 7688 7497 7422 7422
q19 1633 1540 1528 1528
q20 1951 1786 1749 1749
q21 10379 4737 4812 4737
q22 550 488 478 478
Total cold run time: 78169 ms
Total hot run time: 55510 ms
TPC-DS: Total hot run time: 185968 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 79bfa779114f35c0011be912780b80c64df66944, data reload: false
query1 921 356 343 343
query2 6445 2351 2301 2301
query3 6644 201 202 201
query4 23151 21140 21188 21140
query5 4101 407 411 407
query6 261 179 208 179
query7 4583 295 301 295
query8 255 190 186 186
query9 8665 2304 2287 2287
query10 425 238 232 232
query11 14754 14187 14178 14178
query12 142 90 82 82
query13 1629 363 360 360
query14 10480 7416 7425 7416
query15 224 172 178 172
query16 7716 259 264 259
query17 1716 573 560 560
query18 1963 266 269 266
query19 202 143 143 143
query20 90 84 85 84
query21 199 122 125 122
query22 5011 4846 4823 4823
query23 33761 33101 33240 33101
query24 6744 3001 2967 2967
query25 591 376 376 376
query26 707 153 144 144
query27 2113 319 330 319
query28 4076 2012 2003 2003
query29 838 607 592 592
query30 251 150 151 150
query31 999 733 731 731
query32 86 50 52 50
query33 486 246 237 237
query34 867 467 483 467
query35 780 694 687 687
query36 1034 928 864 864
query37 104 67 68 67
query38 3145 3037 3034 3034
query39 1575 1532 1515 1515
query40 192 124 122 122
query41 41 36 37 36
query42 105 94 95 94
query43 581 553 541 541
query44 1074 722 725 722
query45 259 258 257 257
query46 1062 730 732 730
query47 1947 1880 1856 1856
query48 363 291 284 284
query49 832 407 394 394
query50 766 374 384 374
query51 6720 6509 6634 6509
query52 98 90 94 90
query53 339 275 275 275
query54 261 225 228 225
query55 78 74 76 74
query56 238 218 219 218
query57 1193 1134 1133 1133
query58 219 195 192 192
query59 3268 3326 3127 3127
query60 263 230 235 230
query61 93 113 88 88
query62 613 447 438 438
query63 307 274 277 274
query64 8123 7150 7132 7132
query65 3065 3027 3053 3027
query66 780 338 331 331
query67 15091 15184 15156 15156
query68 5358 530 549 530
query69 533 307 302 302
query70 1191 1162 1079 1079
query71 401 262 266 262
query72 8435 2730 2547 2547
query73 724 326 326 326
query74 6538 6074 6071 6071
query75 3365 2702 2669 2669
query76 3639 999 1016 999
query77 598 263 262 262
query78 11015 10212 10203 10203
query79 8456 509 526 509
query80 2192 446 440 440
query81 542 229 228 228
query82 1138 97 96 96
query83 308 167 165 165
query84 276 86 85 85
query85 1518 328 312 312
query86 457 298 325 298
query87 3350 3074 3153 3074
query88 5220 2319 2303 2303
query89 503 379 382 379
query90 2037 183 182 182
query91 124 95 97 95
query92 66 50 47 47
query93 6706 517 498 498
query94 1258 179 181 179
query95 390 292 295 292
query96 599 263 263 263
query97 3114 2943 2963 2943
query98 230 223 222 222
query99 1222 839 886 839
Total cold run time: 287208 ms
Total hot run time: 185968 ms
TeamCity be ut coverage result: Function Coverage: 35.52% (8926/25130) Line Coverage: 27.14% (73457/270656) Region Coverage: 26.33% (37951/144120) Branch Coverage: 23.12% (19330/83604) Coverage Report: http://coverage.selectdb-in.cc/coverage/21a8ec70429cb98f147cd178bb3cf2f689afe0ad_21a8ec70429cb98f147cd178bb3cf2f689afe0ad/report/index.html
TPC-DS: Total hot run time: 185067 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 21a8ec70429cb98f147cd178bb3cf2f689afe0ad, data reload: false
query1 920 356 347 347
query2 6935 2422 2370 2370
query3 6659 209 207 207
query4 22869 21273 21135 21135
query5 4166 438 417 417
query6 288 179 177 177
query7 4590 289 304 289
query8 257 207 175 175
query9 8446 2323 2314 2314
query10 431 242 245 242
query11 14833 14250 14192 14192
query12 137 90 87 87
query13 1630 366 379 366
query14 10500 6677 6772 6677
query15 216 172 184 172
query16 7868 271 252 252
query17 1831 580 551 551
query18 1985 297 266 266
query19 203 152 153 152
query20 91 87 85 85
query21 201 136 129 129
query22 4932 4841 4798 4798
query23 33778 33088 33229 33088
query24 10943 2958 2967 2958
query25 635 371 366 366
query26 1394 153 152 152
query27 3117 309 324 309
query28 7842 2020 2021 2020
query29 899 614 591 591
query30 295 151 152 151
query31 965 717 726 717
query32 91 55 55 55
query33 754 256 248 248
query34 1092 473 474 473
query35 839 675 663 663
query36 1040 918 876 876
query37 138 65 68 65
query38 3171 3001 2964 2964
query39 1575 1536 1519 1519
query40 211 126 122 122
query41 44 39 39 39
query42 103 93 98 93
query43 573 552 548 548
query44 1202 736 746 736
query45 275 264 263 263
query46 1060 719 714 714
query47 1924 1854 1862 1854
query48 373 297 302 297
query49 1088 399 409 399
query50 759 399 378 378
query51 6910 6840 6851 6840
query52 102 87 93 87
query53 343 281 276 276
query54 299 248 265 248
query55 77 73 71 71
query56 239 220 224 220
query57 1225 1127 1133 1127
query58 231 199 199 199
query59 3579 3243 3279 3243
query60 269 244 237 237
query61 101 110 90 90
query62 675 425 441 425
query63 305 281 288 281
query64 8512 7158 7200 7158
query65 3149 3110 3035 3035
query66 1424 340 336 336
query67 15305 15054 14638 14638
query68 5206 545 528 528
query69 500 298 295 295
query70 1145 1132 1124 1124
query71 382 271 272 271
query72 7257 2692 2412 2412
query73 696 322 323 322
query74 6458 5981 6168 5981
query75 3405 2676 2672 2672
query76 2926 1022 973 973
query77 415 266 272 266
query78 10972 10225 10266 10225
query79 5988 534 517 517
query80 1755 465 425 425
query81 537 228 216 216
query82 1338 98 91 91
query83 282 172 175 172
query84 274 83 82 82
query85 2151 280 264 264
query86 487 307 294 294
query87 3259 3114 3093 3093
query88 4873 2317 2334 2317
query89 493 379 373 373
query90 1982 185 181 181
query91 129 99 98 98
query92 64 47 48 47
query93 5343 519 507 507
query94 1245 186 188 186
query95 392 303 305 303
query96 604 263 262 262
query97 3130 2964 2925 2925
query98 248 231 212 212
query99 1219 884 864 864
Total cold run time: 294068 ms
Total hot run time: 185067 ms
TeamCity be ut coverage result: Function Coverage: 35.50% (8926/25146) Line Coverage: 27.19% (73613/270722) Region Coverage: 26.37% (38022/144162) Branch Coverage: 23.17% (19374/83624) Coverage Report: http://coverage.selectdb-in.cc/coverage/2b285080651595dba8a7c3211c1ad9103917de5a_2b285080651595dba8a7c3211c1ad9103917de5a/report/index.html
TPC-H: Total hot run time: 41119 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2b285080651595dba8a7c3211c1ad9103917de5a, data reload: false
------ Round 1 ----------------------------------
q1 17590 4362 4237 4237
q2 2007 187 191 187
q3 10469 1217 1236 1217
q4 10197 762 855 762
q5 7531 2690 2830 2690
q6 213 134 137 134
q7 1027 630 630 630
q8 9230 2131 2085 2085
q9 10018 6808 6810 6808
q10 9104 4002 3969 3969
q11 436 245 244 244
q12 444 222 238 222
q13 17222 3086 3224 3086
q14 267 228 255 228
q15 515 476 473 473
q16 487 390 409 390
q17 959 680 691 680
q18 8342 7894 7679 7679
q19 2763 1563 1489 1489
q20 632 326 303 303
q21 5186 4107 3330 3330
q22 342 276 325 276
Total cold run time: 114981 ms
Total hot run time: 41119 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4609 4426 4343 4343
q2 375 263 263 263
q3 3153 2980 2928 2928
q4 1858 1584 1578 1578
q5 5456 5517 5495 5495
q6 214 122 126 122
q7 2345 1995 1966 1966
q8 3283 3415 3340 3340
q9 8812 8817 8835 8817
q10 4020 3732 3847 3732
q11 589 490 498 490
q12 803 640 656 640
q13 16323 3118 3165 3118
q14 303 291 295 291
q15 510 482 488 482
q16 500 440 445 440
q17 1767 1483 1442 1442
q18 7785 7642 7361 7361
q19 1646 1491 1520 1491
q20 1939 1743 1756 1743
q21 9430 4865 4863 4863
q22 579 509 502 502
Total cold run time: 76299 ms
Total hot run time: 55447 ms
TPC-DS: Total hot run time: 185463 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 2b285080651595dba8a7c3211c1ad9103917de5a, data reload: false
query1 904 362 352 352
query2 6455 2451 2477 2451
query3 6651 213 210 210
query4 23600 21170 21185 21170
query5 4123 418 432 418
query6 267 199 182 182
query7 4587 283 288 283
query8 236 185 195 185
query9 8571 2383 2369 2369
query10 408 237 245 237
query11 14671 14112 14195 14112
query12 143 85 85 85
query13 1655 372 379 372
query14 9742 7384 6750 6750
query15 234 168 177 168
query16 8037 275 275 275
query17 1700 587 556 556
query18 2036 294 276 276
query19 202 158 156 156
query20 94 101 89 89
query21 199 127 128 127
query22 5026 4769 4840 4769
query23 33824 33147 33111 33111
query24 8883 2991 2965 2965
query25 572 369 376 369
query26 694 151 145 145
query27 2199 315 327 315
query28 5820 2065 2075 2065
query29 847 615 608 608
query30 262 156 151 151
query31 1004 728 733 728
query32 91 52 52 52
query33 636 253 248 248
query34 883 483 480 480
query35 773 691 664 664
query36 1094 919 943 919
query37 105 65 68 65
query38 3183 3048 3030 3030
query39 1567 1548 1549 1548
query40 196 124 123 123
query41 44 38 39 38
query42 103 95 102 95
query43 560 590 553 553
query44 1105 733 733 733
query45 277 272 276 272
query46 1082 711 742 711
query47 1954 1865 1909 1865
query48 363 312 294 294
query49 822 391 396 391
query50 779 386 386 386
query51 6782 6556 6666 6556
query52 108 86 89 86
query53 350 283 282 282
query54 319 264 245 245
query55 79 75 71 71
query56 236 221 222 221
query57 1224 1129 1126 1126
query58 213 195 197 195
query59 3561 3107 3321 3107
query60 262 253 238 238
query61 93 89 90 89
query62 588 456 442 442
query63 304 274 274 274
query64 8178 7124 7074 7074
query65 3083 3053 3023 3023
query66 809 338 339 338
query67 15821 15563 14879 14879
query68 5174 545 585 545
query69 471 307 310 307
query70 1152 1123 1047 1047
query71 374 272 279 272
query72 8187 2622 2471 2471
query73 710 333 339 333
query74 6520 6042 6154 6042
query75 3351 2711 2653 2653
query76 2842 1007 1022 1007
query77 379 258 259 258
query78 10947 10378 10189 10189
query79 5348 523 520 520
query80 1879 434 439 434
query81 535 218 219 218
query82 1571 102 100 100
query83 298 191 173 173
query84 264 88 85 85
query85 1496 318 269 269
query86 471 285 291 285
query87 3295 3083 3090 3083
query88 5189 2440 2439 2439
query89 506 377 363 363
query90 2058 187 185 185
query91 127 99 99 99
query92 57 51 48 48
query93 5874 533 520 520
query94 1261 187 185 185
query95 405 302 305 302
query96 597 275 267 267
query97 3133 2936 2927 2927
query98 249 218 220 218
query99 1239 857 863 857
Total cold run time: 287232 ms
Total hot run time: 185463 ms