带有 query_string 和范围的 Elasticsearch

Question

我试图得到一个大于 X 且字段等于 Y 的结果。我试过这个:

{
   "sort": {
      "datapublicacao": "desc"
   },
   "query": {
      "query_string": {
         "query": "fullslug:noticia"
      },
      "range": {
         "id": {
            "gt": "145890"
         }
      }
   }
}

但是出现如下错误:

{
   "error": "SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[PkbOJvspSO-yk_8dRMmxcg][jornal.jurid][2]: SearchParseException[[jornal.jurid][2]: query[fullslug:noticia],from[-1],size[-1],sort[<custom:\"datapublicacao\": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@4105c103>!]: Parse Failure [Failed to parse source [{\n   \"sort\": {\n      \"datapublicacao\": \"desc\"\n   },\n   \"query\": {\n      \"query_string\": {\n         \"query\": \"fullslug:noticia\"\n      },\n      \"range\": {\n         \"id\": {\n            \"gt\": \"145890\"\n         }\n      }\n   }\n}\n]]]; nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"range\"]; }{[PkbOJvspSO-yk_8dRMmxcg][jornal.jurid][3]: SearchParseException[[jornal.jurid][3]: query[fullslug:noticia],from[-1],size[-1],sort[<custom:\"datapublicacao\": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@32ef6244>!]: Parse Failure [Failed to parse source [{\n   \"sort\": {\n      \"datapublicacao\": \"desc\"\n   },\n   \"query\": {\n      \"query_string\": {\n         \"query\": \"fullslug:noticia\"\n      },\n      \"range\": {\n         \"id\": {\n            \"gt\": \"145890\"\n         }\n      }\n   }\n}\n]]]; nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"range\"]; }{[PkbOJvspSO-yk_8dRMmxcg][jornal.jurid][0]: SearchParseException[[jornal.jurid][0]: query[fullslug:noticia],from[-1],size[-1],sort[<custom:\"datapublicacao\": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@1534ed83>!]: Parse Failure [Failed to parse source [{\n   \"sort\": {\n      \"datapublicacao\": \"desc\"\n   },\n   \"query\": {\n      \"query_string\": {\n         \"query\": \"fullslug:noticia\"\n      },\n      \"range\": {\n         \"id\": {\n            \"gt\": \"145890\"\n         }\n      }\n   }\n}\n]]]; nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"range\"]; }{[PkbOJvspSO-yk_8dRMmxcg][jornal.jurid][1]: SearchParseException[[jornal.jurid][1]: query[fullslug:noticia],from[-1],size[-1],sort[<custom:\"datapublicacao\": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@21c787c>!]: Parse Failure [Failed to parse source [{\n   \"sort\": {\n      \"datapublicacao\": \"desc\"\n   },\n   \"query\": {\n      \"query_string\": {\n         \"query\": \"fullslug:noticia\"\n      },\n      \"range\": {\n         \"id\": {\n            \"gt\": \"145890\"\n         }\n      }\n   }\n}\n]]]; nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"range\"]; }{[PkbOJvspSO-yk_8dRMmxcg][jornal.jurid][4]: SearchParseException[[jornal.jurid][4]: query[fullslug:noticia],from[-1],size[-1],sort[<custom:\"datapublicacao\": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@45d53e55>!]: Parse Failure [Failed to parse source [{\n   \"sort\": {\n      \"datapublicacao\": \"desc\"\n   },\n   \"query\": {\n      \"query_string\": {\n         \"query\": \"fullslug:noticia\"\n      },\n      \"range\": {\n         \"id\": {\n            \"gt\": \"145890\"\n         }\n      }\n   }\n}\n]]]; nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"range\"]; }]",
   "status": 400
}

如果我只使用 query_string 或范围进行查询，它可以工作，但对它们都不起作用。

Answer 1

使用 Elasticsearch bool search如下

{
"query": {
    "filtered": {
        "query": {
            "bool": {
                "must": [
                    {
                        "query_string": {
                            "query": "fullslug:noticia"
                        }
                    },
                    {
                        "range": {
                            "id": {
                                "gte": 145890
                            }
                        }
                    }
                ]
            }
        }
    }
},
"sort": {
    "datapublicacao": "desc"
}
}