Elasticsearch复杂条件查询
发布时间
阅读量：
阅读量
Elasticsearch复杂条件查询
From the table, select all records where either (the class2 equals "空气质量" and type3 equals "国家") or (the class2 equals "水质量" and class3 equals 国家).
PUT /_bulk
{"index":{"_index":"test_join","_id":1}}
{"context":"测试数据[空气质量-国家]","class1":"监测","class2":"空气质量","class3":"国家"}
{"index":{"_index":"test_join","_id":2}}
{"context":"测试数据[空气质量-地方]","class1":"监测","class2":"空气质量","class3":"地方"}
{"index":{"_index":"test_join","_id":3}}
{"context":"测试数据[空气质量-其它]","class1":"监测","class2":"空气质量","class3":"其它"}
{"index":{"_index":"test_join","_id":4}}
{"context":"测试数据[水质量-国家]","class1":"监测","class2":"水质量","class3":"国家"}
{"index":{"_index":"test_join","_id":5}}
{"context":"测试数据[水质量-地方]","class1":"监测","class2":"水质量","class3":"地方"}
{"index":{"_index":"test_join","_id":6}}
{"context":"测试数据[水质量-区县]","class1":"监测","class2":"水质量","class3":"区县"}
{"index":{"_index":"test_join","_id":7}}
{"context":"测试数据[空气质量-国家]","class1":"监测","class2":"空气质量","class3":"国家"}
{"index":{"_index":"test_join","_id":8}}
{"context":"测试数据[空气质量-地方]","class1":"监测","class2":"空气质量","class3":"地方"}
{"index":{"_index":"test_join","_id":9}}
{"context":"测试数据[空气质量-地方]","class1":"监测","class2":"水质量","class3":"地方"}
{"index":{"_index":"test_join","_id":10}}
{"context":"测试数据[空气质量-地方]","class1":"监测","class2":"水质量","class3":"区县"}
AI写代码 GET test_join/_search
POST test_join/_search
{
"size": 10,
"query": {
"bool": {
"should": [
{
"bool": {
"must": [
{
"term": {
"class2.keyword": {
"value": "空气质量"
}
}
},
{
"term": {
"class3.keyword": {
"value": "国家"
}
}
}
]
}
},
{
"bool": {
"must": [
{
"term": {
"class2.keyword": {
"value": "水质量"
}
}
},
{
"terms": {
"class3.keyword": [
"国家",
"区县"
]
}
}
]
}
}
]
}
}
}
POST test_join/_search
{
"size": 1,
"query": {"match_all": {}},
"aggs": {
"agg1": {
"terms": {
"field": "class1.keyword",
"size": 10
}
,"aggs": {
"agg2": {
"terms": {
"field": "class2.keyword",
"size": 10
},"aggs": {
"agg3": {
"terms": {
"field": "class3.keyword",
"size": 10
}
}
}
}
}
}
}
}
AI写代码全部评论 (0)
还没有任何评论哟~