Skip to content

[fix](index) Enforce SNII compatibility corpus and simplify comments - #68607

Merged
airborne12 merged 6 commits into
apache:masterfrom
airborne12:snii-master-review-cleanup-20260929
Oct 26, 2026
Merged

airborne12 merged 6 commits into
apache:masterfrom
airborne12:snii-master-review-cleanup-20260929

Conversation

@airborne12

@airborne12 airborne12 commented Sep 29, 2026 •

Copy link
Copy Markdown
Member

What problem does this PR solve?

Related PR: #67537, #68584, #67657, #68758, #69192

Problem Summary:

The SNII golden corpus test skipped unless SNII_GOLDEN_DIR was supplied, leaving existing wire-format compatibility checks out of ordinary BE unit-test runs. This PR bundles eight synthetic index/expectation pairs and verifies them by default across disabled, cold, and warm query-cache modes.

CMake supplies the bundled corpus directory to the test source. This lets the test find the files when run-be-ut.sh resets DORIS_HOME to the test binary directory. SNII_GOLDEN_DIR still selects an external corpus or an explicit write destination. Write mode requires that override and adds the Apache license header to generated expectations.

The expectations follow the current shared query engine: analyzed multiword equality intersects its terms, and phrase queries requiring positions on a docs-only index return NOT_IMPLEMENTED_ERROR (3). The original eight index images remain unchanged.

The remaining source and protobuf edits simplify comments and rename one metadata test without changing its assertions. A token comparison excluding comments and whitespace confirms that the production and protobuf changes do not alter behavior. The branch includes the upstream IColumn writer API migration.

Release note

None

Check List (For Author)

  • Test:
    • Reproduced the old path-helper failure with the BE runner's build-directory DORIS_HOME.
    • Compiled the actual path helper, sample list, three GTests, and CMake source property in an isolated harness. All 18 executions pass across three working directories with runner and absent DORIS_HOME; every run finds all 16 corpus files. This harness does not run the BE query engine.
    • BE build-hygiene checks and the independent equality/posting audit pass. The corpus contains 171 query records and 513 cache-mode comparisons. All eight binary images are unchanged.
    • Full merged-tree clang-format 16, JDK 17 FE Checkstyle, and complete PR English checks pass for the committed candidate.
    • Full BE GTest runtime verification is pending the new CI run; no local full-BE runtime result is claimed.
  • Behavior changed: No production behavior changes. The existing compatibility test now runs by default and locates its bundled data in the ordinary runner.
  • Does this need documentation: No.

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
Copy Markdown
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?

@airborne12
airborne12 force-pushed the snii-master-review-cleanup-20260929 branch from e9ff8a5 to 277989b Compare September 29, 2026 04:55
@airborne12

Copy link
Copy Markdown
Member Author

run buildall

@airborne12

Copy link
Copy Markdown
Member Author

/review

@github-actions github-actions Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

Complete static review of PR #68607 at head 277989b759100c60d39917d8bdc3f571d1e7f42e: no new findings. There are no existing P0/P1 inline comments to carry forward. The initial main risk scan, two full-coverage reviews, a separate risk-focused review, candidate reconciliation, and final 120-path sweep converged in one round. The live base/head and inline comments were refreshed immediately before submission.

Code-review critical checkpoints:

  • Goal and proof: The golden-corpus test now uses eight bundled SNII index/expectation pairs by default. The five analyzed fixtures each cover 27 queries and the three keyword fixtures each cover 12, yielding 513 expected observations across uncached, cache-cold, and cache-warm reads. Static inspection proves fixture presence, query inventory, and verifier wiring; it does not prove a fresh test run on this head.
  • Scope and clarity: Effective production C++ and protobuf declarations are unchanged; the large production diff simplifies comments. Functional changes are confined to the golden test's directory fallback, explicit write-mode guard, and expectation license header, plus its fixtures.
  • Concurrency and locks: No production thread, lock, atomic, or lock-order behavior changes. The fixture restores the prior global query-cache pointer in TearDown; no new concurrent path was introduced.
  • Lifecycle and initialization: No new production ownership or cross-translation-unit static initialization dependency. The test's cache setup and teardown remain paired, including the new early write-mode failure path.
  • Configuration: No config value or dynamic-update contract changes. SNII_GOLDEN_DIR still overrides the corpus; write mode requires a nonempty explicit directory.
  • Compatibility: All SNII protobuf fields and tag numbers remain identical, and the supplied binary files retain the existing SNII version 1 container signature. The corpus now supplies a readback compatibility check; no rolling-upgrade protocol or storage writer change occurs in this PR.
  • Parallel paths and conditions: The corpus includes scalar and array samples, keyword and analyzed lanes, null bitmaps, phrase behavior, and three cache states. The supported run-be-ut.sh runner resolves the default path after the build's __FILE__ prefix mapping. The write guard and fallback conditions follow their stated behavior.
  • Coverage and expected results: All eight .idx/.expect pairs exist, and every expectation has six parseable columns in the same query order as the test source. The verifier compares status, document IDs, null-read status, and null IDs. No build or test was run under this review's no-build instruction, so runtime and exact-head test success remain unverified.
  • Observability: Existing GTest failures identify missing files, sample open failures, and mismatched sample/query observations; no production logging or metrics path changes.
  • Transactions, persistence, writes, and crashes: No production data write, EditLog, transaction, MoW, version-visibility, or crash-recovery path changes. Corpus generation writes files only in explicit write mode.
  • FE/BE variables: None added or transmitted.
  • Performance and memory: No production path changes. Default unit-test execution adds the finite corpus readback work; the test uses the existing cache fixture.
  • Other BE obligations: No new hub-header include, PCH edge, extern-template list, gate-table exception, source-including test, glibc dependency, or new Status/exception path. No additional user review focus was supplied.

This conclusion is based on static inspection of the authoritative bundled diff and checked-in corpus only.

### What problem does this PR solve?

Related PR: apache#67657, apache#68607

Problem Summary:

The compatibility corpus and comment cleanup conflicted with the posting
workspace and spool changes now on master. Merge the current target branch,
retain its implementation and interfaces, and reapply concise comments that
describe the spool, workspace and merge fan-in behavior.

### Release note

None

### Check List (For Author)

- Test: Complete C++ formatter scope passed with clang-format 16; BE header
  hygiene passed. All 57 changed production/protobuf files match master
  after removing comments. The 16 corpus files are unchanged from the
  original PR and contain 513 expected observations. Exact-head BE runtime
  tests have not been run locally; the required Paimon headers and real
  library are unavailable in the local dependency installation.
