Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

[Fix](PaimonCatalog) fix the problem that paimon catalog can not access to OSS-HDFS #42585

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.

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

Merged
merged 2 commits into from
Nov 2, 2024

Conversation

BePPPower
Copy link
Contributor

@BePPPower BePPPower commented Oct 28, 2024

Fix the problem that paimon catalog can not access to OSS-HDFS.

There are 2 problems in paimon catalog:

  1. Doris FE can not list paimon tables.
    This is because we pass these three properties -- fs.oss.endpoint / fs.oss.accessKeyId / fs.oss.accessKeySecret -- to the PaimonCatalog. When PaimonCatalog get these three properties, it will use OSSLoader rather than HadoopFileIOLoader.

  2. Doris BE does not use libhdfs to access OSS-HDFS
    This is because the tmpLocation in LocationPath does not contain oss-dls.aliyuncs. We should use endpoint to judge if user wants to access OSS-HDFS

What's more, if you want to access OSS-HDFS with PaimonCatalog, you should:

  1. Download Jindo SDK: https://github.com/aliyun/alibabacloud-jindodata/blob/latest/docs/user/zh/jindosdk/jindosdk_download.md
  2. copy jindo-core.jar、jindo-sdk.jar to ${DORIS_HOME}/fe/lib and ${DORIS_HOME}/be/lib/java_extensions/preload-extensions directory.

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

@BePPPower BePPPower marked this pull request as draft October 28, 2024 07:40
@BePPPower
Copy link
Contributor Author

run buildall

@BePPPower BePPPower changed the title [Fix](PaimonCatalog) fix the problem that paimong catalog can not access to OSS-HDFS [Fix](PaimonCatalog) fix the problem that paimon catalog can not access to OSS-HDFS Oct 28, 2024
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17622	7365	7267	7267
q2	2065	165	150	150
q3	10601	1092	1185	1092
q4	10567	787	814	787
q5	7740	3051	3072	3051
q6	233	149	142	142
q7	1026	630	601	601
q8	9365	1945	2003	1945
q9	6604	6434	6456	6434
q10	7108	2409	2428	2409
q11	451	249	250	249
q12	423	221	221	221
q13	17787	3018	3018	3018
q14	246	207	208	207
q15	572	510	518	510
q16	653	573	592	573
q17	973	552	489	489
q18	7309	6712	6765	6712
q19	1332	1083	1003	1003
q20	470	175	182	175
q21	4188	3322	3398	3322
q22	1138	1020	973	973
Total cold run time: 108473 ms
Total hot run time: 41330 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7271	7244	7317	7244
q2	331	228	228	228
q3	3024	2921	2969	2921
q4	2097	1923	1796	1796
q5	5750	5724	5760	5724
q6	240	148	146	146
q7	2233	1832	1797	1797
q8	3393	3545	3426	3426
q9	8969	8947	8896	8896
q10	3590	3526	3563	3526
q11	585	493	494	493
q12	862	636	653	636
q13	9802	3189	3248	3189
q14	306	276	273	273
q15	579	518	519	518
q16	680	649	645	645
q17	1844	1635	1603	1603
q18	8373	7884	7651	7651
q19	1710	1590	1589	1589
q20	2162	1855	1907	1855
q21	5541	5569	5641	5569
q22	1177	1038	1061	1038
Total cold run time: 70519 ms
Total hot run time: 60763 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 197620 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 430325f98f1ec8524f8a8d1338fb6887cb9fe436, data reload: false

