使用Kibana操作ES命令汇总
1.查询模块命令汇总
1.1查询一张表内的全部数据
GET test3/_doc/_search
{
"query": {
"match_all": {}
}
}
1.2精确查询一张表内符合条件的数据
GET test3/_doc/_search
{
"query":{
"term": { "name.keyword" : "douglas1"}
}
}
1.3精确查询一张表内符合一个条件多值的数据
GET test3/_doc/_search
{
"query":{
"terms": {
"name.keyword" : ["douglas1","douglas2"]
}
}
}
1.4精确查询一张表内符合多条件多值的数据==and
GET test3/_doc/_search
{
"query": {
"bool": {
"must": [
{
"terms":{
"name.keyword":["douglas1","douglas2"]
}
},
{
"terms":{
"age.keyword":["21","22"]
}
}
]
}
}
}
1.5精确查询一张表内符合多条件多值的数据==or
GET test3/_doc/_search
{
"query": {
"bool": {
"should": [
{
"terms":{
"name.keyword":["douglas1","douglas2"]
}
},
{
"terms":{
"age.keyword":["21","22"]
}
}
]
}
}
}
1.6精确查询一张表内不等于当前条件的数据==not
GET test3/_doc/_search
{
"query": {
"bool": {
"must_not": [
{
"term":{
"name":"代"
}
},
{
"term":{
"age":"21"
}
}
]
}
}
}
1.7分页查询
GET test3/_doc/_search
{
"from":1,
"size":1,
"query": {
"bool": {
"must": [
{
"match":{
"name":"代"
}
},
{
"match":{
"age":"21"
}
}
]
}
}
}
1.8根据条件排序查询
GET test3/_doc/_search
{
"from":0,
"size":10,
"query": {
"bool": {
"must": [
{
"match":{
"name":"代"
}
}
]
}
},
"sort":[
{
"age.keyword":{
"order":"asc"
}
}
]
}