- Behavior changed: No production behavior changes; preserve the PR's
  existing default compatibility verification and explicit write directory.
- Does this need documentation: No.
@airborne12

Copy link
Copy Markdown
Member Author

run buildall

@hello-stephen

Copy link
Copy Markdown
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 77.54% (2064/2662)
Line Coverage 65.94% (38030/57678)
Region Coverage 53.42% (35688/66812)
Branch Coverage 56.82% (11470/20188)

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	17556	3970	3951	3951
q2	2154	365	327	327
q3	9969	1418	786	786
q4	4686	481	365	365
q5	7497	826	539	539
q6	188	176	141	141
q7	737	784	607	607
q8	9341	1666	1542	1542
q9	6044	4237	4185	4185
q10	6873	1347	1023	1023
q11	438	276	243	243
q12	635	439	305	305
q13	18063	2658	1994	1994
q14	268	266	232	232
q15	q16	731	718	675	675
q17	1808	1088	938	938
q18	6544	5582	5539	5539
q19	1169	1267	1098	1098
q20	489	406	263	263
q21	5424	3477	3009	3009
q22	448	366	323	323
Total cold run time: 101062 ms
Total hot run time: 28085 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4704	4671	4678	4671
q2	725	592	549	549
q3	4778	5399	4562	4562
q4	2208	2419	1445	1445
q5	4609	4482	4544	4482
q6	252	187	131	131
q7	1955	1717	1498	1498
q8	2344	2138	2051	2051
q9	7145	6905	6842	6842
q10	3651	3556	3076	3076
q11	514	375	339	339
q12	707	703	520	520
q13	2281	2620	2027	2027
q14	264	273	245	245
q15	q16	665	689	603	603
q17	7314	6688	6624	6624
q18	11946	11113	11979	11113
q19	1122	1035	1051	1035
q20	2206	2199	1914	1914
q21	5060	4122	4343	4122
q22	508	455	428	428
Total cold run time: 64958 ms
Total hot run time: 58277 ms

@hello-stephen

Copy link
Copy Markdown
Contributor

FE UT Coverage Report

Increment line coverage `` 🎉
Increment coverage report
Complete coverage report

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	17565	3925	3908	3908
q2	2226	354	301	301
q3	9915	1395	781	781
q4	4691	484	366	366
q5	7515	819	553	553
q6	190	169	138	138
q7	732	796	614	614
q8	9369	1480	1549	1480
q9	5875	4199	4186	4186
q10	6886	1326	1018	1018
q11	439	271	236	236
q12	650	424	299	299
q13	18053	2630	1996	1996
q14	266	257	243	243
q15	q16	744	723	679	679
q17	1742	1046	907	907
q18	6467	5617	5549	5549
q19	1162	1303	976	976
q20	460	397	267	267
q21	5451	3228	2983	2983
q22	438	375	308	308
Total cold run time: 100836 ms
Total hot run time: 27788 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4601	4451	4465	4451
q2	733	598	532	532
q3	4757	5326	4684	4684
q4	2273	2328	1479	1479
q5	4648	4439	4465	4439
q6	226	171	131	131
q7	1911	1664	1492	1492
q8	2371	2074	2014	2014
q9	6954	6877	6781	6781
q10	3612	3583	3139	3139
q11	520	375	340	340
q12	782	703	512	512
q13	2260	2602	1992	1992
q14	265	272	248	248
q15	q16	666	687	607	607
q17	7259	6771	6620	6620
q18	11861	11007	11743	11007
q19	1092	980	1022	980
q20	2205	2179	1888	1888
q21	4940	4067	4267	4067
q22	535	446	404	404
Total cold run time: 64471 ms
Total hot run time: 57807 ms

@hello-stephen

Copy link
Copy Markdown
Contributor

FE Regression Coverage Report

Increment line coverage 0.00% (0/63) 🎉
Increment coverage report
Complete coverage report

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 151678 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 ef86edcf65c6de2c27b0f1be371408fa28b047d6, data reload: false

query5	4339	603	464	464
query6	442	213	199	199
query7	4963	557	302	302
query8	317	173	191	173
query9	8821	3924	3905	3905
query10	450	307	255	255
query11	5808	3543	3220	3220
query12	159	90	85	85
query13	1244	586	390	390
query14	6541	4484	4240	4240
query14_1	3930	3969	3939	3939
query15	214	199	192	192
query16	968	453	483	453
query17	964	638	519	519
query18	2459	450	323	323
query19	212	170	136	136
query20	81	79	80	79
query21	234	129	113	113
query22	13013	12952	12773	12773
query23	13992	12972	12362	12362
query23_1	12556	12423	12531	12423
query24	7214	1088	614	614
query24_1	639	709	680	680
query25	525	401	353	353
query26	1270	309	168	168
query27	2683	551	341	341
query28	4575	1944	1933	1933
query29	1653	705	515	515
query30	287	206	180	180
query31	911	749	630	630
query32	151	98	99	98
query33	514	285	241	241
query34	1226	1145	631	631
query35	716	769	637	637
query36	768	798	709	709
query37	139	103	99	99
query38	1829	1754	1655	1655
query39	701	683	686	683
query39_1	626	647	651	647
query40	230	128	103	103
query41	72	72	68	68
query42	95	103	95	95
query43	335	350	295	295
query44	1344	706	701	701
query45	187	183	172	172
query46	1041	1204	707	707
query47	1478	1535	1396	1396
query48	412	378	312	312
query49	600	409	300	300
query50	976	362	254	254
query51	10201	10496	10214	10214
query52	90	89	77	77
query53	231	264	182	182
query54	264	210	197	197
query55	78	77	70	70
query56	259	224	217	217
query57	1480	1385	1432	1385
query58	290	260	255	255
query59	1966	2043	1882	1882
query60	279	239	213	213
query61	148	150	136	136
query62	402	318	272	272
query63	213	176	175	175
query64	2809	971	801	801
query65	3466	3392	3420	3392
query66	1792	419	309	309
query67	20154	20211	19769	19769
query68	3194	1488	886	886
query69	408	302	265	265
query70	902	858	788	788
query71	284	229	203	203
query72	2669	2533	2282	2282
query73	797	759	407	407
query74	4628	4476	4267	4267
query75	2295	2335	1906	1906
query76	2303	1086	742	742
query77	359	399	304	304
query78	9152	9026	8485	8485
query79	1222	1147	766	766
query80	514	450	363	363
query81	525	322	280	280
query82	264	159	125	125
query83	215	224	198	198
query84	293	144	114	114
query85	774	470	396	396
query86	289	251	230	230
query87	1958	1955	1815	1815
query88	3575	2725	2667	2667
query89	319	276	246	246
query90	2088	191	173	173
query91	163	155	125	125
query92	104	96	90	90
query93	1530	1483	933	933
query94	511	345	303	303
query95	646	454	336	336
query96	1014	792	339	339
query97	2448	2432	2329	2329
query98	158	152	143	143
query99	715	726	612	612
Total cold run time: 234926 ms
Total hot run time: 151678 ms

@hello-stephen

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

query1	0.01	0.00	0.01
query2	0.14	0.08	0.08
query3	0.42	0.24	0.23
query4	1.62	0.24	0.24
query5	0.33	0.31	0.31
query6	1.16	0.66	0.65
query7	0.05	0.01	0.00
query8	0.09	0.08	0.07
query9	0.52	0.39	0.39
query10	0.56	0.56	0.57
query11	0.33	0.18	0.18
query12	0.31	0.19	0.19
query13	0.52	0.52	0.53
query14	0.87	0.87	0.86
query15	0.67	0.59	0.59
query16	0.39	0.39	0.38
query17	1.00	0.97	1.00
query18	0.28	0.28	0.28
query19	1.91	1.81	1.75
query20	0.02	0.02	0.01
query21	15.40	0.35	0.31
query22	4.94	0.13	0.13
query23	15.80	0.47	0.28
query24	2.58	0.58	0.42
query25	0.17	0.11	0.11
query26	0.79	0.27	0.21
query27	0.10	0.10	0.10
query28	3.47	0.78	0.43
query29	12.47	4.08	3.22
query30	0.38	0.26	0.26
query31	2.78	0.60	0.33
query32	3.25	0.59	0.48
query33	2.91	2.92	2.98
query34	15.78	3.87	3.23
query35	3.16	3.17	3.15
query36	0.63	0.52	0.50
query37	0.12	0.09	0.10
query38	0.07	0.07	0.06
query39	0.06	0.06	0.06
query40	0.19	0.17	0.17
query41	0.10	0.06	0.05
query42	0.06	0.05	0.06
query43	0.06	0.06	0.05
Total cold run time: 96.47 s
Total hot run time: 24.87 s

### What problem does this PR solve?

Related PR: apache#68607, apache#68758, apache#69192

Problem Summary:

The compatibility corpus and comment cleanup conflict with the SNII directory
move and query execution changes on master. Merge master, retain its production
implementation and deleted query files, and apply concise comments at the new
paths. Move the unchanged corpus beside the relocated golden corpus test so
default verification finds its input files.

### Release note

None

### Check List (For Author)

- Test: Static token comparison confirms all 50 changed production/protobuf
  files match master after comments and whitespace are removed. All 16 corpus
  files are byte-identical to the previous PR head and retain 171 query records
  checked across three cache modes. BE header hygiene and full clang-format 16
  checks passed. Exact-head compilation and runtime tests remain pending CI.
- Behavior changed: No additional production behavior changes. Preserve the
  existing default compatibility verification and explicit write directory.
- Does this need documentation: No.
@airborne12

Copy link
Copy Markdown
Member Author

run buildall

@airborne12

Copy link
Copy Markdown
Member Author

/review

@github-actions github-actions Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

Request changes: five newly bundled analyzed EQUAL_QUERY expectations contain union results, while this head executes the analyzed terms as a conjunction. The committed scalar images yield {0}, and the analyzed array image yields {0,8}. Enabling this test by default therefore exposes deterministic expectation mismatches. One inline finding covers all five copies; no existing inline findings need to be carried forward.

Critical checkpoint conclusions:

  1. Goal and proof: the corpus is registered and discovered by default, but the stale equality records prevent successful current-head verification.
  2. Scope and clarity: all 111 changed paths were reviewed. All 50 production/protobuf files have identical non-comment tokens; executable changes are confined to the golden test and one test-name rename.
  3. Concurrency and locking: no production synchronization changes. The serial test fixture owns its cache; no new lock order or heavy locked operation was found.
  4. Lifecycle and static initialization: cache restoration, query handles and borrowed readers are balanced; the early write-mode failure precedes cache replacement. No new cross-translation-unit initialization dependency.
  5. Configuration: no Doris configuration additions or dynamic-config changes. Existing test environment overrides remain supported.
  6. Symbols, storage formats and rolling upgrades: production behavior and encoded definitions are unchanged. The fixture issue is a query-result expectation mismatch, with no new storage-format regression established.
  7. Protobuf compatibility: complete definitions match branch-4.2. The file and Snii definitions are absent from branch-3.1/4.0/4.1. No changed/reused ids, enum values or required fields.
  8. Parallel paths: scalar/array, keyword/analyzed, casing, phrase/docs-only, NULL and three query-cache settings were covered; all five equality instances are grouped in the finding. Unchanged BKD/spill/compaction/count-only paths were checked for comment accuracy.
  9. Special conditions: requiring an explicit write directory prevents an unintended implicit corpus write; normal runner cwd matches the mapped FILE path. No separate path/setup defect was substantiated.
  10. Test coverage: eight fixture pairs contain 171 query records for 513 cache-mode comparisons. Existing corruption, differential, memory-accounting and byte-layout assertions remain unchanged. Missing-file/open/parse/mismatch failures remain explicit.
  11. Expected results: five equality rows disagree with current AND execution and the actual stored postings. Static audits checked binary framing, CRCs, metadata, all 219 term entries/postings and NULL payloads; no second result defect was substantiated.
  12. Observability: existing expected/actual, sample/open and mismatch-count diagnostics suffice for this test-only behavior change; no new production metrics are needed.
  13. Transactions, persistence and failover: no EditLog, visible-version, transaction or MoW behavior changes.
  14. Writes, atomicity and crashes: ordinary verification reads the corpus; generation requires an explicit destination. Production write/cleanup behavior is unchanged.
  15. FE/BE variables: none added or changed; no transport send path needs updating.
  16. Performance and memory: production hot paths are unchanged. Verification has a small fixed corpus and one fixture-scoped cache; no new production memory-accounting defect was found.
  17. Other issues and user focus: no additional user focus was supplied. No further verified finding remained after the final sweep.

Convergence: converged after 2 review rounds, with all reviewers reporting NO_NEW_VALUABLE_FINDINGS on this frozen finding set and no unresolved candidates or unreviewed changed paths. Validation was static only: no Doris build, unit/regression runtime, sanitizer, performance or final ELF validation was performed.

Review converged after 2 round(s).

