You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2024/06/03 15:15:00 UTC
[PR] [feature](join) add hash table build type check [doris]
Mryange opened a new pull request, #35825:
URL: https://github.com/apache/doris/pull/35825
## Proposed changes
```
ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[INTERNAL_ERROR]build hash table failed , build type = (UInt32) , insert type = (Nullable, (UInt32), (UInt8))
```
<!--Describe your changes.-->
--
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] [feature](join) add hash table build type check [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2145473918
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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2145699181
TeamCity be ut coverage result:
Function Coverage: 36.23% (9240/25502)
Line Coverage: 27.57% (75847/275119)
Region Coverage: 26.81% (39287/146517)
Branch Coverage: 23.55% (19903/84530)
Coverage Report: http://coverage.selectdb-in.cc/coverage/70d135d43da43118cc6a2f284614c163c1195b15_70d135d43da43118cc6a2f284614c163c1195b15/report/index.html
--
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] [feature](join) add hash table build type check [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146296581
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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146345632
<details>
<summary>ClickBench: <b>Total hot run time: 31.3 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 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.05 0.04
query4 1.67 0.08 0.08
query5 0.52 0.50 0.51
query6 1.13 0.73 0.73
query7 0.02 0.01 0.01
query8 0.06 0.04 0.05
query9 0.56 0.48 0.50
query10 0.54 0.56 0.55
query11 0.16 0.12 0.12
query12 0.14 0.12 0.12
query13 0.59 0.59 0.61
query14 0.77 0.77 0.77
query15 0.83 0.81 0.81
query16 0.36 0.37 0.35
query17 1.00 1.03 1.02
query18 0.21 0.26 0.22
query19 1.85 1.70 1.76
query20 0.02 0.01 0.02
query21 15.73 0.66 0.65
query22 3.58 6.99 2.59
query23 18.29 1.36 1.24
query24 1.88 0.26 0.21
query25 0.15 0.08 0.08
query26 0.29 0.17 0.17
query27 0.07 0.07 0.09
query28 13.31 1.08 1.08
query29 13.17 3.31 3.28
query30 0.25 0.06 0.05
query31 2.85 0.38 0.38
query32 3.27 0.47 0.46
query33 2.91 2.86 2.93
query34 17.16 4.42 4.44
query35 4.45 4.61 4.48
query36 0.65 0.46 0.45
query37 0.18 0.15 0.15
query38 0.15 0.14 0.14
query39 0.05 0.04 0.04
query40 0.16 0.15 0.15
query41 0.09 0.06 0.05
query42 0.05 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.52 s
Total hot run time: 31.3 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] [feature](join) add hash table build type check [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146303477
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2145473518
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146322721
TeamCity be ut coverage result:
Function Coverage: 36.24% (9242/25503)
Line Coverage: 27.57% (75865/275132)
Region Coverage: 26.82% (39292/146525)
Branch Coverage: 23.56% (19914/84538)
Coverage Report: http://coverage.selectdb-in.cc/coverage/7380f125a1c086a6af79c8f17f5ef5ea3f370a99_7380f125a1c086a6af79c8f17f5ef5ea3f370a99/report/index.html
--
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] [feature](join) add hash table build type check [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2145495376
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146341046
<details>
<summary>TPC-DS: <b>Total hot run time: 170876 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 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
query1 917 379 364 364
query2 6436 2538 2444 2444
query3 6643 207 207 207
query4 21986 17269 17372 17269
query5 4169 471 456 456
query6 263 163 164 163
query7 4581 301 296 296
query8 304 287 286 286
query9 8529 2370 2381 2370
query10 453 295 289 289
query11 10552 9899 9960 9899
query12 139 90 90 90
query13 1650 375 381 375
query14 9941 7856 7565 7565
query15 242 191 188 188
query16 7816 273 265 265
query17 1399 567 571 567
query18 1898 267 276 267
query19 199 157 154 154
query20 93 89 92 89
query21 203 133 127 127
query22 4325 4007 4089 4007
query23 33924 33070 33086 33070
query24 11018 2820 2833 2820
query25 610 354 361 354
query26 1049 157 155 155
query27 2301 324 330 324
query28 6175 2066 2057 2057
query29 892 602 607 602
query30 286 148 152 148
query31 950 749 721 721
query32 99 54 55 54
query33 780 286 278 278
query34 954 468 473 468
query35 759 625 619 619
query36 1092 935 920 920
query37 132 66 66 66
query38 2872 2713 2715 2713
query39 877 789 779 779
query40 211 126 126 126
query41 54 51 52 51
query42 127 98 99 98
query43 578 530 564 530
query44 1285 749 750 749
query45 202 163 165 163
query46 1088 735 737 735
query47 1830 1785 1776 1776
query48 380 295 295 295
query49 995 421 420 420
query50 785 389 383 383
query51 6961 6858 6692 6692
query52 104 92 97 92
query53 353 285 297 285
query54 880 457 463 457
query55 75 71 73 71
query56 284 250 284 250
query57 1104 1079 1098 1079
query58 248 252 279 252
query59 3418 3098 3163 3098
query60 296 268 274 268
query61 91 90 85 85
query62 655 449 441 441
query63 325 291 293 291
query64 8745 2235 1779 1779
query65 3293 3102 3109 3102
query66 857 318 337 318
query67 15518 15032 15037 15032
query68 5357 555 559 555
query69 591 473 435 435
query70 1136 1132 1145 1132
query71 442 288 290 288
query72 8298 5360 2701 2701
query73 764 327 328 327
query74 5861 5466 5513 5466
query75 3816 2643 2684 2643
query76 3153 879 886 879
query77 635 301 298 298
query78 10268 9860 9627 9627
query79 2246 523 510 510
query80 1316 537 457 457
query81 580 221 221 221
query82 758 109 100 100
query83 205 171 171 171
query84 272 91 84 84
query85 1273 289 271 271
query86 457 313 328 313
query87 3267 3097 3086 3086
query88 3843 2443 2456 2443
query89 464 387 393 387
query90 1803 189 187 187
query91 125 151 99 99
query92 63 49 51 49
query93 2230 510 503 503
query94 1161 197 187 187
query95 413 310 310 310
query96 595 273 272 272
query97 3248 3024 3022 3022
query98 261 223 218 218
query99 1298 832 842 832
Total cold run time: 274449 ms
Total hot run time: 170876 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] [feature](join) add hash table build type check [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35825:
URL: https://github.com/apache/doris/pull/35825#issuecomment-2146331673
<details>
<summary>TPC-H: <b>Total hot run time: 41844 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 7380f125a1c086a6af79c8f17f5ef5ea3f370a99, data reload: false
------ Round 1 ----------------------------------
q1 17615 4319 4296 4296
q2 2033 184 189 184
q3 10482 1168 1191 1168
q4 10180 816 802 802
q5 7483 2699 2826 2699
q6 226 140 145 140
q7 969 604 611 604
q8 9215 2129 2099 2099
q9 9010 6690 6690 6690
q10 10096 3958 3848 3848
q11 442 247 250 247
q12 504 249 241 241
q13 17474 3212 3287 3212
q14 271 228 220 220
q15 516 470 481 470
q16 500 399 385 385
q17 986 671 617 617
q18 8399 7747 7723 7723
q19 6691 1581 1543 1543
q20 636 320 319 319
q21 5341 3999 4052 3999
q22 402 345 338 338
Total cold run time: 119471 ms
Total hot run time: 41844 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4662 4392 4352 4352
q2 393 272 267 267
q3 3161 2982 2922 2922
q4 1877 1616 1600 1600
q5 5445 5511 5527 5511
q6 231 125 131 125
q7 2194 1789 1780 1780
q8 3232 3397 3386 3386
q9 8643 8545 8726 8545
q10 4056 3876 3807 3807
q11 605 492 483 483
q12 772 576 595 576
q13 17033 3136 3111 3111
q14 309 258 278 258
q15 516 481 499 481
q16 479 438 431 431
q17 1810 1508 1488 1488
q18 8088 7471 7476 7471
q19 1775 1566 1554 1554
q20 3040 1788 1750 1750
q21 8692 4733 4868 4733
q22 626 547 561 547
Total cold run time: 77639 ms
Total hot run time: 55178 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] [feature](join) add hash table build type check [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange closed pull request #35825: [feature](join) add hash table build type check
URL: https://github.com/apache/doris/pull/35825
--
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