ElasticSearch使用说明
...约 381 字大约 1 分钟
1. 索引 index,相当于数据库表Table
1.1 查看所有索引
GET _cat/indices?v
1.2 创建索引字段映射关系
PUT /test
{
"settings": {
"number_of_shards": 1,
"number_of_replicas": 0
},
"mappings": {
"properties": {
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"age": {
"type": "long"
},
"address": {
"type": "keyword"
},
"birthday": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis"
}
}
}
}
1.3 获取索引信息
# 获取所有信息
GET /test
# 获取设置信息
GET /test/_settings
# 获取映射关系
GET /test/_mappings
1.4 添加索引字段
POST /test/_mappings
{
"properties": {
"remark": {
"type": "text"
}
}
}
1.5 删除索引
DELETE /test
2. 文档 doc,相当于数据行Row
2.1 添加数据
POST test/_doc
{
"name": "dennis",
"age": "18",
"birthday": "2022-09-27 11:28:06",
"address": "上海市杨浦区隆昌路666号"
}
2.2 修改数据(全量)
PUT test/_doc/<id>
{
"name": "dennis1",
"age": "188",
"birthday": "2022-09-27 11:28:06",
"address": "上海市杨浦区隆昌路888号"
}
2.3 修改数据(局部)
POST test/_update/<id>
{
"doc": {
"name": "上海",
"age": "20"
}
}
2.4 删除数据
DELETE /test/_doc/<id>
2.5 查询全部数据
GET test/_search
{
"query": {
"match_all": {}
}
}
2.6 分词查询(text类型的字段才支持分词查询)
GET test/_search
{
"query": {
"match": {
"name": "海"
}
}
}
2.7 精确查询
GET test/_search
{
"query": {
"match": {
"name.keyword": "上海"
}
}
}
3. 复合查询
3.1 多条件查询(and)
GET test/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"name": {
"value": "dennis"
}
}
},
{
"query_string": {
"default_field": "address",
"query": "上海"
}
}
]
}
}
}
3.2 多条件查询(or)
GET test/_search
{
"query": {
"bool": {
"should": [
{
"term": {
"name": {
"value": "dennis"
}
}
},
{
"query_string": {
"default_field": "address",
"query": "is"
}
}
]
}
}
}
3.3 分组查询
# 汇总条目
GET test/_search
{
"aggs": {
"age_group": {
"terms": {
"field": "age"
}
}
},
"size": 0
}
# 平均值
GET test/_search
{
"aggs": {
"age_group": {
"avg": {
"field": "age"
}
}
},
"size": 0
}
Powered by Waline v2.15.6