elasticsearch cardinality 多字段联合唯一，以及如何访问runtime_fields

会飞的尼古拉斯

已于 2023-03-17 11:13:23 修改

阅读量715

点赞数

分类专栏： elasticsearch 文章标签： elasticsearch 大数据搜索引擎

于 2023-03-17 10:56:43 首次发布

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

版权

elasticsearch 专栏收录该内容

38 篇文章 1 订阅

订阅专栏

我们都知道cardinality 默认情况下只能传入一个字段，用来计算这一个字段的唯一值
形如下

PUT ellisintstring/
{
  "mappings": {
    "properties": {
      "ceshi":{
        "type": "nested"
      }
    }
  }
}

PUT ellisintstring/_doc/1
{
  "ceshi":{
    "item":"0001",
    "shuju":"haha"
  }
}

PUT ellisintstring/_doc/2-10
{
  "ceshi":{
    "item":"0401",
    "shuju":"haha"
  }
}

PUT ellisintstring/_doc/11
{
  "ceshi":{
    "item":"0014",
    "shuju":"haha5"
  }
}

字段唯一值查询

GET ellisintstring/_search
{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "haha": {
      "nested": {
        "path": "ceshi"
      },"aggs": {
        "distinct": {
          "cardinality": {
            "field": "ceshi.item.keyword"
          }
        }
      }
    }
  }
}

现在想多字段联合唯一

GET ellisintstring/_search
{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "haha": {
      "nested": {
        "path": "ceshi"
      },"aggs": {
        "distinct": {
          "cardinality": {
            "script": {
              "inline": "doc['ceshi.item.keyword'].value+doc['ceshi.shuju.keyword'].value"
            }
          }
        }
      }
    }
  }
}

针对item 以及shuju字段做两个runtime 字段，根据这两个字段求唯一值

GET ellisintstring/_search
{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "haha": {
      "nested": {
        "path": "ceshi"
      },"aggs": {
        "distinct": {
          "cardinality": {
            "script": {
              "inline": "doc['ii'].value+doc['ss'].value"
            }
          }
        }
      }
    }
  },
  "runtime_mappings":{
    "ii":{
      "type":"keyword",
      "script":{
        "source":"""
        emit(doc["ceshi.item.keyword"].value.substring(0, 1))
        """
      }
    },
    "ss":{
      "type":"keyword",
      "script":{
        "source":"""
        emit(doc["ceshi.shuju.keyword"].value.substring(0, 1))
        """
      }
    }
    }
}