准备:
- ElasticSearch 版本 6.7.0(本次使用的是基于阿里云托管服务)
- kibana 的 控制台访问权限(用于执行本次的查询命令)
数据展示:
- 查询全部
GET /indices/sensor/_search
{
"query": {
"match_all": { }
}
}
- 精准匹配 并按时间进行排序 asc 和 desc
GET /indices/sensor/_search
{
"query": {
"match": {
"mac": "123"
}
},
"sort": [
{
"startDt.keyword": {
"order": "desc"
}
}
]
}
- 精准匹配 从0开始取两条 并按时间进行排序 asc 和 desc
GET /indices/sensor/_search
{
"query": {
"match": {
"mac": "123"
}
},
"from": 0,
"size": 2,
"sort": [
{
"startDt.keyword": {
"order": "desc"
}
}
]
}
- 指定查询结果的字段
GET /indices/sensor/_search
{
"query": {"match_all": {}},
"_source": ["mac","startDt"]
}
- 指定匹配字段的value,根据时间范围检索,升序
GET /indices/sensor/_search
{
"query": {
"bool": {
"must":{
"match": {
"mac": "123"
}
},
"filter": {
"range": {
"startDt.keyword": {
"gte": "2018-03-13 16:00:000.000",
"lte": "2018-03-13 21:00:000.000"
}
}
}
}
},
"sort": [
{
"startDt.keyword": {
"order": "asc"
}
}
]
}
- 多条件检索过滤
GET /indices/sensor/_search
{
"query": {
"bool": {
"must": [
{"match": {
"mac": "123"
}}
],
"filter": {
"range": {
"status": {"gte": 0}
}
}
}
},
"sort": [
{
"status": {
"order": "desc"
}
}
]
}