Loading...

XML

Word

Printable

JSON

Type: Task
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 8.1.0-rc0, 8.0.14
Affects Version/s: None
Component/s: None
Labels:
- M3

Assigned Teams:

Query Integration
Backwards Compatibility:
Fully Compatible
Linked BF Score:
200
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

The results of $vectorSearch come out sorted by 'vectorSearchScore'. If a $sort stage comes directly after $vectorSearch, and the sort criteria is by the vectorSearchScore, the sort should be able to be removed, as it should pass the documents in and out it in the same order.

The $sort that follows the $vectorSearch can come from being explicitly specified, or from desugaring of another stage that requires sorting like $setWindowFields. The optimizing code should not need to differentiate these cases, but both types should be tested for correctness.

Note: This optimization should only apply to single node environments, as $vectorSearch pipelines that have subsequent $sort stages are broken apart as a $vectorSearch on the shard nodes, with a $mergeCursors stage followed by the $sort on the merging (mongos) node. This part of the optimization will be handled separately, and is more generic as many pipelines (other than $search ones) in a sharded environment may have a $mergeCursors stage followed by a $sort.

Note: This optimization should only apply to pipelines where the $sort comes directly after the $vectorSearch stage. This optimization should be generalizable to cases where stages that do not affect the sort order of the documents come in-between the $vectorSearch and $sort, however there are some pre-requisites to tackle before we can implement this generalization, which will be handled in subsequent tickets.

is depended on by

SERVER-96068 Generalize the $sort removal optimizations after $search/$vectorSearch/$mergeCursors

Open

SERVER-95168 Implement $setWindowFields version of desugaring for $rankFusion

Closed

is related to

SERVER-104636 Do not serialize _internalOutputSortKeyMetadata in query shape hash

Closed

SERVER-97189 $rankFusion and $scoreFusion are missing parsing assertions

Closed

SERVER-98343 $rankFusion seg faults if given empty pipeline

Closed

SERVER-99887 $setWindowFields can fail when spilling to disk

Closed

SERVER-100394 Validation of score $meta field is skipped for mongot queries

Closed

SERVER-101653 Do not allow rankFusion to run on views

Closed

SERVER-107409 View definitions with stages that include $rankFusion with subpipelines are not getting disallowed

Closed

SERVER-108052 DocumentSourceInternalSetWindowFields doesn't have sort key metadata in bounded sorts

Closed

SERVER-94669 Implement 'scoreDetails' for $rankFusion

Closed

SERVER-96415 Add $sort pushdown optimization to $_internalSearchIdLookup

Backlog

SERVER-91281 Allow $rank and $denseRank window functions to operate without a SortKeyPattern

Closed

SERVER-94603 Add 'weights' argument to $rankFusion

Closed

SERVER-94660 Test $rankFusion query shape and stable API restrictions

Closed

SERVER-94668 POC 'scoreDetails' for $score

Closed

SERVER-97339 Implement serialization and query shape testing for $score

Closed

SERVER-97645 Refactor serializeTransformation to remove redundant explain parameter

Closed

SERVER-97915 Create feature flag for earlier $rankFusion milestone

Closed

SERVER-97917 Move $rankFusion to be guarded under featureFlagRankFusionBasic

Closed

SERVER-97919 Enable featureFlagRankFusionBasic by default

Closed

SERVER-98453 Refactor $sort to make it easier to add a new option

Closed

SERVER-98994 Make featureFlagRankFusionBasic FCV-gated

Closed

SERVER-99153 $rankFusion scoreDetails should error if not requested by top-level pipeline (but specified in inner)

Closed

SERVER-99169 score cannot be used when not defined

Closed

SERVER-99210 $rankFusion should reject duplicate input.pipelines names

Closed

SERVER-99335 Support projecting textScore with $meta: score

Closed

SERVER-99589 Consolidate metadata dependency tracking of search and non-search metadata

Closed

SERVER-99596 Refactor how metadata dependencies are validated

Closed

SERVER-100045 Add property-based test for metadata field dependency validation

Closed

SERVER-100107 Add "description" and "weight" to $rankFusion scoreDetails

Closed

SERVER-100203 Change scoreDetails to use array rather than object

Closed

SERVER-100546 Handle deps tracking generically in DocumentSourceFacet::getDependencies()

Closed

SERVER-100678 scoreDetails cannot be used when not defined

Closed

SERVER-100799 Guard meta_dependency_validation.js on featureFlagRankFusionFull

Closed

SERVER-100948 Re-enable scoreDetails "value" field

Closed

SERVER-101155 Run search e2e metadata tests in the search passthroughs

Closed

SERVER-101701 $rankFusion must be the first stage of the pipeline

Closed

SERVER-101702 Add tests for $rankFusion in $lookup/$unionWith subpipelines

Closed

SERVER-101781 Reject $rankFusion in a view definiton

Closed

SERVER-104730 Explicitly ban nested $rankFusions and $scoreFusions

Closed

SERVER-99505 Refactor string building in document_source_rank_fusion.cpp

Closed

SERVER-101568 $rankFusion should reject scoreDetails: true unless FF is on

Closed

SERVER-94628 Ensure we do not do a redundant $sort by search score during $rankFusion.

Closed

SERVER-95164 Allow more than 2 input pipelines for $rankFusion

Closed

SERVER-95169 Add multiversion query test which stresses sharded scenarios

Closed

SERVER-96154 Validate field names for 'inputs.pipelines' and 'weights'

Closed

SERVER-96792 Allow {$meta: "score"} to return any kind of score metadata

Closed

SERVER-96793 Allow {$meta: "scoreDetails"} to return any kind of scoreDetails metadata

Closed

SERVER-97103 Allow sorting by {$meta: "score"}

Closed

SERVER-97104 Restrict {$meta: "scoreDetails"} to featureFlagRankFusionFull and apiStrict=false

Closed

SERVER-98322 Improve field path validation error messages

Closed

SERVER-99674 Change $rankFusion weights object to accept a subset of pipelines specified

Closed

SERVER-99675 Improve feedback for misspelled $rankFusion pipelines in weights object

Closed

SERVER-99732 Switch sort key metadata assertion to tassert (from invariant)

Closed

SERVER-100752 $rankFusion should output score metadata

Closed

SERVER-102728 Audit rankFusion's scoreDetails testing

Closed

SERVER-105358 Modify hybrid search input pipeline validation to analyze pre-desugared stages

Closed

SERVER-96835 Update commands_lib.js rankFusion pipeline to new syntax.

Closed

SERVER-97102 Stress test dependency tracking for {$meta: "scoreDetails"} for pipelines spanning across sharded network split

Closed

related to

SERVER-96764 Create geoNear index in rankFusion auth test

Closed

SERVER-94841 Implement 'score' for $score

Closed

SERVER-96067 Properly set the ‘preserveOrderAndMetadata’ field for common aggregation states

Open

SERVER-91200 Add end-to-end ranked fusion test using existing syntax

Closed

SERVER-91201 Add end-to-end score fusion test using existing syntax

Closed

SERVER-82019 Create feature flag

Closed

SERVER-91278 Allow sorting by more kinds of metadata

Closed

SERVER-91279 Add example rank fusion tests which use $setWindowFields

Closed

SERVER-91907 Create skeleton of DocumentSourceRankFusion

Closed

SERVER-91909 Implement basic parsing of $rankFusion

Closed

SERVER-91911 Add validation that $rankFusion subpipelines are valid

Closed

SERVER-91912 Test auth for $rankFusion stage

Closed

SERVER-92213 Implement desugaring of $rankFusion

Closed

SERVER-92244 Create Feature Flag for Milestones 1 and 2

Closed

SERVER-92357 Create js testing strategy for search scoring differences in sharded vs non-sharded configurations

Closed

SERVER-96736 Switch $rankFusion to use 'featureFlagSearchHybridScoringPrerequisites'

Closed

SERVER-107693 [v8.0] Backport Hybrid Search Rank Fusion

Closed

SERVER-88046 Support $vectorSearch execution within unionWith subpipeline

Closed

SERVER-93391 Remove rankConstant field from $rankFusion

Closed

SERVER-93576 Remove vector embeddings from $vectorSearch explain

Closed

SERVER-95162 Refactor multiversion query test to make it more re-usable

Closed

SERVER-96127 Adjust $rankFusion syntax to adopt 'input.pipelines' revision

Closed

(55 is related to, 22 related to)

Assignee:: Joe Shalabi
Reporter:: Joe Shalabi
Participants:: Githook User, Joe Shalabi
Votes:: 0 Vote for this issue
Watchers:: 3 Start watching this issue

Created:: Oct 21 2024 11:24:01 PM UTC
Updated:: Aug 22 2025 08:23:44 PM UTC
Resolved:: Nov 07 2024 07:43:26 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates