search

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
11.8k stars 3.11k forks source link

[enhance](Stage) Make the provider property for CreateStageStmt case insensitive #36995

Closed ByteYue closed 3 days ago

ByteYue commented 3 days ago

Proposed changes

Formerly the provider property for CreateStageStmt must be upper case like COS or AZURE, this pr makes it case insensitive.

doris-robot commented 3 days ago

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.

ByteYue commented 3 days ago

run buildall

doris-robot commented 3 days ago
TPC-H: Total hot run time: 39855 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ee5f5084e76022f187e79a0f638e1b5668eec37c, data reload: false ------ Round 1 ---------------------------------- q1 18016 4569 4369 4369 q2 2851 196 192 192 q3 12039 1188 1087 1087 q4 10607 867 818 818 q5 7739 2720 2681 2681 q6 222 139 135 135 q7 956 590 595 590 q8 9223 2060 2063 2060 q9 8958 6474 6524 6474 q10 8943 3728 3712 3712 q11 460 240 237 237 q12 416 240 235 235 q13 17769 2980 2956 2956 q14 257 218 223 218 q15 521 466 482 466 q16 511 372 371 371 q17 948 627 668 627 q18 8077 7460 7377 7377 q19 1682 1454 1412 1412 q20 638 309 335 309 q21 4972 3191 3311 3191 q22 395 342 338 338 Total cold run time: 116200 ms Total hot run time: 39855 ms ----- Round 2, with runtime_filter_mode=off ----- q1 4321 4240 4199 4199 q2 370 268 266 266 q3 2952 2738 2684 2684 q4 1884 1609 1600 1600 q5 5252 5282 5240 5240 q6 221 134 131 131 q7 2077 1737 1692 1692 q8 3170 3362 3271 3271 q9 8301 8369 8285 8285 q10 3897 3697 3649 3649 q11 573 489 481 481 q12 801 609 624 609 q13 16258 2982 3007 2982 q14 291 264 261 261 q15 510 472 474 472 q16 451 411 424 411 q17 1756 1470 1447 1447 q18 7753 7523 7357 7357 q19 2298 1555 1602 1555 q20 2018 1769 1762 1762 q21 4778 4614 4796 4614 q22 622 521 526 521 Total cold run time: 70554 ms Total hot run time: 53489 ms ```
doris-robot commented 3 days ago
TPC-DS: Total hot run time: 173977 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 ee5f5084e76022f187e79a0f638e1b5668eec37c, data reload: false query1 913 373 374 373 query2 6456 2455 2300 2300 query3 6650 210 215 210 query4 22238 17497 17273 17273 query5 4192 476 498 476 query6 262 161 165 161 query7 4595 302 294 294 query8 311 295 274 274 query9 8636 2513 2497 2497 query10 609 303 292 292 query11 10671 10086 10086 10086 query12 142 90 82 82 query13 1645 378 370 370 query14 10254 7790 7662 7662 query15 227 192 188 188 query16 7982 273 270 270 query17 1897 564 539 539 query18 1867 285 281 281 query19 207 164 157 157 query20 92 85 85 85 query21 214 140 137 137 query22 4274 4063 4067 4063 query23 33801 32977 33089 32977 query24 11045 2855 2877 2855 query25 641 386 382 382 query26 1555 157 161 157 query27 2908 316 323 316 query28 7304 2135 2131 2131 query29 960 644 636 636 query30 272 162 166 162 query31 988 753 780 753 query32 100 54 63 54 query33 792 305 298 298 query34 917 474 471 471 query35 747 623 630 623 query36 1076 929 937 929 query37 147 74 74 74 query38 2899 2768 2791 2768 query39 868 795 793 793 query40 285 128 129 128 query41 56 53 56 53 query42 128 103 106 103 query43 579 532 561 532 query44 1250 752 741 741 query45 201 168 167 167 query46 1072 748 733 733 query47 1886 1780 1783 1780 query48 370 299 312 299 query49 1214 417 422 417 query50 776 392 402 392 query51 6996 6833 6723 6723 query52 104 95 99 95 query53 360 304 300 300 query54 1075 459 447 447 query55 78 79 77 77 query56 306 291 305 291 query57 1162 1084 1065 1065 query58 271 249 247 247 query59 3416 3403 3189 3189 query60 297 276 280 276 query61 111 94 90 90 query62 660 446 475 446 query63 315 291 286 286 query64 9959 2269 1753 1753 query65 3208 3104 3121 3104 query66 1309 338 342 338 query67 15543 14961 14851 14851 query68 8589 587 584 584 query69 724 539 394 394 query70 1240 1076 1153 1076 query71 518 284 279 279 query72 8167 6018 5033 5033 query73 1712 325 322 322 query74 5888 5531 5466 5466 query75 5231 2686 2656 2656 query76 5050 961 964 961 query77 762 309 300 300 query78 10593 9915 9815 9815 query79 9342 527 526 526 query80 899 468 468 468 query81 551 231 221 221 query82 261 100 106 100 query83 345 171 165 165 query84 273 84 83 83 query85 961 293 310 293 query86 356 305 334 305 query87 3281 3122 3129 3122 query88 4661 2373 2374 2373 query89 517 379 371 371 query90 2063 194 195 194 query91 127 101 98 98 query92 66 49 48 48 query93 6153 520 508 508 query94 1358 192 184 184 query95 406 313 315 313 query96 593 273 280 273 query97 3202 3029 3100 3029 query98 221 200 193 193 query99 1197 852 853 852 Total cold run time: 299648 ms Total hot run time: 173977 ms ```