如何在Atlas Search中实现类似$geoNear的distanceField功能？

你可以通过以下两种方式在Atlas Search的聚合管道中获取文档到指定位置的距离，替代$geoNear的distanceField功能：

方法一：$search后追加$addFields+$geoDistance计算距离 #

先通过$search完成文本匹配、地理范围过滤和状态筛选，再用$geoDistance表达式计算每个结果到目标点的距离并添加为字段：

[
  {
    "$search": {
      "index": "searchResults",
      "compound": {
        "must": [
          {
            "text": {
              "query": `${req.body.query}`,
              "path": ["name", "description", "tag"],
              "fuzzy": {
                "maxEdits": 2,
                "prefixLength": 4
              }
            }
          },
          {                            
            "geoWithin": {
              "circle": {
                "center": {
                  "type": "Point",
                  "coordinates": [req.body.position.lng, req.body.position.lat]
                },
                "radius": req.body.distance,
              },
              "path": "location",
            }
          }
        ],
        "filter": [{
          "text": {
            "query": "Active",
            "path": "active",
          }
        }]
      }
    }
  },
  {
    "$addFields": {
      "dist.calculated": {
        "$geoDistance": {
          "near": {
            "type": "Point",
            "coordinates": [req.body.position.lng, req.body.position.lat]
          },
          "spherical": true,
          "path": "location"
        }
      }
    }
  }
]

方法二：$geoNear作为首阶段，后续追加$search过滤 #

如果业务允许先按地理范围筛选，再做文本搜索，可以将$geoNear放在聚合管道最前面（它必须是首阶段），然后用$search做文本和状态过滤：

[
  {
    "$geoNear": {
      "near": { 
        "type": "Point", 
        "coordinates": [req.body.position.lng, req.body.position.lat] 
      },
      "distanceField": "dist.calculated",
      "maxDistance": req.body.distance,
      "spherical": true
    }
  },
  {
    "$search": {
      "index": "searchResults",
      "compound": {
        "must": [
          {
            "text": {
              "query": `${req.body.query}`,
              "path": ["name", "description", "tag"],
              "fuzzy": {
                "maxEdits": 2,
                "prefixLength": 4
              }
            }
          }
        ],
        "filter": [{
          "text": {
            "query": "Active",
            "path": "active",
          }
        }]
      }
    }
  }
]

注意事项 #

• 方法一中的$geoDistance会基于文档的location字段和目标点计算球面距离，单位与你传入的req.body.distance一致（米）。
• 方法二需要确保$geoNear是聚合管道的第一个阶段，适合地理范围过滤后数据量较小的场景，能提升后续搜索的效率。

内容的提问来源于stack exchange，提问作者GT Thompson