如何在elasticsearch中正确地编写布尔或逻辑？
如何在elasticsearch中正确地编写布尔或逻辑？
提问于 2013-09-05 22:54:12
我想用loId=6 和 (actionType = "SAVE_DATA" 或 actionType = "OPEN_SCREEN")获取所有文档。
，我是不是写错了这个逻辑？
为什么我的查询返回0结果？
注意事项：我会接受一个查询或过滤器来解决这个问题。
以下是一些样本文件：
{
"_index": "logs",
"_type": "record",
"_id": "eIIt3vtrSxmdOVGClQmN3w",
"_score": 1,
"_source": {
"timestamp": 1373569919000,
"uid": 6,
"paId": 56298,
"loId": 6,
"prId": 2,
"vId": 6577,
"actionType": "SAVE_DATA"
}
},
{
"_index": "logs",
"_type": "record",
"_id": "yQGCia6qRYCImZLyH7DrEA",
"_score": 1,
"_source": {
"timestamp": 1373570314000,
"uid": 6,
"paId": 56641,
"loId": 6,
"prId": 2,
"vId": 6578,
"actionType": "CHECK_IN"
}
},
{
"_index": "logs",
"_type": "record",
"_id": "2raajrNKTKeRKG88wiNPpw",
"_score": 1,
"_source": {
"timestamp": 1373570532000,
"uid": 6,
"paId": 56641,
"loId": 6,
"prId": 2,
"vId": 6579,
"actionType": "LOAD_DATA"
}
},
{
"_index": "logs",
"_type": "record",
"_id": "0FDBxW2ESl6tfmj81YJvIg",
"_score": 1,
"_source": {
"timestamp": 1373570761000,
"uid": 6,
"paId": 56298,
"loId": 6,
"prId": 2,
"vId": 6577,
"actionType": "OPEN_SCREEN"
}
},
{
"_index": "logs",
"_type": "record",
"_id": "-bFQyEdCQVWiXNldtxz04g",
"_score": 1,
"_source": {
"timestamp": 1373570777000,
"uid": 6,
"paId": 56298,
"loId": 6,
"prId": 2,
"vId": 6577,
"actionType": "OPEN_SCREEN"
}
}查询
{
"query": {
"filtered": {
"query": {
"term": {
"loId": 6
}
},
"filter": {
"or": {
"filters": [
{
"term": {
"actionType": "SAVE_DATA"
}
},
{
"term": {
"actionType": "OPEN_SCREEN"
}
}
],
"_cache": false
}
}
}
}
}回答 1
Stack Overflow用户
回答已采纳
发布于 2013-09-06 17:18:36
无法获得结果的主要原因是您试图在term上对actionType进行筛选，这是一个分析过的字段。如果要对该字段执行term匹配，则需要更新类型映射以将该字段设置为not_analyzed。参见此示例映射：
{
"record": {
"properties": {
"actionType": {
"type": "string",
"index": "not_analyzed",
},
"loId": {
"type": "long"
},
"paId": {
"type": "long"
},
"prId": {
"type": "long"
},
"timestamp": {
"type": "long"
},
"uid": {
"type": "long"
},
"vId": {
"type": "long"
}
}
}
} 阅读从这里开始的映射：http://www.elasticsearch.org/guide/reference/mapping/。您需要重新索引您的数据。有了这个解决方案，下面是一个可以工作的查询：
{
"query": {
"filtered": {
"query": {"match_all":{}},
"filter": {
"bool": {
"must": [
{"term": {"loId":6}},
{
"or": [
{"term":{"actionType": "SAVE_DATA"}},
{"term":{"actionType": "OPEN_SCREEN"}}
]
}
]
}
}
}
}
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/18647228
复制相关文章
相似问题
腾讯云开发者
