Skip to content

Conversation

@csun5285
Copy link
Contributor

@csun5285 csun5285 commented Dec 19, 2025

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

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

@csun5285
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.72% (1757/2204)
Line Coverage 65.35% (30883/47256)
Region Coverage 66.05% (15411/23333)
Branch Coverage 56.54% (8193/14490)

@csun5285
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.72% (1757/2204)
Line Coverage 65.36% (30885/47256)
Region Coverage 66.04% (15410/23333)
Branch Coverage 56.51% (8189/14490)

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 74.80% (92/123) 🎉
Increment coverage report
Complete coverage report

@csun5285
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.50% (1765/2220)
Line Coverage 65.05% (31068/47763)
Region Coverage 65.50% (15483/23639)
Branch Coverage 56.11% (8230/14668)

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 52.03% (64/123) 🎉
Increment coverage report
Complete coverage report

@csun5285
Copy link
Contributor Author

run p0 10

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17654	4242	4090	4090
q2	2024	356	245	245
q3	10244	1337	740	740
q4	10323	876	311	311
q5	9149	2189	1936	1936
q6	231	175	138	138
q7	1010	874	710	710
q8	9368	1461	1215	1215
q9	7162	5371	5448	5371
q10	6886	2404	1973	1973
q11	533	335	323	323
q12	703	737	580	580
q13	17791	3695	3011	3011
q14	277	290	272	272
q15	607	505	518	505
q16	747	698	646	646
q17	714	876	516	516
q18	7537	8191	7731	7731
q19	1217	1014	644	644
q20	422	394	261	261
q21	4670	4320	4171	4171
q22	1074	1106	986	986
Total cold run time: 110343 ms
Total hot run time: 36375 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4505	4302	4331	4302
q2	339	401	310	310
q3	2328	2848	2572	2572
q4	1413	1900	1376	1376
q5	4752	4495	4539	4495
q6	210	164	130	130
q7	2053	1968	1750	1750
q8	2851	2521	2586	2521
q9	7564	7437	7423	7423
q10	2991	3100	2687	2687
q11	583	530	488	488
q12	636	693	572	572
q13	3288	3694	3030	3030
q14	264	273	259	259
q15	535	491	485	485
q16	605	649	619	619
q17	1119	1368	1416	1368
q18	7268	7001	7033	7001
q19	829	854	869	854
q20	1876	1928	1777	1777
q21	4733	4402	4173	4173
q22	1085	1038	997	997
Total cold run time: 51827 ms
Total hot run time: 49189 ms

@doris-robot
Copy link

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

