Make analyzeShardKey command return shard key values correctly when the supporting index is hashed

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • ALL
    • v7.0
    • Sharding NYC 2023-04-17
    • 51
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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.

            Assignee:
            Cheahuychou Mao
            Reporter:
            Cheahuychou Mao
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: