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/02/28 10:54:41 UTC
[PR] [fix](Nereids) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
morrySnow opened a new pull request, #31545:
URL: https://github.com/apache/doris/pull/31545
pick from master #31510
commit id a459e6f35a9ae4beabfb9e36fe29451b075fea93
SQL: SELECT iD FROM t1
before the label was: id
after this PR the label will be: iD
--
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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968727681
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
--
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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968793521
<details>
<summary>ClickBench: <b>Total hot run time: 30.98 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 0800b08670113e24aab35b2e01f48ca0dd9f03f6, data reload: false
query1 0.03 0.02 0.03
query2 0.06 0.02 0.02
query3 0.24 0.06 0.05
query4 1.81 0.07 0.06
query5 0.53 0.53 0.53
query6 1.26 0.62 0.63
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.53 0.50 0.47
query10 0.53 0.53 0.54
query11 0.11 0.09 0.08
query12 0.12 0.09 0.09
query13 0.63 0.62 0.61
query14 0.77 0.79 0.79
query15 0.79 0.76 0.76
query16 0.38 0.39 0.35
query17 1.01 1.00 1.02
query18 0.22 0.25 0.23
query19 1.95 1.84 1.86
query20 0.02 0.00 0.01
query21 15.48 0.57 0.57
query22 2.01 2.41 1.60
query23 17.47 0.93 0.91
query24 4.62 2.42 1.24
query25 0.38 0.09 0.04
query26 0.73 0.14 0.14
query27 0.05 0.04 0.04
query28 7.03 0.75 0.70
query29 12.75 2.33 2.34
query30 0.60 0.53 0.52
query31 2.85 0.39 0.37
query32 3.43 0.50 0.49
query33 3.08 3.03 3.10
query34 15.25 4.85 4.82
query35 4.89 4.85 4.84
query36 1.05 1.02 1.02
query37 0.05 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.01
query40 0.16 0.13 0.14
query41 0.07 0.01 0.01
query42 0.01 0.01 0.01
query43 0.02 0.01 0.02
Total cold run time: 103.06 s
Total hot run time: 30.98 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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968784752
<details>
<summary>TPC-DS: <b>Total hot run time: 202253 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 0800b08670113e24aab35b2e01f48ca0dd9f03f6, data reload: false
query1 915 388 378 378
query2 6540 2235 2280 2235
query3 6907 204 208 204
query4 21220 17994 17911 17911
query5 19723 6486 6502 6486
query6 288 215 219 215
query7 4167 304 294 294
query8 266 254 286 254
query9 3122 2684 2630 2630
query10 436 274 279 274
query11 11332 10671 10665 10665
query12 125 76 70 70
query13 5577 630 618 618
query14 17748 13206 13295 13206
query15 367 233 237 233
query16 6435 275 262 262
query17 1577 1451 859 859
query18 2275 405 407 405
query19 217 141 148 141
query20 80 78 78 78
query21 199 94 94 94
query22 5236 5077 5142 5077
query23 32231 31857 31868 31857
query24 6947 6501 6435 6435
query25 527 418 423 418
query26 529 166 155 155
query27 1904 288 295 288
query28 6054 2208 2188 2188
query29 2881 2805 2680 2680
query30 242 162 162 162
query31 898 746 724 724
query32 64 62 57 57
query33 393 257 248 248
query34 864 462 493 462
query35 1148 901 965 901
query36 1759 1527 1444 1444
query37 89 57 59 57
query38 3073 2971 2901 2901
query39 1368 1319 1303 1303
query40 204 95 95 95
query41 38 32 32 32
query42 94 84 83 83
query43 636 597 629 597
query44 1136 693 710 693
query45 240 226 225 225
query46 1245 968 985 968
query47 1763 1852 1636 1636
query48 988 676 658 658
query49 613 366 358 358
query50 862 594 579 579
query51 4759 4691 4641 4641
query52 86 81 82 81
query53 442 319 314 314
query54 2649 2414 2484 2414
query55 95 73 86 73
query56 196 205 204 204
query57 1268 1119 1028 1028
query58 210 210 202 202
query59 3391 3147 3317 3147
query60 200 184 208 184
query61 83 86 87 86
query62 883 456 525 456
query63 473 335 339 335
query64 2523 1477 1284 1284
query65 3618 3520 3532 3520
query66 757 357 354 354
query67 15853 15651 14984 14984
query68 8622 663 673 663
query69 575 335 349 335
query70 1912 1893 1833 1833
query71 402 310 303 303
query72 6472 3392 3443 3392
query73 724 331 320 320
query74 6323 5909 5898 5898
query75 5047 3670 3687 3670
query76 5207 1168 1170 1168
query77 790 242 250 242
query78 12847 15109 12567 12567
query79 8012 629 658 629
query80 742 379 397 379
query81 491 232 233 232
query82 571 95 101 95
query83 163 134 131 131
query84 260 72 69 69
query85 684 276 288 276
query86 380 368 390 368
query87 3219 3036 3013 3013
query88 4547 2348 2337 2337
query89 340 317 296 296
query90 1905 212 210 210
query91 163 122 116 116
query92 57 53 52 52
query93 2963 553 580 553
query94 679 205 210 205
query95 1099 1090 1057 1057
query96 648 329 323 323
query97 6609 6393 6411 6393
query98 184 169 179 169
query99 2434 1002 859 859
Total cold run time: 306099 ms
Total hot run time: 202253 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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968727712
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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #31545:
URL: https://github.com/apache/doris/pull/31545
--
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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968764739
<details>
<summary>TPC-H: <b>Total hot run time: 49958 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 0800b08670113e24aab35b2e01f48ca0dd9f03f6, data reload: false
------ Round 1 ----------------------------------
q1 17953 4390 4362 4362
q2 2038 153 140 140
q3 10484 1943 1946 1943
q4 10344 1217 1292 1217
q5 8551 3917 3934 3917
q6 230 122 125 122
q7 2028 1608 1624 1608
q8 9316 2708 2713 2708
q9 11147 10795 10613 10613
q10 8600 3514 3489 3489
q11 419 235 247 235
q12 464 300 297 297
q13 18357 3914 4027 3914
q14 355 329 334 329
q15 500 450 458 450
q16 697 585 590 585
q17 1121 968 954 954
q18 7185 6913 6763 6763
q19 1695 1592 1552 1552
q20 534 302 305 302
q21 4505 4108 4070 4070
q22 510 412 388 388
Total cold run time: 117033 ms
Total hot run time: 49958 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4298 4308 4281 4281
q2 316 220 232 220
q3 4174 4125 4116 4116
q4 2753 2730 2746 2730
q5 7348 7195 7217 7195
q6 238 118 119 118
q7 3179 2818 2819 2818
q8 4379 4431 4459 4431
q9 17577 17313 17299 17299
q10 4261 4262 4264 4262
q11 787 691 703 691
q12 1021 842 850 842
q13 7226 3721 3685 3685
q14 450 419 414 414
q15 495 458 448 448
q16 742 688 690 688
q17 3820 3825 3883 3825
q18 8746 8726 8728 8726
q19 1704 1693 1652 1652
q20 2371 2133 2070 2070
q21 8463 8386 8464 8386
q22 1026 981 931 931
Total cold run time: 85374 ms
Total hot run time: 79828 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) Make the case sensitivity of the result labels compatible with MySQL (#31510) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31545:
URL: https://github.com/apache/doris/pull/31545#issuecomment-1968798526
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 0800b08670113e24aab35b2e01f48ca0dd9f03f6 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.3 seconds inserted 10000000 Rows, about 469K 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