query5	4709	572	443	443
query6	344	242	220	220
query7	4224	467	272	272
query8	313	249	260	249
query9	8787	2571	2554	2554
query10	528	368	351	351
query11	15642	15046	14705	14705
query12	184	120	115	115
query13	1286	517	396	396
query14	5986	3097	2815	2815
query14_1	2698	2673	2689	2673
query15	209	196	179	179
query16	868	490	455	455
query17	1124	728	600	600
query18	2431	447	352	352
query19	241	232	212	212
query20	129	118	115	115
query21	225	144	121	121
query22	3823	3984	3925	3925
query23	16572	16072	15923	15923
query23_1	15953	16116	16166	16116
query24	7359	1710	1220	1220
query24_1	1247	1217	1258	1217
query25	591	505	482	482
query26	1255	283	166	166
query27	2738	490	310	310
query28	4466	2135	2139	2135
query29	827	576	481	481
query30	318	248	217	217
query31	810	705	635	635
query32	84	71	73	71
query33	547	352	293	293
query34	913	919	581	581
query35	773	853	714	714
query36	860	933	832	832
query37	135	106	77	77
query38	2945	3109	3012	3012
query39	765	757	729	729
query39_1	692	740	697	697
query40	218	140	121	121
query41	66	61	62	61
query42	109	112	104	104
query43	423	437	405	405
query44	1325	758	728	728
query45	191	189	194	189
query46	871	967	607	607
query47	1666	1695	1619	1619
query48	310	326	268	268
query49	605	433	346	346
query50	672	317	230	230
query51	3867	3797	3849	3797
query52	102	111	100	100
query53	339	356	305	305
query54	306	270	247	247
query55	78	77	76	76
query56	293	319	320	319
query57	1161	1148	1088	1088
query58	274	266	250	250
query59	2399	2595	2414	2414
query60	362	310	293	293
query61	166	156	161	156
query62	758	708	663	663
query63	334	300	305	300
query64	5079	1288	1027	1027
query65	4011	3927	3935	3927
query66	1457	431	315	315
query67	15829	15014	15065	15014
query68	8350	1009	720	720
query69	494	345	310	310
query70	1071	1010	998	998
query71	382	305	295	295
query72	6056	5048	5218	5048
query73	734	687	315	315
query74	9007	8866	8703	8703
query75	3182	3164	2811	2811
query76	3856	1138	759	759
query77	534	402	294	294
query78	9548	9452	8838	8838
query79	1665	846	607	607
query80	759	666	547	547
query81	523	262	240	240
query82	479	132	101	101
query83	263	264	243	243
query84	268	137	111	111
query85	976	515	468	468
query86	383	298	277	277
query87	3275	3259	3116	3116
query88	4373	2292	2301	2292
query89	473	421	397	397
query90	2116	166	169	166
query91	179	171	150	150
query92	82	68	69	68
query93	1635	918	566	566
query94	478	298	257	257
query95	587	329	360	329
query96	604	504	210	210
query97	2248	2257	2223	2223
query98	221	199	194	194
query99	1395	1363	1299	1299
Total cold run time: 263195 ms
Total hot run time: 180018 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.09	0.05	0.05
query3	0.26	0.08	0.09
query4	1.60	0.11	0.11
query5	0.27	0.26	0.24
query6	1.19	0.62	0.64
query7	0.03	0.02	0.03
query8	0.05	0.03	0.04
query9	0.57	0.51	0.51
query10	0.54	0.54	0.54
query11	0.15	0.11	0.10
query12	0.14	0.11	0.12
query13	0.62	0.59	0.61
query14	0.99	0.98	0.98
query15	0.82	0.80	0.80
query16	0.39	0.39	0.40
query17	1.05	0.96	1.00
query18	0.22	0.22	0.22
query19	1.82	1.90	1.86
query20	0.02	0.02	0.01
query21	15.44	0.31	0.15
query22	4.78	0.05	0.05
query23	15.94	0.28	0.10
query24	0.99	0.24	0.21
query25	0.09	0.08	0.06
query26	0.15	0.14	0.13
query27	0.06	0.05	0.04
query28	3.10	1.23	1.04
query29	12.56	4.00	3.18
query30	0.28	0.15	0.12
query31	2.82	0.61	0.40
query32	3.23	0.54	0.44
query33	3.01	2.98	3.06
query34	16.91	5.22	4.54
query35	4.56	4.55	5.16
query36	0.71	0.54	0.55
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.05	0.04	0.03
query40	0.17	0.15	0.15
query41	0.08	0.04	0.02
query42	0.04	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 96.06 s
Total hot run time: 27.17 s

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 71.54% (88/123) 🎉
Increment coverage report
Complete coverage report

