You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "starocean999 (via GitHub)" <gi...@apache.org> on 2024/01/04 08:37:22 UTC
[PR] [fix](nereids)index type should be converted to upper case for later comparasion [doris]
starocean999 opened a new pull request, #29524:
URL: https://github.com/apache/doris/pull/29524
## 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)index type should be converted to upper case for later comparasion [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1878429930
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)index type should be converted to upper case for later comparasion [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1876706582
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)index type should be converted to upper case for later comparasion [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1876756230
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.81 seconds
stream load tsv: 579 seconds loaded 74807831229 Bytes, about 123 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.3 seconds inserted 10000000 Rows, about 353K ops/s
storage size: 17184001011 Bytes
--
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)index type should be converted to upper case for later comparasion [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1878429878
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)index type should be converted to upper case for later comparasion [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #29524:
URL: https://github.com/apache/doris/pull/29524
--
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)index type should be converted to upper case for later comparasion [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1876757645
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 609b31453805d285f097a4774b97954e8ac0e2eb, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 940 341 327 327
query2 6414 2001 2113 2001
query3 6665 214 204 204
query4 26685 22422 22379 22379
query5 3885 488 493 488
query6 268 192 182 182
query7 4582 263 273 263
query8 230 205 195 195
query9 8183 2667 2522 2522
query10 408 261 229 229
query11 16247 15521 15565 15521
query12 132 77 79 77
query13 1627 330 321 321
query14 11314 7004 7110 7004
query15 223 187 194 187
query16 6157 264 259 259
query17 1837 499 488 488
query18 1811 261 253 253
query19 189 138 128 128
query20 81 71 78 71
query21 184 96 97 96
query22 4769 4610 4731 4610
query23 32092 30976 31396 30976
query24 12049 2778 2795 2778
query25 607 343 330 330
query26 1797 140 136 136
query27 2914 274 275 274
query28 7092 1864 1859 1859
query29 2182 382 399 382
query30 288 148 140 140
query31 1036 767 750 750
query32 88 58 52 52
query33 735 256 254 254
query34 906 445 436 436
query35 874 775 744 744
query36 1319 1232 1214 1214
query37 183 65 63 63
query38 3397 3277 3245 3245
query39 1324 1282 1274 1274
query40 309 90 86 86
query41 38 37 34 34
query42 85 84 93 84
query43 514 518 516 516
query44 1068 687 694 687
query45 194 187 187 187
query46 1086 648 636 636
query47 1674 1651 1567 1567
query48 334 253 253 253
query49 1233 312 308 308
query50 775 324 318 318
query51 5382 5262 5267 5262
query52 90 84 81 81
query53 208 152 143 143
query54 1437 577 548 548
query55 92 86 79 79
query56 198 180 183 180
query57 1073 945 946 945
query58 222 189 193 189
query59 2889 2617 2618 2617
query60 222 211 209 209
query61 89 87 88 87
query62 632 477 467 467
query63 161 151 150 150
query64 5941 1711 1659 1659
query65 3307 3258 3244 3244
query66 1389 348 334 334
query67 15371 15267 15234 15234
query68 9821 518 517 517
query69 519 252 254 252
query70 1724 1468 1543 1468
query71 472 221 215 215
query72 5380 3606 3593 3593
query73 1891 318 308 308
query74 7104 6385 6422 6385
query75 4712 2274 2274 2274
query76 6259 1100 1095 1095
query77 661 244 243 243
query78 9143 8626 8701 8626
query79 1021 503 495 495
query80 540 344 355 344
query81 477 208 213 208
query82 204 97 98 97
query83 168 138 134 134
query84 242 54 53 53
query85 939 299 278 278
query86 386 383 420 383
query87 3499 3402 3396 3396
query88 2843 2252 2241 2241
query89 324 260 270 260
query90 1882 195 192 192
query91 117 92 94 92
query92 61 53 50 50
query93 1037 469 474 469
query94 814 177 176 176
query95 455 413 406 406
query96 609 316 316 316
query97 4295 4170 4162 4162
query98 214 194 182 182
query99 1111 853 860 853
Total cold run time: 286651 ms
Total hot run time: 178579 ms
```
--
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)index type should be converted to upper case for later comparasion [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1876741754
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 609b31453805d285f097a4774b97954e8ac0e2eb, data reload: false
------ Round 1 ----------------------------------
q1 17665 5093 5096 5093
q2 2010 152 139 139
q3 10553 1107 1096 1096
q4 10182 766 803 766
q5 7783 2910 2929 2910
q6 211 134 137 134
q7 919 514 538 514
q8 9266 1981 2005 1981
q9 6714 6388 6349 6349
q10 8202 3003 2968 2968
q11 434 220 205 205
q12 394 230 228 228
q13 17995 3643 3643 3643
q14 233 217 219 217
q15 556 527 517 517
q16 439 413 399 399
q17 939 456 484 456
q18 7287 6617 6585 6585
q19 1592 1350 1335 1335
q20 698 312 318 312
q21 2801 2358 2418 2358
q22 373 327 311 311
Total cold run time: 107246 ms
Total hot run time: 38516 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5123 5022 5057 5022
q2 343 228 241 228
q3 3303 3263 3263 3263
q4 2115 2018 2004 2004
q5 5765 5731 5732 5731
q6 210 123 127 123
q7 2294 1920 1891 1891
q8 3326 3395 3379 3379
q9 8768 8689 8707 8689
q10 3769 3831 3830 3830
q11 574 487 486 486
q12 809 645 621 621
q13 6484 3188 3218 3188
q14 292 268 279 268
q15 579 525 522 522
q16 534 510 487 487
q17 1917 1781 1743 1743
q18 8669 8279 8232 8232
q19 1608 1563 1563 1563
q20 2154 1951 1923 1923
q21 5475 5242 5244 5242
q22 525 460 472 460
Total cold run time: 64636 ms
Total hot run time: 58895 ms
```
--
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)index type should be converted to upper case for later comparasion [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29524:
URL: https://github.com/apache/doris/pull/29524#issuecomment-1876752029
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 609b31453805d285f097a4774b97954e8ac0e2eb, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5476 5110 5090 5090
q2 387 168 158 158
q3 1475 1190 1237 1190
q4 1081 827 765 765
q5 3111 3079 3121 3079
q6 226 137 137 137
q7 996 565 537 537
q8 2155 2212 2234 2212
q9 6717 6677 6672 6672
q10 3182 3132 3192 3132
q11 346 222 210 210
q12 378 229 233 229
q13 4382 3643 3674 3643
q14 255 223 214 214
q15 578 536 522 522
q16 460 393 395 393
q17 1039 497 575 497
q18 7123 6734 6877 6734
q19 1652 1506 1491 1491
q20 596 362 352 352
q21 2892 2498 2483 2483
q22 386 317 332 317
Total cold run time: 44893 ms
Total hot run time: 40057 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5075 4996 5083 4996
q2 341 236 231 231
q3 3361 3328 3315 3315
q4 2161 2068 2033 2033
q5 5953 5927 5930 5927
q6 224 127 129 127
q7 2385 1928 1954 1928
q8 3565 3639 3653 3639
q9 9028 9010 8972 8972
q10 3878 3891 3898 3891
q11 569 491 483 483
q12 811 634 616 616
q13 3890 3195 3194 3194
q14 311 263 251 251
q15 594 538 529 529
q16 558 510 538 510
q17 2073 1862 1856 1856
q18 8797 8381 8396 8381
q19 1756 1678 1701 1678
q20 2269 1968 1983 1968
q21 5750 5350 5352 5350
q22 543 534 485 485
Total cold run time: 63892 ms
Total hot run time: 60360 ms
```
--
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