SteNicholas opened a new issue, #407: URL: https://github.com/apache/paimon-cpp/issues/407
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon-cpp/issues) and found nothing similar. ### Motivation Sub-issue of #399 (step 4: hybrid search). Java `Table#newHybridSearchBuilder()` combines vector and full-text routes into one ranked result. It was built up over several PRs: apache/paimon#8271, apache/paimon#8288, apache/paimon#8294, apache/paimon#8324, apache/paimon#8327, apache/paimon#8336, apache/paimon#8348 and apache/paimon#8351. Paimon C++ has neither a hybrid search API nor a table-level vector search builder. Java design: - **Builder.** `HybridSearchBuilder` (`HybridSearchBuilderImpl`) provides: - `withPartitionFilter`, `withFilter` - `addVectorRoute(column, vector, limit[, weight[, options]])`; the weight defaults to 1.0 - `addFullTextRoute(field, query, limit, weight)` - `withLimit` - `withRanker(String)`, `withRrfRanker()`, `withWeightedScoreRanker()` - `executeLocal()` All routes are pinned to one snapshot, and the filters are forwarded to every route. Full-text routes accept row filters since apache/paimon#9855. - **Routes.** `HybridSearchRoute` is either `VECTOR` or `FULL_TEXT`. - Weights must be finite and greater than 0. - Full-text routes reject route options. - The route builder rejects mixing vector and full-text settings. - **Rankers.** `HybridSearchRanker` normalizes the ranker name: blank means `rrf`; otherwise the name is trimmed and lower-cased. - `rrf`: Σ weight / (60 + rank + 1). Ties are broken by score descending, then row id ascending. - `weighted_score`: min-max normalize each route's scores to [0, 1] (all 1.0 when the range is 0), then compute Σ weight × normalized score. - `mrr`: Σ weight / (rank + 1). - The final top-k uses a heap. - **Primary-key tables.** They rank physical positions with `PrimaryKeySearchRanker.weightedRrf`, `weightedScore` and `weightedMrr`. Mixing primary-key physical results with global row-id results is rejected. ### Solution 1. Port the rankers and route validation. They are self-contained and can land first with unit tests. 2. Add the hybrid search builder on top of the table-level full-text search ({{S5}}) and a table-level vector search builder. 3. Add tests: - each ranker - tie-breaking - weights - an empty route result - route validation - snapshot pinning across routes ### Anything else? - Prerequisite: a table-level vector search builder (Java `VectorSearchBuilder` / scan / read). It does not exist in Paimon C++ yet, and could be tracked separately or delivered as part of this issue. - Depends on {{S5}}. Primary-key hybrid search depends on {{S11}}. ### Are you willing to submit a PR? - [x] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
