Elasticsearch增删改查、count、sum、group by、order by、like

最新推荐文章于 2024-05-02 21:32:21 发布

VIP文章刨冰雨

最新推荐文章于 2024-05-02 21:32:21 发布

阅读量1.3k

点赞数

分类专栏： Elasticsearch 文章标签： elasticsearch 聚合查询

本文链接：https://blog.csdn.net/andy20050125/article/details/128167286

版权

1、查找所有索引

GET index/_mapping
{
   }

2、查询

GET index/type/_search
{
   }

3、count

GET index/type/_count
{
   }

4、查询SQL:

where application = "service-client"
and name = "gauge.response.star-star.favicon.ico"
and timestamp <= "2017-08-18T20:25:11.000Z"
order by value desc

{
   
  "size": 10,
  "sort": [
    {
   
      "value": "desc"
    },
    "_score"
  ],
  "query": {
   
    "bool": {
   
      "must": [
        {
   
          "match": {
   
            "application.keyword": {
   
              "query": "nb-service-client"
            }
          }
        },
        {
   
          "match": {
   
            "name.keyword": {
   
              "query": "gauge.response.star-star.favicon.ico"
            }
          }
        },
        {
   
          "range": {
   
            "timestamp": {<