三、Elasticsearch 简单数据分析

先将文本 field 的 fielddata 属性设置为 true

- Elasticsearch 5.x 版本写法
PUT /ecommerce/_mapping/product

- Elasticsearch 7.x 版本写法
PUT /ecommerce/_mapping/product?include_type_name=true
{
    "properties": {
        "tags": {
            "type": "text",
            "fielddata": true
        }
    }
}

注意: es 不同版本之间语法存在差异

计算每个商品tag下的商品数量(分组求和)

GET /ecommerce/product/_search
{
    "size": 0,
    "aggs": {
        "group_by_tags": {
            "terms": {
                "field": "tags"
            }
        }
    }
}

size 控制元数据返回的数目，0 则不返回元数据

对名称中包含 yagao 的商品，计算每个 tag 下的商品数量

GET /ecommerce/product/_search
{
    "size": 0,
    "query": {
        "match": {
            "name": "yagao"
        }
    },
    "aggs": {
        "group_by_tags": {
            "terms": {
                "field": "tags"
            }
        }
    }
}

计算每个 tag 下的商品平均价格

GET /ecommerce/product/_search
{
    "size": 0,
    "aggs": {
        "group_by_tags": {
            "terms": {
                "field": "tags"
            },
            "aggs": {
                "avg_price": {
                    "avg": {
                        "field": "price"
                    }
                }
            }
        }
    }
}

计算每个 tag 下的商品平均价格,并将结果按照平均价格降序排序

GET /ecommerce/product/_search
{
    "size": 0,
    "aggs": {
        "group_by_tags": {
            "terms": {
                "field": "tags",
                "order": {
                    "avg_price": "asc"
                }
            },
            "aggs": {
                "avg_price": {
                    "avg": {
                        "field": "price"
                    }
                }
            }
        }
    }
}

按照指定的价格范围区间进行分组，然后在每组内在按照tag进行分组，最后再计算每组的平均价格

GET /ecommerce/product/_search
{
    "size": 0,
    "aggs": {
        "group_by_price": {
            "range": {
                "field": "price",
                "ranges": [
                    {
                        "from": 0,
                        "to": 20
                    },
                    {
                        "from": 20,
                        "to": 40
                    },
                    {
                        "from": 40,
                        "to": 60
                    }
                ]
            },
            "aggs": {
                "group_by_tags": {
                    "terms": {
                        "field": "tags"
                    },
                    "aggs": {
                        "avg_price": {
                            "avg": {
                                "field": "price"
                            }
                        }
                    }
                }
            }
        }
    }
}