是否可以在ElasticSearch文档中过滤掉数组中的对象？

polhcujo 于 7个月前发布在 ElasticSearch

关注(0)|答案(1)|浏览(73)

对于这样的文档：

{
    {
        "id": 1,
        "vehicle": "car",
        "equipment": [
            {
                "v_id": 11,
                "gps": false,
                "color": "yellow"
            }
        ]
    },
    {
        "id": 2,
        "vehicle": "bus",
        "equipment": [
            {
                "v_id": 34,
                "gps": false,
                "color": "red"
            },
            {
                "v_id": 99,
                "gps": false,
                "color": "yellow"
            },
            {
                "v_id": 10,
                "gps": true,
                "color": "red"
            }
        ]
    }
}

字符串
是否可以同时检索vehicle: bus和vehicle: car文档，然后在此基础上过滤掉不必要的equipment？
例如，搜索巴士和汽车的预期结果，但结果中仅包含equipment和gps: true。

{
    {
        "id": 1,
        "vehicle": "car",
        "equipment": []
    },
    {
        "id": 2,
        "vehicle": "bus",
        "equipment": [
            {
                "v_id": 10,
                "gps": true,
                "color": "red"
            }
        ]
    }
}

型

elasticsearch

来源：https://stackoverflow.com/questions/77399059/is-it-possible-to-filter-out-objects-of-an-array-in-elasticsearch-documents

1条答案

按热度按时间

wfveoks01#

如果设备的类型为nested，您可以添加一个伪nested查询，它将执行inner_hits检索：

DELETE test

PUT test
{
  "mappings": {
    "properties": {
      "id": {
        "type": "long"
      },
      "vehicle": {
        "type": "keyword"
      },
      "equipment": {
        "type": "nested",
        "properties": {
          "v_id": {
            "type": "long"
          },
          "gps": {
            "type": "boolean"
          },
          "color": {
            "type": "keyword"
          }
        }
      }
    }
  }
}

PUT test/_bulk?refresh
{"index":{"_id": 1}}
{"id":1,"vehicle":"car","equipment":[{"v_id":11,"gps":false,"color":"yellow"}]}
{"index":{"_id": 2}}
{"id":2,"vehicle":"bus","equipment":[{"v_id":34,"gps":false,"color":"red"},{"v_id":99,"gps":false,"color":"yellow"},{"v_id":10,"gps":true,"color":"red"}]}

POST test/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "terms": {
            "vehicle": [
              "bus",
              "car"
            ]
          }
        },
        {
          "nested": {
            "path": "equipment",
            "query": {
              "term": {
                "equipment.gps": true
              }
            },
            "inner_hits": {}
          }
        }
      ]
    }
  },
  "_source": {
    "excludes": "equipment"
  }
}

字符串

赞(0）回复(0）举报 7个月前

我来回答

是否可以在ElasticSearch文档中过滤掉数组中的对象？

1条答案

相关问题

热门标签

最新问答