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.

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

[Enhancement] (nereids)implement showColumnsCommand in nereids #45832

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

Conversation

msridhar78
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #42747

Related PR: #xxx

Problem Summary:
[Enhancement] (nereids)implement showColumnsCommand in nereids

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

@Thearas
Copy link
Contributor

Thearas commented Dec 23, 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?

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17574	8267	7370	7370
q2	2046	179	165	165
q3	10742	1083	1176	1083
q4	10523	781	750	750
q5	7613	2752	2742	2742
q6	245	151	147	147
q7	969	610	610	610
q8	9249	1882	1918	1882
q9	6567	6411	6430	6411
q10	7048	2324	2371	2324
q11	460	266	259	259
q12	434	219	219	219
q13	17760	2959	2914	2914
q14	239	215	204	204
q15	560	502	506	502
q16	684	579	582	579
q17	975	641	521	521
q18	7406	6708	6728	6708
q19	1330	1037	1021	1021
q20	474	186	186	186
q21	4097	3222	3284	3222
q22	383	320	312	312
Total cold run time: 107378 ms
Total hot run time: 40131 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7406	7371	7382	7371
q2	334	230	231	230
q3	2877	2964	2945	2945
q4	2121	1811	1862	1811
q5	5634	5672	5666	5666
q6	234	148	142	142
q7	2273	1822	1807	1807
q8	3397	3554	3564	3554
q9	8826	9026	8933	8933
q10	3606	3554	3551	3551
q11	606	504	506	504
q12	801	585	584	584
q13	12267	3075	3138	3075
q14	312	273	293	273
q15	557	521	494	494
q16	722	654	669	654
q17	1854	1651	1603	1603
q18	8434	7816	7746	7746
q19	1852	1696	1685	1685
q20	2133	1822	1885	1822
q21	5677	5471	5497	5471
q22	650	594	611	594
Total cold run time: 72573 ms
Total hot run time: 60515 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 196895 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 56331956e1e43264a1913ddcb9d4629acf9e8ecc, data reload: false

query1	1311	947	963	947
query2	6223	2476	2492	2476
query3	11142	4606	4871	4606
query4	33345	23276	23690	23276
query5	4387	490	463	463
query6	297	214	194	194
query7	4010	315	309	309
query8	294	247	234	234
query9	9521	2766	2751	2751
query10	496	258	262	258
query11	18109	15017	15133	15017
query12	156	107	109	107
query13	1588	456	423	423
query14	9531	7255	7433	7255
query15	328	192	204	192
query16	8252	527	474	474
query17	1765	617	584	584
query18	2153	303	311	303
query19	360	166	165	165
query20	126	118	119	118
query21	210	106	113	106
query22	4633	4683	4480	4480
query23	34704	33563	33722	33563
query24	10613	2583	2529	2529
query25	603	390	405	390
query26	1100	153	161	153
query27	2364	341	335	335
query28	7433	2478	2512	2478
query29	853	434	434	434
query30	232	155	162	155
query31	1071	844	872	844
query32	98	60	55	55
query33	776	289	298	289
query34	980	552	519	519
query35	910	774	775	774
query36	1138	969	969	969
query37	128	75	76	75
query38	4175	4239	4146	4146
query39	1539	1453	1468	1453
query40	208	103	107	103
query41	45	46	43	43
query42	118	107	106	106
query43	537	511	500	500
query44	1244	846	838	838
query45	195	170	167	167
query46	1185	784	757	757
query47	2023	1891	1931	1891
query48	441	329	345	329
query49	900	401	408	401
query50	829	419	407	407
query51	7319	7314	7309	7309
query52	104	95	93	93
query53	262	188	196	188
query54	1133	434	426	426
query55	83	76	81	76
query56	274	244	260	244
query57	1282	1149	1176	1149
query58	241	251	229	229
query59	3448	3241	3056	3056
query60	288	266	263	263
query61	120	109	129	109
query62	876	715	712	712
query63	219	198	193	193
query64	3807	710	654	654
query65	3243	3183	3191	3183
query66	795	299	300	299
query67	15972	15567	15461	15461
query68	5089	561	574	561
query69	498	258	249	249
query70	1224	1171	1127	1127
query71	492	261	253	253
query72	7139	4145	4072	4072
query73	788	359	363	359
query74	9920	8851	8920	8851
query75	3808	2715	2643	2643
query76	3746	1085	1132	1085
query77	585	276	284	276
query78	10316	9450	9419	9419
query79	1234	604	595	595
query80	768	440	449	440
query81	542	231	273	231
query82	763	123	123	123
query83	261	145	146	145
query84	234	72	70	70
query85	1600	312	323	312
query86	477	298	304	298
query87	4842	4293	4473	4293
query88	3897	2219	2226	2219
query89	429	288	295	288
query90	1994	191	191	191
query91	145	103	107	103
query92	67	55	54	54
query93	2486	562	556	556
query94	920	295	295	295
query95	361	258	251	251
query96	611	289	284	284
query97	2878	2671	2680	2671
query98	228	195	206	195
query99	1589	1336	1301	1301
Total cold run time: 304076 ms
Total hot run time: 196895 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.04
query2	0.08	0.04	0.03
query3	0.24	0.07	0.07
query4	1.61	0.10	0.10
query5	0.43	0.42	0.40
query6	1.17	0.66	0.65
query7	0.02	0.02	0.02
query8	0.04	0.04	0.04
query9	0.57	0.49	0.50
query10	0.57	0.57	0.55
query11	0.16	0.11	0.10
query12	0.14	0.12	0.11
query13	0.61	0.61	0.59
query14	2.74	2.72	2.73
query15	0.91	0.82	0.83
query16	0.39	0.39	0.41
query17	0.96	1.02	0.99
query18	0.23	0.20	0.21
query19	1.85	1.88	1.96
query20	0.01	0.01	0.01
query21	15.36	0.59	0.59
query22	2.52	1.91	1.79
query23	16.99	0.95	0.80
query24	3.05	0.66	1.71
query25	0.29	0.15	0.15
query26	0.32	0.13	0.14
query27	0.04	0.04	0.05
query28	10.50	1.10	1.07
query29	12.58	3.26	3.26
query30	0.24	0.06	0.06
query31	2.86	0.39	0.38
query32	3.23	0.49	0.46
query33	3.15	3.10	3.10
query34	16.88	4.47	4.52
query35	4.63	4.47	4.55
query36	0.63	0.49	0.50
query37	0.09	0.06	0.06
query38	0.04	0.03	0.04
query39	0.04	0.02	0.02
query40	0.17	0.12	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 106.54 s
Total hot run time: 32.42 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

[Enhancement] (nereids)implement showColumnsCommand in nereids
3 participants