============ select * from table t where app_sessionId = "xxx" and name is null sort by log_tome desc limit 1; =============================================
GET /online-iteach-front-web-log-2021/_search
{
"query": {
"bool": {
"must": [
{
"match":{
"app_sessionId":"CJ9QGFCtfrnZKKI1PSBL3pXxBXpP5zpH"
}
}],
"must_not":[
{
"exists": {
"field": "name"
}
}
]
}
},
"sort":[{"log_time":"desc"}],
"size":1
}
=================select * from table t where app_sessionId = "xxx" and name is not null sort by log_tome desc limit 1;========================================
GET /online-iteach-front-web-log-2021/_search
{
"query": {
"bool": {
"must": [
{
"exists": {
"field": "name"
}
},
{
"match":{
"app_sessionId":"CJ9QGFCtfrnZKKI1PSBL3pXxBXpP5zpH"
}
}
]
}
},
"sort":[{"log_time":"desc"}],
"size":1
}
按照时间范围筛选 ,统计日志条数
select count(1) from t where date between '2021-08-22' and '2021-08-23'
body = """{
"track_total_hits": true,
"query": {
"bool": {
"filter": [
{
"range": {
"r_time": {
"gte": "2021-08-20 00:00:00",
"lte": "2021-08-20 23:59:59"
}
}}
]
}
},
"aggs": {
},
"size": 0
}"""