…ion semantics

### What problem does this PR solve?

Related PR: apache#68607

Problem Summary:

The bundled corpus contains five multiword EQUAL_QUERY observations with union
results. The current FULLTEXT reader lowers analyzed equality to a conjunction,
so default corpus verification reports a mismatch in each cache mode.

Correct the five expected document-ID fields using the existing index images:
the four scalar samples match document 0, and the array sample matches 0 and 8.
Preserve every binary index, status field, null bitmap expectation, and other
query observation.

### Release note

None

### Check List (For Author)

- Test: An independent wire-format decoder verified the images' checksums and
  stored postings. Its equality audit failed on all five analyzed observations
  before the change and passed all eight corpus equality cases after it. The
  scope audit confirms eight unchanged index images and 166 unchanged query
  records. These audits are not a BE runtime test; exact-head runtime results
  remain pending CI.
- Behavior changed: No production behavior changes. Fix test expectations to
  match the existing analyzed equality contract.
- Does this need documentation: No.
@hello-stephen

Copy link
Copy Markdown
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 78.02% (2080/2666)
Line Coverage 66.29% (38363/57868)
Region Coverage 53.74% (36038/67054)
Branch Coverage 57.27% (11613/20276)

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	17300	5154	5050	5050
q2	2107	317	259	259
q3	10160	1372	810	810
q4	4678	461	332	332
q5	7447	787	531	531
q6	183	186	154	154
q7	739	792	595	595
q8	9280	1324	1024	1024
q9	5420	4209	4171	4171
q10	6828	1298	1028	1028
q11	452	249	229	229
q12	644	407	277	277
q13	18136	3681	3041	3041
q14	279	271	247	247
q15	q16	742	738	673	673
q17	1206	763	585	585
q18	6973	6190	6128	6128
q19	1113	966	606	606
q20	397	335	223	223
q21	5296	2484	2444	2444
q22	382	326	271	271
Total cold run time: 99762 ms
Total hot run time: 28678 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	5968	5890	6081	5890
q2	717	585	582	582
q3	5501	5792	5313	5313
q4	2019	2215	1547	1547
q5	5754	5667	5827	5667
q6	240	186	139	139
q7	2186	1965	1841	1841
q8	3010	2609	2605	2605
q9	7987	7863	7772	7772
q10	3638	3591	3142	3142
q11	576	406	372	372
q12	676	665	504	504
q13	3236	3588	3006	3006
q14	297	286	255	255
q15	q16	658	669	605	605
q17	7652	7025	6788	6788
q18	12937	12187	12859	12187
q19	896	789	775	775
q20	2150	2143	1937	1937
q21	5557	4553	4653	4553
q22	499	440	411	411
Total cold run time: 72154 ms
Total hot run time: 65891 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 150512 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 896069a439d7f7b697df02d509786ccdef644cc0, data reload: false

query5	4331	565	446	446
query6	420	233	186	186
query7	4805	444	228	228
query8	321	180	158	158
query9	8758	3064	3065	3064
query10	468	306	264	264
query11	5973	3886	3568	3568
query12	156	95	86	86
query13	1257	428	324	324
query14	6131	3920	3620	3620
query14_1	3422	3443	3380	3380
query15	208	203	180	180
query16	955	448	414	414
query17	876	681	526	526
query18	2412	412	317	317
query19	202	162	138	138
query20	85	85	83	83
query21	211	125	108	108
query22	12855	13034	12655	12655
query23	13412	12767	12622	12622
query23_1	12551	12569	12479	12479
query24	7356	813	454	454
query24_1	473	476	482	476
query25	538	414	364	364
query26	1260	255	142	142
query27	2799	437	283	283
query28	4621	1954	1958	1954
query29	1519	620	454	454
query30	290	221	186	186
query31	1005	930	814	814
query32	139	87	93	87
query33	533	311	250	250
query34	890	844	486	486
query35	738	749	650	650
query36	803	825	738	738
query37	124	100	97	97
query38	1791	1741	1665	1665
query39	796	779	751	751
query39_1	734	730	738	730
query40	221	116	97	97
query41	73	70	69	69
query42	100	83	79	79
query43	345	359	316	316
query44	1292	680	682	680
query45	179	176	167	167
query46	821	954	555	555
query47	3006	3060	2647	2647
query48	311	305	215	215
query49	570	401	289	289
query50	661	265	201	201
query51	10511	10478	10428	10428
query52	79	78	69	69
query53	184	209	148	148
query54	235	199	179	179
query55	79	65	69	65
query56	229	213	206	206
query57	1672	1586	1584	1584
query58	290	261	258	258
query59	2168	2211	1919	1919
query60	297	244	222	222
query61	141	151	151	151
query62	387	335	285	285
query63	186	161	157	157
query64	2765	937	777	777
query65	3345	3275	3266	3266
query66	1758	417	292	292
query67	20297	20214	20144	20144
query68	3355	1003	608	608
query69	393	298	241	241
query70	826	750	769	750
query71	299	227	209	209
query72	2859	2624	2234	2234
query73	529	532	299	299
query74	4631	4534	4318	4318
query75	2352	2279	1920	1920
query76	2387	996	568	568
query77	375	370	271	271
query78	9782	9638	9118	9118
query79	1852	844	518	518
query80	1563	410	346	346
query81	600	320	269	269
query82	556	125	106	106
query83	298	209	180	180
query84	309	121	104	104
query85	843	419	360	360
query86	394	247	231	231
query87	1996	1949	1812	1812
query88	3672	2657	2641	2641
query89	334	279	232	232
query90	1846	166	159	159
query91	161	149	130	130
query92	99	86	83	83
query93	1144	996	566	566
query94	619	301	277	277
query95	567	318	310	310
query96	671	482	229	229
query97	2470	2446	2329	2329
query98	165	153	146	146
query99	771	764	644	644
Total cold run time: 236930 ms
Total hot run time: 150512 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 24.19 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 896069a439d7f7b697df02d509786ccdef644cc0, data reload: false

