Skip to content

test ttz get_field#61600

Draft
zclllyybb wants to merge 1 commit intoapache:masterfrom
zclllyybb:test_ttz_field
Draft

test ttz get_field#61600
zclllyybb wants to merge 1 commit intoapache:masterfrom
zclllyybb:test_ttz_field

Conversation

@zclllyybb
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

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

@zclllyybb
Copy link
Contributor Author

run buildall

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

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
orders	Doris	NULL	NULL	0	0	0	NULL	0	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	17645	4446	4271	4271
q2	q3	10647	771	522	522
q4	4669	356	254	254
q5	7545	1196	1005	1005
q6	169	171	148	148
q7	797	839	670	670
q8	9310	1477	1387	1387
q9	4891	4742	4687	4687
q10	6292	1920	1653	1653
q11	463	256	254	254
q12	757	580	467	467
q13	18046	2931	2166	2166
q14	226	226	220	220
q15	q16	736	732	680	680
q17	722	850	459	459
q18	5893	5468	5288	5288
q19	1111	975	639	639
q20	545	494	380	380
q21	4774	1851	1444	1444
q22	555	387	289	289
Total cold run time: 95793 ms
Total hot run time: 26883 ms

----- Round 2, with runtime_filter_mode=off -----
orders	Doris	NULL	NULL	150000000	42	6422171781	NULL	22778155	NULL	NULL	2023-12-26 18:27:23	2023-12-26 18:42:55	NULL	utf-8	NULL	NULL	
============================================
q1	4694	4591	4691	4591
q2	q3	3883	4364	3792	3792
q4	869	1203	794	794
q5	4061	4334	4375	4334
q6	190	174	142	142
q7	1804	1635	1543	1543
q8	2532	2701	2565	2565
q9	7510	7409	7549	7409
q10	3747	3953	3603	3603
q11	506	430	415	415
q12	486	599	444	444
q13	2699	3299	2325	2325
q14	295	294	281	281
q15	q16	716	823	747	747
q17	1215	1314	1420	1314
q18	7095	6846	6546	6546
q19	924	925	912	912
q20	2067	2185	2214	2185
q21	4050	3484	3373	3373
q22	477	429	391	391
Total cold run time: 49820 ms
Total hot run time: 47706 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 168587 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 377bc8309be4daadb568397d398c303950b3b564, data reload: false

query5	4330	630	494	494
query6	339	229	198	198
query7	4218	458	283	283
query8	336	249	239	239
query9	8718	2695	2719	2695
query10	533	386	333	333
query11	7010	5091	4885	4885
query12	182	129	129	129
query13	1280	495	364	364
query14	5687	3691	3448	3448
query14_1	2869	2837	2813	2813
query15	205	194	178	178
query16	969	464	447	447
query17	1025	734	618	618
query18	2443	466	361	361
query19	213	214	189	189
query20	136	126	130	126
query21	209	135	113	113
query22	13308	13927	14932	13927
query23	16293	15938	15888	15888
query23_1	15757	15714	15576	15576
query24	7162	1633	1238	1238
query24_1	1228	1206	1255	1206
query25	610	458	407	407
query26	1243	273	155	155
query27	2751	499	305	305
query28	4403	1840	1825	1825
query29	859	568	483	483
query30	299	233	190	190
query31	1022	940	871	871
query32	80	73	70	70
query33	513	332	299	299
query34	885	870	559	559
query35	642	686	605	605
query36	1093	1100	944	944
query37	137	95	88	88
query38	2980	2904	2893	2893
query39	859	829	797	797
query39_1	790	799	785	785
query40	244	162	136	136
query41	63	97	59	59
query42	269	257	252	252
query43	252	260	231	231
query44	
query45	202	191	185	185
query46	904	987	609	609
query47	2729	2111	2039	2039
query48	315	323	229	229
query49	632	465	385	385
query50	705	292	228	228
query51	4054	4054	4149	4054
query52	258	264	256	256
query53	302	348	298	298
query54	301	276	270	270
query55	92	91	92	91
query56	315	311	318	311
query57	1940	1765	1742	1742
query58	315	272	267	267
query59	2759	2936	2772	2772
query60	346	339	323	323
query61	154	154	161	154
query62	637	584	523	523
query63	322	281	274	274
query64	5108	1257	998	998
query65	
query66	1471	448	358	358
query67	24201	24267	24261	24261
query68	
query69	398	313	286	286
query70	914	945	957	945
query71	353	315	297	297
query72	2850	2678	2419	2419
query73	549	568	325	325
query74	9631	9575	9410	9410
query75	2901	2793	2459	2459
query76	2267	1018	691	691
query77	395	384	301	301
query78	10945	11004	10488	10488
query79	1374	787	583	583
query80	1349	640	530	530
query81	543	262	232	232
query82	991	153	123	123
query83	341	270	243	243
query84	281	115	102	102
query85	912	484	442	442
query86	408	310	293	293
query87	3148	3077	3008	3008
query88	3609	2660	2675	2660
query89	435	373	343	343
query90	2055	181	182	181
query91	174	165	144	144
query92	80	81	73	73
query93	1008	832	503	503
query94	648	335	298	298
query95	590	343	320	320
query96	659	534	233	233
query97	2477	2518	2391	2391
query98	236	220	227	220
query99	1043	993	924	924
Total cold run time: 250594 ms
Total hot run time: 168587 ms

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.

3 participants