查询某个索引下面的所有数据
GET /trace/_search?q=*
一、基本概念
Index – 相当于mysql 中的database
Type – 相当于mysql中的table
Document – 相当于mysql中的Row
Field – 相当于mysql中的Column
Mapping 相当于mysql中的Schema
注:
Elasticsearch提供api接口进行查询
二、查询操作
2.1 查询所有
GET /serverlog_20190820/_search
{
"query":{
"match_all":{
}
}
}
2.2 根据id查询 get index/type/_id (方法一)
get serverlog_20181217/log/Hwt1u2cBAwaWi2qJbDV4
2.2.1 条件查询 (方法二)
GET /serverlog_20190816/_search
{
"query":{
"match":{
"caller":"18656059551"
}
}
}
2.3 查询返回指定字段
GET _search
{
"_source":[
"utm",
"ctm"
],
"query":{
"match":{
"logtype":"llbxinterface"
}
}
}
2.4 复合条件查询
GET _search
{
"_source":[
"retcode",
"ctm",
"cmd"
],
"query":{
"bool":{
"must":[
{
"match":{
"cmd":"get_fee_transfer_content_data"
}
},
{
"match":{
"retcode":"000000"
}
}
]
}
}
}
2.5 查询后按某字段倒序
GET /serverlog_20191219/_search
{
"query":{
"match_all":{
}
},
"sort":[
{
"ctm":"desc"
}
]
}
2.6 按时间范围查询
GET _search
{
"_source":[
"retcode",
"ctm",
"cmd"
],
"query":{
"bool":{
"must":[
{
"match":{
"cmd":"get_fee_transfer_content_data"
}
},
{
"range":{
"ctm":{
"gte":"2018-12-17 17:24:14.677",
"lte":"2018-12-17 17:24:14.678"
}
}
}
]
}
},
"sort":[
{
"ctm":"desc"
}
]
}
2.7 查询指定返回数据数量
GET _search
{
"size":20,
"query":{
"bool":{
"must":[
{
"match":{
"logtype":"lxaiui"
}
}
]
}
},
"sort":[
{
"ctm":"desc"
}
]
}
2.8 查询–聚合查询
GET _search
{
"size":20,
"_source":[
"retcode",
"ctm",
"utm"
],
"query":{
"bool":{
"must":[
{
"match":{
"logtype":"lxaiui"
}
},
{
"range":{
"ctm":{
"gte":"2018-12-19 09:35:00.000",
"lte":"2018-12-19 09:40:00.000"
}
}
}
]
}
},
"aggs":{
"avg_utm":{
"avg":{
"field":"utm"
}
}
},
"sort":[
{
"ctm":"desc"
}
]
}
三、删除操作
3.1 删除索引
DELETE /serverlog_20190820
四、修改操作
4.1 根据id修改某字段 – 修改index/type/_id/_source 文档的retcode字段
POST serverlog_20181217/log/Hwt1u2cBAwaWi2qJbDV4/_update
{
"script":"ctx._source.retcode = '000000'"
}
4.2 根据id修改某字段 – 修改index/type/_id/_source 文档的retcode字段
POST serverlog_20181217/log/Hwt1u2cBAwaWi2qJbDV4/_update
{
"doc":{
"retcode":"000110"
}
}
4.3 更新多个字段
POST serverlog_20181218/log/CQ4nv2cBAwaWi2qJH5ur/_update
{
"doc":{
"retcode":"000110",
"ctm":"2018-12-19 15:34:59.287"
}
}
5 插件安装
git clone git://github.com/mobz/elasticsearch-head.git
cd elasticsearch-head
npm install
npm run start
访问 http://localhost:9100/ 就可以访问了
5查看集群
查看集群健康值
curl -i -X GET http://127.0.0.1:9200/_cluster/health```
查看集群状态
```shell
curl -i -X GET http://127.0.0.1:9200/_cluster/state|
查看集群统计
curl -i -X GET http://127.0.0.1:9200/_cluster/stats
查看集群节点信息
curl -i -X GET http://127.0.0.1:9200/_nodes
查看节点统计
curl -i -X GET http://127.0.0.1:9200/_nodes/stats
6其他:
curl http://127.0.0.1:9200/_cat/indices
curl http://127.0.0.1:9200/jaeger-dependencies-2020-04-10/_search
创建用户
参考: https://www.cnblogs.com/jassa/p/12554135.html