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](ES table)Support desc es_table all command #49408

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

[fix](ES table)Support desc es_table all command #49408

wants to merge 1 commit into from
+143 −0

Conversation

qidaye
Copy link
Contributor

@qidaye qidaye commented Mar 24, 2025 •
edited
Loading

What problem does this PR solve?

Issue Number: close #49409

Problem Summary:

Describe command dose not support Elasticsearch table.

The result is like:

mysql> desc test_v1 all;
+------------------------+------+----------+-------+
| Hosts                  | User | Password | Index |
+------------------------+------+----------+-------+
| http://127.0.0.1:39200 |      |          | test1 |
+------------------------+------+----------+-------+

Release note

None

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test (add detailed scripts or steps below)
    • No need to test or manual test. Explain why:
      • This is a refactor/code format and no logic has been changed.
      • Previous test can cover this change.
      • No code files have been changed.
      • Other reason

  • Behavior changed:

    • No.
    • Yes.

  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@hello-stephen
Copy link
Contributor

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

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@qidaye
Copy link
Contributor Author

qidaye commented Mar 24, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25585	5093	5020	5020
q2	2071	301	168	168
q3	10386	1232	664	664
q4	10233	1007	532	532
q5	7547	2271	2369	2271
q6	185	170	141	141
q7	899	739	604	604
q8	9317	1293	1114	1114
q9	6807	5121	5148	5121
q10	6868	2309	1886	1886
q11	476	274	261	261
q12	336	347	215	215
q13	17771	3638	3024	3024
q14	223	227	211	211
q15	540	484	481	481
q16	618	618	569	569
q17	568	843	329	329
q18	7422	7099	6976	6976
q19	1844	948	539	539
q20	303	317	193	193
q21	3860	3413	2402	2402
q22	1114	1011	964	964
Total cold run time: 114973 ms
Total hot run time: 33685 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5408	5123	5147	5123
q2	248	331	224	224
q3	2131	2635	2285	2285
q4	1412	1789	1403	1403
q5	4487	4394	4355	4355
q6	216	170	133	133
q7	1988	1899	1745	1745
q8	2585	2593	2493	2493
q9	7245	7269	7093	7093
q10	3017	3175	2797	2797
q11	586	494	490	490
q12	674	766	625	625
q13	3467	3863	3300	3300
q14	292	320	309	309
q15	543	493	482	482
q16	656	662	648	648
q17	1130	1567	1414	1414
q18	8062	7804	7603	7603
q19	813	874	1019	874
q20	1951	1974	1864	1864
q21	5332	4967	4857	4857
q22	1102	1054	1018	1018
Total cold run time: 53345 ms
Total hot run time: 51135 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192803 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 9f56355a1942c5e7c96208c4db618f1b8afcc4b0, data reload: false

query1	1375	1057	1031	1031
query2	6337	1973	1931	1931
query3	11103	4737	4703	4703
query4	25760	23619	22863	22863
query5	4049	624	477	477
query6	307	209	188	188
query7	3983	474	264	264
query8	300	241	238	238
query9	8496	2585	2583	2583
query10	449	307	258	258
query11	15397	15088	14761	14761
query12	167	107	111	107
query13	1567	508	396	396
query14	9074	6116	6081	6081
query15	201	179	170	170
query16	7597	626	473	473
query17	1175	719	562	562
query18	1998	412	314	314
query19	188	189	151	151
query20	133	150	112	112
query21	216	125	103	103
query22	4468	4668	4594	4594
query23	34216	33584	33631	33584
query24	8480	2401	2381	2381
query25	480	470	397	397
query26	905	268	138	138
query27	2770	507	327	327
query28	4593	2440	2436	2436
query29	657	567	455	455
query30	278	221	193	193
query31	902	885	766	766
query32	70	62	63	62
query33	536	362	313	313
query34	765	859	501	501
query35	848	826	802	802
query36	952	1010	902	902
query37	121	110	78	78
query38	4304	4258	4130	4130
query39	1551	1440	1451	1440
query40	207	122	107	107
query41	54	51	50	50
query42	116	104	105	104
query43	498	517	488	488
query44	1332	803	802	802
query45	174	174	171	171
query46	865	1036	640	640
query47	1874	1912	1831	1831
query48	387	420	306	306
query49	741	502	434	434
query50	701	754	408	408
query51	4227	4325	4244	4244
query52	114	110	101	101
query53	219	255	181	181
query54	500	502	415	415
query55	89	80	79	79
query56	284	265	266	265
query57	1173	1250	1132	1132
query58	242	246	237	237
query59	2810	2908	2727	2727
query60	283	275	249	249
query61	130	141	128	128
query62	798	725	686	686
query63	231	194	181	181
query64	3341	1170	699	699
query65	4537	4466	4459	4459
query66	878	402	304	304
query67	16206	15646	15438	15438
query68	8843	880	492	492
query69	472	301	253	253
query70	1229	1123	1103	1103
query71	446	287	274	274
query72	5140	4952	4841	4841
query73	700	543	337	337
query74	8930	8975	8983	8975
query75	4073	3224	2706	2706
query76	3665	1192	744	744
query77	770	364	283	283
query78	9879	10089	9371	9371
query79	5759	801	543	543
query80	707	515	419	419
query81	465	264	230	230
query82	606	124	91	91
query83	197	170	149	149
query84	292	92	72	72
query85	742	349	305	305
query86	343	284	289	284
query87	4400	4468	4228	4228
query88	2827	2192	2197	2192
query89	427	304	278	278
query90	2164	200	205	200
query91	149	148	111	111
query92	71	56	53	53
query93	3370	1009	567	567
query94	671	406	298	298
query95	347	264	261	261
query96	477	553	271	271
query97	3336	3356	3262	3262
query98	214	219	252	219
query99	1432	1387	1260	1260
Total cold run time: 282922 ms
Total hot run time: 192803 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.12	0.10	0.11
query3	0.24	0.19	0.19
query4	1.60	0.19	0.19
query5	0.59	0.58	0.60
query6	1.20	0.73	0.71
query7	0.02	0.02	0.01
query8	0.04	0.04	0.03
query9	0.59	0.52	0.51
query10	0.56	0.58	0.59
query11	0.15	0.11	0.11
query12	0.14	0.11	0.12
query13	0.62	0.60	0.59
query14	2.69	2.82	2.84
query15	0.93	0.87	0.86
query16	0.38	0.38	0.37
query17	1.05	1.02	1.03
query18	0.22	0.19	0.20
query19	1.90	1.95	1.80
query20	0.02	0.01	0.01
query21	15.37	0.91	0.55
query22	0.76	1.22	0.73
query23	14.86	1.37	0.59
query24	6.70	2.41	0.65
query25	0.48	0.28	0.13
query26	0.58	0.16	0.15
query27	0.05	0.05	0.04
query28	9.55	0.86	0.42
query29	12.55	3.97	3.28
query30	0.24	0.10	0.06
query31	2.84	0.56	0.38
query32	3.22	0.56	0.47
query33	3.00	3.09	3.07
query34	15.78	5.14	4.57
query35	4.51	4.54	4.55
query36	0.65	0.49	0.48
query37	0.09	0.07	0.06
query38	0.06	0.04	0.03
query39	0.03	0.02	0.02
query40	0.17	0.13	0.13
query41	0.07	0.02	0.03
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 104.73 s
Total hot run time: 31.23 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@CalvinKirs CalvinKirs Awaiting requested review from CalvinKirs CalvinKirs is a code owner

@morningman morningman Awaiting requested review from morningman morningman is a code owner

At least 1 approving review is required to merge this pull request.

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

Successfully merging this pull request may close these issues.

[Bug] desc es_table all failed
3 participants
@qidaye @hello-stephen @doris-robot