查询全部:
POST /gwrec/rdb/_search
{
"query":{
"match_all":{
}
}
}
注:gwrec为库名(index),rdb为type,_search为请求方式
- elasticsearch-head插件
- sense插件
下同,不再赘述。
单条件查询:
POST /macasset/rdb/_search
{
"query": {
"match": {
"MAC_ADDRESS": "XXXXXXXXXXXX"
}
}
}
随机获取多条数据:
POST /macasset/rdb/_search
{
"from": 0,
"size": 1,
"sort": {
"_script": {
"script": "Math.random()",
"type": "number"
}
}
}
分组查询:
POST /macasset/rdb/_search
{
"size": 0,
"aggs": {
"nu": {
"terms": {
"field": "PROV_CODE.keyword",
"size": 40
}
}
}
}
注:关于.keyword文末说明
单条件分组查询:
POST /macasset/rdb/_search
{
"size": 10,
"query": {
"match": {
"MODEL": "Ltd"
}
},
"aggs": {
"nu": {
"terms": {
"field": "VENDOR.keyword",
"size&#