sorting - 在Elasticsearch 2.4中按 child 数排序 parent (包括无子女)-6ren

sorting - 在Elasticsearch 2.4中按 child 数排序 parent (包括无子女)

转载作者：行者123 更新时间：2023-12-03 01:46:51

我试图按文档的子级数对结果进行排序，将没有子级的子级放在第一位(其次是order值)。

相关问题

Elasticsearch get all parents with no children

How to sort parents by number of children in Elasticsearch

根据这些答案，我设法使用 bool查询对文档进行了排序，以选择没有文档的文档，并使用boost将其评分为0，并计算其他文档的子级数量。

这在ES 5.3中可以正常工作，但是增强功能在ES 2.4(我需要使用)中似乎没有任何作用。而是使用 must_not的分数 bool。

是否有一种对no child进行计分以确保其返回0的替代方法？还是我可以确信 queryNorm在ES 2.4中将始终<1(似乎有风险，但这可能是无知...)？

制图

PUT parent_child
{
    "mappings": {
        "parent_doc": {
            "dynamic": "strict",
            "properties": {
                "parent_id": {
                    "type": "string",
                    "index": "not_analyzed"
                },
                "age": {
                    "type": "long"
                },
                "relationship_status": {
                    "type": "string",
                    "index": "not_analyzed"
                },
                "order": {
                    "type": "long"
                }
            }
        },
        "child_doc": {
            "dynamic": "strict",
            "_parent": {
                "type": "parent_doc"
            },
            "properties": {
                "parent_id": {
                    "type": "string",
                    "index": "not_analyzed"
                },
                "child_id": {
                    "type": "string",
                    "index": "not_analyzed"
                },
                "accommodation": {
                    "type": "string",
                    "index": "not_analyzed"
                }
            }
        }
    }
}

数据

PUT parent_child/parent_doc/0
{
    "parent_id": "p0",
    "age": 20,
    "relationship_status": "single",
    "order": 0
}

PUT parent_child/parent_doc/1
{
    "parent_id": "p1",
    "age": 33,
    "relationship_status": "married",
    "order": 1
}

PUT parent_child/child_doc/0?parent=0
{
    "parent_id": "p0",
    "child_id": "c0",
    "accommodation": "rent"
}

询问

GET parent_child/parent_doc/_search?explain=true
{
    "query": {
        "bool": {
            "should": [
                {
                    "has_child": {
                        "type": "child_doc",
                        "score_mode": "sum",
                        "query": {
                            "match_all": {}
                        }
                    }
                },
                {
                  "bool": {
                    "boost": 0,
                    "constant_score" : {
                        "must_not": [
                            {
                                "has_child": {
                                    "type": "child_doc",
                                    "query": {
                                      "match_all": {}
                                    }
                                }
                            }
                        ]
                    }
                  }
                }
            ],
            "minimum_should_match": 1,
            "disable_coord": true
        }
    },
    "sort" : [
        {"_score" : {"order" : "asc"}},
        {"order" : {"order" : "desc"}}
   ]
}

说明

在Boost 0的Elasticsearch 5.3中，我得到