@csun5285
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.48% (1766/2222)
Line Coverage 64.83% (31249/48205)
Region Coverage 65.34% (15549/23798)
Branch Coverage 56.01% (8270/14764)

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17644	4319	4135	4135
q2	2021	365	239	239
q3	10433	1348	758	758
q4	10328	873	315	315
q5	9343	2188	1902	1902
q6	205	177	136	136
q7	992	862	709	709
q8	9364	1432	1137	1137
q9	7225	5382	5305	5305
q10	6893	2399	1957	1957
q11	507	335	300	300
q12	696	716	558	558
q13	17797	3675	3012	3012
q14	294	293	270	270
q15	594	519	516	516
q16	688	692	645	645
q17	736	848	476	476
q18	7950	7163	7103	7103
q19	1141	964	596	596
q20	400	363	247	247
q21	4210	4070	3772	3772
q22	1043	1007	954	954
Total cold run time: 110504 ms
Total hot run time: 35042 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4213	4066	4083	4066
q2	333	404	309	309
q3	2162	2676	2242	2242
q4	1327	1725	1318	1318
q5	4514	4670	4648	4648
q6	220	176	137	137
q7	1995	2014	1815	1815
q8	2648	2575	2520	2520
q9	7468	7532	7485	7485
q10	3147	3238	2959	2959
q11	679	563	502	502
q12	677	728	614	614
q13	3516	3938	3256	3256
q14	297	293	295	293
q15	544	496	504	496
q16	662	681	676	676
q17	1183	1449	1428	1428
q18	7949	7937	7683	7683
q19	866	853	882	853
q20	1985	2058	1795	1795
q21	4599	4321	4200	4200
q22	1068	1016	978	978
Total cold run time: 52052 ms
Total hot run time: 50273 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 178720 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 943db930298af39d52905f681a19c51d8fdfa5dc, data reload: false

query5	4406	586	448	448
query6	324	225	215	215
query7	4219	464	263	263
query8	308	253	234	234
query9	8747	2503	2531	2503
query10	524	365	327	327
query11	15456	14914	14690	14690
query12	168	116	118	116
query13	1260	489	413	413
query14	5579	2971	2751	2751
query14_1	2642	2613	2608	2608
query15	214	200	181	181
query16	851	461	444	444
query17	1008	713	603	603
query18	2440	446	351	351
query19	261	219	204	204
query20	115	117	110	110
query21	220	135	117	117
query22	4007	4125	3969	3969
query23	16726	16235	15986	15986
query23_1	16152	16220	16128	16128
query24	7350	1628	1200	1200
query24_1	1243	1230	1231	1230
query25	552	465	422	422
query26	1253	266	150	150
query27	2800	472	303	303
query28	4472	2140	2119	2119
query29	829	551	436	436
query30	314	242	210	210
query31	798	688	618	618
query32	79	69	65	65
query33	537	337	277	277
query34	907	904	535	535
query35	764	804	700	700
query36	868	920	826	826
query37	129	96	75	75
query38	2917	2957	2955	2955
query39	753	746	727	727
query39_1	704	703	732	703
query40	231	132	120	120
query41	65	62	59	59
query42	109	109	108	108
query43	423	431	405	405
query44	1337	737	732	732
query45	194	183	183	183
query46	876	974	602	602
query47	1697	1690	1606	1606
query48	314	329	238	238
query49	634	435	338	338
query50	656	304	230	230
query51	3800	3797	3868	3797
query52	110	108	104	104
query53	319	356	294	294
query54	302	268	257	257
query55	82	77	71	71
query56	307	301	314	301
query57	1197	1170	1100	1100
query58	283	253	277	253
query59	2392	2558	2382	2382
query60	334	333	311	311
query61	193	187	184	184
query62	757	700	662	662
query63	332	295	304	295
query64	5145	1398	1038	1038
query65	4010	3953	3970	3953
query66	1453	425	323	323
query67	15489	15057	14625	14625
query68	7640	991	722	722
query69	500	386	306	306
query70	1033	969	970	969
query71	359	306	279	279
query72	6155	4992	5084	4992
query73	751	674	312	312
query74	8731	9041	8709	8709
query75	3226	3176	2789	2789
query76	3847	1144	732	732
query77	524	399	278	278
query78	9508	9685	8815	8815
query79	1603	925	616	616
query80	931	653	545	545
query81	538	272	235	235
query82	397	134	98	98
query83	258	254	242	242
query84	312	114	105	105
query85	924	503	461	461
query86	419	313	247	247
query87	3184	3136	3021	3021
query88	3261	2266	2242	2242
query89	462	411	400	400
query90	2035	157	163	157
query91	170	166	146	146
query92	81	68	68	68
query93	1366	932	556	556
query94	533	297	274	274
query95	575	315	352	315
query96	608	478	219	219
query97	2283	2266	2257	2257
query98	218	197	190	190
query99	1326	1348	1300	1300
Total cold run time: 259906 ms
Total hot run time: 178720 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.04
query2	0.13	0.07	0.07
query3	0.30	0.08	0.08
query4	1.60	0.10	0.10
query5	0.28	0.24	0.25
query6	1.19	0.64	0.64
query7	0.03	0.03	0.02
query8	0.08	0.05	0.07
query9	0.57	0.52	0.49
query10	0.57	0.55	0.55
query11	0.26	0.13	0.13
query12	0.25	0.14	0.13
query13	0.63	0.63	0.62
query14	1.02	0.98	1.00
query15	0.87	0.81	0.81
query16	0.38	0.39	0.37
query17	1.05	1.03	0.98
query18	0.24	0.22	0.22
query19	1.84	1.79	1.78
query20	0.02	0.02	0.01
query21	15.46	0.28	0.24
query22	4.97	0.09	0.10
query23	15.41	0.39	0.22
query24	2.40	0.50	0.31
query25	0.11	0.09	0.10
query26	0.17	0.17	0.17
query27	0.09	0.09	0.09
query28	3.82	1.34	1.15
query29	12.60	4.12	3.39
query30	0.32	0.12	0.11
query31	2.80	0.62	0.42
query32	3.24	0.58	0.49
query33	2.95	3.12	3.00
query34	16.75	5.19	4.57
query35	4.60	4.70	4.64
query36	0.61	0.50	0.49
query37	0.24	0.08	0.08
query38	0.19	0.06	0.05
query39	0.07	0.04	0.05
query40	0.20	0.17	0.17
query41	0.13	0.06	0.06
query42	0.07	0.06	0.05
query43	0.06	0.05	0.05
Total cold run time: 98.62 s
Total hot run time: 28.28 s

