[refactor](predicate) Refine column predicates on OLAP table #58582

Gabriel39 · 2025-12-01T12:49:29Z

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

Thearas · 2025-12-01T12:49:44Z

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:

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

Gabriel39 · 2025-12-02T09:40:37Z

run buildall

Gabriel39 · 2025-12-03T03:13:44Z

run buildall

doris-robot · 2025-12-03T04:08:31Z

TPC-H: Total hot run time: 35134 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 788252664385e08d4ab090e46a90fbe2481f236b, data reload: false

------ Round 1 ----------------------------------
q1	17613	5076	4861	4861
q2	2068	354	235	235
q3	10180	1323	726	726
q4	10208	880	317	317
q5	7510	2083	1958	1958
q6	194	173	136	136
q7	1001	841	716	716
q8	9359	1418	1138	1138
q9	6994	5327	5355	5327
q10	6844	2368	2005	2005
q11	513	318	295	295
q12	646	725	577	577
q13	17789	3672	2990	2990
q14	293	307	281	281
q15	583	515	517	515
q16	225	230	186	186
q17	695	822	527	527
q18	7466	7178	6974	6974
q19	1108	955	604	604
q20	384	379	247	247
q21	4202	4057	3580	3580
q22	1036	1027	939	939
Total cold run time: 106911 ms
Total hot run time: 35134 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4932	4861	4920	4861
q2	327	388	320	320
q3	2165	2659	2311	2311
q4	1389	1751	1320	1320
q5	4206	4547	4622	4547
q6	224	175	139	139
q7	2060	1940	1877	1877
q8	2706	2575	2506	2506
q9	7597	7556	7550	7550
q10	3034	3259	2885	2885
q11	578	506	496	496
q12	714	765	591	591
q13	3547	3983	3267	3267
q14	271	311	298	298
q15	562	501	506	501
q16	174	240	178	178
q17	1209	1421	1457	1421
q18	7925	7557	7606	7557
q19	873	812	847	812
q20	1940	1948	1816	1816
q21	4593	4282	4090	4090
q22	1101	1031	1005	1005
Total cold run time: 52127 ms
Total hot run time: 50348 ms

Gabriel39 · 2025-12-03T07:42:31Z

run buildall

yiguolei · 2025-12-03T09:03:37Z

