[SERVER-75886] Make analyzeShardKey command return shard key values correctly when the supporting index is hashed Created: 10/Apr/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: Bug Priority: Major - P3
Reporter: Cheahuychou Mao Assignee: Cheahuychou Mao
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
depends on SERVER-72814 Support looking up original values fr... Closed
Related
is related to SERVER-70994 Make analyzeShardKey command return t... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v7.0
Sprint: Sharding NYC 2023-04-17
Participants:
Linked BF Score: 51

 Description   

Currently, when the supporting index for the shard key is hashed, the "mostCommonValues" metrics returned by analyzeShardKey command would contain the hashed values instead of the original values. This is because the aggregation pipeline for calculating the metrics uses the $meta key stage. SERVER-72814 will provide us with a way to looking documents from the hashed field values.



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

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-75886 Make analyzeShardKey command return shard key values correctly when the supporting index is hashed

(cherry picked from commit 1cbff166af8ac11c633613973dbbd714a0ede6b4)
Branch: v7.0
https://github.com/mongodb/mongo/commit/484133efdb75abaa2f9d4837c3c85683f92683e9

Comment by Githook User [ 12/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-75886 Add cardinality_and_frequency_basic.js to backports_required_for_multiversion_tests.yml
Branch: master
https://github.com/mongodb/mongo/commit/3584c503a4d4f2df0d8dce7a18deffd4ef59f25f

Comment by Githook User [ 11/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-75886 Make analyzeShardKey command return shard key values correctly when the supporting index is hashed
Branch: master
https://github.com/mongodb/mongo/commit/1cbff166af8ac11c633613973dbbd714a0ede6b4

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