ElasticSearch索引基本查询语法_es查询索引的sql语句-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_28077405/article/details/80676578

本文介绍了ElasticSearch的基本操作，包括列出所有索引、删除索引、条件查询和复合查询。同时，详细展示了如何创建索引，设置分析器及映射字段，帮助理解ElasticSearch的查询语法和数据管理。

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

#列出所有索引

GET http://127.0.0.1:9200/_cat/indices?v

#删除索引

DELETE 索引名

# 条件查询

GET http://127.0.0.1:9200/索引/_search?pretty

{
"query": {
"bool": {
"must": [
{
"match": {

"tweet": "elasticsearch"

}
},
{
"match": {
"name": "zhangsan"
}
}
]
}
}

}

# 复合查询

GET http://127.0.0.1:9200/索引/_search?pretty
{
"bool": {
"must": { "match": { "tweet": "elasticsearch" },
"match": { "tweet": "elasticsearch" } },
"must_not": { "match": { "name": "mary" }},
"should": { "match": { "tweet": "full text" }},
"filter": { "range": { "age" : { "gt" : 30 }} }
}
}

创建索引

PUT /es_index
{
"settings": {
"analysis": {
"normalizer": {
"my_normalizer": {
"type": "custom",
"char_filter": [],
"filter": [
"lowercase",
"asciifolding"
]
}
}
}
},
"mappings": {
"myindex": {
"properties": {
"Id": {
"type": "keyword"
},
"code": {
"type": "keyword",
"normalizer": "my_normalizer"
},
"name": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fielddata":true,
"fields": {"keyword": {"type": "keyword"}}
},
"type": {
"type": "keyword"
},
"formId": {
"type": "keyword"
},
"lastEntryESDate": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
}
}
}
}