elasticsearch常用的http操作

1、创建mapping

  PUT /my_index_name1/

{
  "settings": {
    "index": {
      "number_of_shards": "3",
      "number_of_replicas": "0",
      "max_result_window": 100000
    }
  },
  "mappings": {
    "_doc": {
      "properties": {
        "id": {
          "type": "keyword",
          "index": "true"
        },
        "name": {
          "type": "text",
          "index": "true",
          "fields": {
            "keyword": {
              "ignore_above": 256,
              "type": "keyword"
            }
          }
        },
        "date_time": {
          "type": "date",
          "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis",
          "index": "true"
        },
        "children": {
          "type": "nested",
          "properties": {
            "id": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "children_ids": {
          "type": "keyword"
        }
      }
    }
  }
}

2、term查询、range查询、bool查询、分页、排序

POST http://localhost:9200/my_index_name2/   _search

{
  "from": 0,
  "size": 10,
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "is_delete": {
              "value": 0,
              "boost": 1
            }
          }
        },
        {
          "range": {
            "date_time": {
              "from": "2022-09-12 09:19:07",
              "to": null,
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "version": true,
  "sort": [
    {
      "date_time": {
        "order": "desc"
      }
    }
  ]
}

3、聚合操作

{
  "from": 0,
  "size": 1,
  "query": {
    "range": {
      "date_time": {
        "from": "2022-09-12 09:48:59",
        "to": null,
        "include_lower": true,
        "include_upper": true,
        "boost": 1
      }
    }
  },
  "version": true,
  "aggregations": {
    "groupCount": {
      "terms": {
        "field": "group_col",
        "size": 10,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          {
            "_count": "desc"
          },
          {
            "_key": "asc"
          }
        ]
      }
    }
  }
}

4、must存在查询

{
  "from": 0,
  "size": 10,
  "query": {
    "bool": {
      "must": [
        {
          "exists": {
            "field": "children_ids",
            "boost": 1
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "version": true,
  "sort": [
    {
      "date_time": {
        "order": "desc"
      }
    }
  ]
}

5、must、should与通配符查询

{
  "from": 0,
  "size": 10,
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "pub_time": {
              "from": null,
              "to": 1663035144435,
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        }
      ],
      "should": [
        {
          "wildcard": {
            "name1.keyword": {
              "wildcard": "*Tax and digital*",
              "boost": 1
            }
          }
        },
        {
          "wildcard": {
            "name1.keyword": {
              "wildcard": "*Tax and digital*",
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "minimum_should_match": "1",
      "boost": 1
    }
  },
  "version": true,
  "sort": [
    {
      "date_time": {
        "order": "desc"
      }
    }
  ]
}

6、date_histogram nested_group

{
  "from": 0,
  "size": 0,
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "date_time": {
              "from": 1627747200000,
              "to": null,
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        },
        {
          "range": {
            "date_time": {
              "from": null,
              "to": 1667145600000,
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "version": true,
  "aggregations": {
    "nested_property_group": {
      "nested": {
        "path": "property"
      },
      "aggregations": {
        "property_group": {
          "terms": {
            "field": "property.id",
            "size": 1000,
            "min_doc_count": 1,
            "shard_min_doc_count": 0,
            "show_term_doc_count_error": false,
            "order": [
              {
                "_count": "desc"
              },
              {
                "_key": "asc"
              }
            ]
          },
          "aggregations": {
            "property_day_group": {
              "date_histogram": {
                "field": "date_time",
                "format": "MM-dd",
                "interval": "1d",
                "offset": 0,
                "order": {
                  "_key": "asc"
                },
                "keyed": false,
                "min_doc_count": 0
              }
            }
          }
        }
      }
    }
  }
}