elasticsearch 7.12.1报错处理：ElasticsearchStatusException[Elasticsearch exception [type=parse

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

文章目录

• 前言
• 一、我的测试代码：
• 二、问题所在
• 最后分享一下我自己的范围测试查询代码

  ---

  前言

  最近在使用RestHighLevelClient测试后端数据时，遇到如下一个报错：

  ElasticsearchStatusException[Elasticsearch exception [type=parse_exception, reason=numeric value expected]
  ]
  	at org.elasticsearch.rest.BytesRestResponse.errorFromXContent(BytesRestResponse.java:176)
  	at org.elasticsearch.client.RestHighLevelClient.parseEntity(RestHighLevelClient.java:1933)
  	...
  	Suppressed: org.elasticsearch.client.ResponseException: method [POST], host [http://192.***.***.***:9200], URI [/exp_store_location/_search?typed_keys=true&max_concurrent_shard_requests=5&ignore_unavailable=false&expand_wildcards=open&allow_no_indices=true&ignore_throttled=true&search_type=query_then_fetch&batched_reduce_size=512&ccs_minimize_roundtrips=true], status line [HTTP/1.1 400 Bad Request]
  {"error":{"root_cause":[{"type":"parse_exception","reason":"numeric value expected"}],"type":"parse_exception","reason":"numeric value expected"},"status":400}
  		at org.elasticsearch.client.RestClient.convertResponse(RestClient.java:326)
  		at org.elasticsearch.client.RestClient.performRequest(RestClient.java:296)
  		at org.elasticsearch.client.RestClient.performRequest(RestClient.java:270)
  		at org.elasticsearch.client.RestHighLevelClient.internalPerformRequest(RestHighLevelClient.java:1654)
  		... 71 more
  

  ---

  一、我的测试代码：

  // 根据坐标排序
      @Test
      void testByLocation() throws Exception {
          SearchRequest request = new SearchRequest("exp_store_location");
          String location = "22.910906957435557,113.87965738641294";
          GeoDistanceQueryBuilder geoDistanceQuery = QueryBuilders.geoDistanceQuery("location"); // 设置查询字段
          //geoDistanceQuery.point(new GeoPoint(location)); // 设置查询中心坐标
          geoDistanceQuery.distance("15",DistanceUnit.KILOMETERS); // 设置查询半径
          request.source().query(geoDistanceQuery);
          /*request.source().query(QueryBuilders.geoDistanceQuery("location").point(new GeoPoint(location)).distance("15",DistanceUnit.KILOMETERS)).sort(
                  SortBuilders
                          .geoDistanceSort("location",new GeoPoint(location))
                          .order(SortOrder.ASC)
                          .unit(DistanceUnit.KILOMETERS)
          ).sort(SortBuilders
                  .fieldSort("averagePrice")
                  .order(SortOrder.ASC)
          );*/
          SearchResponse response = client.search(request, RequestOptions.DEFAULT);
          System.out.println(response.toString());
      }
  

  ---

  二、问题所在

  问题出在我没有给geoDistanceQuery设置中心坐标

   		GeoDistanceQueryBuilder geoDistanceQuery = QueryBuilders.geoDistanceQuery("location"); // 设置搜索字段
          geoDistanceQuery.point(new GeoPoint(location)); // 设置中心坐标
          geoDistanceQuery.distance("15",DistanceUnit.KILOMETERS); // 设置搜索距离范围
  

  设置中心坐标后问题得到解决。

  以下是elastic客户端查询索引的代码

  GET /exp_store_location/_search
  {
    "query": {
      "geo_distance": {
        "distance": "150km",
        "location": "22.910906957435557,113.87965738641294"
      }
    }
    , "sort": [
      {
        "_geo_distance": {
          "location": "22.910906957435557,113.87965738641294",
          "order": "asc",
          "unit": "km"
        },
        "averagePrice": {
          "order": "asc"
        }
      }
    ]
  }
  

  ---

  最后分享一下我自己的范围测试查询代码

   // 根据坐标排序
      @Test
      void testByLocation() throws Exception {
          SearchRequest request = new SearchRequest("exp_store_location");
          String location = "22.910906957435557,113.87965738641294";
          /*GeoDistanceQueryBuilder geoDistanceQuery = QueryBuilders.geoDistanceQuery("location"); // 设置查询字段
          geoDistanceQuery.point(new GeoPoint(location)); // 设置查询中心坐标
          geoDistanceQuery.distance("15",DistanceUnit.KILOMETERS); // 设置查询半径
          request.source().query(geoDistanceQuery);*/
          request.source()
                   // 查询条件
                  .query(QueryBuilders.geoDistanceQuery("location")
                          .point(new GeoPoint(location))
                          .distance("15",DistanceUnit.KILOMETERS)
                  )
                  // 对结果的排序方式
                  .sort(SortBuilders
                          .geoDistanceSort("location",new GeoPoint(location))
                          .order(SortOrder.ASC)
                          .unit(DistanceUnit.KILOMETERS)
                  )
                  .sort(SortBuilders
                  .fieldSort("averagePrice")
                  .order(SortOrder.ASC)
                  );
          SearchResponse response = client.search(request, RequestOptions.DEFAULT);
          System.out.println(response.toString());
      }