Elasticsearch | 04 基本语句和SQL支持_es的swl支持-优快云博客

本文档详细介绍了Elasticsearch的基本语句，包括索引创建、数据增删改查、批量操作以及SQL查询的支持。同时展示了如何进行排序、过滤字段、分页查询等操作，还涉及到了分词引擎分析和不同查询类型的应用。此外，文中还提及了使用Elasticsearch进行日志监控和健康检查的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

Elasticsearch | 03 基本语句和SQL支持

Elasticsearch | 03 基本语句和SQL支持

POST /account/_bulk
{"index":{"_id":"1"}}
{"account_number":1,"balance":39225,"firstname":"Amber","lastname":"Duke","age":32,"gender":"M","address":"880 Holmes Lane","employer":"Pyrami","email":"amberduke@pyrami.com","city":"Brogan","state":"IL"}
{"index":{"_id":"6"}}
{"account_number":6,"balance":5686,"firstname":"Hattie","lastname":"Bond","age":36,"gender":"M","address":"671 Bristol Street","employer":"Netagy","email":"hattiebond@netagy.com","city":"Dante","state":"TN"}

在这里插入图片描述

POST /_sql?format=txt
{
  "query": "SELECT account_number,firstname ,lastname, age, balance, address FROM account LIMIT 10"
}

在这里插入图片描述

# 查看健康状态
GET /_cat/health?format=json

# 查看节点信息
GET /_cat/nodes?format=json

# 创建index
PUT /test

# 删除index及数据
DELETE /test
DELETE /es_event
DELETE /account
DELETE /book-index

# 查看index列表
GET /_cat/indices?format=json

# 新增/覆盖数据
PUT /test/_doc/1
{
  "name": "jack word",
  "age":22
}

# 查询数据
GET /test/_doc/1
# 删除数据
DELETE /test/_doc/1

# 新增/更新某字段数据
POST /test/_doc/1/_update
{
  "doc":{"nick": "John"}
}

# 查询index的mapping
GET /test/_mapping

# 查询index分页数据
GET /test/_search
{
  "query": { "match_all": {} },
  "from": 0,
  "size": 2
}

# 排序
GET /test/_search
{
  "query": { "match_all": {} },
  "sort": [
    { "age": "asc" }
  ],
  "from":0,
  "size":10
}

# 过滤字段
GET /test/_search
{
  "query": { "match_all": {} },
  "_source": ["age", "name"]
}

# 批量创建
POST /customer/_doc/_bulk
{"index":{"_id":"3"}}
{"name": "John Doe3" }
{"index":{"_id":"4"}}
{"name": "Jane Doe4" }

# 批量更新、删除
POST /customer/_doc/_bulk
{"update":{"_id":"1"}}
{"doc": { "name": "John Doe becomes Jane Doe" } }
{"delete":{"_id":"2"}}

# 使用SQL查询
POST /_sql?format=txt
{
  "query": "SELECT eleId,eleCode,eleType,eleName,eleContent FROM element LIMIT 10"
}

# 分词引擎分析
POST _analyze
{
  "analyzer": "ik_smart",
  "text": "pafcmall电商项目"
}

# match查询
GET /test/_search
{
    "query" : {
        "match" : { "name" : "word" }
    }
}

# term查询
GET /test/_search
{
    "query" : {
        "term" : { "name" : "word" }
    }
}