{
  "took": 58,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": null,
    "hits": [
      {
        "_shard": "[parent_child][3]",
        "_node": "k-pLeatPSsaA8OXrcuLHqg",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "1",
        "_score": 0,
        "_source": {
          "parent_id": "p1",
          "age": 33,
          "relationship_status": "married",
          "order": 1
        },
        "sort": [
          0,
          1
        ],
        "_explanation": {
          "value": 0,
          "description": "sum of:",
          "details": [
            {
              "value": 0,
              "description": "sum of:",
              "details": [
                {
                  "value": 0,
                  "description": "ConstantScore(-GlobalOrdinalsQuery{joinField=_parent#parent_doc} +*:*), product of:",
                  "details": [
                    {
                      "value": 0,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 1,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 1,
                  "description": "*:*, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 1,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      },
      {
        "_shard": "[parent_child][0]",
        "_node": "k-pLeatPSsaA8OXrcuLHqg",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "0",
        "_score": 1,
        "_source": {
          "parent_id": "p0",
          "age": 20,
          "relationship_status": "single",
          "order": 0
        },
        "sort": [
          1,
          0
        ],
        "_explanation": {
          "value": 1,
          "description": "sum of:",
          "details": [
            {
              "value": 1,
              "description": "sum of:",
              "details": [
                {
                  "value": 1,
                  "description": "A match, join value 0",
                  "details": []
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 1,
                  "description": "_type:parent_doc, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 1,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ]
  }
}

在带有提升1(修改查询提升)的ES 5.3中，我得到了

{
  "took": 7,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": null,
    "hits": [
      {
        "_shard": "[parent_child][3]",
        "_node": "6WApYVoYSSaj3BeMwO1z_Q",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "1",
        "_score": 1,
        "_source": {
          "parent_id": "p1",
          "age": 33,
          "relationship_status": "married",
          "order": 1
        },
        "sort": [
          1,
          1
        ],
        "_explanation": {
          "value": 1,
          "description": "sum of:",
          "details": [
            {
              "value": 1,
              "description": "sum of:",
              "details": [
                {
                  "value": 1,
                  "description": "sum of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "*:*, product of:",
                      "details": [
                        {
                          "value": 1,
                          "description": "boost",
                          "details": []
                        },
                        {
                          "value": 1,
                          "description": "queryNorm",
                          "details": []
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 1,
                  "description": "*:*, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 1,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      },
      {
        "_shard": "[parent_child][0]",
        "_node": "6WApYVoYSSaj3BeMwO1z_Q",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "0",
        "_score": 1,
        "_source": {
          "parent_id": "p0",
          "age": 20,
          "relationship_status": "single",
          "order": 0
        },
        "sort": [
          1,
          0
        ],
        "_explanation": {
          "value": 1,
          "description": "sum of:",
          "details": [
            {
              "value": 1,
              "description": "sum of:",
              "details": [
                {
                  "value": 1,
                  "description": "A match, join value 0",
                  "details": []
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 1,
                  "description": "_type:parent_doc, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 1,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ]
  }
}

在带有加速0或1(或其他任何值)的ES 2.4中，我得到了

{
  "took": 63,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": null,
    "hits": [
      {
        "_shard": 3,
        "_node": "prwYMacQRLCOi_qDoVSmpA",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "1",
        "_score": 0.70710677,
        "_source": {
          "parent_id": "p1",
          "age": 33,
          "relationship_status": "married",
          "order": 1
        },
        "sort": [
          0.70710677,
          1
        ],
        "_explanation": {
          "value": 0.70710677,
          "description": "sum of:",
          "details": [
            {
              "value": 0.70710677,
              "description": "sum of:",
              "details": [
                {
                  "value": 0.70710677,
                  "description": "sum of:",
                  "details": [
                    {
                      "value": 0.70710677,
                      "description": "*:*, product of:",
                      "details": [
                        {
                          "value": 1,
                          "description": "boost",
                          "details": []
                        },
                        {
                          "value": 0.70710677,
                          "description": "queryNorm",
                          "details": []
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 0.70710677,
                  "description": "_type:parent_doc, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 0.70710677,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      },
      {
        "_shard": 0,
        "_node": "prwYMacQRLCOi_qDoVSmpA",
        "_index": "parent_child",
        "_type": "parent_doc",
        "_id": "0",
        "_score": 1,
        "_source": {
          "parent_id": "p0",
          "age": 20,
          "relationship_status": "single",
          "order": 0
        },
        "sort": [
          1,
          0
        ],
        "_explanation": {
          "value": 1,
          "description": "sum of:",
          "details": [
            {
              "value": 1,
              "description": "sum of:",
              "details": [
                {
                  "value": 1,
                  "description": "A match, join value 0",
                  "details": []
                }
              ]
            },
            {
              "value": 0,
              "description": "match on required clause, product of:",
              "details": [
                {
                  "value": 0,
                  "description": "# clause",
                  "details": []
                },
                {
                  "value": 0.70710677,
                  "description": "_type:parent_doc, product of:",
                  "details": [
                    {
                      "value": 1,
                      "description": "boost",
                      "details": []
                    },
                    {
                      "value": 0.70710677,
                      "description": "queryNorm",
                      "details": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ]
  }
}

最佳答案

这是在ES 2.4.3中对我有用的查询:

{
  "query": {
    "bool": {
      "should": [
        {
          "has_child": {
            "type": "child_doc",
            "score_mode": "sum",
            "query": {
              "match_all": {}
            }
          }
        },
        {
          "constant_score": {
            "boost": 0,
            "query": {
              "bool": {
                "must_not": [
                  {
                    "has_child": {
                      "type": "child_doc",
                      "query": {
                        "match_all": {}
                      }
                    }
                  }
                ]
              }
            }
          }
        }
      ],
      "minimum_should_match": 1,
      "disable_coord": true
    }
  },
  "sort": [
    {
      "_score": {
        "order": "asc"
      }
    },
    {
      "order": {
        "order": "desc"
      }
    }
  ]
}

关于sorting - 在Elasticsearch 2.4中按 child 数排序 parent (包括无子女)，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/43214141/

文章推荐： c# - 将音频信号从内存流分别拆分为帧。字节数组 [C#]

文章推荐： elasticsearch - 在ElasticSearch中如何过滤某些单词的结果集？

文章推荐： ios - 无法使用WKWebView通过XMLHttpRequest加载音频文件

django - 我可以在同一个 url 模式中包含两个不同的 url 吗？示例 [路径 ('api/' , 包括 ('quiz.urls' )), 路径 ('api/' , 包括 ('user.urls' )) ]
127.0.0.1:8000/api/仅包含来自第二个应用程序的 url，但我将两个 url 模块链接到相同的模式。甚至有可能做到这一点吗？第一个应用程序: from django.urls imp
ColdFusion 包括
我目前正在学习 ColdFusion。我有 PHP 背景，对此我有点困惑。我有一个选择菜单，我希望将选项保存在不同的文件中。 (例如 options.cfm)当我调用文件时，我想在选择菜单中包含选项
java正则表达式删除数字，包括，
字符串: "75,000", "is", "95%", "or", "95/100" "of", "monthly", "income" o/p: "is","%, "or", "/", "of",
JavaScript 包括
我有 4 个 javascript 文件(每个文件对应一个 HTML 文件)，所有 4 个文件中的 3 个函数都是相同的。我想找到一个顺利的解决方案，我可以以某种方式分别包含这 3 个函数...是否可
php - 包括/要求路径解析
我在 PHP 中有这种情况，其中 include在一台服务器上被遗漏，但在另一台服务器上没有(我没有设置服务器，所以我不能告诉你更多；我不是真正的 devops 人，所以这就是我在这里问的原因)。两台
xsd - 包括/导入具有命名空间的本地模式
这是一个模式文件，midi.xsd定义类型，note ，用于存储 MIDI 音符值: 这是另一个模式文件，octaves.xsd使用
备份多个文件夹(包括/不包括)
我想备份以下文件夹 /home /etc /usr/local /root /var /boot 并排除 /var/tmp /var/run /var/lock /home/*/.thumbnails
重新编码具有许多值的数值变量，包括 NA
如何重新编码具有许多值(包括缺失值)的数值变量，以获得数字 0:n-1哪里n是唯一值的数量，包括 NA ，整齐？例子: df 1 1000 0 2 1000 0 3 N
JQuery:选择一个元素的html，包括？
选择元素的 html(包括在内)的最佳方法是什么？例如: This is just a test. 而$('#testDiv').html()返回"This is just a test."
未处理ESI的 Varnish 包括
我正在尝试设置Varnish来处理本地环境中的ESI包含。我在虚拟机中运行 Varnish ，内容在主机上运行。我有两个文件“index.html”和“test.html”。它们都存储在apach
xml - 使用XPath表达式获取XML中的非空元素，包括
我有以下内容，并且想要检索“ FromEmail”不为空的数据 Simple email@gma
PHP "Global"包括
欧海，我正在编写一个小型 PHP 应用程序，使用一个单独的 config.php 文件和一个functions.php，其中包含我将在应用程序中使用的所有自定义函数。现在，我真的必须在每个函数中包含
javascript - 包括 JavaScript
我知道可以将 JavaScript 放在一个特定的 .js 文件中，然后通过执行以下操作将其包含在任何页面中...... 我注意到，对于包含的这些 .js 文件: 它们实际上不必以 .js 结尾其
java - 包括 & 在我的组合框中
我使用 gwt UIBinder 添加了一些项目到我的 ComboBox。 --select one-- Dispute Referral Form Dispute Settlement Clause
c - 包括.c文件c程序
我可以将一个 first.c 文件包含到另一个 second.c 中吗？ (我正在做一些套接字编程，以将服务器收到的消息存储在链接列表中，因此在第一个程序中，我尝试保留链接列表和第二个程序套接字编程文
java - 包括 NOT IN 条件下的省略记录
我有一个简单的 Spring MVC 数据项目设置，我试图选择 Admin 中尚不存在的用户列表。 table 。这是我的存储库方法 SELECT u FROM User u WHERE u.id N
bash - 删除两个定界符之间的字符串，包括
在 bash 脚本中，使用什么实用程序以及如何删除两个字符串之间的文本，包括字符串。原文: (ABC blah1)blah 2(def blah 5)blah 7)(DEF blah 8)blah
Java - 包括 BST
我有这个 BST 问题，我试图用 Java 解决，但我不知道为什么它不起作用。问题是: 二叉搜索树 (BST) 是一种二叉树，其中每个值节点大于或等于该节点的所有节点中的值左子树并且小于该树中所有节点
java替换字符串中的多个字符，包括 "\u00A2"
我有一个字符串，其中包含“Dollars”和“Cents”符号。我想删除它们。我试过了 string.replaceAll("[\"\\u00A2\" $]", "") 但它不起作用。正确的做法是什么
mysql - 按标签搜索，包括
我在 stories 和 tags 之间有一个多对多的关系，为保存关系而创建的表是 taxonomies。我想搜索所有具有所有给定标签的故事。到目前为止我使用的查询是这个，当然它对我不起作用，它返回

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

sorting - 在Elasticsearch 2.4中按 child 数排序 parent (包括无子女)