Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-30359

Add a more generalized $hash expression

    XMLWordPrintable

Details

    • Query 2019-08-12

    Description

      We added $toHashedIndexKey in SERVER-49214 which solves some similar use cases, and some described below in the original description and comments. This ticket remains open to add a more general hash expression - perhaps for more cryptographic use cases, or if someone wants/needs a particular algorithm.

      Original Description

      Oracle has http://docs.oracle.com/database/121/SQLRF/functions183.htm#SQLRF55647 which computes one of several standard hash functions on a particular column.

      It would be nice if there was analogous expression in agg:

      hashMD5:{$hash:{source:"$expression", function:"MD5"}}
      

      or something like that.

      Attachments

        Issue Links

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              asya.kamsky@mongodb.com Asya Kamsky
              Votes:
              16 Vote for this issue
              Watchers:
              21 Start watching this issue

              Dates

                Created:
                Updated: