使用实例 rs = [] rs.append({"match": {"grzh": grzh}}) rs.append({"match_phrase": {"ywlx": "缴"}}) detailRes, detailTotal = elSearch.searchDataSearch("transaction", 0, 100, rs, [{"rq": {"order": "desc"}}, {"hjyf": {"order": "desc"}}], "must") if detailRes and len(detailRes) > 0: ids = [] for item in detailRes: ids.append(item["_id"]) result = hbase.getRows("transaction" if dataType < 2 else "debit", ids) if result != None and len(result) > 0: for key, item in result: if dataType == 1: lastDetail["payemnh"] = item["jyrq:"].split()[0] lastDetail["depmny"] = float(item["credit_sum:"]) else: lastDetail["payemnh"] = "" lastDetail["depmny"] = "" -----------------------------------------------------------------------------------------------------------------------------
# bool组合查询
# filter:过滤，不参与打分# must:如果有多个条件，这些条件都必须满足 and与# should:如果有多个条件，满足一个或多个即可 or或# must_not:和must相反，必须都不满足条件才可以匹配到 ！非 GET 51jobs/job/_search{ "query": { "bool": { "must": { "match_all": {} }, "filter": { "term": { "salary": 6666 } } } }}# select * from job where salary=6666 or salary=7777
# 查询所有数据，筛选出工资等于6666或者7777的数据GET 51jobs/job/_search{ "query": { "bool": { "must": { "match_all": {} }, "filter": { "terms": { "salary": [6666,7777] } } } }}# 查询salary等于6666或者title等于python、salary不等于7777、salary不等于8888GET 51jobs/job/_search
{ "query": { "bool": { "should": [ {"term": { "salary": { "value": 6666 } }}, {"term": { "title": { "value": "python" } }} ], "must_not": [ {"term": { "salary": { "value": 7777 } }}, {"term": { "salary": { "value": 8888 } }} ] } }}# salary等于6666或者title等于python salary不等于9999 title不等于redis
GET 51jobs/job/_search
{ "query": { "bool": { "should": [ {"term": { "salary": { "value": 6666 } }}, {"term": { "title": { "value": "python" } }} ], "must_not": [ {"term": { "salary": { "value": 9999 } }}, { "term": { "title": { "value": "redis" } } } ] } }}# 查询title为python或者(title为搜索并且salary等于6666)的数据GET 51jobs/job/_search{ "query": { "bool": { "should": [ {"term": { "title": { "value": "python" } }}, { "bool": { "must": [ {"term": { "title": { "value": "搜索" } }}, { "term": { "salary": { "value": 6666 } } } ] } } ] } }} # 添加空值测试数据PUT nulldb/test/_bulk{"index":{"_id":1}}{"tags":["IT","python"]}{"index":{"_id":2}}{"tags":["java","python"]}{"index":{"_id":3}}{"tags":null}{"index":{"_id":4}}{"tags":["IT","php"]}{"index":{"_id":5}}{"tags":[null,"python"]} # 处理null空值# 过滤空值# exists 处理值不为空或者值不为null的数据GET nulldb/test/_search{ "query": { "bool": { "filter": { "exists": { "field": "tags" } } } }}# 筛选出tags值为空或者没有tags属性的数据
GET nulldb/test/_search{ "query": { "bool": { "must_not": [ { "exists":{ "field":"tags" } } ] } }}---------------------
作者：纳尔逊皮卡丘 来源：CSDN 原文：https://blog.csdn.net/zhaobig/article/details/78502805 版权声明：本文为博主原创文章，转载请附上博文链接！