You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "924060929 (via GitHub)" <gi...@apache.org> on 2024/09/25 09:08:38 UTC
[PR] [fix](Nereids) fix Unknown column 'mva_SUM__CAST` [doris]
924060929 opened a new pull request, #41283:
URL: https://github.com/apache/doris/pull/41283
## Proposed changes
fix insert into select statement failed when upgrade doris
```sql
ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'mva_SUM__CAST(`goods_number` AS BIGINT)' in 'dm_sales_settlement_day_goods'
```
--
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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373656997
<details>
<summary>TPC-DS: <b>Total hot run time: 192139 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 cfbe1297e2216f598a5ce229afb41b3800c8b90c, data reload: false
query1 945 383 397 383
query2 6335 2221 2101 2101
query3 8691 195 206 195
query4 33739 23632 23665 23632
query5 3398 465 460 460
query6 276 169 161 161
query7 4191 305 301 301
query8 281 219 227 219
query9 9479 2686 2690 2686
query10 479 285 270 270
query11 18101 15278 15261 15261
query12 156 97 101 97
query13 1554 440 416 416
query14 9698 7425 7477 7425
query15 251 166 180 166
query16 8047 468 527 468
query17 1662 612 597 597
query18 2145 327 326 326
query19 365 161 164 161
query20 122 115 112 112
query21 208 109 104 104
query22 4703 4300 4422 4300
query23 35367 34778 34514 34514
query24 11242 3022 2841 2841
query25 629 404 425 404
query26 1074 170 156 156
query27 2271 298 301 298
query28 7738 2440 2449 2440
query29 831 461 422 422
query30 262 160 162 160
query31 1032 806 777 777
query32 104 57 54 54
query33 763 307 305 305
query34 933 505 502 502
query35 903 776 762 762
query36 1107 934 938 934
query37 163 93 89 89
query38 4008 4035 3975 3975
query39 1546 1507 1434 1434
query40 210 98 98 98
query41 51 48 48 48
query42 117 101 104 101
query43 549 503 498 498
query44 1228 829 798 798
query45 196 166 165 165
query46 1124 715 718 715
query47 1892 1845 1851 1845
query48 461 384 380 380
query49 900 403 419 403
query50 835 422 414 414
query51 6935 6959 6930 6930
query52 101 86 92 86
query53 263 209 193 193
query54 1236 466 470 466
query55 84 79 75 75
query56 288 268 272 268
query57 1222 1101 1110 1101
query58 231 229 226 226
query59 3231 3133 2935 2935
query60 288 266 271 266
query61 106 110 109 109
query62 840 664 642 642
query63 213 191 190 190
query64 3922 628 629 628
query65 3227 3242 3190 3190
query66 763 298 312 298
query67 15733 15525 15301 15301
query68 4824 557 557 557
query69 585 297 291 291
query70 1176 1145 1096 1096
query71 401 265 282 265
query72 7496 3802 4104 3802
query73 778 339 342 339
query74 10505 8992 8981 8981
query75 3822 2658 2650 2650
query76 3381 943 991 943
query77 624 293 298 293
query78 10064 9297 9218 9218
query79 1775 595 600 595
query80 1026 447 451 447
query81 578 240 238 238
query82 696 137 134 134
query83 312 140 141 140
query84 279 82 72 72
query85 1316 276 290 276
query86 390 280 291 280
query87 4441 4262 4287 4262
query88 3440 2426 2345 2345
query89 404 288 289 288
query90 1980 189 186 186
query91 181 144 140 140
query92 62 51 48 48
query93 1743 533 541 533
query94 941 305 285 285
query95 359 259 257 257
query96 612 281 289 281
query97 3245 3108 3172 3108
query98 227 200 208 200
query99 1543 1312 1313 1312
Total cold run time: 300251 ms
Total hot run time: 192139 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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373505606
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](Nereids) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373505663
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](meta) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #41283:
URL: https://github.com/apache/doris/pull/41283
--
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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373631872
<details>
<summary>TPC-H: <b>Total hot run time: 40961 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 cfbe1297e2216f598a5ce229afb41b3800c8b90c, data reload: false
------ Round 1 ----------------------------------
q1 17580 7387 7297 7297
q2 2025 279 267 267
q3 12390 1076 1107 1076
q4 10555 782 714 714
q5 7746 2876 2787 2787
q6 238 147 148 147
q7 974 624 609 609
q8 9364 1966 2015 1966
q9 7499 6444 6388 6388
q10 6995 2297 2338 2297
q11 440 248 246 246
q12 422 222 223 222
q13 17780 2992 3001 2992
q14 234 208 211 208
q15 570 525 519 519
q16 657 613 631 613
q17 975 543 538 538
q18 7195 6653 6733 6653
q19 1398 1062 963 963
q20 585 296 277 277
q21 3949 3186 3184 3184
q22 1102 998 1001 998
Total cold run time: 110673 ms
Total hot run time: 40961 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7242 7184 7168 7168
q2 332 236 227 227
q3 3069 2984 2975 2975
q4 2096 1872 1827 1827
q5 5677 5649 5752 5649
q6 233 148 142 142
q7 2253 1835 1841 1835
q8 3443 3511 3530 3511
q9 8904 9049 9000 9000
q10 3612 3504 3576 3504
q11 591 480 487 480
q12 871 625 625 625
q13 9005 3190 3138 3138
q14 324 267 277 267
q15 592 523 510 510
q16 737 672 672 672
q17 1842 1621 1647 1621
q18 8247 8033 7777 7777
q19 1728 1697 1462 1462
q20 2180 1888 1903 1888
q21 5598 5574 5518 5518
q22 1169 1097 1036 1036
Total cold run time: 69745 ms
Total hot run time: 60832 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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373669744
<details>
<summary>ClickBench: <b>Total hot run time: 32.61 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 cfbe1297e2216f598a5ce229afb41b3800c8b90c, data reload: false
query1 0.05 0.05 0.04
query2 0.06 0.03 0.03
query3 0.23 0.06 0.06
query4 1.66 0.10 0.10
query5 0.54 0.52 0.52
query6 1.14 0.74 0.72
query7 0.03 0.02 0.01
query8 0.04 0.04 0.03
query9 0.59 0.50 0.49
query10 0.55 0.55 0.54
query11 0.14 0.10 0.10
query12 0.14 0.11 0.11
query13 0.61 0.61 0.59
query14 3.10 2.95 3.02
query15 0.93 0.84 0.83
query16 0.39 0.39 0.38
query17 1.08 1.06 1.04
query18 0.20 0.19 0.20
query19 1.97 1.86 1.95
query20 0.02 0.01 0.01
query21 15.37 0.58 0.57
query22 2.60 2.62 1.89
query23 17.46 0.72 0.82
query24 2.50 0.66 1.48
query25 0.17 0.09 0.03
query26 0.46 0.14 0.13
query27 0.05 0.04 0.05
query28 10.95 1.09 1.07
query29 12.56 3.27 3.28
query30 0.24 0.06 0.06
query31 2.88 0.39 0.38
query32 3.25 0.48 0.47
query33 3.01 3.05 3.04
query34 17.04 4.47 4.46
query35 4.48 4.49 4.46
query36 0.68 0.50 0.49
query37 0.08 0.06 0.06
query38 0.05 0.03 0.04
query39 0.03 0.02 0.02
query40 0.16 0.12 0.12
query41 0.07 0.01 0.02
query42 0.03 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 107.62 s
Total hot run time: 32.61 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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373526768
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) fix Unknown column 'mva_SUM__CAST` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41283:
URL: https://github.com/apache/doris/pull/41283#issuecomment-2373526846
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