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/09/11 03:56:51 UTC
[PR] [fix](planner) throw NPE when insert overwrite partition(*) [doris]
morrySnow opened a new pull request, #40656:
URL: https://github.com/apache/doris/pull/40656
(no comment)
--
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343206075
<details>
<summary>ClickBench: <b>Total hot run time: 31.09 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 964c65edac13516cef257afd9e0ec6a23f52b027, data reload: false
query1 0.04 0.05 0.04
query2 0.07 0.04 0.04
query3 0.23 0.06 0.06
query4 1.66 0.08 0.07
query5 0.51 0.51 0.50
query6 1.13 0.72 0.72
query7 0.02 0.01 0.02
query8 0.05 0.05 0.05
query9 0.53 0.49 0.47
query10 0.53 0.56 0.54
query11 0.15 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.58 0.60
query14 1.38 1.44 1.41
query15 0.87 0.83 0.81
query16 0.37 0.37 0.37
query17 1.06 1.01 1.07
query18 0.17 0.17 0.18
query19 1.89 1.76 1.77
query20 0.01 0.01 0.01
query21 15.38 0.67 0.67
query22 4.87 7.16 1.61
query23 18.31 1.45 1.31
query24 2.15 0.23 0.22
query25 0.16 0.08 0.07
query26 0.27 0.18 0.18
query27 0.08 0.08 0.08
query28 13.21 1.03 0.99
query29 12.65 3.29 3.26
query30 0.25 0.05 0.05
query31 2.89 0.41 0.40
query32 3.22 0.47 0.48
query33 2.97 3.06 3.03
query34 17.02 4.41 4.42
query35 4.46 4.44 4.45
query36 0.65 0.47 0.49
query37 0.18 0.16 0.15
query38 0.16 0.15 0.14
query39 0.05 0.04 0.03
query40 0.16 0.13 0.13
query41 0.09 0.04 0.04
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.73 s
Total hot run time: 31.09 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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #40656:
URL: https://github.com/apache/doris/pull/40656
--
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2342569057
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] [fix](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343193899
<details>
<summary>TPC-DS: <b>Total hot run time: 191334 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 964c65edac13516cef257afd9e0ec6a23f52b027, data reload: false
query1 919 381 378 378
query2 6291 1891 1906 1891
query3 6576 203 217 203
query4 34177 23276 23187 23187
query5 3747 508 498 498
query6 251 167 171 167
query7 4561 287 289 287
query8 279 216 220 216
query9 8655 2485 2479 2479
query10 436 263 274 263
query11 17765 14977 15023 14977
query12 142 98 98 98
query13 1642 378 362 362
query14 9342 6238 7114 6238
query15 225 165 165 165
query16 7630 452 481 452
query17 1504 568 549 549
query18 2015 296 294 294
query19 195 148 143 143
query20 119 108 109 108
query21 195 104 102 102
query22 4656 4108 4136 4108
query23 34228 33824 33514 33514
query24 10657 2874 2852 2852
query25 607 398 385 385
query26 941 151 152 151
query27 2834 272 281 272
query28 7437 2060 2049 2049
query29 758 407 407 407
query30 262 158 149 149
query31 971 772 781 772
query32 84 56 53 53
query33 695 277 279 277
query34 920 467 475 467
query35 854 742 734 734
query36 1113 928 959 928
query37 156 89 86 86
query38 3955 3899 3845 3845
query39 1447 1403 1402 1402
query40 203 114 114 114
query41 47 49 45 45
query42 117 95 95 95
query43 515 477 473 473
query44 1266 754 739 739
query45 196 166 170 166
query46 1091 727 752 727
query47 1933 1801 1830 1801
query48 363 288 283 283
query49 927 428 435 428
query50 822 409 406 406
query51 7140 6836 6851 6836
query52 100 89 88 88
query53 255 190 186 186
query54 843 466 455 455
query55 79 75 110 75
query56 280 240 253 240
query57 1222 1079 1076 1076
query58 229 243 244 243
query59 2977 2842 2637 2637
query60 305 266 270 266
query61 103 98 96 96
query62 836 657 658 657
query63 219 185 179 179
query64 3851 718 735 718
query65 3209 3167 3159 3159
query66 1272 332 336 332
query67 15779 15467 15625 15467
query68 3007 851 840 840
query69 424 317 328 317
query70 1159 1168 1091 1091
query71 346 335 335 335
query72 5794 3501 3474 3474
query73 595 585 578 578
query74 9143 8884 8811 8811
query75 3054 3000 2960 2960
query76 1612 845 852 845
query77 493 406 406 406
query78 9844 9097 9901 9097
query79 918 883 855 855
query80 818 805 811 805
query81 455 256 267 256
query82 269 266 271 266
query83 203 210 204 204
query84 239 110 111 110
query85 702 479 378 378
query86 303 327 316 316
query87 4368 4383 4220 4220
query88 4228 4059 4059 4059
query89 372 366 365 365
query90 1356 314 315 314
query91 125 122 122 122
query92 79 71 73 71
query93 917 925 917 917
query94 445 354 364 354
query95 419 409 404 404
query96 474 470 469 469
query97 3110 3109 3099 3099
query98 226 232 228 228
query99 1359 1273 1273 1273
Total cold run time: 282276 ms
Total hot run time: 191334 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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343452432
run cloud_p0
--
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343131340
run cloud_p0
--
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343131067
run performance
--
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343865876
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2342569231
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2342601082
<details>
<summary>TPC-H: <b>Total hot run time: 38188 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 964c65edac13516cef257afd9e0ec6a23f52b027, data reload: false
------ Round 1 ----------------------------------
q1 17602 4321 4268 4268
q2 2017 187 186 186
q3 11832 970 1114 970
q4 10513 814 690 690
q5 7741 2823 2810 2810
q6 224 140 139 139
q7 975 613 617 613
q8 9343 2057 2076 2057
q9 7059 6563 6583 6563
q10 6999 2272 2170 2170
q11 515 251 250 250
q12 395 231 228 228
q13 17762 3073 3075 3073
q14 284 242 249 242
q15 529 494 496 494
q16 524 424 428 424
q17 967 765 714 714
q18 7481 6885 6841 6841
q19 1389 1064 945 945
q20 683 337 337 337
q21 3940 3147 3169 3147
q22 1105 1027 1048 1027
Total cold run time: 109879 ms
Total hot run time: 38188 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4373 4317 4336 4317
q2 387 283 264 264
q3 2954 2681 2704 2681
q4 1934 1717 1667 1667
q5 5728 5769 5823 5769
q6 229 141 139 139
q7 2275 1887 1863 1863
q8 3302 3496 3481 3481
q9 8956 8990 8953 8953
q10 3646 3476 3461 3461
q11 606 518 519 518
q12 843 713 684 684
q13 13412 3551 3479 3479
q14 343 329 306 306
q15 537 509 502 502
q16 561 538 540 538
q17 1863 1569 1643 1569
q18 8951 8077 7958 7958
q19 2401 1485 1690 1485
q20 2163 1940 1931 1931
q21 5868 5541 5538 5538
q22 1179 1053 1052 1052
Total cold run time: 72511 ms
Total hot run time: 58155 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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2342586450
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](planner) throw NPE when insert overwrite partition(*) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40656:
URL: https://github.com/apache/doris/pull/40656#issuecomment-2343169104
<details>
<summary>TPC-H: <b>Total hot run time: 38364 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 964c65edac13516cef257afd9e0ec6a23f52b027, data reload: false
------ Round 1 ----------------------------------
q1 17636 4423 4324 4324
q2 2032 186 189 186
q3 10456 1135 1051 1051
q4 10135 719 728 719
q5 7721 2913 2829 2829
q6 223 137 140 137
q7 973 633 609 609
q8 9358 2135 2107 2107
q9 8368 6619 6622 6619
q10 7084 2270 2229 2229
q11 465 243 247 243
q12 540 226 231 226
q13 17771 3127 3082 3082
q14 291 236 252 236
q15 535 482 500 482
q16 552 449 429 429
q17 1000 706 806 706
q18 7533 7061 6896 6896
q19 1396 980 1007 980
q20 678 345 338 338
q21 4000 2895 2971 2895
q22 1135 1047 1041 1041
Total cold run time: 109882 ms
Total hot run time: 38364 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4391 4340 4263 4263
q2 384 284 277 277
q3 2930 2738 2692 2692
q4 1975 1720 1706 1706
q5 5463 5486 5440 5440
q6 219 131 132 131
q7 2115 1748 1760 1748
q8 3252 3373 3399 3373
q9 8542 8528 8548 8528
q10 3500 3264 3242 3242
q11 592 493 524 493
q12 811 593 619 593
q13 11376 3131 3111 3111
q14 305 279 266 266
q15 540 488 479 479
q16 503 475 491 475
q17 1802 1527 1478 1478
q18 7887 7663 7501 7501
q19 1702 1610 1529 1529
q20 2082 1808 1839 1808
q21 5654 5149 5161 5149
q22 1128 1033 1076 1033
Total cold run time: 67153 ms
Total hot run time: 55315 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