be/src/olap/delete_handler.h

 struct DeleteConditions {
    int64_t filter_version = 0; // The version of this condition
-    std::vector<const ColumnPredicate*> column_predicate_vec;
+    std::vector<std::shared_ptr<ColumnPredicate>> column_predicate_vec;


这里为什么不是const的了？

std::vector must have a non-const, non-volatile value_type

std::vector<std::shared_ptr> 我们应该是这个结构，感觉是可以的吧？

Gabriel39 · 2025-12-03T09:15:32Z

run buildall

be/src/runtime/runtime_predicate.h

doris-robot · 2025-12-03T10:26:41Z

TPC-H: Total hot run time: 35912 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ffdd5f4333ab6d897e139062c65a925348669b3f, data reload: false

------ Round 1 ----------------------------------
q1	8472	4933	4940	4933
q2	2039	355	241	241
q3	10193	1335	769	769
q4	6480	862	333	333
q5	1970	1985	1917	1917
q6	204	176	136	136
q7	991	864	717	717
q8	1501	1472	1329	1329
q9	7122	5302	5338	5302
q10	6883	2397	1972	1972
q11	514	326	296	296
q12	630	715	590	590
q13	17006	3681	3067	3067
q14	302	292	272	272
q15	591	509	504	504
q16	231	212	184	184
q17	696	810	566	566
q18	7524	7085	7074	7074
q19	644	969	620	620
q20	438	382	257	257
q21	4311	3964	3885	3885
q22	1056	1001	948	948
Total cold run time: 79798 ms
Total hot run time: 35912 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4996	4996	4943	4943
q2	342	416	324	324
q3	2152	2706	2345	2345
q4	1334	1769	1292	1292
q5	4317	4179	4176	4176
q6	216	168	129	129
q7	1937	1821	1686	1686
q8	2569	2432	2355	2355
q9	7029	6999	7036	6999
q10	2920	3108	2686	2686
q11	604	504	494	494
q12	669	714	563	563
q13	3267	3655	3062	3062
q14	267	286	275	275
q15	547	521	521	521
q16	185	217	179	179
q17	1124	1356	1383	1356
q18	7172	7148	6967	6967
q19	853	866	845	845
q20	1893	1977	1819	1819
q21	4649	4271	4238	4238
q22	1152	1041	985	985
Total cold run time: 50194 ms
Total hot run time: 48239 ms

be/src/olap/accept_null_predicate.h

be/src/olap/block_column_predicate.h

be/src/olap/column_predicate.h

be/src/olap/in_list_predicate.h

be/src/olap/predicate_creator.cpp

Gabriel39 · 2025-12-04T04:02:14Z

run buildall

doris-robot · 2025-12-04T05:35:35Z

TPC-H: Total hot run time: 36922 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a5a6686514d903dec00b07347b1d92b8ad1935fb, data reload: false

------ Round 1 ----------------------------------
q1	17721	5121	4930	4930
q2	2066	347	241	241
q3	10174	1337	750	750
q4	10207	850	328	328
q5	7537	2144	1957	1957
q6	189	181	141	141
q7	1016	870	736	736
q8	9357	1475	1232	1232
q9	7089	5332	5448	5332
q10	6859	2390	1996	1996
q11	536	334	308	308
q12	710	752	580	580
q13	17810	3735	3028	3028
q14	307	310	280	280
q15	599	533	529	529
q16	228	238	186	186
q17	714	819	570	570
q18	7562	7614	7799	7614
q19	1230	993	649	649
q20	403	378	260	260
q21	4595	4269	4248	4248
q22	1134	1105	1027	1027
Total cold run time: 108043 ms
Total hot run time: 36922 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5252	5195	5143	5143
q2	372	396	327	327
q3	2408	3030	2426	2426
q4	1417	1778	1405	1405
q5	4650	4479	4507	4479
q6	233	171	130	130
q7	2029	1974	1847	1847
q8	2815	2611	2598	2598
q9	7461	7354	6990	6990
q10	2916	3099	2664	2664
q11	595	505	487	487
q12	633	701	525	525
q13	3289	3656	3037	3037
q14	269	305	268	268
q15	532	505	503	503
q16	170	217	172	172
q17	1149	1499	1389	1389
q18	7352	7140	6967	6967
q19	853	804	836	804
q20	1897	2016	1822	1822
q21	4739	4245	4177	4177
q22	1133	1041	1008	1008
Total cold run time: 52164 ms
Total hot run time: 49168 ms

doris-robot · 2025-12-04T05:46:13Z

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

query5	5031	648	482	482
query6	342	249	239	239
query7	98	87	92	87
query8	333	263	241	241
query9	9517	2622	2629	2622
query10	691	417	361	361
query11	15199	15508	14539	14539
query12	104	63	64	63
query13	3694	628	474	474
query14	6691	3355	3152	3152
query14_1	3101	3060	3015	3015
query15	216	202	187	187
query16	7471	722	549	549
query17	1286	755	619	619
query18	199	192	181	181
query19	251	286	230	230
query20	53	56	54	54
query21	217	137	116	116
query22	3965	3970	3827	3827
query23	16668	16231	15835	15835
query23_1	15903	16062	15926	15926
query24	6924	1661	1293	1293
query24_1	1276	1245	1250	1245
query25	641	552	484	484
query26	70	66	78	66
query27	76	72	70	70
query28	7128	2169	2155	2155
query29	957	645	521	521
query30	313	248	218	218
query31	859	727	626	626
query32	89	80	73	73
query33	176	247	319	247
query34	195	122	124	122
query35	795	883	721	721
query36	891	977	842	842
query37	167	112	91	91
query38	3872	3904	3854	3854
query39	744	747	737	737
query39_1	706	694	699	694
query40	230	133	123	123
query41	57	52	49	49
query42	132	123	117	117
query43	461	493	439	439
query44	1361	778	759	759
query45	195	192	184	184
query46	965	1024	682	682
query47	1660	1746	1616	1616
query48	76	75	75	75
query49	795	506	418	418
query50	626	592	398	398
query51	3921	3882	3873	3873
query52	125	126	116	116
query53	57	59	56	56
query54	154	143	137	137
query55	107	94	89	89
query56	156	146	159	146
query57	1184	1164	1089	1089
query58	283	275	270	270
query59	2290	2509	2282	2282
query60	154	158	151	151
query61	161	154	164	154
query62	771	722	650	650
query63	59	55	59	55
query64	769	755	634	634
query65	4062	4006	3951	3951
query66	152	147	145	145
query67	15126	14992	14790	14790
query68	4668	1006	747	747
query69	580	401	361	361
query70	1158	1033	1055	1033
query71	94	87	80	80
query72	1041	1058	969	969
query73	53	62	58	58
query74	8778	8646	8604	8604
query75	211	207	206	206
query76	6814	1221	820	820
query77	549	413	306	306
query78	9387	9505	8772	8772
query79	1036	886	616	616
query80	752	694	601	601
query81	476	268	242	242
query82	201	142	111	111
query83	254	255	238	238
query84	255	117	98	98
query85	810	478	438	438
query86	317	285	280	280
query87	3929	4063	4002	4002
query88	3179	2542	2495	2495
query89	58	58	57	57
query90	2049	224	220	220
query91	102	94	94	94
query92	69	68	64	64
query93	41	40	42	40
query94	120	129	120	120
query95	125	131	137	131
query96	773	1224	1193	1193
query97	3902	2703	2580	2580
query98	43	45	47	45
query99	1269	1372	1260	1260
Total cold run time: 245921 ms
Total hot run time: 171944 ms

Gabriel39 · 2025-12-04T08:52:21Z

run buildall

doris-robot · 2025-12-04T10:44:35Z

TPC-DS: Total hot run time: 171095 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 6cd5fd5fd5e62b2ac6d26b7c635d5e41e42f8260, data reload: false

query5	5414	644	464	464
query6	351	236	214	214
query7	97	89	91	89
query8	331	278	251	251
query9	9502	2612	2649	2612
query10	728	385	330	330
query11	15450	15139	14762	14762
query12	94	56	66	56
query13	3695	526	371	371
query14	6972	3232	2985	2985
query14_1	2909	2902	2913	2902
query15	218	197	183	183
query16	7670	478	443	443
query17	1290	718	600	600
query18	201	193	212	193
query19	232	219	193	193
query20	55	57	54	54
query21	226	134	113	113
query22	3989	3909	3843	3843
query23	16937	16471	16335	16335
query23_1	16583	16431	16457	16431
query24	7679	1621	1248	1248
query24_1	1282	1267	1268	1267
query25	654	522	485	485
query26	61	91	68	68
query27	88	66	73	66
query28	7370	2203	2197	2197
query29	914	596	504	504
query30	347	258	219	219
query31	855	747	649	649
query32	90	69	71	69
query33	164	226	287	226
query34	187	113	116	113
query35	873	880	766	766
query36	944	960	866	866
query37	197	84	76	76
query38	4202	4202	4023	4023
query39	796	800	790	790
query39_1	734	725	784	725
query40	234	129	119	119
query41	49	47	45	45
query42	121	101	99	99
query43	462	432	397	397
query44	1308	744	753	744
query45	193	186	180	180
query46	982	981	615	615
query47	1677	1692	1618	1618
query48	76	78	72	72
query49	781	417	335	335
query50	605	263	217	217
query51	3917	3846	3844	3844
query52	122	110	100	100
query53	55	58	54	54
query54	148	149	136	136
query55	93	74	71	71
query56	148	138	150	138
query57	1177	1112	1074	1074
query58	294	252	273	252
query59	2378	2463	2410	2410
query60	152	158	152	152
query61	157	158	155	155
query62	768	685	631	631
query63	54	53	57	53
query64	927	824	818	818
query65	3994	3946	3960	3946
query66	162	174	152	152
query67	14979	14750	14709	14709
query68	3273	1012	786	786
query69	542	360	322	322
query70	1076	987	1011	987
query71	94	87	91	87
query72	1076	975	943	943
query73	49	57	58	57
query74	8488	8874	8539	8539
query75	222	199	197	197
query76	4675	1189	811	811
query77	449	384	294	294
query78	9289	9557	8820	8820
query79	1034	860	628	628
query80	751	633	561	561
query81	478	266	238	238
query82	211	131	101	101
query83	252	255	239	239
query84	266	113	95	95
query85	823	455	411	411
query86	313	296	295	295
query87	4040	4020	3907	3907
query88	3189	2322	2270	2270
query89	62	60	56	56
query90	2117	161	155	155
query91	98	93	92	92
query92	74	66	64	64
query93	43	50	44	44
query94	117	115	122	115
query95	129	130	479	130
query96	4082	2947	443	443
query97	2585	2706	2577	2577
query98	41	52	41	41
query99	1374	1288	1196	1196
Total cold run time: 248072 ms
Total hot run time: 171095 ms

doris-robot · 2025-12-04T10:49:39Z

ClickBench: Total hot run time: 27.71 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6cd5fd5fd5e62b2ac6d26b7c635d5e41e42f8260, data reload: false

query1	0.05	0.04	0.05
query2	0.10	0.06	0.05
query3	0.26	0.09	0.09
query4	1.63	0.12	0.11
query5	0.28	0.27	0.25
query6	1.18	0.68	0.66
query7	0.03	0.03	0.03
query8	0.05	0.04	0.05
query9	0.58	0.52	0.50
query10	0.56	0.55	0.55
query11	0.17	0.12	0.11
query12	0.16	0.12	0.13
query13	0.65	0.62	0.62
query14	1.02	0.98	1.00
query15	0.84	0.82	0.83
query16	0.40	0.40	0.40
query17	1.00	1.09	1.03
query18	0.24	0.22	0.21
query19	1.84	1.88	1.90
query20	0.01	0.01	0.01
query21	15.55	0.28	0.14
query22	4.82	0.05	0.05
query23	15.97	0.29	0.10
query24	1.26	0.26	0.17
query25	0.10	0.06	0.06
query26	0.14	0.13	0.14
query27	0.08	0.06	0.06
query28	3.30	1.30	1.04
query29	12.58	4.09	3.38
query30	0.28	0.14	0.12
query31	2.82	0.63	0.41
query32	3.25	0.58	0.48
query33	3.07	3.00	3.10
query34	16.89	5.34	4.62
query35	4.57	4.60	4.66
query36	0.67	0.51	0.50
query37	0.11	0.06	0.06
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.17	0.14	0.14
query41	0.09	0.04	0.03
query42	0.04	0.03	0.02
query43	0.04	0.03	0.04
Total cold run time: 96.97 s
Total hot run time: 27.71 s

doris-robot · 2025-12-08T04:02:09Z

ClickBench: Total hot run time: 27.3 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 39a904f73e5fea93c0210c33104dd357e055d131, data reload: false

query1	0.05	0.04	0.04
query2	0.09	0.05	0.05
query3	0.25	0.08	0.09
query4	1.61	0.12	0.11
query5	0.27	0.26	0.24
query6	1.18	0.64	0.62
query7	0.03	0.02	0.03
query8	0.06	0.05	0.04
query9	0.57	0.50	0.50
query10	0.55	0.56	0.54
query11	0.15	0.10	0.10
query12	0.15	0.11	0.11
query13	0.63	0.60	0.60
query14	0.99	1.00	0.98
query15	0.83	0.80	0.80
query16	0.40	0.39	0.40
query17	1.05	0.98	1.01
query18	0.24	0.22	0.21
query19	1.88	1.80	1.76
query20	0.01	0.01	0.01
query21	15.46	0.30	0.14
query22	4.73	0.05	0.05
query23	16.11	0.28	0.10
query24	1.93	0.64	0.53
query25	0.07	0.04	0.08
query26	0.14	0.13	0.12
query27	0.08	0.04	0.04
query28	4.45	1.20	1.01
query29	12.69	3.99	3.17
query30	0.29	0.13	0.13
query31	2.82	0.64	0.40
query32	3.23	0.55	0.45
query33	3.09	3.12	3.09
query34	16.59	5.27	4.48
query35	4.58	4.61	4.56
query36	0.65	0.51	0.48
query37	0.11	0.06	0.07
query38	0.08	0.04	0.04
query39	0.04	0.03	0.03
query40	0.16	0.14	0.13
query41	0.09	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 98.46 s
Total hot run time: 27.3 s

Gabriel39 · 2025-12-08T04:32:46Z

run buildall

doris-robot · 2025-12-08T04:52:40Z

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

query5	
query6	
query7	
query8	
query9	
query10	
query11	
query12	
query13	
query14	
query14_1	
query15	
query16	
query17	
query18	
query19	
query20	
query21	
query22	
query23	
query23_1	
query24	
query24_1	
query25	
query26	
query27	
query28	
query29	
query30	
query31	
query32	
query33	
query34	
query35	
query36	
query37	
query38	
query39	
query39_1	
query40	
query41	
query42	
query43	
query44	
query45	
query46	
query47	
query48	
query49	
query50	
query51	
query52	
query53	
query54	
query55	
query56	
query57	
query58	
query59	
query60	
query61	
query62	
query63	
query64	
query65	
query66	
query67	
query68	
query69	
query70	
query71	
query72	
query73	
query74	
query75	
query76	
query77	
query78	
query79	
query80	
query81	
query82	
query83	
query84	
query85	
query86	
query87	
query88	
query89	
query90	
query91	
query92	
query93	
query94	
query95	
query96	
query97	
query98	
query99	
Total cold run time: 0 ms
Total hot run time: 0 ms

Gabriel39 · 2025-12-08T07:00:07Z

run buildall

github-actions · 2025-12-08T07:14:27Z

PR approved by at least one committer and no changes requested.

github-actions · 2025-12-08T07:14:29Z

PR approved by anyone and no changes requested.

doris-robot · 2025-12-08T07:53:20Z

TPC-H: Total hot run time: 36232 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ebb0eee04362de0fbc165f58b0548de19febbd69, data reload: false

------ Round 1 ----------------------------------
q1	17631	5082	4942	4942
q2	2061	359	238	238
q3	10131	1313	753	753
q4	10212	836	324	324
q5	7529	2356	1972	1972
q6	189	175	138	138
q7	1009	858	720	720
q8	9348	1536	1147	1147
q9	7094	5356	5345	5345
q10	6794	2404	1976	1976
q11	521	318	292	292
q12	654	756	603	603
q13	17783	3705	3036	3036
q14	279	295	269	269
q15	610	524	507	507
q16	935	941	896	896
q17	725	851	469	469
q18	7709	7169	7004	7004
q19	1080	958	629	629
q20	402	391	266	266
q21	4265	3893	3745	3745
q22	1052	997	961	961
Total cold run time: 108013 ms
Total hot run time: 36232 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5001	5006	4953	4953
q2	331	398	325	325
q3	2131	2726	2264	2264
q4	1334	1743	1308	1308
q5	5072	4646	4551	4551
q6	222	173	131	131
q7	2034	1959	1859	1859
q8	2723	2588	2657	2588
q9	7594	7595	7496	7496
q10	3107	3264	2886	2886
q11	686	525	500	500
q12	663	750	584	584
q13	3471	3851	3337	3337
q14	287	302	291	291
q15	573	524	512	512
q16	920	972	899	899
q17	1259	1417	1428	1417
q18	8105	7663	7669	7663
q19	942	868	911	868
q20	1987	2137	1951	1951
q21	4912	4468	4072	4072
q22	1090	1028	982	982
Total cold run time: 54444 ms
Total hot run time: 51437 ms

doris-robot · 2025-12-08T08:04:41Z

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

query5	5174	635	499	499
query6	350	245	223	223
query7	4651	474	289	289
query8	339	260	253	253
query9	8752	2635	2645	2635
query10	644	397	352	352
query11	15345	14958	14521	14521
query12	197	119	115	115
query13	1711	497	406	406
query14	6708	3285	3079	3079
query14_1	2887	2910	2930	2910
query15	213	197	181	181
query16	7660	469	434	434
query17	1451	681	557	557
query18	2008	416	331	331
query19	244	230	210	210
query20	122	114	112	112
query21	215	148	110	110
query22	3876	3892	3842	3842
query23	16621	16137	15887	15887
query23_1	16162	15937	16099	15937
query24	7064	1617	1259	1259
query24_1	1227	1212	1185	1185
query25	630	458	419	419
query26	1263	272	167	167
query27	2898	467	306	306
query28	4402	2169	2155	2155
query29	805	554	437	437
query30	322	246	215	215
query31	817	688	601	601
query32	81	67	67	67
query33	663	333	283	283
query34	876	865	550	550
query35	797	816	726	726
query36	904	892	821	821
query37	127	97	75	75
query38	3860	3853	3737	3737
query39	758	746	720	720
query39_1	718	703	695	695
query40	232	134	123	123
query41	67	66	64	64
query42	137	108	101	101
query43	456	444	405	405
query44	1339	766	753	753
query45	192	189	182	182
query46	919	971	609	609
query47	1709	1714	1620	1620
query48	432	317	242	242
query49	787	430	354	354
query50	655	282	220	220
query51	3969	3911	3827	3827
query52	118	105	98	98
query53	335	344	300	300
query54	337	264	272	264
query55	92	74	72	72
query56	340	285	321	285
query57	1134	1123	1102	1102
query58	287	247	251	247
query59	2337	2409	2395	2395
query60	357	309	289	289
query61	161	159	160	159
query62	800	666	618	618
query63	342	295	302	295
query64	4614	1348	1107	1107
query65	4048	3941	3982	3941
query66	1173	445	346	346
query67	15269	15141	14809	14809
query68	5538	1041	759	759
query69	581	360	323	323
query70	1138	1031	996	996
query71	462	311	307	307
query72	6188	4949	4901	4901
query73	691	562	308	308
query74	8766	8804	8663	8663
query75	3576	3511	3168	3168
query76	3304	1132	732	732
query77	513	371	291	291
query78	9599	9804	8861	8861
query79	1780	878	612	612
query80	974	661	556	556
query81	521	272	239	239
query82	447	127	105	105
query83	269	259	235	235
query84	268	120	103	103
query85	948	492	456	456
query86	417	281	298	281
query87	4017	4070	3933	3933
query88	3267	2274	2293	2274
query89	482	444	382	382
query90	2012	157	149	149
query91	171	163	144	144
query92	81	63	65	63
query93	1650	906	569	569
query94	832	306	265	265
query95	567	361	327	327
query96	595	470	210	210
query97	2610	2697	2605	2605
query98	231	192	189	189
query99	1308	1340	1223	1223
Total cold run time: 269847 ms
Total hot run time: 180953 ms

doris-robot · 2025-12-08T08:09:44Z

ClickBench: Total hot run time: 27.21 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit ebb0eee04362de0fbc165f58b0548de19febbd69, data reload: false

query1	0.06	0.04	0.05
query2	0.10	0.05	0.05
query3	0.26	0.08	0.08
query4	1.61	0.11	0.11
query5	0.27	0.24	0.26
query6	1.17	0.64	0.62
query7	0.04	0.03	0.02
query8	0.06	0.04	0.04
query9	0.57	0.50	0.50
query10	0.56	0.56	0.55
query11	0.16	0.11	0.11
query12	0.14	0.12	0.11
query13	0.63	0.61	0.59
query14	0.99	0.98	0.99
query15	0.80	0.78	0.80
query16	0.40	0.40	0.39
query17	1.03	1.06	1.02
query18	0.23	0.22	0.21
query19	1.96	1.86	1.79
query20	0.02	0.02	0.01
query21	15.46	0.28	0.14
query22	4.98	0.05	0.04
query23	16.00	0.28	0.10
query24	1.38	0.72	0.28
query25	0.09	0.06	0.06
query26	0.14	0.13	0.13
query27	0.07	0.06	0.05
query28	3.59	1.23	1.03
query29	12.56	3.99	3.20
query30	0.28	0.14	0.14
query31	2.82	0.62	0.39
query32	3.25	0.56	0.47
query33	3.08	3.04	3.13
query34	16.91	5.12	4.52
query35	4.56	4.54	4.54
query36	0.64	0.50	0.48
query37	0.11	0.07	0.06
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.16	0.14	0.14
query41	0.09	0.04	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 97.43 s
Total hot run time: 27.21 s

Gabriel39 · 2025-12-08T08:58:20Z

run buildall

doris-robot · 2025-12-08T10:05:42Z

TPC-H: Total hot run time: 36329 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 004a3842fed9826cf2a75dcc6147586d25c365e0, data reload: false

------ Round 1 ----------------------------------
q1	17611	5130	4951	4951
q2	2060	357	237	237
q3	10175	1348	772	772
q4	10227	843	331	331
q5	7517	2150	1941	1941
q6	182	169	135	135
q7	1004	852	718	718
q8	9348	1393	1136	1136
q9	7157	5343	5287	5287
q10	6854	2382	1996	1996
q11	526	316	294	294
q12	654	728	577	577
q13	17787	3671	3061	3061
q14	289	293	274	274
q15	594	524	501	501
q16	931	906	861	861
q17	735	816	535	535
q18	7842	7043	7073	7043
q19	1101	974	606	606
q20	412	381	261	261
q21	4243	4015	3835	3835
q22	1075	1014	977	977
Total cold run time: 108324 ms
Total hot run time: 36329 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4989	4903	4958	4903
q2	335	406	328	328
q3	2141	2727	2293	2293
q4	1336	1735	1315	1315
q5	4904	4758	4434	4434
q6	219	170	135	135
q7	2034	1915	1865	1865
q8	2673	2594	2517	2517
q9	7649	7574	7568	7568
q10	3032	3234	3010	3010
q11	602	519	510	510
q12	657	794	584	584
q13	3579	4127	3246	3246
q14	271	284	281	281
q15	557	581	534	534
q16	925	943	889	889
q17	1227	1484	1375	1375
q18	8147	7614	7528	7528
q19	870	824	843	824
q20	1875	1951	1816	1816
q21	4561	4192	4124	4124
q22	1080	1040	978	978
Total cold run time: 53663 ms
Total hot run time: 51057 ms

doris-robot · 2025-12-08T10:16:59Z

TPC-DS: Total hot run time: 181928 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 004a3842fed9826cf2a75dcc6147586d25c365e0, data reload: false

query5	4825	644	474	474
query6	333	257	224	224
query7	4658	472	275	275
query8	329	254	253	253
query9	8760	2635	2627	2627
query10	597	404	336	336
query11	15707	14825	15129	14825
query12	192	121	120	120
query13	1711	514	412	412
query14	6391	3343	3052	3052
query14_1	2908	2898	2945	2898
query15	226	196	178	178
query16	7628	463	452	452
query17	1196	672	562	562
query18	1996	415	345	345
query19	255	225	200	200
query20	124	117	115	115
query21	228	136	113	113
query22	4023	3969	3920	3920
query23	16620	16031	16024	16024
query23_1	16091	16136	16021	16021
query24	7197	1629	1230	1230
query24_1	1222	1207	1251	1207
query25	582	460	417	417
query26	1269	268	160	160
query27	2901	458	309	309
query28	4420	2172	2155	2155
query29	812	571	445	445
query30	317	244	216	216
query31	829	684	624	624
query32	81	69	70	69
query33	667	341	286	286
query34	856	894	545	545
query35	798	816	744	744
query36	910	917	838	838
query37	126	87	77	77
query38	3911	3891	3768	3768
query39	744	743	725	725
query39_1	693	722	711	711
query40	234	132	126	126
query41	67	64	62	62
query42	126	108	106	106
query43	457	436	406	406
query44	1313	765	760	760
query45	199	189	183	183
query46	933	973	613	613
query47	1682	1687	1657	1657
query48	421	341	256	256
query49	769	426	350	350
query50	661	296	229	229
query51	3862	3875	3930	3875
query52	123	111	109	109
query53	334	347	302	302
query54	337	272	248	248
query55	91	74	74	74
query56	354	305	295	295
query57	1158	1135	1086	1086
query58	298	254	254	254
query59	2282	2455	2438	2438
query60	370	307	315	307
query61	158	157	160	157
query62	815	684	627	627
query63	350	293	298	293
query64	4475	1273	1009	1009
query65	4047	4015	3952	3952
query66	1186	429	337	337
query67	15023	14936	14844	14844
query68	2788	1043	771	771
query69	504	346	304	304
query70	1086	1017	983	983
query71	394	308	289	289
query72	6071	5019	4998	4998
query73	534	553	308	308
query74	8536	8722	8667	8667
query75	3501	3578	3195	3195
query76	2379	1144	761	761
query77	381	401	309	309
query78	9644	10064	8795	8795
query79	1045	879	633	633
query80	1322	671	558	558
query81	529	272	243	243
query82	218	126	112	112
query83	363	252	236	236
query84	264	120	99	99
query85	1006	515	483	483
query86	382	317	287	287
query87	4146	4110	3914	3914
query88	3171	2277	2282	2277
query89	478	427	389	389
query90	1909	175	154	154
query91	172	165	146	146
query92	73	70	64	64
query93	967	934	560	560
query94	745	303	276	276
query95	554	371	321	321
query96	594	451	205	205
query97	2600	2659	2570	2570
query98	228	194	190	190
query99	1331	1312	1190	1190
Total cold run time: 263443 ms
Total hot run time: 181928 ms

doris-robot · 2025-12-08T10:22:01Z

ClickBench: Total hot run time: 27.3 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 004a3842fed9826cf2a75dcc6147586d25c365e0, data reload: false

query1	0.05	0.04	0.05
query2	0.10	0.05	0.05
query3	0.26	0.08	0.08
query4	1.61	0.11	0.10
query5	0.28	0.26	0.26
query6	1.19	0.65	0.62
query7	0.04	0.02	0.03
query8	0.06	0.05	0.05
query9	0.57	0.50	0.51
query10	0.55	0.56	0.55
query11	0.16	0.11	0.11
query12	0.16	0.12	0.12
query13	0.63	0.61	0.61
query14	0.98	0.99	0.98
query15	0.83	0.80	0.81
query16	0.42	0.38	0.41
query17	1.02	1.04	0.96
query18	0.23	0.21	0.20
query19	1.93	1.83	1.78
query20	0.02	0.01	0.01
query21	15.48	0.27	0.13
query22	4.89	0.05	0.04
query23	16.08	0.29	0.10
query24	0.99	0.35	0.38
query25	0.08	0.08	0.07
query26	0.14	0.12	0.13
query27	0.07	0.05	0.05
query28	3.49	1.24	1.02
query29	12.57	4.07	3.31
query30	0.28	0.14	0.12
query31	2.83	0.63	0.38
query32	3.23	0.56	0.46
query33	3.00	3.05	3.05
query34	16.88	5.17	4.55
query35	4.55	4.49	4.59
query36	0.68	0.51	0.50
query37	0.11	0.07	0.07
query38	0.08	0.04	0.04
query39	0.04	0.02	0.03
query40	0.17	0.14	0.13
query41	0.09	0.03	0.02
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 96.9 s
Total hot run time: 27.3 s

hello-stephen · 2025-12-08T10:56:01Z

BE UT Coverage Report

Increment line coverage 27.29% (238/872) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.24% (18627/34984)
Line Coverage	38.94% (171918/441510)
Region Coverage	33.59% (133143/396329)
Branch Coverage	34.54% (57295/165863)

shuke987 · 2025-12-09T01:38:13Z

skip buildall

jacktengg · 2025-12-10T02:08:51Z

be/src/olap/predicate_creator.cpp

+        return BloomFilterColumnPredicate<TYPE_IPV6>::create_shared(cid, filter_olap);
+    }
+    default:
+        return nullptr;


Should also throw Exception here?

…58582)

Gabriel39 requested a review from zclllyybb as a code owner December 1, 2025 12:49

Gabriel39 force-pushed the dev_1201 branch 2 times, most recently from f89b74e to db045ad Compare December 2, 2025 09:39

Gabriel39 changed the title ~~[refactor](WIP)~~ [refactor](predicate) Refine column predicates on OLAP table Dec 3, 2025

Gabriel39 force-pushed the dev_1201 branch from f34c92f to da1b538 Compare December 3, 2025 07:40

yiguolei reviewed Dec 3, 2025

View reviewed changes

be/src/runtime/runtime_predicate.h Show resolved Hide resolved