query1	0.01	0.01	0.00
query2	0.09	0.04	0.05
query3	0.25	0.09	0.09
query4	1.62	0.10	0.10
query5	0.24	0.24	0.23
query6	1.17	0.68	0.68
query7	0.04	0.01	0.01
query8	0.06	0.04	0.04
query9	0.40	0.34	0.35
query10	0.55	0.57	0.58
query11	0.20	0.14	0.15
query12	0.18	0.14	0.15
query13	0.49	0.49	0.48
query14	1.03	1.02	1.01
query15	0.65	0.63	0.60
query16	0.33	0.35	0.34
query17	1.14	1.18	1.11
query18	0.21	0.19	0.19
query19	2.11	1.98	1.88
query20	0.02	0.01	0.01
query21	15.42	0.21	0.13
query22	4.82	0.06	0.05
query23	16.25	0.32	0.13
query24	3.11	0.49	0.41
query25	0.14	0.05	0.06
query26	1.26	0.21	0.15
query27	0.05	0.05	0.05
query28	3.88	0.80	0.37
query29	12.51	4.11	3.22
query30	0.28	0.12	0.10
query31	2.77	0.54	0.33
query32	3.22	0.59	0.52
query33	3.05	3.18	3.21
query34	15.43	3.99	3.40
query35	3.33	3.35	3.37
query36	0.56	0.43	0.40
query37	0.09	0.07	0.06
query38	0.05	0.04	0.04
query39	0.03	0.04	0.03
query40	0.18	0.15	0.14
query41	0.08	0.03	0.03
query42	0.03	0.03	0.02
query43	0.04	0.04	0.03
Total cold run time: 97.37 s
Total hot run time: 24.19 s

@hello-stephen

Copy link
Copy Markdown
Contributor

FE UT Coverage Report

Increment line coverage `` 🎉
Increment coverage report
Complete coverage report

@airborne12

Copy link
Copy Markdown
Member Author

run buildall

@airborne12

Copy link
Copy Markdown
Member Author

/review

@github-actions github-actions Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

Request changes on head 1b94c07e3669d194a24d2bb781751207bf886a28: two independent P1 defects prevent the newly mandatory compatibility test from passing. Default discovery uses the runner's binary-directory DORIS_HOME as a source root; with an explicit valid corpus directory, nine docs-only phrase/prefix status expectations still disagree with the current reader.

Reviewed all 111 changed paths: 49 BE production files plus the protobuf are comment-only, 44 other BE tests preserve their bodies except one test-name rename, and the remaining scope is the golden test plus eight index/expectation pairs. The static image/query audit examined all 171 records and their NULL fields. Existing finding 4365933499 is fixed: stored equality postings intersect at {0} for the four scalar samples and {0,8} for the array sample. It is not reposted or retained as an existing blocker. The two new findings concern separate discovery and no-position error-code paths. No additional user focus was supplied.

Critical checkpoint conclusions:

  1. Goal and proof: making the compatibility corpus mandatory is not yet achieved successfully; the two inline findings identify concrete failures. The three path unit tests omit the actual runner environment.
  2. Scope and clarity: functional edits are confined to fixture discovery, write-mode protection, and expectation headers; the broad production cleanup changes comments only.
  3. Concurrency and locks: no new threads, synchronization, lock ordering, or work under locks. The fixture follows existing serial GTest cache replacement.
  4. Lifecycle and initialization: handles/readers die before fixture cache destruction; the prior cache pointer is restored. New constants are constexpr, with no cross-translation-unit initialization dependency.
  5. Configuration: no new BE configuration or changed defaults/dynamic behavior. Explicit SNII_GOLDEN_DIR precedence is preserved and write mode requires it.
  6. Compatibility: production symbols and format logic are unchanged. All eight committed images structurally decode with supported metadata; optional norms/stat fields remain accepted.
  7. Thrift/protobuf: schema tokens and field/enum IDs are unchanged. The complete branch-4.2 schema matches; the file is absent on branch-3.1, branch-4.0, and branch-4.1. No new required field or reused ID.
  8. Parallel paths: inspected scalar/array, analyzed/keyword, docs-only/positions, Unicode/lowercase, empty/missing terms, cache modes, and runner launch variants. The docs-only and default-discovery defects are inline.
  9. Conditional checks: the explicit-directory and write-destination checks have concrete purposes; the DORIS_HOME assumption is incorrect. Production conditions are unchanged.
  10. Test coverage: eight pairs provide 171 records and 513 intended cache-mode comparisons. Current path tests miss runner integration, and the docs-only negative cases encode stale status codes. Existing test assertions otherwise remain intact.
  11. Expected results: all recorded docid/NULL sets have static byte/model support; nine english_docs status fields require reconciliation. The previously reported five equality results are corrected.
  12. Observability: existing missing-file/open/query mismatch diagnostics identify these failures; no new production metrics or logging are needed for the test-only behavior.
  13. Transactions and persistence: no changed transaction, visible-version, delete-bitmap, EditLog, or persistent schema logic.
  14. Writes and crash behavior: normal verification reads committed fixtures. Explicit regeneration retains checked writer calls; the new destination requirement protects bundled files. No production write/atomicity/cleanup change.
  15. FE/BE propagation: no new transmitted variable or sending path.
  16. Performance and memory: no production hot-path/allocation change. Fixture work is bounded, and its existing cache ownership pattern remains intact.
  17. Other issues: no further substantiated introduced issue after the complete static recheck.

Validation limits: no builds or Doris tests were run, as required by this review contract. Temporary scripts decoded committed bytes and modeled only the exercised query shapes; they do not replace BE runtime validation. Both findings are independently established by concrete current C++/runner control flow. No remaining unreviewed changed path or unresolved candidate within this static scope.

Review converged after 2 round(s).

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	16428	5077	5026	5026
q2	2100	324	286	286
q3	9715	1386	810	810
q4	4446	461	336	336
q5	7168	803	520	520
q6	183	185	151	151
q7	744	795	595	595
q8	9230	1327	1078	1078
q9	5442	4191	4178	4178
q10	6856	1285	1009	1009
q11	428	242	238	238
q12	636	395	285	285
q13	17917	3676	3026	3026
q14	273	275	249	249
q15	q16	741	722	680	680
q17	1185	753	575	575
q18	7021	6185	6119	6119
q19	1106	948	610	610
q20	369	329	234	234
q21	5330	2436	2638	2436
q22	369	326	267	267
Total cold run time: 97687 ms
Total hot run time: 28708 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	5911	5948	5912	5912
q2	711	742	580	580
q3	5517	5888	5278	5278
q4	2016	2143	1558	1558
q5	5555	5626	5723	5626
q6	245	188	144	144
q7	2245	2037	1842	1842
q8	2966	2690	2691	2690
q9	7903	7951	7847	7847
q10	3701	3681	3144	3144
q11	580	412	373	373
q12	659	668	490	490
q13	3270	3602	3059	3059
q14	299	296	277	277
q15	q16	682	680	602	602
q17	7636	6982	6853	6853
q18	13030	12234	12868	12234
q19	917	778	779	778
q20	2136	2145	1932	1932
q21	5611	4641	4815	4641
q22	501	440	428	428
Total cold run time: 72091 ms
Total hot run time: 66288 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 150659 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 1b94c07e3669d194a24d2bb781751207bf886a28, data reload: false

query5	4302	601	429	429
query6	421	202	190	190
query7	4804	462	224	224
query8	321	169	156	156
query9	8781	3084	3102	3084
query10	463	314	247	247
query11	5951	3845	3568	3568
query12	149	91	88	88
query13	1265	452	321	321
query14	6141	3901	3648	3648
query14_1	3395	3429	3383	3383
query15	210	206	193	193
query16	940	442	420	420
query17	847	664	528	528
query18	2428	432	312	312
query19	193	180	135	135
query20	84	84	87	84
query21	212	128	108	108
query22	12870	12967	12748	12748
query23	13486	12698	12423	12423
query23_1	12565	12422	12468	12422
query24	7116	813	452	452
query24_1	475	482	471	471
query25	539	427	368	368
query26	1265	267	142	142
query27	2759	441	273	273
query28	4462	1941	1934	1934
query29	1552	604	445	445
query30	303	225	183	183
query31	1009	966	810	810
query32	147	101	94	94
query33	534	307	248	248
query34	896	839	489	489
query35	736	747	642	642
query36	821	802	718	718
query37	124	97	82	82
query38	1782	1721	1682	1682
query39	788	792	738	738
query39_1	748	717	758	717
query40	230	118	98	98
query41	75	71	66	66
query42	89	85	84	84
query43	345	355	319	319
query44	1286	676	682	676
query45	187	172	167	167
query46	848	951	553	553
query47	2989	2951	2891	2891
query48	297	300	211	211
query49	569	397	295	295
query50	686	267	210	210
query51	10649	10418	10545	10418
query52	78	80	67	67
query53	184	204	149	149
query54	230	198	194	194
query55	73	67	58	58
query56	222	226	212	212
query57	1664	1598	1602	1598
query58	281	264	256	256
query59	2058	2205	1983	1983
query60	274	244	222	222
query61	149	148	146	146
query62	379	327	310	310
query63	181	152	160	152
query64	2654	940	773	773
query65	3344	3270	3262	3262
query66	1767	410	303	303
query67	20069	20216	19959	19959
query68	3172	985	601	601
query69	391	309	248	248
query70	835	782	761	761
query71	298	228	216	216
query72	2854	2548	2317	2317
query73	517	516	303	303
query74	4642	4524	4316	4316
query75	2352	2310	1901	1901
query76	2149	997	593	593
query77	355	373	262	262
query78	9782	9675	9161	9161
query79	982	829	511	511
query80	1212	417	350	350
query81	599	316	277	277
query82	591	127	110	110
query83	303	203	181	181
query84	316	124	102	102
query85	860	421	364	364
query86	406	238	228	228
query87	1986	1992	1825	1825
query88	3703	2678	2644	2644
query89	334	281	264	264
query90	1861	175	169	169
query91	164	151	130	130
query92	105	89	86	86
query93	1018	1001	567	567
query94	637	294	274	274
query95	582	344	301	301
query96	664	493	231	231
query97	2460	2429	2317	2317
query98	162	150	145	145
query99	762	778	646	646
Total cold run time: 234479 ms
Total hot run time: 150659 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 24.2 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 1b94c07e3669d194a24d2bb781751207bf886a28, data reload: false

query1	0.00	0.01	0.01
query2	0.09	0.05	0.05
query3	0.26	0.08	0.08
query4	1.61	0.13	0.11
query5	0.23	0.24	0.23
query6	1.17	0.69	0.68
query7	0.04	0.01	0.01
query8	0.05	0.04	0.04
query9	0.40	0.33	0.35
query10	0.57	0.57	0.57
query11	0.21	0.15	0.15
query12	0.18	0.14	0.15
query13	0.49	0.49	0.49
query14	1.03	1.01	1.01
query15	0.62	0.59	0.61
query16	0.36	0.35	0.32
query17	1.12	1.13	1.15
query18	0.21	0.18	0.18
query19	2.03	1.93	1.97
query20	0.02	0.01	0.01
query21	15.50	0.19	0.13
query22	4.89	0.05	0.06
query23	16.28	0.33	0.12
query24	3.07	0.67	0.45
query25	0.13	0.07	0.04
query26	1.32	0.22	0.16
query27	0.03	0.05	0.03
query28	3.07	0.74	0.34
query29	12.47	4.20	3.24
query30	0.28	0.14	0.10
query31	2.77	0.57	0.31
query32	3.23	0.60	0.51
query33	3.21	3.24	3.24
query34	15.40	4.01	3.35
query35	3.34	3.35	3.31
query36	0.57	0.44	0.41
query37	0.09	0.07	0.06
query38	0.06	0.04	0.04
query39	0.04	0.03	0.03
query40	0.18	0.14	0.15
query41	0.09	0.03	0.03
query42	0.04	0.02	0.03
query43	0.04	0.04	0.03
Total cold run time: 96.79 s
Total hot run time: 24.2 s

@hello-stephen

Copy link
Copy Markdown
Contributor

FE UT Coverage Report

Increment line coverage `` 🎉
Increment coverage report
Complete coverage report

@hello-stephen

Copy link
Copy Markdown
Contributor

FE Regression Coverage Report

Increment line coverage 100% (0/0) 🎉
Increment coverage report
Complete coverage report

### What problem does this PR solve?

Related PR: apache#68607

Problem Summary: The BE unit-test runner resets DORIS_HOME to the test
binary directory. The mandatory SNII corpus test consequently found none
of its eight samples in build 1079928. Pass the corpus directory from CMake
to the corpus test source and retain explicit absolute and relative
directory overrides. Verify that the default directory contains all eight
index and expectation pairs.

Reconcile the nine docs-only phrase and phrase-prefix observations with
the current NOT_IMPLEMENTED_ERROR (3) contract. SniiIndexSource rejects
position requests on docs-only indexes, and the shared reader preserves
that status. All eight committed index images and the other 162 query
records remain unchanged.

Merge master 4571c06, retaining the IColumn writer API migration and
resolving the introductory comment conflict in the golden-bytes test.
Production and protobuf tokens match the updated target branch.

### Release note

None

### Check List (For Author)

- Test: Reproduced the old helper failure with the runner's DORIS_HOME;
  compiled the actual path helper, sample list and three GTests using the
  actual CMake source property; all 18 test executions pass across three
  working directories with runner and absent DORIS_HOME. BE build hygiene,
  corpus image/change audits, independent equality posting audit and
  clang-format 16 passed. Full BE GTest runtime remains for CI.
- Behavior changed: No production behavior changes. The compatibility
  test can locate its bundled corpus in the ordinary BE unit-test runner.
- Does this need documentation: No.
@airborne12

Copy link
Copy Markdown
Member Author

run buildall

@airborne12

Copy link
Copy Markdown
Member Author

/review

@github-actions github-actions Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

Reviewed head 9df654a58784172203aab289d4068f2158cb22f0. No new actionable findings.

All three existing P1 findings are fixed at this head: runner corpus discovery, docs-only phrase status codes, and analyzed equality expectations. None remains an existing blocking finding; no duplicate inline comments are posted.

Reviewed all 112 changed paths. Independent lexical audits found no production or protobuf token/preprocessor changes; the other existing tests retain their assertions, with one metadata test renamed. Static decoding validates all eight images, including checksums, metadata/dictionary routing, postings, positions, bloom membership and NULL bitmaps. All 171 stored observations match a query model grounded in the inspected reader, analyzer-selection and lowering paths. The harness compares those observations in three result-cache settings, for 513 comparisons.

Required checkpoint Conclusion
Goal and proof Default lookup now uses CMake's absolute source corpus directory; three path tests cover bundled files and absolute/relative overrides. The native corpus test was inspected, not run.
Scope and clarity Behavioral edits are confined to the test harness and its CMake definition; remaining changes shorten comments or rename one test.
Concurrency and locks No production thread, shared-state or lock change. The fixture runs synchronously and restores the previous query-cache pointer.
Lifecycle and static initialization Reader/file/context ownership and fatal-assertion cleanup remain valid; the new license string is constexpr, with no cross-translation-unit dependency.
Configuration No production setting, default or mutability changes. Explicit test-directory overrides are preserved.
Symbols and storage compatibility Production symbols and format logic are unchanged; the committed old images are read as compatibility fixtures.
Protobuf compatibility All definitions retain their tags, labels and enum values; branch-4.2 definitions match. This proto path is absent on branch-4.1, branch-4.0 and branch-3.1.
Parallel paths Scalar/array, keyword/analyzed, docs-only/positioned and result-cache-disabled/cold/warm paths are represented. NULL caching follows its existing independent contract.
Conditional checks Directory selection preserves explicit overrides; write mode fails before mutation when no explicit destination is supplied.
Test coverage and negative cases Fixtures cover empty input, absent terms, ignored long values, control bytes, NULL rows/elements, array phrase boundaries and unsupported positions. Existing assertion bodies are preserved.
Expected results Static byte/semantic audit found zero modeled mismatches across 171 records; corrected equality intersections and the nine status-3 records agree with current code.
Observability Existing failures identify missing files, failed opens, sample/query and expected/actual tuples. No new production path requires metrics.
Transactions and persistence No transaction, EditLog, visibility, delete-bitmap or failover behavior changes.
Writes, atomicity and failures Default verification reads fixtures; writing requires an explicit directory. Production write/error/cleanup logic is unchanged.
FE/BE variables None added; no thrift changes.
Performance and memory No production hot-path or allocation change. Test work is bounded by eight small images and the existing fixture cache, released after restoring the prior pointer.
Other issues Final changed-path, candidate, known-thread and risk sweeps found no additional substantiated defect or unresolved static-review question.

No additional user focus was supplied. This was a static-only review: no builds, native BE/CLucene tests or sanitizer runs were performed. The analyzer model covers the committed query strings; the binary audit does not establish a native GTest pass.

Review converged after 1 round(s).

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	17643	5341	5085	5085
q2	2148	321	265	265
q3	10166	1387	862	862
q4	4684	475	339	339
q5	7445	793	526	526
q6	184	183	151	151
q7	755	797	614	614
q8	9321	1374	1139	1139
q9	5619	4262	4249	4249
q10	6867	1305	1000	1000
q11	455	249	231	231
q12	641	402	281	281
q13	18175	3587	3012	3012
q14	271	268	250	250
q15	q16	726	709	674	674
q17	1218	757	583	583
q18	7017	6212	6134	6134
q19	1113	965	599	599
q20	408	349	225	225
q21	5352	2157	2318	2157
q22	356	299	260	260
Total cold run time: 100564 ms
Total hot run time: 28636 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	5669	5922	5663	5663
q2	687	588	549	549
q3	5185	5403	4952	4952
q4	2019	2140	1614	1614
q5	5255	5135	5788	5135
q6	250	193	154	154
q7	2212	2056	1883	1883
q8	3178	2678	2716	2678
q9	8058	7902	7952	7902
q10	3761	3743	3339	3339
q11	633	459	421	421
q12	716	698	536	536
q13	3684	3941	3283	3283
q14	302	325	306	306
q15	q16	690	713	673	673
q17	8285	7519	7109	7109
q18	13058	12266	12932	12266
q19	915	783	799	783
q20	2173	2194	1926	1926
q21	5945	4763	4914	4763
q22	502	441	411	411
Total cold run time: 73177 ms
Total hot run time: 66346 ms

@hello-stephen

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

------ Round 1 ----------------------------------
============================================
q1	17615	5184	5104	5104
q2	2154	312	250	250
q3	10171	1386	838	838
q4	4680	465	346	346
q5	7445	818	545	545
q6	188	182	160	160
q7	750	817	608	608
q8	9254	1395	1050	1050
q9	5657	4295	4230	4230
q10	6897	1300	1036	1036
q11	445	253	237	237
q12	637	406	297	297
q13	18092	3671	3021	3021
q14	272	277	245	245
q15	q16	743	715	657	657
q17	1221	764	564	564
q18	7128	6172	6121	6121
q19	1093	958	624	624
q20	385	345	230	230
q21	5294	2191	2375	2191
q22	350	307	259	259
Total cold run time: 100471 ms
Total hot run time: 28613 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	5677	5616	5639	5616
q2	693	574	566	566
q3	5185	5393	4893	4893
q4	2025	2166	1548	1548
q5	5295	5170	5760	5170
q6	260	197	157	157
q7	2309	2065	1893	1893
q8	3113	2685	2726	2685
q9	8052	7974	7951	7951
q10	3719	3696	3519	3519
q11	618	458	441	441
q12	706	702	537	537
q13	3657	3901	3258	3258
q14	324	322	301	301
q15	q16	713	737	665	665
q17	8482	7373	7067	7067
q18	13000	12186	12902	12186
q19	980	857	851	851
q20	2162	2143	1891	1891
q21	5896	4720	4919	4720
q22	493	449	417	417
Total cold run time: 73359 ms
Total hot run time: 66332 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
TPC-DS: Total hot run time: 150764 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 9df654a58784172203aab289d4068f2158cb22f0, data reload: false

query5	4309	598	452	452
query6	431	206	199	199
query7	4799	442	226	226
query8	322	165	151	151
query9	8797	3113	3143	3113
query10	475	308	258	258
query11	5973	3863	3593	3593
query12	158	104	85	85
query13	1257	432	312	312
query14	6163	3870	3668	3668
query14_1	3364	3406	3393	3393
query15	207	202	185	185
query16	945	433	394	394
query17	876	667	534	534
query18	2433	427	313	313
query19	208	166	137	137
query20	93	87	86	86
query21	213	131	107	107
query22	12968	13022	12877	12877
query23	13465	12948	12411	12411
query23_1	12612	12483	12451	12451
query24	7367	859	482	482
query24_1	490	476	482	476
query25	535	421	354	354
query26	1259	258	140	140
query27	2763	444	279	279
query28	4627	1987	1964	1964
query29	1576	606	463	463
query30	304	216	181	181
query31	1007	932	805	805
query32	138	88	90	88
query33	516	279	235	235
query34	896	847	499	499
query35	731	736	629	629
query36	815	830	725	725
query37	130	96	83	83
query38	1760	1716	1671	1671
query39	793	794	743	743
query39_1	735	732	740	732
query40	222	111	92	92
query41	69	63	63	63
query42	84	80	80	80
query43	343	357	306	306
query44	1310	692	682	682
query45	184	176	164	164
query46	820	971	572	572
query47	2815	2977	2685	2685
query48	308	307	223	223
query49	575	397	294	294
query50	657	271	208	208
query51	10432	10608	10470	10470
query52	81	82	71	71
query53	185	209	154	154
query54	248	182	178	178
query55	77	73	65	65
query56	238	222	223	222
query57	1686	1598	1575	1575
query58	280	267	252	252
query59	2118	2143	1901	1901
query60	305	226	228	226
query61	136	146	136	136
query62	380	335	283	283
query63	192	159	153	153
query64	2714	907	753	753
query65	3324	3288	3287	3287
query66	1767	421	297	297
query67	20159	20318	19964	19964
query68	2981	1024	628	628
query69	387	291	255	255
query70	856	800	788	788
query71	299	237	206	206
query72	2673	2594	2286	2286
query73	516	562	301	301
query74	4648	4545	4381	4381
query75	2335	2279	1921	1921
query76	2308	1020	625	625
query77	348	387	273	273
query78	9762	9667	9155	9155
query79	992	851	528	528
query80	1206	410	337	337
query81	570	319	263	263
query82	624	133	103	103
query83	306	195	201	195
query84	301	119	102	102
query85	864	411	360	360
query86	396	237	229	229
query87	1990	1935	1799	1799
query88	3709	2678	2661	2661
query89	328	283	240	240
query90	1903	163	167	163
query91	155	148	127	127
query92	96	82	94	82
query93	1031	1012	597	597
query94	650	315	280	280
query95	567	344	325	325
query96	675	490	226	226
query97	2449	2438	2312	2312
query98	160	151	175	151
query99	787	761	649	649
Total cold run time: 234835 ms
Total hot run time: 150764 ms

@hello-stephen

Copy link
Copy Markdown
Contributor
ClickBench: Total hot run time: 25.07 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 9df654a58784172203aab289d4068f2158cb22f0, data reload: false

query1	0.01	0.01	0.00
query2	0.14	0.08	0.08
query3	0.35	0.13	0.13
query4	1.61	0.14	0.13
query5	0.28	0.26	0.24
query6	1.16	0.65	0.65
query7	0.04	0.01	0.01
query8	0.09	0.07	0.08
query9	0.45	0.35	0.36
query10	0.60	0.57	0.60
query11	0.33	0.19	0.18
query12	0.31	0.19	0.18
query13	0.52	0.53	0.54
query14	0.92	0.94	0.92
query15	0.67	0.59	0.58
query16	0.36	0.35	0.32
query17	1.00	0.99	1.02
query18	0.28	0.27	0.27
query19	1.95	1.84	1.87
query20	0.02	0.01	0.02
query21	15.42	0.35	0.30
query22	4.92	0.14	0.13
query23	15.84	0.49	0.29
query24	2.23	0.52	0.40
query25	0.16	0.11	0.10
query26	0.77	0.27	0.22
query27	0.11	0.10	0.10
query28	3.32	0.82	0.41
query29	12.59	4.35	3.37
query30	0.34	0.17	0.14
query31	2.76	0.61	0.33
query32	3.23	0.61	0.48
query33	3.04	2.95	2.92
query34	15.91	4.13	3.46
query35	3.36	3.40	3.38
query36	0.59	0.51	0.46
query37	0.12	0.09	0.10
query38	0.08	0.06	0.07
query39	0.06	0.06	0.06
query40	0.19	0.17	0.16
query41	0.10	0.06	0.05
query42	0.06	0.07	0.05
query43	0.06	0.06	0.06
Total cold run time: 96.35 s
Total hot run time: 25.07 s

@hello-stephen

Copy link
Copy Markdown
Contributor

FE Regression Coverage Report

Increment line coverage 0.00% (0/236) 🎉
Increment coverage report
Complete coverage report

@hello-stephen

Copy link
Copy Markdown
Contributor

BE UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 66.74% (32035/48001)
Line Coverage 51.54% (338455/656667)
Region Coverage 46.97% (274403/584155)
Branch Coverage 48.69% (129342/265670)

@hello-stephen

Copy link
Copy Markdown
Contributor

BE Regression && UT Coverage Report

Increment line coverage 100% (0/0) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 77.21% (35911/46509)
Line Coverage 62.42% (405520/649640)
Region Coverage 58.91% (342895/582044)
Branch Coverage 59.87% (158656/265022)

@eldenmoon eldenmoon left a comment

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

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

LGTM

@airborne12
airborne12 merged commit dbdd07d into apache:master Oct 26, 2026
48 checks passed
@airborne12
airborne12 deleted the snii-master-review-cleanup-20260929 branch October 26, 2026 10:27
@github-actions github-actions Bot added the approved Indicates a PR has been approved by one committer. label Oct 26, 2026
@github-actions

Copy link
Copy Markdown
Contributor

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

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

Labels

approved Indicates a PR has been approved by one committer. dev/4.2.x dev/4.2.x-conflict

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants