进阶-第04_结构化搜索_filter执行原理深度剖析（bitset机制与caching机制）

 

term: {"field": "value"}

terms: {"field": ["value1", "value2"]}

 

sql中的in

 

select * from tbl where col in ("value1", "value2")

 

1. 为帖子数据增加tag字段

 

POST /forum/article/_bulk { "update": { "_id": "1"} } { "doc" : {"tag" : ["java", "hadoop"]} } { "update": { "_id": "2"} } { "doc" : {"tag" : ["java"]} } { "update": { "_id": "3"} } { "doc" : {"tag" : ["hadoop"]} } { "update": { "_id": "4"} } { "doc" : {"tag" : ["java", "elasticsearch"]} } 结果 {   "took": 42,   "errors": false,   "items": [     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "1",         "_version": 2,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "2",         "_version": 2,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "3",         "_version": 2,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "4",         "_version": 2,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     }   ] }

 

2、搜索articleID为KDKE-B-9947-#kL5或QQPX-R-3956-#aD8的帖子

GET /forum/article/_search {   "query": {     "constant_score": {       "filter": {//如果是多个，这个地方用bool         "terms": {           "articleID": [             "KDKE-B-9947-#kL5",             "QQPX-R-3956-#aD8"           ]         }       }     }   } } 注意这是相同字段，不需要用should,should用于不同字段 结果： {   "took": 2,   "timed_out": false,   "_shards": {     "total": 5,     "successful": 5,     "failed": 0   },   "hits": {     "total": 2,     "max_score": 1,     "hits": [       {         "_index": "forum",         "_type": "article",         "_id": "2",         "_score": 1,         "_source": {           "articleID": "KDKE-B-9947-#kL5",           "userID": 1,           "hidden": false,           "postDate": "2017-01-02",           "tag": [             "java"           ]         }       },       {         "_index": "forum",         "_type": "article",         "_id": "4",         "_score": 1,         "_source": {           "articleID": "QQPX-R-3956-#aD8",           "userID": 2,           "hidden": true,           "postDate": "2017-01-02",           "tag": [             "java",             "elasticsearch"           ]         }       }     ]   } }

 

1. 搜索tag中包含java的帖子

 

GET /forum/article/_search {     "query" : {         "constant_score" : {             "filter" : {                 "terms" : {                     "tag" : ["java"]                 }             }         }     } } 结果 {   "took": 1,   "timed_out": false,   "_shards": {     "total": 5,     "successful": 5,     "failed": 0   },   "hits": {     "total": 3,     "max_score": 1,     "hits": [       {         "_index": "forum",         "_type": "article",         "_id": "2",         "_score": 1,         "_source": {           "articleID": "KDKE-B-9947-#kL5",           "userID": 1,           "hidden": false,           "postDate": "2017-01-02",           "tag": [             "java"           ]         }       },       {         "_index": "forum",         "_type": "article",         "_id": "4",         "_score": 1,         "_source": {           "articleID": "QQPX-R-3956-#aD8",           "userID": 2,           "hidden": true,           "postDate": "2017-01-02",           "tag": [             "java",             "elasticsearch"           ]         }       },       {         "_index": "forum",         "_type": "article",         "_id": "1",         "_score": 1,         "_source": {           "articleID": "XHDK-A-1293-#fJ3",           "userID": 1,           "hidden": false,           "postDate": "2017-01-01",           "tag": [             "java",             "hadoop"           ]         }       }     ]   } }

 

1. 优化搜索结果，仅仅搜索tag只包含java的帖子

添加字段

POST /forum/article/_bulk { "update": { "_id": "1"} } { "doc" : {"tag_cnt" : 2} } { "update": { "_id": "2"} } { "doc" : {"tag_cnt" : 1} } { "update": { "_id": "3"} } { "doc" : {"tag_cnt" : 1} } { "update": { "_id": "4"} } { "doc" : {"tag_cnt" : 2} } （每个tag中的数目在tag_cnt中） {   "took": 45,   "errors": false,   "items": [     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "1",         "_version": 3,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "2",         "_version": 3,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "3",         "_version": 3,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     },     {       "update": {         "_index": "forum",         "_type": "article",         "_id": "4",         "_version": 3,         "result": "updated",         "_shards": {           "total": 2,           "successful": 1,           "failed": 0         },         "status": 200       }     }   ] }

搜索

GET /forum/article/_search {   "query": {     "constant_score": {       "filter": {         "bool": {           "must": [             {               "term": {                 "tag_cnt": 1               }             },             {               "terms": {                 "tag": ["java"]               }             }           ]         }       }     }   } } 结果 {   "took": 1,   "timed_out": false,   "_shards": {     "total": 5,     "successful": 5,     "failed": 0   },   "hits": {     "total": 1,     "max_score": 1,     "hits": [       {         "_index": "forum",         "_type": "article",         "_id": "2",         "_score": 1,         "_source": {           "articleID": "KDKE-B-9947-#kL5",           "userID": 1,           "hidden": false,           "postDate": "2017-01-02",           "tag": [             "java"           ],           "tag_cnt": 1         }       }     ]   } }

 

["java", "hadoop", "elasticsearch"]

 

4、学到的知识点梳理

（1）terms多值搜索

（2）优化terms多值搜索的结果

（3）相当于SQL中的in语句