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

branch-3.0: [improvement](information_schema)Show view definition in information_schema.views. #45857 #45904

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
Merged
merged 1 commit into from
Dec 25, 2024
Merged

branch-3.0: [improvement](information_schema)Show view definition in information_schema.views. #45857 #45904

merged 1 commit into from
Dec 25, 2024

Conversation

github-actions[bot]
Copy link
Contributor

Cherry-picked from #45857

@Jibing-Li
[improvement](information_schema)Show view definition in information_…
d43adbb 
…schema.views. (#45857)

### What problem does this PR solve?

Support show view definition sql in information_schema.views.

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

### Release note

None
@Thearas
Copy link
Contributor

Thearas commented Dec 25, 2024

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?

@dataroaring dataroaring reopened this Dec 25, 2024
@Thearas
Copy link
Contributor

Thearas commented Dec 25, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17623	7398	7359	7359
q2	2265	171	169	169
q3	11887	1065	1135	1065
q4	10559	745	740	740
q5	7731	2793	2806	2793
q6	233	142	150	142
q7	969	606	597	597
q8	9342	1930	2012	1930
q9	6507	6367	6380	6367
q10	6976	2253	2327	2253
q11	461	261	265	261
q12	394	209	215	209
q13	17768	2962	2959	2959
q14	241	205	210	205
q15	562	513	528	513
q16	674	597	615	597
q17	973	503	599	503
q18	7228	6626	6468	6468
q19	3825	1040	972	972
q20	475	204	189	189
q21	3909	3023	3102	3023
q22	1069	948	934	934
Total cold run time: 111671 ms
Total hot run time: 40248 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7402	7167	7182	7167
q2	325	241	229	229
q3	2987	2875	2873	2873
q4	2066	1689	1719	1689
q5	5649	5729	5711	5711
q6	226	143	145	143
q7	2221	1753	1759	1753
q8	3351	3472	3345	3345
q9	8827	8893	8813	8813
q10	3546	3515	3506	3506
q11	597	515	519	515
q12	800	615	594	594
q13	16546	3111	3134	3111
q14	296	289	270	270
q15	559	524	528	524
q16	710	670	664	664
q17	1834	1595	1577	1577
q18	8210	7770	7509	7509
q19	5133	1485	1598	1485
q20	2091	1865	1854	1854
q21	5456	5140	5152	5140
q22	1098	1000	1032	1000
Total cold run time: 79930 ms
Total hot run time: 59472 ms

@doris-robot
Copy link

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

query1	1289	926	973	926
query2	6241	2031	2001	2001
query3	10816	4174	4188	4174
query4	65762	29221	23498	23498
query5	5050	440	441	440
query6	445	188	190	188
query7	5669	315	307	307
query8	322	239	230	230
query9	9075	2781	2740	2740
query10	505	263	271	263
query11	17439	15146	15697	15146
query12	169	107	112	107
query13	1554	441	436	436
query14	10745	7267	7203	7203
query15	218	186	180	180
query16	7185	497	456	456
query17	1117	575	583	575
query18	1806	356	317	317
query19	224	166	162	162
query20	116	118	115	115
query21	69	46	49	46
query22	4529	4471	4624	4471
query23	35818	34702	34881	34702
query24	6161	2976	2953	2953
query25	523	427	413	413
query26	690	170	166	166
query27	1853	302	310	302
query28	4287	2582	2536	2536
query29	760	456	439	439
query30	247	163	155	155
query31	1000	816	829	816
query32	66	55	54	54
query33	466	299	301	299
query34	916	506	503	503
query35	851	748	744	744
query36	1083	932	952	932
query37	121	68	76	68
query38	4190	3945	3996	3945
query39	1524	1488	1465	1465
query40	144	83	82	82
query41	51	49	47	47
query42	124	102	99	99
query43	513	494	489	489
query44	1179	812	804	804
query45	188	171	175	171
query46	1153	730	734	730
query47	1961	1862	1909	1862
query48	446	363	383	363
query49	712	363	376	363
query50	853	416	420	416
query51	7181	7160	7135	7135
query52	103	85	88	85
query53	254	186	179	179
query54	563	449	440	440
query55	75	76	73	73
query56	265	221	241	221
query57	1163	1089	1083	1083
query58	199	201	199	199
query59	3031	2954	3067	2954
query60	282	243	243	243
query61	105	104	104	104
query62	769	658	652	652
query63	208	188	197	188
query64	1763	642	621	621
query65	3268	3203	3190	3190
query66	645	306	301	301
query67	15582	15314	15405	15314
query68	4620	570	556	556
query69	457	251	255	251
query70	1181	1079	1078	1078
query71	397	264	252	252
query72	6354	3950	3925	3925
query73	774	342	333	333
query74	10122	8877	8999	8877
query75	3339	2616	2679	2616
query76	2592	1062	1088	1062
query77	547	267	264	264
query78	10561	9696	9525	9525
query79	6829	585	596	585
query80	2040	421	415	415
query81	547	249	239	239
query82	933	120	113	113
query83	294	142	138	138
query84	281	84	83	83
query85	1594	302	286	286
query86	478	312	303	303
query87	4376	4392	4157	4157
query88	5395	2508	2426	2426
query89	519	285	288	285
query90	2213	200	185	185
query91	180	142	144	142
query92	70	47	49	47
query93	6580	531	529	529
query94	915	285	289	285
query95	339	247	256	247
query96	620	281	282	281
query97	3307	3139	3125	3125
query98	213	198	196	196
query99	1673	1286	1259	1259
Total cold run time: 334021 ms
Total hot run time: 196946 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.06	0.03	0.03
query3	0.23	0.07	0.07
query4	1.63	0.10	0.10
query5	0.52	0.51	0.51
query6	1.14	0.73	0.73
query7	0.02	0.02	0.01
query8	0.05	0.03	0.03
query9	0.56	0.50	0.50
query10	0.53	0.56	0.56
query11	0.14	0.11	0.10
query12	0.14	0.10	0.10
query13	0.60	0.58	0.59
query14	2.95	2.94	3.00
query15	0.90	0.83	0.81
query16	0.37	0.40	0.38
query17	1.00	1.00	1.03
query18	0.23	0.21	0.22
query19	1.90	1.74	1.97
query20	0.02	0.01	0.02
query21	15.36	0.59	0.58
query22	2.24	2.64	1.42
query23	17.06	0.88	0.87
query24	3.02	1.58	1.27
query25	0.16	0.16	0.16
query26	0.50	0.15	0.13
query27	0.04	0.05	0.05
query28	9.97	1.10	1.06
query29	12.56	3.25	3.24
query30	0.24	0.06	0.06
query31	2.85	0.38	0.38
query32	3.27	0.46	0.48
query33	2.93	2.96	2.96
query34	16.99	4.39	4.45
query35	4.51	4.43	4.48
query36	0.63	0.49	0.48
query37	0.09	0.07	0.06
query38	0.04	0.04	0.04
query39	0.03	0.02	0.02
query40	0.16	0.12	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 105.82 s
Total hot run time: 32.69 s

@Jibing-Li Jibing-Li merged commit a88183e into branch-3.0 Dec 25, 2024
19 of 21 checks passed
@github-actions github-actions bot deleted the auto-pick-45857-branch-3.0 branch December 25, 2024 04:57
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
4 participants
@Thearas @doris-robot @Jibing-Li @dataroaring
Morty Proxy This is a proxified and sanitized view of the page, visit original site.