You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/01/17 12:12:00 UTC
[PR] [fix](Nereids) update assignment column name should case insensitive [doris]
morrySnow opened a new pull request, #30071:
URL: https://github.com/apache/doris/pull/30071
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1897877041
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1897868308
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895735482
<details>
<summary>TPC-DS: <b>Total hot run time: 177225 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a62c1d567c5658163705024b710c1f0c69791ebf, data reload: false
query1 937 329 331 329
query2 6549 1866 1940 1866
query3 6693 200 199 199
query4 32578 22154 22010 22010
query5 6903 508 532 508
query6 253 171 172 171
query7 4600 257 259 257
query8 223 179 194 179
query9 8394 2563 2548 2548
query10 421 228 238 228
query11 16823 15529 15622 15529
query12 121 69 69 69
query13 1711 378 378 378
query14 10600 6925 6933 6925
query15 209 182 186 182
query16 4606 236 225 225
query17 1002 485 484 484
query18 1786 264 258 258
query19 177 142 138 138
query20 70 66 66 66
query21 183 132 136 132
query22 5018 4839 4843 4839
query23 31553 30907 30812 30812
query24 12835 2823 2834 2823
query25 555 318 302 302
query26 1798 140 152 140
query27 3626 270 274 270
query28 7464 1851 1833 1833
query29 2142 625 629 625
query30 289 140 142 140
query31 895 751 771 751
query32 87 50 51 50
query33 713 209 224 209
query34 1305 477 454 454
query35 851 767 746 746
query36 1372 1267 1264 1264
query37 175 57 60 57
query38 3357 3233 3282 3233
query39 1321 1264 1254 1254
query40 338 87 81 81
query41 41 38 34 34
query42 99 79 82 79
query43 547 475 492 475
query44 1058 682 699 682
query45 196 186 177 177
query46 1053 644 663 644
query47 1687 1608 1566 1566
query48 396 327 320 320
query49 1218 285 281 281
query50 674 306 304 304
query51 5304 5173 5223 5173
query52 88 74 73 73
query53 322 257 249 249
query54 881 442 448 442
query55 84 77 75 75
query56 189 166 172 166
query57 996 936 936 936
query58 175 163 161 161
query59 2969 2667 2684 2667
query60 203 180 183 180
query61 86 82 90 82
query62 631 403 390 390
query63 281 266 256 256
query64 6123 1786 1760 1760
query65 3363 3245 3233 3233
query66 1383 317 313 313
query67 15467 15181 15077 15077
query68 12216 534 533 533
query69 589 304 290 290
query70 1729 1497 1553 1497
query71 556 207 223 207
query72 4857 2836 2812 2812
query73 2713 318 313 313
query74 7048 6412 6432 6412
query75 5005 2254 2315 2254
query76 6202 1049 990 990
query77 639 233 235 233
query78 9088 8952 8697 8697
query79 975 496 523 496
query80 541 320 322 320
query81 448 210 207 207
query82 199 86 78 78
query83 141 116 116 116
query84 271 69 73 69
query85 1076 319 309 309
query86 386 371 369 369
query87 3546 3372 3325 3325
query88 3103 2164 2148 2148
query89 444 361 353 353
query90 1994 188 183 183
query91 163 130 131 130
query92 52 41 44 41
query93 1365 463 450 450
query94 1161 161 156 156
query95 510 456 454 454
query96 602 319 318 318
query97 4299 4194 4245 4194
query98 196 207 196 196
query99 1089 716 742 716
Total cold run time: 299250 ms
Total hot run time: 177225 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895791422
<details>
<summary>TPC-DS: <b>Total hot run time: 176505 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit ee6d21e0206fc14778058fa0f2205267a916ecdd, data reload: false
query1 927 335 328 328
query2 6556 1931 2044 1931
query3 6705 202 199 199
query4 32238 22318 21996 21996
query5 6885 625 598 598
query6 254 171 175 171
query7 4624 259 260 259
query8 224 179 179 179
query9 8403 2581 2567 2567
query10 427 237 247 237
query11 16663 15544 15424 15424
query12 125 70 70 70
query13 1685 401 378 378
query14 10447 6881 6860 6860
query15 205 177 199 177
query16 4601 233 225 225
query17 997 478 465 465
query18 1799 264 252 252
query19 177 138 133 133
query20 67 73 62 62
query21 185 125 135 125
query22 4944 4728 4763 4728
query23 31705 30847 30740 30740
query24 11587 2832 2824 2824
query25 577 309 307 307
query26 1640 140 144 140
query27 3194 275 272 272
query28 7280 1844 1837 1837
query29 1650 633 631 631
query30 275 137 141 137
query31 931 737 732 732
query32 75 50 50 50
query33 696 206 208 206
query34 1168 455 447 447
query35 899 762 765 762
query36 1326 1258 1249 1249
query37 90 61 61 61
query38 3364 3236 3277 3236
query39 1308 1266 1258 1258
query40 303 89 86 86
query41 36 34 34 34
query42 87 87 80 80
query43 519 490 488 488
query44 1120 695 702 695
query45 208 183 175 175
query46 1073 650 655 650
query47 1666 1599 1603 1599
query48 402 313 314 313
query49 1127 283 285 283
query50 674 303 309 303
query51 5332 5153 5271 5153
query52 93 84 79 79
query53 320 254 249 249
query54 907 434 451 434
query55 79 75 75 75
query56 174 160 168 160
query57 944 917 909 909
query58 184 173 166 166
query59 2964 2760 2681 2681
query60 206 184 189 184
query61 84 85 84 84
query62 625 400 368 368
query63 273 257 257 257
query64 5093 1749 1762 1749
query65 3347 3233 3269 3233
query66 1293 322 311 311
query67 15533 14826 14878 14826
query68 12148 541 526 526
query69 619 292 298 292
query70 1722 1554 1545 1545
query71 550 209 207 207
query72 4893 2814 2837 2814
query73 2675 314 312 312
query74 7106 6325 6322 6322
query75 5070 2347 2258 2258
query76 6164 1021 1008 1008
query77 663 234 242 234
query78 9430 8825 8577 8577
query79 1009 498 510 498
query80 549 331 309 309
query81 459 208 205 205
query82 210 85 80 80
query83 144 116 117 116
query84 279 70 69 69
query85 1075 337 314 314
query86 370 377 409 377
query87 3613 3361 3347 3347
query88 3099 2161 2150 2150
query89 439 351 358 351
query90 1975 186 185 185
query91 152 124 122 122
query92 54 43 43 43
query93 1459 465 452 452
query94 1115 159 156 156
query95 483 469 453 453
query96 617 315 310 310
query97 4268 4112 4147 4112
query98 200 201 186 186
query99 1052 698 712 698
Total cold run time: 295230 ms
Total hot run time: 176505 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895806642
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ee6d21e0206fc14778058fa0f2205267a916ecdd 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: 14.9 seconds inserted 10000000 Rows, about 671K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895801115
<details>
<summary>ClickBench: <b>Total hot run time: 31.01 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit ee6d21e0206fc14778058fa0f2205267a916ecdd, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.03 0.02
query3 0.23 0.05 0.04
query4 1.71 0.08 0.08
query5 0.55 0.52 0.51
query6 1.34 0.65 0.62
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.54 0.49 0.50
query10 0.55 0.55 0.56
query11 0.11 0.09 0.08
query12 0.11 0.09 0.09
query13 0.60 0.61 0.61
query14 0.76 0.80 0.79
query15 0.78 0.78 0.77
query16 0.37 0.36 0.40
query17 0.98 1.00 0.99
query18 0.24 0.24 0.25
query19 1.84 1.78 1.78
query20 0.01 0.01 0.01
query21 15.42 0.56 0.56
query22 2.30 2.36 2.55
query23 17.34 0.84 0.77
query24 2.33 0.79 1.11
query25 0.50 0.18 0.17
query26 0.44 0.15 0.14
query27 0.05 0.06 0.05
query28 11.94 0.77 0.76
query29 12.53 3.07 3.16
query30 0.54 0.51 0.45
query31 2.78 0.34 0.35
query32 3.40 0.48 0.48
query33 3.29 3.20 3.21
query34 15.68 4.32 4.24
query35 4.22 4.20 4.29
query36 1.10 1.05 1.08
query37 0.06 0.05 0.05
query38 0.03 0.03 0.03
query39 0.03 0.02 0.01
query40 0.16 0.13 0.13
query41 0.07 0.02 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.12 s
Total hot run time: 31.01 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #30071:
URL: https://github.com/apache/doris/pull/30071
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895683550
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895716179
<details>
<summary>TPC-H: <b>Total hot run time: 39275 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a62c1d567c5658163705024b710c1f0c69791ebf, data reload: false
------ Round 1 ----------------------------------
q1 17594 5633 5457 5457
q2 2036 147 140 140
q3 10648 1200 1191 1191
q4 10837 786 777 777
q5 7825 3277 3209 3209
q6 208 127 126 126
q7 865 513 512 512
q8 9348 2007 2019 2007
q9 7830 6410 6386 6386
q10 8198 3031 3022 3022
q11 407 208 214 208
q12 361 199 194 194
q13 17989 3395 3400 3395
q14 251 215 220 215
q15 538 510 508 508
q16 427 401 373 373
q17 945 492 525 492
q18 7563 6768 6963 6768
q19 1551 1268 1456 1268
q20 604 306 291 291
q21 2907 2446 2436 2436
q22 359 308 300 300
Total cold run time: 109291 ms
Total hot run time: 39275 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5367 5255 5214 5214
q2 331 219 216 216
q3 3352 3257 3219 3219
q4 2096 2105 2050 2050
q5 6025 5951 5957 5951
q6 195 116 118 116
q7 2317 1880 1921 1880
q8 3217 3385 3380 3380
q9 9043 8865 8854 8854
q10 5930 3767 3836 3767
q11 703 459 469 459
q12 811 640 650 640
q13 16931 3184 3203 3184
q14 291 256 293 256
q15 551 506 496 496
q16 533 467 460 460
q17 1901 1836 1858 1836
q18 9516 10465 9303 9303
q19 24254 1622 1530 1530
q20 4649 1941 1931 1931
q21 14313 5524 5404 5404
q22 992 562 578 562
Total cold run time: 113318 ms
Total hot run time: 60708 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895737099
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](Nereids) update assignment column name should case insensitive [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30071:
URL: https://github.com/apache/doris/pull/30071#issuecomment-1895770938
<details>
<summary>TPC-H: <b>Total hot run time: 38994 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ee6d21e0206fc14778058fa0f2205267a916ecdd, data reload: false
------ Round 1 ----------------------------------
q1 17812 5278 5455 5278
q2 2392 139 130 130
q3 11319 1196 1165 1165
q4 10572 748 807 748
q5 7893 3220 3160 3160
q6 205 122 127 122
q7 868 511 482 482
q8 9250 1976 1987 1976
q9 7282 6400 6380 6380
q10 8221 3076 3037 3037
q11 422 211 211 211
q12 361 194 192 192
q13 18016 3346 3341 3341
q14 254 221 212 212
q15 544 505 497 497
q16 437 377 390 377
q17 937 527 512 512
q18 7629 6786 6955 6786
q19 1582 1369 1418 1369
q20 589 302 309 302
q21 2769 2408 2417 2408
q22 362 327 309 309
Total cold run time: 109716 ms
Total hot run time: 38994 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5314 5390 5339 5339
q2 326 225 208 208
q3 3349 3265 3200 3200
q4 2120 2051 2083 2051
q5 6010 5901 5912 5901
q6 199 121 120 120
q7 2276 1931 1910 1910
q8 3242 3358 3414 3358
q9 9013 8918 8795 8795
q10 4302 3752 3797 3752
q11 556 466 472 466
q12 822 618 615 615
q13 16917 3166 3168 3166
q14 285 266 264 264
q15 561 512 510 510
q16 526 489 472 472
q17 1912 1871 1819 1819
q18 9447 9420 17692 9420
q19 23772 1606 1536 1536
q20 4603 1925 1921 1921
q21 14198 5468 5459 5459
q22 966 536 568 536
Total cold run time: 110716 ms
Total hot run time: 60818 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org