Status parse_variant_columns(vectorized::Block& block, const TabletSchema& tablet_schema,
const std::vector<uint32_t>& column_pos);

// Moved from `vec/common/schema_util.{h,cpp}`.
Copy link
Member

Choose a reason for hiding this comment

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

remove this comment


namespace doris::segment_v2::variant_util {

// Parse variant columns by picking variant positions from `column_pos` and generating ParseConfig
Copy link
Member

Choose a reason for hiding this comment

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

and generating ParseConfig?

}

void ColumnVariant::serialize_from_doc_snapshot_to_json_format(int64_t row_num,
BufferWritable& output,
Copy link
Member

Choose a reason for hiding this comment

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

too many duplicated code

BeConsts::DEFAULT_VARIANT_MAX_SPARSE_COLUMN_STATS_SIZE;
// default to 0, no shard
int32_t _variant_sparse_hash_shard_count = 0;

Copy link
Member

Choose a reason for hiding this comment

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

better wrap all the variant related properties to a structure


int64_t _variant_doc_snapshot_min_rows = 0;

int32_t _variant_doc_snapshot_shard_count = 128;
Copy link
Member

Choose a reason for hiding this comment

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

what if specify _variant_sparse_hash_shard_count and _variant_doc_snapshot_shard_count at the same time?

Copy link
Member

Choose a reason for hiding this comment

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

  1. 哪些互斥、哪些是必须一起的


vectorized::MutableColumnPtr variant_column;
if (var.is_doc_snapshot_mode()) {
// doc snapshot mode, we need to parse the doc snapshot column
Copy link
Member

Choose a reason for hiding this comment

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

什么情况会走到这里, need comments

Copy link
Member

Choose a reason for hiding this comment

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

判断config

auto converter = std::make_unique<vectorized::OlapBlockDataConvertor>();
int column_id = 0;
int64_t variant_doc_snapshot_min_rows = parent_column.variant_doc_snapshot_min_rows();
if (variant_doc_snapshot_min_rows == 0 ||
Copy link
Member

Choose a reason for hiding this comment

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

variant_doc_snapshot_min_rows == 0 is redundant and could be removed ?

@SerializedName(value = "variantSparseHashShardCount")
private final int variantSparseHashShardCount;

@SerializedName(value = "enableVariantDocSnapshotMode")
Copy link
Member

Choose a reason for hiding this comment

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

enable_doc_mode?

@SerializedName(value = "enableVariantDocSnapshotMode")
private final boolean enableVariantDocSnapshotMode;

@SerializedName(value = "variantDocSnapshotMinRows")
Copy link
Member

@eldenmoon eldenmoon Dec 23, 2025

Choose a reason for hiding this comment

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

doc_materizalization_min_rows?

@SerializedName(value = "variantDocSnapshotMinRows")
private final long variantDocSnapshotMinRows;

@SerializedName(value = "variantDocSnapshotShardCount")
Copy link
Member

Choose a reason for hiding this comment

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

doc_hash_shard_count?

@csun5285
Copy link
Contributor Author

run p0 10

@csun5285
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.52% (1771/2227)
Line Coverage 64.83% (31311/48299)
Region Coverage 65.37% (15579/23831)
Branch Coverage 55.98% (8283/14796)

@csun5285
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.52% (1771/2227)
Line Coverage 64.85% (31320/48299)
Region Coverage 65.43% (15593/23831)
Branch Coverage 56.01% (8287/14796)

@csun5285
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.52% (1771/2227)
Line Coverage 64.81% (31303/48299)
Region Coverage 65.38% (15580/23831)
Branch Coverage 55.95% (8278/14796)

@csun5285
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.52% (1771/2227)
Line Coverage 64.80% (31300/48299)
Region Coverage 65.39% (15582/23831)
Branch Coverage 55.98% (8283/14796)

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17656	4254	4091	4091
q2	2049	366	256	256
q3	10126	1306	736	736
q4	10224	848	319	319
q5	8213	2156	2017	2017
q6	211	172	135	135
q7	1019	873	730	730
q8	9359	1390	1236	1236
q9	7355	5317	5408	5317
q10	6891	2389	1987	1987
q11	565	336	307	307
q12	707	769	562	562
q13	17790	3728	3017	3017
q14	287	299	270	270
q15	598	530	530	530
q16	730	703	645	645
q17	700	788	618	618
q18	7573	7759	7852	7759
q19	1142	1071	675	675
q20	418	366	262	262
q21	4713	4165	4283	4165
q22	1127	1084	1004	1004
Total cold run time: 109453 ms
Total hot run time: 36638 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4498	4344	4302	4302
q2	350	400	331	331
q3	2679	2780	2447	2447
q4	1392	1924	1435	1435
q5	4646	4340	4547	4340
q6	222	163	121	121
q7	2030	2045	1816	1816
q8	2920	2580	2549	2549
q9	7560	7473	7477	7473
q10	3018	3073	2656	2656
q11	597	523	492	492
q12	634	712	603	603
q13	3254	3665	2995	2995
q14	275	284	261	261
q15	535	500	486	486
q16	618	656	614	614
q17	1150	1387	1400	1387
q18	7494	7198	7098	7098
q19	851	810	874	810
q20	1915	1959	1813	1813
q21	4628	4250	4153	4153
q22	1080	1012	954	954
Total cold run time: 52346 ms
Total hot run time: 49136 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 179402 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 3e56c7a49fe2658693c7c7db7a83cb58b6be61cf, data reload: false

query5	4645	610	473	473
query6	353	245	228	228
query7	4246	471	275	275
query8	322	254	248	248
query9	8807	2593	2533	2533
query10	494	401	330	330
query11	15664	14858	14778	14778
query12	177	120	123	120
query13	1280	512	407	407
query14	6070	3046	2807	2807
query14_1	2682	2684	2692	2684
query15	218	202	176	176
query16	860	493	432	432
query17	1138	719	603	603
query18	2443	446	359	359
query19	237	240	212	212
query20	128	118	114	114
query21	232	140	120	120
query22	3933	3952	3980	3952
query23	16616	16119	15771	15771
query23_1	16031	15991	16208	15991
query24	7383	1671	1245	1245
query24_1	1240	1238	1249	1238
query25	611	502	446	446
query26	1251	277	167	167
query27	2756	471	316	316
query28	4498	2152	2131	2131
query29	845	585	485	485
query30	324	241	216	216
query31	825	713	634	634
query32	89	74	76	74
query33	552	349	306	306
query34	909	890	558	558
query35	832	782	713	713
query36	863	907	835	835
query37	131	91	77	77
query38	3002	3069	2982	2982
query39	777	742	708	708
query39_1	701	708	679	679
query40	231	136	118	118
query41	67	62	60	60
query42	109	109	110	109
query43	415	449	403	403
query44	1325	743	739	739
query45	192	185	181	181
query46	884	971	616	616
query47	1667	1699	1627	1627
query48	312	318	253	253
query49	616	430	339	339
query50	659	287	216	216
query51	3804	3843	3757	3757
query52	114	109	104	104
query53	316	350	292	292
query54	283	255	250	250
query55	80	76	71	71
query56	294	319	343	319
query57	1175	1141	1110	1110
query58	281	259	256	256
query59	2442	2528	2440	2440
query60	317	309	300	300
query61	157	156	154	154
query62	713	698	670	670
query63	332	295	298	295
query64	5033	1296	1033	1033
query65	4009	3920	4035	3920
query66	1463	462	318	318
query67	15192	14993	14994	14993
query68	8350	991	715	715
query69	499	351	306	306
query70	1082	952	967	952
query71	374	314	290	290
query72	6141	4823	4801	4801
query73	655	559	310	310
query74	8729	8995	8671	8671
query75	3223	3236	2802	2802
query76	3984	1157	746	746
query77	585	383	283	283
query78	9399	9554	8950	8950
query79	1623	837	623	623
query80	694	644	563	563
query81	535	266	237	237
query82	316	127	104	104
query83	252	258	239	239
query84	257	124	103	103
query85	953	518	488	488
query86	378	310	291	291
query87	3115	3294	3060	3060
query88	4360	2298	2329	2298
query89	475	431	400	400
query90	2135	164	159	159
query91	171	166	140	140
query92	83	81	66	66
query93	1684	893	559	559
query94	473	294	282	282
query95	565	380	302	302
query96	598	474	210	210
query97	2289	2290	2241	2241
query98	216	204	195	195
query99	1370	1369	1311	1311
Total cold run time: 262382 ms
Total hot run time: 179402 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.14	0.07	0.06
query3	0.33	0.08	0.08
query4	1.61	0.11	0.11
query5	0.27	0.24	0.24
query6	1.19	0.64	0.64
query7	0.03	0.03	0.03
query8	0.08	0.06	0.06
query9	0.58	0.52	0.50
query10	0.56	0.57	0.56
query11	0.27	0.14	0.13
query12	0.26	0.14	0.15
query13	0.63	0.62	0.61
query14	1.01	0.99	1.00
query15	0.88	0.81	0.81
query16	0.40	0.39	0.40
query17	0.97	1.05	1.03
query18	0.23	0.21	0.22
query19	1.92	1.88	1.87
query20	0.01	0.01	0.02
query21	15.41	0.28	0.24
query22	4.98	0.10	0.10
query23	15.41	0.39	0.22
query24	2.44	0.50	0.30
query25	0.09	0.10	0.09
query26	0.18	0.17	0.17
query27	0.10	0.09	0.09
query28	3.88	1.35	1.16
query29	12.59	4.09	3.31
query30	0.33	0.12	0.10
query31	2.81	0.65	0.42
query32	3.23	0.61	0.49
query33	2.97	3.05	3.02
query34	16.75	5.19	4.65
query35	4.64	4.64	4.69
query36	0.62	0.49	0.49
query37	0.23	0.09	0.09
query38	0.20	0.06	0.05
query39	0.07	0.05	0.05
query40	0.20	0.17	0.17
query41	0.12	0.07	0.06
query42	0.08	0.06	0.05
query43	0.06	0.06	0.05
Total cold run time: 98.82 s
Total hot run time: 28.53 s

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

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants