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

Add a more generalized $hash expression

    • Query Optimization
    • Query 2019-08-12

      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.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            asya.kamsky@mongodb.com Asya Kamsky
            Votes:
            16 Vote for this issue
            Watchers:
            23 Start watching this issue

              Created:
              Updated: