[SERVER-72814] Support looking up original values from hash values Created: 12/Jan/23  Updated: 29/Oct/23  Resolved: 11/Apr/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.0.0-rc0

Type: Task Priority: Major - P3
Reporter: Cheahuychou Mao Assignee: Ben Shteinfeld
Resolution: Fixed Votes: 0
Labels: query-director-triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-75886 Make analyzeShardKey command return s... Closed
is depended on by SERVER-70994 Make analyzeShardKey command return t... Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-02-20, QE 2023-03-06, QE 2023-03-20, QO 2023-04-03, QO 2023-04-17
Participants:

 Description   

For SERVER-70994, we need an efficient way to look up the original values for the N most common shard key values from the hash values returned by the {$meta: "indexKey"} in this aggregation pipeline.



 Comments   
Comment by Githook User [ 10/Apr/23 ]

Author:

{'name': 'Ben Shteinfeld', 'email': 'ben.shteinfeld@mongodb.com', 'username': 'bshteinfeld'}

Message: SERVER-72814 Add $_internalEqHash MatchExpression
Branch: master
https://github.com/mongodb/mongo/commit/9fd56c17736f2e6557e5a91c6d607040ec191289

Comment by Charlie Swanson [ 16/Mar/23 ]

I'm throwing this up for triage once again after ratika.gandhi@mongodb.com flagged that there's an upcoming deadline catching me by surprise. I had been working on this in spare cycles but have other project work to prioritize for the same rc0 deadline. james.wahlin@mongodb.com or steve.tarzia@mongodb.com is there anyone who is not swamped who could maybe help get this over the line for the sharding team?

Comment by Ana Meza [ 01/Mar/23 ]

Charlie the team decided to leave this ticket on your queue and just add it to a future Sprint

Comment by Charlie Swanson [ 24/Feb/23 ]

Hi triager who is reading this. I am putting this back up for scheduling after investigating the complexity. I think the linked draft PR pretty much covers it, and this should be pretty straightforward to do. See my latest PR comment for the details, but essentially just review and more testing.

I'm happy to take this back assigned to me, but I am about to leave on vacation for a week, and then there's skunkworks, so wanted to give an opportunity for someone else to pick it up.

Generated at Thu Feb 08 06:22:53 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.