query1	1250	990	993	990
query2	6256	2032	2079	2032
query3	11595	4815	4852	4815
query4	33844	23514	23534	23514
query5	4856	466	461	461
query6	281	187	174	174
query7	3986	300	304	300
query8	299	254	238	238
query9	9353	2754	2730	2730
query10	504	252	244	244
query11	18382	15300	15347	15300
query12	148	102	95	95
query13	1554	420	416	416
query14	8589	7389	7144	7144
query15	243	184	201	184
query16	7868	493	484	484
query17	1441	604	576	576
query18	1819	307	315	307
query19	208	169	162	162
query20	129	114	113	113
query21	207	108	113	108
query22	4762	4645	4309	4309
query23	35010	34191	34148	34148
query24	11123	2797	2794	2794
query25	624	409	406	406
query26	1216	159	161	159
query27	2727	286	291	286
query28	7816	2458	2437	2437
query29	861	430	418	418
query30	260	158	166	158
query31	1015	824	836	824
query32	89	54	59	54
query33	766	278	277	277
query34	939	533	532	532
query35	1034	905	883	883
query36	1133	918	972	918
query37	137	74	78	74
query38	4442	4400	4323	4323
query39	1478	1424	1404	1404
query40	207	101	101	101
query41	51	46	48	46
query42	109	99	99	99
query43	542	518	493	493
query44	1287	807	806	806
query45	182	170	169	169
query46	1143	726	734	726
query47	1937	1825	1859	1825
query48	433	334	327	327
query49	950	409	400	400
query50	834	403	390	390
query51	7132	7005	6977	6977
query52	97	88	87	87
query53	253	179	179	179
query54	1070	392	411	392
query55	76	76	73	73
query56	247	236	236	236
query57	1343	1162	1154	1154
query58	213	218	227	218
query59	3252	3239	3059	3059
query60	286	239	256	239
query61	105	103	95	95
query62	843	654	675	654
query63	218	194	187	187
query64	3927	637	636	636
query65	3296	3194	3202	3194
query66	913	299	289	289
query67	15908	15743	15858	15743
query68	4369	578	556	556
query69	437	257	255	255
query70	1232	1174	1114	1114
query71	325	283	280	280
query72	6270	4147	3945	3945
query73	788	363	365	363
query74	10257	9091	9171	9091
query75	3405	2670	2667	2667
query76	2654	983	893	893
query77	387	274	284	274
query78	10650	9505	9496	9496
query79	1112	595	609	595
query80	791	419	422	419
query81	541	247	240	240
query82	1322	117	114	114
query83	226	143	144	143
query84	234	68	67	67
query85	1040	301	285	285
query86	321	307	267	267
query87	4880	4766	4646	4646
query88	3469	2202	2174	2174
query89	404	295	295	295
query90	1916	187	183	183
query91	136	100	99	99
query92	58	48	48	48
query93	1081	547	536	536
query94	766	280	297	280
query95	352	247	248	247
query96	610	274	287	274
query97	2923	2697	2697	2697
query98	218	195	196	195
query99	1575	1332	1297	1297
Total cold run time: 299847 ms
Total hot run time: 197620 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32.52 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 430325f98f1ec8524f8a8d1338fb6887cb9fe436, data reload: false

query1	0.03	0.03	0.04
query2	0.07	0.04	0.02
query3	0.23	0.06	0.06
query4	1.65	0.10	0.10
query5	0.40	0.40	0.40
query6	1.15	0.66	0.65
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.57	0.51	0.50
query10	0.56	0.55	0.54
query11	0.15	0.13	0.11
query12	0.13	0.11	0.12
query13	0.62	0.59	0.60
query14	2.74	2.74	2.71
query15	0.91	0.82	0.83
query16	0.39	0.38	0.39
query17	1.07	1.07	1.09
query18	0.19	0.20	0.20
query19	1.98	1.87	1.92
query20	0.01	0.02	0.00
query21	15.35	0.61	0.59
query22	2.44	2.54	1.84
query23	17.09	0.99	0.70
query24	2.81	0.80	1.76
query25	0.38	0.20	0.13
query26	0.27	0.13	0.14
query27	0.04	0.03	0.04
query28	10.69	1.09	1.07
query29	12.58	3.38	3.41
query30	0.25	0.07	0.06
query31	2.88	0.38	0.37
query32	3.27	0.46	0.46
query33	2.98	2.97	3.02
query34	17.03	4.47	4.51
query35	4.59	4.54	4.57
query36	0.68	0.49	0.48
query37	0.09	0.06	0.06
query38	0.05	0.03	0.03
query39	0.04	0.02	0.03
query40	0.16	0.12	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.73 s
Total hot run time: 32.52 s

@wm1581066 wm1581066 added dev/3.0.x usercase Important user case type label p0_b labels Oct 29, 2024
@morningman morningman marked this pull request as ready for review November 1, 2024 01:56
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17610	7474	7359	7359
q2	2039	165	161	161
q3	10625	1095	1217	1095
q4	10578	868	867	867
q5	7740	3093	3068	3068
q6	231	148	148	148
q7	1036	629	630	629
q8	9363	1947	2002	1947
q9	6536	6422	6492	6422
q10	7048	2455	2454	2454
q11	458	268	260	260
q12	404	222	217	217
q13	17789	3007	3028	3007
q14	254	209	210	209
q15	576	537	524	524
q16	647	597	601	597
q17	982	535	553	535
q18	7279	6716	6763	6716
q19	1327	1067	967	967
q20	477	185	183	183
q21	4056	3309	3301	3301
q22	1118	994	1023	994
Total cold run time: 108173 ms
Total hot run time: 41660 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7317	7293	7313	7293
q2	334	224	237	224
q3	3113	2993	2939	2939
q4	2158	1982	1823	1823
q5	5712	5840	5770	5770
q6	246	153	152	152
q7	2255	1879	1786	1786
q8	3392	3558	3482	3482
q9	8959	8990	8934	8934
q10	3604	3610	3566	3566
q11	615	512	501	501
q12	849	670	622	622
q13	9331	3226	3197	3197
q14	307	282	269	269
q15	579	515	510	510
q16	667	638	642	638
q17	1896	1649	1622	1622
q18	8259	7783	7609	7609
q19	1721	1555	1519	1519
q20	2128	1907	1890	1890
q21	5751	5533	5505	5505
q22	1187	1105	1048	1048
Total cold run time: 70380 ms
Total hot run time: 60899 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 198802 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 430325f98f1ec8524f8a8d1338fb6887cb9fe436, data reload: false

query1	1232	933	928	928
query2	6235	2162	2131	2131
query3	10940	4206	4005	4005
query4	67966	28842	23666	23666
query5	4930	491	463	463
query6	397	179	173	173
query7	5553	307	313	307
query8	312	234	231	231
query9	9099	2808	2829	2808
query10	445	272	253	253
query11	17446	15609	15849	15609
query12	161	107	106	106
query13	1552	470	448	448
query14	10689	8116	7675	7675
query15	239	204	184	184
query16	7014	458	479	458
query17	1052	562	566	562
query18	1749	322	298	298
query19	207	161	152	152
query20	123	111	108	108
query21	199	104	109	104
query22	4639	4395	4225	4225
query23	34474	34275	34499	34275
query24	6017	2907	2821	2821
query25	516	399	411	399
query26	647	167	163	163
query27	1658	303	308	303
query28	4528	2602	2609	2602
query29	663	398	414	398
query30	237	159	158	158
query31	956	793	828	793
query32	67	54	59	54
query33	459	280	265	265
query34	920	524	525	524
query35	884	751	737	737
query36	1066	917	953	917
query37	120	72	74	72
query38	4433	4276	4323	4276
query39	1462	1469	1446	1446
query40	204	101	102	101
query41	47	46	47	46
query42	110	100	103	100
query43	550	511	502	502
query44	1223	884	877	877
query45	188	167	169	167
query46	1148	724	730	724
query47	1937	1849	1847	1847
query48	424	316	321	316
query49	721	418	381	381
query50	826	409	396	396
query51	7265	7106	7133	7106
query52	101	89	88	88
query53	272	188	185	185
query54	539	434	426	426
query55	74	73	78	73
query56	263	275	245	245
query57	1318	1204	1168	1168
query58	213	213	210	210
query59	3212	2940	2921	2921
query60	274	258	248	248
query61	106	102	105	102
query62	782	662	672	662
query63	223	203	192	192
query64	1320	668	633	633
query65	3326	3325	3274	3274
query66	711	307	310	307
query67	15804	15712	15736	15712
query68	2554	695	712	695
query69	410	268	265	265
query70	1192	1177	1145	1145
query71	375	265	292	265
query72	5934	4092	4045	4045
query73	791	367	362	362
query74	9746	9065	9166	9065
query75	3419	2696	2696	2696
query76	1583	1179	1155	1155
query77	517	320	310	310
query78	10457	9428	9334	9334
query79	1153	646	655	646
query80	657	445	455	445
query81	519	245	251	245
query82	214	128	121	121
query83	227	143	145	143
query84	289	71	69	69
query85	807	311	291	291
query86	308	306	316	306
query87	4862	4649	4696	4649
query88	3448	2237	2185	2185
query89	396	306	303	303
query90	2015	189	187	187
query91	136	101	101	101
query92	59	52	51	51
query93	1085	593	604	593
query94	765	290	279	279
query95	345	252	246	246
query96	620	278	288	278
query97	2949	2703	2755	2703
query98	215	202	196	196
query99	1571	1345	1322	1322
Total cold run time: 314085 ms
Total hot run time: 198802 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32.47 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 430325f98f1ec8524f8a8d1338fb6887cb9fe436, data reload: false

query1	0.04	0.04	0.03
query2	0.06	0.03	0.03
query3	0.23	0.06	0.06
query4	1.64	0.10	0.10
query5	0.40	0.38	0.38
query6	1.14	0.67	0.66
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.57	0.51	0.50
query10	0.57	0.56	0.55
query11	0.15	0.11	0.10
query12	0.15	0.12	0.11
query13	0.61	0.61	0.60
query14	2.70	2.74	2.72
query15	0.92	0.82	0.82
query16	0.38	0.40	0.39
query17	1.00	1.06	1.05
query18	0.20	0.20	0.20
query19	1.86	1.81	1.89
query20	0.03	0.01	0.01
query21	15.38	0.61	0.57
query22	2.35	1.98	1.58
query23	17.23	0.84	0.87
query24	3.30	1.08	1.68
query25	0.26	0.11	0.22
query26	0.45	0.14	0.13
query27	0.05	0.04	0.05
query28	10.06	1.09	1.07
query29	12.59	3.23	3.19
query30	0.24	0.06	0.06
query31	2.89	0.39	0.39
query32	3.26	0.47	0.46
query33	3.01	3.01	3.09
query34	16.96	4.53	4.48
query35	4.64	4.50	4.55
query36	0.68	0.49	0.49
query37	0.08	0.06	0.06
query38	0.05	0.03	0.04
query39	0.03	0.03	0.02
query40	0.15	0.13	0.13
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 106.52 s
Total hot run time: 32.47 s

morningman
morningman previously approved these changes Nov 1, 2024
Copy link
Contributor

@morningman morningman left a comment

Choose a reason for hiding this comment

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

LGTM

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Nov 1, 2024
Copy link
Contributor

github-actions bot commented Nov 1, 2024

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

Copy link
Contributor

github-actions bot commented Nov 1, 2024

PR approved by anyone and no changes requested.

CalvinKirs
CalvinKirs previously approved these changes Nov 1, 2024
@BePPPower BePPPower dismissed stale reviews from CalvinKirs and morningman via d4a9df8 November 1, 2024 08:48
@BePPPower
Copy link
Contributor Author

run buildall

@github-actions github-actions bot removed the approved Indicates a PR has been approved by one committer. label Nov 1, 2024
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17607	7492	7424	7424
q2	2046	162	181	162
q3	10675	1078	1188	1078
q4	10461	876	804	804
q5	7780	3011	3074	3011
q6	234	147	145	145
q7	1041	615	594	594
q8	9358	1927	2054	1927
q9	6609	6391	6412	6391
q10	7060	2418	2464	2418
q11	472	252	255	252
q12	428	223	208	208
q13	17846	3107	3115	3107
q14	242	213	211	211
q15	569	523	513	513
q16	680	599	594	594
q17	991	545	682	545
q18	7527	6656	6738	6656
q19	1342	1005	1086	1005
q20	458	182	187	182
q21	4013	3282	3167	3167
q22	1111	1008	1006	1006
Total cold run time: 108550 ms
Total hot run time: 41400 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7253	7256	7238	7238
q2	322	227	230	227
q3	3006	2957	2962	2957
q4	2122	1858	1793	1793
q5	5739	5784	5782	5782
q6	220	140	136	136
q7	2256	1839	1778	1778
q8	3389	3495	3515	3495
q9	8940	8967	8826	8826
q10	3603	3583	3564	3564
q11	617	504	511	504
q12	861	638	594	594
q13	10985	3205	3172	3172
q14	316	289	292	289
q15	564	509	529	509
q16	712	642	649	642
q17	1870	1667	1654	1654
q18	8298	7780	7577	7577
q19	1719	1587	1586	1586
q20	2132	1864	1877	1864
q21	5699	5508	5479	5479
q22	1173	1072	1040	1040
Total cold run time: 71796 ms
Total hot run time: 60706 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 197343 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 d4a9df801aa5043a1eea89c9df4120faae925516, data reload: false

