elasticsearch nested terms取唯一值以及composite

会飞的尼古拉斯

已于 2022-12-06 18:20:54 修改

阅读量542

点赞数

分类专栏： elasticsearch 文章标签： elasticsearch 大数据

于 2022-12-04 20:46:41 首次发布

本文链接：https://blog.csdn.net/weixin_43632687/article/details/128177072

版权

elasticsearch 专栏收录该内容

38 篇文章 1 订阅

订阅专栏

创建索引

PUT ellis
{
  "mappings": {
    "properties": {
      "test":
      {
        "type": "nested"
      }
    }
  }
}

插入数据

PUT ellis/_doc/1
{
  "test":{
    "a":"a1",
    "b":"b1"
  }
}


PUT ellis/_doc/2
{
  "test":{
    "a":"a1",
    "b":"b2"
  }
}


PUT ellis/_doc/3
{
  "test":{
    "a":"a3",
    "b":"b2"
  }
}

对test 的a字段取唯一值

GET ellis/_search
{
  "aggs": {
    "Nesting": {
      "nested": {
        "path": "test"
      },
      "aggs": {
        "NAME": {
          "terms": {
            "field": "test.a.keyword"
          }
        }
      }
    }
  },
  "size": 0
}

composite

GET ellis/_search
{
  "aggs": {
    "Nesting": {
      "nested": {
        "path": "test"
      },
      "aggs": {
        "yourname":
        {
          "composite": {
            "sources": [
              {
                "a": {
                  "terms": {
                    "field": "test.a.keyword"
                  }
                }
              }
            ]
            , "size": 1,
            "after": {
              "a":"a1"
            }
          }
        }
      }
    }
  },
  "size": 0
}

多键组合求唯一值

GET ellis/_search
{
  "aggs": {
    "Nesting": {
      "nested": {
        "path": "test"
      },
      "aggs": {
        "yourname":
        {
          "composite": {
            "sources": [
              {
                "a": {
                  "terms": {
                    "field": "test.a.keyword"
                  }
                }
              },
              {
                "b": {
                  "terms": {
                    "field": "test.b.keyword"
                  }
                }
              }
            ]
            , "size": 10
            
          }
        }
      }
    }
  },
  "size": 0
}