java - ElasticSearch 7 中的运算符 IN
问题描述
我有一个关于 Spring data elasticSearch 的项目。模型:
@Document(indexName = "house", createIndex = false)
public class House {
@Id
private String id;
private String aoGuid;
private String buildNum;
private String houseGuid;
private String houseId;
private String houseNum;
private String postalCode;
private String regionCode;
}
存储库:
@Query("{\n" +
" \"bool\": {\n" +
" \"must\": [\n" +
" {\n" +
" \"bool\": {\n" +
" \"must\": [\n" +
" {\n" +
" \"terms\": {\n" +
" \"aoGuid\": \"[?0]\"\n" +
" }\n" +
" }\n" +
" ]\n" +
" }\n" +
" }\n" +
" ]\n" +
" }\n" +
"}")
List<House> findByAoGuidIn(Collection<String> aoGuid);
我在 Elastic 中的索引:
{
"house": {
"aliases": {},
"mappings": {
"properties": {
"_class": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"aoGuid": {
"type": "keyword"
},
"buildNum": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"houseGuid": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"houseId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"houseNum": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"postalCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"regionCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"settings": {
"index": {
"search": {
"slowlog": {
"threshold": {
"query": {
"info": "1ms"
}
}
}
},
"number_of_shards": "1",
"provided_name": "house",
"creation_date": "1582210642568",
"number_of_replicas": "1",
"uuid": "c43T1LthTH6LhTphjZ-Ulw",
"version": {
"created": "7040099"
}
}
}
}
}
当我调用 findByAoGuidIn 方法时,出现错误:
org.elasticsearch.ElasticsearchStatusException: Elasticsearch 异常 [type=parsing_exception, reason=[terms] 查询不支持 [aoGuid]] org.elasticsearch.rest.BytesRestResponse.errorFromXContent(BytesRestResponse.java:177) ~[elasticsearch-7.4.0.jar:7.4.0] at org.elasticsearch.client.RestHighLevelClient.parseEntity(RestHighLevelClient.java:1727) ~[elasticsearch -rest-high-level-client-7.4.0.jar:7.4.0] 在 org.elasticsearch.client.RestHighLevelClient.parseResponseException(RestHighLevelClient.java:1704) ~[elasticsearch-rest-high-level-client-7.4. 0.jar:7.4.0] 在 org.elasticsearch.client.RestHighLevelClient.internalPerformRequest(RestHighLevelClient.java:1467) ~[elasticsearch-rest-high-level-client-7.4.0.jar:7.4.0] 在 org. elasticsearch.client.RestHighLevelClient.performRequest(RestHighLevelClient.java:1424) ~[elasticsearch-rest-high-level-client-7.4.0.jar:7.4.0] 在 org.elasticsearch.client.RestHighLevelClient。performRequestAndParseEntity(RestHighLevelClient.java:1394) ~[elasticsearch-rest-high-level-client-7.4.0.jar:7.4.0]
我在此链接的文档中进行了查询:https ://docs.spring.io/spring-data/elasticsearch/docs/4.0.x/reference/html/#elasticsearch.query-methods
如何修复错误?
解决方案
谢谢@Val,你让我走上了正确的思考之路。问题是我如何形成收藏。我没有在我的问题中提供这个。我发布更正后的代码:
List<String> aoGuidList = new ArrayList<>();
it.getParts().forEach(itt -> {
aoGuidList.add("\"" + itt.getAoGuid() + "\"");
});
queryHouseService.search(aoGuidList);
现在我的存储库:
@Query("{\n" +
" \"bool\": {\n" +
" \"must\": [\n" +
" {\n" +
" \"bool\": {\n" +
" \"must\": [\n" +
" {\n" +
" \"terms\": {\n" +
" \"aoGuid\": ?0\n" +
" }\n" +
" }\n" +
" ]\n" +
" }\n" +
" }\n" +
" ]\n" +
" }\n" +
"}")
List<House> findByAoGuidIn(Collection<String> aoGuid);
事实上,我必须确保我在请求中的集合对应于模式 ["val1", "val2"]。在我的错误版本中,我得到了以下形式的集合: [val1, val2] 或 ["val1, val2"]
推荐阅读
- spring - 如何使用 JUnit 和 Mockito 测试我的 JwtAuthentication 类?
- node.js - MongoError:以度为单位的边缘位置
- php - 想要在不点击按钮的情况下从 HTML 输入文本更新数据库值
- c# - 在构造函数中填充数组
- r - 如何使用数据框中的数据点(坐标)提取栅格(在本例中为土地覆盖类型)中的像元值
- java - htmlUnit - 是否可以只执行特定的 JS 函数?
- r - Rcpp 在两个函数之间共享相同的 roxygen
- .net - 单元测试多目标框架:测试所有框架
- c# - 我们如何从左到右计算出现次数并继续直到我们有连续的数字?
- python - __init__.py 中的类实现