query1	1215	918	901	901
query2	6234	2063	2042	2042
query3	10824	3993	3945	3945
query4	67840	29856	23788	23788
query5	4933	444	439	439
query6	397	162	179	162
query7	5650	297	308	297
query8	315	217	228	217
query9	9557	2731	2718	2718
query10	460	260	248	248
query11	17673	15596	15948	15596
query12	156	106	112	106
query13	1577	471	444	444
query14	12165	7806	7748	7748
query15	201	177	178	177
query16	7009	463	389	389
query17	1008	567	556	556
query18	1556	311	292	292
query19	204	148	156	148
query20	121	112	118	112
query21	203	100	102	100
query22	4643	4423	4189	4189
query23	34877	34240	34191	34191
query24	6007	2794	2763	2763
query25	506	417	395	395
query26	650	157	158	157
query27	1708	284	291	284
query28	4187	2489	2440	2440
query29	680	426	424	424
query30	228	156	151	151
query31	1002	791	817	791
query32	72	52	58	52
query33	401	284	271	271
query34	918	537	531	531
query35	856	750	726	726
query36	1071	965	989	965
query37	123	70	76	70
query38	4361	4376	4235	4235
query39	1474	1432	1407	1407
query40	201	101	102	101
query41	48	47	44	44
query42	112	98	100	98
query43	544	514	485	485
query44	1163	814	810	810
query45	185	165	171	165
query46	1120	701	690	690
query47	1913	1846	1827	1827
query48	433	332	333	332
query49	740	421	398	398
query50	804	398	412	398
query51	7300	7099	6983	6983
query52	104	91	87	87
query53	253	188	183	183
query54	528	411	419	411
query55	76	77	76	76
query56	256	248	279	248
query57	1281	1142	1171	1142
query58	208	211	201	201
query59	3389	3087	3132	3087
query60	276	258	245	245
query61	103	113	105	105
query62	804	673	660	660
query63	211	195	194	194
query64	1345	628	615	615
query65	3303	3198	3209	3198
query66	660	302	303	302
query67	15934	15937	15595	15595
query68	3647	593	576	576
query69	426	263	251	251
query70	1162	1135	1090	1090
query71	365	239	246	239
query72	6147	4019	3984	3984
query73	779	361	378	361
query74	9997	9052	9208	9052
query75	3420	2686	2710	2686
query76	1879	1087	1162	1087
query77	472	291	285	285
query78	10371	9455	9411	9411
query79	2259	607	602	602
query80	1429	422	433	422
query81	546	240	243	240
query82	1278	118	111	111
query83	253	140	138	138
query84	276	73	66	66
query85	1010	306	298	298
query86	413	299	308	299
query87	4966	4636	4651	4636
query88	3759	2228	2175	2175
query89	415	294	297	294
query90	1964	185	186	185
query91	129	99	99	99
query92	62	49	48	48
query93	2869	548	563	548
query94	839	292	290	290
query95	352	250	245	245
query96	643	281	275	275
query97	2922	2725	2718	2718
query98	219	197	189	189
query99	1597	1320	1296	1296
Total cold run time: 323221 ms
Total hot run time: 197343 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32.2 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d4a9df801aa5043a1eea89c9df4120faae925516, data reload: false

query1	0.04	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.64	0.10	0.10
query5	0.41	0.39	0.41
query6	1.14	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.04
query9	0.57	0.49	0.51
query10	0.56	0.55	0.54
query11	0.14	0.10	0.11
query12	0.13	0.11	0.12
query13	0.61	0.59	0.62
query14	2.66	2.74	2.72
query15	0.89	0.83	0.82
query16	0.38	0.37	0.37
query17	1.07	1.02	1.05
query18	0.20	0.19	0.19
query19	1.96	1.82	1.86
query20	0.01	0.01	0.01
query21	15.38	0.59	0.58
query22	2.47	2.34	1.56
query23	16.94	1.09	0.75
query24	2.84	1.11	2.27
query25	0.19	0.19	0.04
query26	0.63	0.14	0.13
query27	0.04	0.06	0.03
query28	9.87	1.11	1.07
query29	12.55	3.23	3.22
query30	0.25	0.06	0.06
query31	2.88	0.39	0.37
query32	3.26	0.46	0.45
query33	2.96	3.02	3.06
query34	16.93	4.50	4.55
query35	4.49	4.48	4.45
query36	0.67	0.49	0.48
query37	0.08	0.05	0.06
query38	0.05	0.03	0.03
query39	0.04	0.02	0.02
query40	0.16	0.12	0.12
query41	0.07	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.58 s
Total hot run time: 32.2 s

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Nov 1, 2024
Copy link
Contributor

github-actions bot commented Nov 1, 2024

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

@morningman morningman merged commit 2ad6cb7 into apache:master Nov 2, 2024
26 of 27 checks passed
github-actions bot pushed a commit that referenced this pull request Nov 2, 2024
…ss to OSS-HDFS (#42585)

Fix the problem that paimon catalog can not access to OSS-HDFS.

There are 2 problems in paimon catalog:
1. Doris FE can not list paimon tables.
This is because we pass these three properties -- `fs.oss.endpoint /
fs.oss.accessKeyId / fs.oss.accessKeySecret` -- to the PaimonCatalog.
When PaimonCatalog get these three properties, it will use `OSSLoader`
rather than `HadoopFileIOLoader`.

2. Doris BE does not use libhdfs to access OSS-HDFS
This is because the `tmpLocation` in `LocationPath` does not contain
`oss-dls.aliyuncs`. We should use `endpoint` to judge if user wants to
access OSS-HDFS

What's more, if you want to access OSS-HDFS with PaimonCatalog, you
should:
1. Download Jindo SDK:
https://github.com/aliyun/alibabacloud-jindodata/blob/latest/docs/user/zh/jindosdk/jindosdk_download.md
2. copy `jindo-core.jar、jindo-sdk.jar` to `${DORIS_HOME}/fe/lib` and
`${DORIS_HOME}/be/lib/java_extensions/preload-extensions` directory.
@morningman morningman removed the p0_b label Nov 4, 2024
morningman pushed a commit to morningman/doris that referenced this pull request Nov 6, 2024
…ss to OSS-HDFS (apache#42585)

Fix the problem that paimon catalog can not access to OSS-HDFS.

There are 2 problems in paimon catalog:
1. Doris FE can not list paimon tables.
This is because we pass these three properties -- `fs.oss.endpoint /
fs.oss.accessKeyId / fs.oss.accessKeySecret` -- to the PaimonCatalog.
When PaimonCatalog get these three properties, it will use `OSSLoader`
rather than `HadoopFileIOLoader`.

2. Doris BE does not use libhdfs to access OSS-HDFS
This is because the `tmpLocation` in `LocationPath` does not contain
`oss-dls.aliyuncs`. We should use `endpoint` to judge if user wants to
access OSS-HDFS

What's more, if you want to access OSS-HDFS with PaimonCatalog, you
should:
1. Download Jindo SDK:
https://github.com/aliyun/alibabacloud-jindodata/blob/latest/docs/user/zh/jindosdk/jindosdk_download.md
2. copy `jindo-core.jar、jindo-sdk.jar` to `${DORIS_HOME}/fe/lib` and
`${DORIS_HOME}/be/lib/java_extensions/preload-extensions` directory.
morningman added a commit that referenced this pull request Nov 6, 2024
…ss to OSS-HDFS #42585 (#43309)

cherry pick from #42585

Co-authored-by: Tiewei Fang <43782773+BePPPower@users.noreply.github.com>
@gavinchou gavinchou added the cir label Nov 11, 2024
morningman pushed a commit to morningman/doris that referenced this pull request Nov 18, 2024
…ss to OSS-HDFS (apache#42585)

Fix the problem that paimon catalog can not access to OSS-HDFS.

There are 2 problems in paimon catalog:
1. Doris FE can not list paimon tables.
This is because we pass these three properties -- `fs.oss.endpoint /
fs.oss.accessKeyId / fs.oss.accessKeySecret` -- to the PaimonCatalog.
When PaimonCatalog get these three properties, it will use `OSSLoader`
rather than `HadoopFileIOLoader`.

2. Doris BE does not use libhdfs to access OSS-HDFS
This is because the `tmpLocation` in `LocationPath` does not contain
`oss-dls.aliyuncs`. We should use `endpoint` to judge if user wants to
access OSS-HDFS

What's more, if you want to access OSS-HDFS with PaimonCatalog, you
should:
1. Download Jindo SDK:
https://github.com/aliyun/alibabacloud-jindodata/blob/latest/docs/user/zh/jindosdk/jindosdk_download.md
2. copy `jindo-core.jar、jindo-sdk.jar` to `${DORIS_HOME}/fe/lib` and
`${DORIS_HOME}/be/lib/java_extensions/preload-extensions` directory.
yiguolei pushed a commit that referenced this pull request Nov 19, 2024
…ss to OSS-HDFS #42585 (#44149)

cherry pick from #42585

Co-authored-by: Tiewei Fang <43782773+BePPPower@users.noreply.github.com>
@yiguolei yiguolei mentioned this pull request Jan 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
approved Indicates a PR has been approved by one committer. cir dev/2.1.8-merged dev/3.0.3-merged reviewed usercase Important user case type label
Projects
None yet
Development

Successfully merging this pull request may close these issues.

8 participants
Morty Proxy This is a proxified and sanitized view of the page, visit original site.