Elasticsearch:数组的交集

Question

假设我的文档是这样的

{
    "salary": {
        "max": 1572,
        "min": 682
    },
    "skills": [
        "Modula-3",
        "Max/MSP",
        "Arduino",
        "SPARK",
        "PL/SQL",
        "Processing",
        "Go",
        "Mathematica",
        "Modula-2",
        "IDL",
        "Heron",
        "Scheme"
    ],
    "company": "Merck",
    "experience": 0,
    "role": "Airport Security Screener",
    "cities": [
        "Ahmedabad",
        "Mangaluru",
        "Malegaon",
        "Bokaro Steel City",
        "Vadodara",
        "Kollam"
    ]
}

我想做一个查询，在这个查询中，我将提供一组城市，并根据交叉点的基数获得排序的文档。也就是说，假设我的城市集合是["Ahmedabad", "Mangaluru"]，那么这个查询与上面的文档的交集基数是2。我的查询应该是什么？

样例响应

{"_score": 4.0202227, "cities": ["Ahmedabad","Mangaluru","Visakhapatnam", "Vijayawada"]}
{"_score": 2.27, "cities": ["Ahmedabad","Visakhapatnam", "Vijayawada"]}
{"_score": 1.79, "cities": ["Mangalauru","Vijayawada", "delhi", "bombay"]}

我使用的是elasticsearch 5.2.2

Answer 1

也许像这样的东西会对你有帮助？

{
  "query": {
    "function_score": {
      "query": {
        "match": {
          "cities": "Ahmedabad Mangaluru"
        }
      },
      "functions": [
        {
          "filter": {
            "match": {
              "cities": "Ahmedabad"
            }
          },
          "weight": 1
        },
        {
          "filter": {
            "match": {
              "cities": "Mangaluru"
            }
          },
          "weight": 1
        }
      ],
      "score_mode": "sum"
    }
  }
}