Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[fix](meta) fix Unknown column 'mva_SUM__CAST` #41283

Merged
merged 1 commit into from
Sep 25, 2024
Merged

[fix](meta) fix Unknown column 'mva_SUM__CAST` #41283

merged 1 commit into from
Sep 25, 2024

Conversation

924060929
Copy link
Contributor

@924060929 924060929 commented Sep 25, 2024 •
edited
Loading

Proposed changes

fix insert into select statement failed when upgrade doris, introduced by #38012

ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'mva_SUM__CAST(`goods_number` AS BIGINT)' in 'dm_sales_settlement_day_goods'

@doris-robot
Copy link

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website.
See Doris Document.

@924060929
Copy link
Contributor Author

run buildall

This was referenced Sep 25, 2024
Merged
Merged
@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Sep 25, 2024
@github-actions GitHub Actions
Copy link
Contributor

PR approved by at least one committer and no changes requested.

@github-actions GitHub Actions
Copy link
Contributor

PR approved by anyone and no changes requested.

@doris-robot
Copy link

TPC-H: Total hot run time: 40961 ms 
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

@doris-robot
Copy link

TPC-DS: Total hot run time: 192139 ms 
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

@doris-robot
Copy link

ClickBench: Total hot run time: 32.61 s 
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

@924060929 924060929 changed the title [fix](Nereids) fix Unknown column 'mva_SUM__CAST` [fix](meta) fix Unknown column 'mva_SUM__CAST` Sep 25, 2024
dataroaring
dataroaring approved these changes Sep 25, 2024
View reviewed changes
Copy link
Contributor

@dataroaring dataroaring left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@dataroaring dataroaring merged commit b0b2da7 into apache:master Sep 25, 2024
29 of 32 checks passed
dataroaring pushed a commit that referenced this pull request Sep 25, 2024
@924060929 @dataroaring
[fix](meta) fix Unknown column 'mva_SUM__CAST` (#41283)
d734207 
fix insert into select statement failed when upgrade doris, introduced
by #38012
```sql
ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'mva_SUM__CAST(`goods_number` AS BIGINT)' in 'dm_sales_settlement_day_goods'
```
yiguolei pushed a commit that referenced this pull request Sep 26, 2024
@924060929
[fix](meta) fix Unknown column 'mva_SUM__CAST` (#41285)
e6ce4a2 
## Proposed changes

cherry pick from #41283
morrySnow pushed a commit that referenced this pull request Sep 27, 2024
@924060929
[fix](meta) fix Unknown column 'mva_SUM__CAST` (#41284)
2df6c84 
cherry pick from master #41283
@gavinchou gavinchou mentioned this pull request Oct 13, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@dataroaring dataroaring dataroaring approved these changes

@BiteTheDDDDt BiteTheDDDDt BiteTheDDDDt approved these changes

Assignees
No one assigned
Labels
approved Indicates a PR has been approved by one committer. dev/2.0.16-merged dev/2.1.7-merged dev/3.0.2-merged p0_b reviewed
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
6 participants
@924060929 @doris-robot @BiteTheDDDDt @dataroaring @yiguolei @morrySnow