插件
elasticheader 谷歌浏览器装一下
Kibana 也可以
严选 | Elasticsearch史上最全最常用工具清单
设置分页上限
PUT index/_settings
{
"index":{
"max_result_window":100000000
}
}
搜索
复合查询
POST index/_search
{"from":88888,"size":10,"query":{"bool":{"must":[{"bool":{"should":[{"range":{"i_CATR01_AGE":{"from":"0","to":"18","include_lower":true,"include_upper":true,"boost":1}}},{"range":{"i_CATR01_AGE":{"from":"18","to":"30","include_lower":true,"include_upper":true,"boost":1}}},{"range":{"i_CATR01_AGE":{"from":"30","to":"40","include_lower":true,"include_upper":true,"boost":1}}},{"range":{"i_CATR01_AGE":{"from":"40","to":"50","include_lower":true,"include_upper":true,"boost":1}}},{"range":{"i_CATR01_AGE":{"from":"50","to":"65","include_lower":true,"include_upper":true,"boost":1}}},{"range":{"i_CATR01_AGE":{"from":"65","to":"150","include_lower":true,"include_upper":true,"boost":1}}}],"adjust_pure_negative":true,"boost":1}}],"adjust_pure_negative":true,"boost":1}},"_source":{"includes":["INDICATOR1","INDICATOR2","INDICATOR3","INDICATOR4","INDICATOR5","INDICATOR6","INDICATOR7","INDICATOR8","INDICATOR9","INDICATOR10"],"excludes":[]}}
基本查询
选择文档 索引名index
must match_all 指标名INDICATOR
term 具体需要查询的值