Elasticsearch搜索查询问题

Question

client = Elasticsearch::Client.new log: true
client.indices.refresh index: 'property_index'
# search_results = client.search(body: { query: { multi_match: { query: search_params, fields: ['street_address', 'suburb'] } } })
match_query = [
  { match: { status: 'Active'} }
]
match_query << { match: { is_published: true} }
match_query << { match: { paid: true} }
match_query << { match: { suburb: params[:suburb].to_s} } if !params[:suburb].blank?
match_query << { match: { advertise_type: params[:advertise_type].to_s} } if !params[:advertise_type].blank?
match_query << { match: { state: params[:state].to_s} } if !params[:state].blank?
match_query << { match: { postal_code: params[:postal_code]} } if !params[:postal_code].blank?
response = client.search(body: {
                                  query: { bool: { must: match_query }},
                                  sort: [
                                    { updated_at: { order: "desc" }}
                                  ]
                              }, from: params[:offset], size: params[:limit])

all_records = client.search(body: {
                query: { bool: { must: match_query }},
                sort: [
                  { updated_at: { order: "desc" }}
                ]
              })

这是我得到的响应输出-

GET http://localhost:9200/_search?from=0&size=10 [status:200, request:0.010s, query:0.003s]

2018-11-20 18:25:34+0530:>{“查询”：{“布尔”：{“必须”：[{“匹配”：{“状态”：“活动”}}，{“匹配”：{“is_published”：true}}，{“匹配”：{“payed”：true}}，{“match”：{“adverse_type”：“sell”}}]}}，“排序”：[{“updated_at”：{“order”：“desc”}}]}2018-11-20 18:25:34+0530:<{“take”：3,“timed_out”：false,“_shards”：{“total：{”总计“：0,”max_score“：null,”hits“：[]}}2018-11-20 18:25:34+0530:GET http://localhost:9200/_search[状态：200,请求：0.008s,查询：0.002s]2018-11-20 18:25:34+0530:>{”查询“：{”布尔“：{”必须“：[{”匹配“：{”状态“：”活动“}},{”匹配“：{”is_published“：true}},{”匹配“：{”payed“：true}},{”匹配“：{”adverse_type“：”sell“}}]}},：{”order“：”desc“}}]}2018-11-20 18:25:34+0530:<{”take“：2,”timed_out“：false,”_shards“：{”total“：1,”successed“：1,”failed“：0},”hits“：{”total“：0,”max_score“：null,”hits“：[]}}

Answer 1

如果我们不知道查询的结构，也不知道查询的目的，那么就很难判断哪里出了问题。

信息日志说：

timed_out:false
Shards:
 total:1 
 successful: 1
 failed:0
Hits: 
 total: 0 

这意味着查询是成功的，服务器没有遇到错误。它只是没有找到任何与您的查询匹配的文档。

我建议首先使用适当的工具来尝试查询，例如Kibanas的search profiler（https://www.elastic.co/guide/en/kibana/current/xpack-profiler.html）。

这将向您显示有关查询的信息，一旦您找到合适的查询，就可以将其集成到代码中。