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](cloud tvf) Fix tvf query run in cloud multi cluster #37157 #39249

Merged
merged 1 commit into from
Aug 13, 2024
Merged

[fix](cloud tvf) Fix tvf query run in cloud multi cluster #37157 #39249

merged 1 commit into from
Aug 13, 2024

Conversation

deardeng
Copy link
Contributor

cherry pick from #37157

@deardeng
Copy link
Contributor Author

run buildall

@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.

@github-actions github-actions bot added the doing label Aug 12, 2024
@deardeng
[fix](cloud tvf) Fix tvf query run in cloud multi cluster (apache#37157)
54115f7 
Fix
```
mysql> select * from numbers("number" = "10");
ERROR 1105 (HY000): errCode = 2, detailMessage = There is no scanNode Backend available.[10002: not exist]
```
@deardeng deardeng force-pushed the pick_37157_to_doris_branch-3.0 branch from e1f4b76 to 54115f7 Compare August 12, 2024 12:36
@deardeng
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 40272 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 54115f7bfe52e5f340535e4ac58bd41f9edf820e, data reload: false

------ Round 1 ----------------------------------
q1	17614	4482	4344	4344
q2	2032	174	174	174
q3	10500	1212	1080	1080
q4	10188	813	800	800
q5	7506	2600	2531	2531
q6	224	139	138	138
q7	955	593	606	593
q8	9212	2086	2107	2086
q9	8768	6574	6596	6574
q10	7173	2625	2604	2604
q11	450	238	231	231
q12	409	222	217	217
q13	18567	2976	2981	2976
q14	282	242	233	233
q15	533	495	486	486
q16	507	380	384	380
q17	986	663	630	630
q18	8078	7522	7374	7374
q19	6798	1384	1417	1384
q20	694	316	317	316
q21	5247	4152	4137	4137
q22	1091	994	984	984
Total cold run time: 117814 ms
Total hot run time: 40272 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4445	4291	4275	4275
q2	381	271	264	264
q3	2882	2809	2828	2809
q4	1973	1676	1738	1676
q5	5529	5518	5419	5419
q6	222	130	131	130
q7	2248	1785	1754	1754
q8	3268	3458	3448	3448
q9	8758	8844	8812	8812
q10	3551	3179	3222	3179
q11	600	504	509	504
q12	809	626	644	626
q13	16060	3136	3160	3136
q14	309	293	290	290
q15	518	498	492	492
q16	504	428	443	428
q17	1839	1544	1507	1507
q18	8020	8092	7837	7837
q19	1796	1584	1562	1562
q20	2158	1900	1860	1860
q21	8354	5179	5301	5179
q22	1130	1067	1047	1047
Total cold run time: 75354 ms
Total hot run time: 56234 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 201485 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 54115f7bfe52e5f340535e4ac58bd41f9edf820e, data reload: false

query1	914	359	357	357
query2	6376	1956	1849	1849
query3	6682	205	218	205
query4	34209	23121	23090	23090
query5	3681	457	488	457
query6	264	175	160	160
query7	4568	300	280	280
query8	244	208	198	198
query9	8460	2496	2444	2444
query10	526	477	461	461
query11	16414	14939	14904	14904
query12	133	94	96	94
query13	1659	375	365	365
query14	9968	7105	6824	6824
query15	274	219	221	219
query16	7779	490	488	488
query17	1438	578	560	560
query18	1952	290	291	290
query19	197	150	152	150
query20	115	105	105	105
query21	205	131	133	131
query22	4870	4240	4410	4240
query23	34512	33569	33709	33569
query24	10598	2671	2659	2659
query25	592	401	393	393
query26	715	156	156	156
query27	2210	281	295	281
query28	5876	2077	2025	2025
query29	864	627	632	627
query30	263	148	147	147
query31	984	776	777	776
query32	98	55	59	55
query33	644	308	291	291
query34	872	538	470	470
query35	958	852	797	797
query36	1084	922	910	910
query37	132	78	74	74
query38	4225	4163	4189	4163
query39	1439	1377	1366	1366
query40	214	117	120	117
query41	47	43	52	43
query42	114	100	101	100
query43	498	471	459	459
query44	1120	726	728	726
query45	254	200	204	200
query46	1066	744	720	720
query47	1877	1777	1787	1777
query48	367	296	286	286
query49	825	412	409	409
query50	790	386	382	382
query51	6813	6600	6718	6600
query52	96	99	92	92
query53	358	290	283	283
query54	883	445	444	444
query55	75	73	72	72
query56	262	238	241	238
query57	1149	1056	1078	1056
query58	221	220	217	217
query59	2926	2865	2914	2865
query60	280	253	261	253
query61	100	120	92	92
query62	789	638	632	632
query63	321	285	287	285
query64	9129	2226	1718	1718
query65	3223	3154	3126	3126
query66	744	326	320	320
query67	15431	14766	14776	14766
query68	8390	550	561	550
query69	465	426	420	420
query70	1440	1150	1084	1084
query71	540	291	274	274
query72	19674	16194	16246	16194
query73	2215	318	315	315
query74	8965	8654	8772	8654
query75	5183	2660	2733	2660
query76	4644	1025	1028	1025
query77	784	316	320	316
query78	9957	11733	9524	9524
query79	8944	528	533	528
query80	877	472	471	471
query81	570	221	227	221
query82	285	133	137	133
query83	307	138	186	138
query84	271	88	82	82
query85	696	264	264	264
query86	345	295	298	295
query87	4686	4531	4511	4511
query88	4916	2342	2356	2342
query89	464	376	379	376
query90	2123	193	186	186
query91	128	94	97	94
query92	67	49	48	48
query93	1272	507	507	507
query94	1323	289	287	287
query95	414	307	320	307
query96	593	267	268	267
query97	3272	3089	3059	3059
query98	212	199	194	194
query99	1465	1251	1263	1251
Total cold run time: 322453 ms
Total hot run time: 201485 ms

@dataroaring dataroaring merged commit ef2f469 into apache:branch-3.0 Aug 13, 2024
14 of 18 checks passed
dataroaring pushed a commit that referenced this pull request Aug 16, 2024
@deardeng @dataroaring
[fix](cloud tvf) Fix tvf query run in cloud multi cluster #37157 (#39249
bcf803d 
)

cherry pick from #37157
@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 Awaiting requested review from dataroaring dataroaring is a code owner

@CalvinKirs CalvinKirs Awaiting requested review from CalvinKirs

@morningman morningman Awaiting requested review from morningman

Assignees
No one assigned
Labels
doing
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
3 participants
@deardeng @doris-robot @dataroaring