索引操作

  2. PUT human
  3. {
  4.     "settings":{
  5.         "number_of_shards":1,
  6.         "number_of_replicas":1
  7.     },
  8.     "mappings":{
  9.         "dynamic":"false",
  10.         "properties":{
  11.             "blackFlag":{
  12.                 "type":"byte"
  13.             },
  14.             "brandName":{
  15.                 "type":"keyword",
  16.                 "index":false
  17.             },
  18.             "keyWord":{
  19.                 "type":"text",
  20.                 "analyzer":"ik_max_word"
  21.             },
  22.             "onlineDate":{
  23.                 "type":"long"
  24.             },
  25.             "unitPrice":{
  26.                 "type":"scaled_float",
  27.                 "scaling_factor":100
  28.             },
  29.             "publicAttrList":{
  30.                 "type":"nested",
  31.                 "dynamic":"false",
  32.                 "properties":{
  33.                     "publicAttrCode":{
  34.                         "type":"keyword"
  35.                     },
  36.                     "publicAttrName":{
  37.                         "type":"keyword",
  38.                         "index":false
  39.                     },
  40.                     "publicAttrValue":{
  41.                         "type":"keyword"
  42.                     },
  43.                     "publicAttrValueCode":{
  44.                         "type":"keyword"
  45.                     },
  46.                     "publicAttrValueName":{
  47.                         "type":"keyword",
  48.                         "index":false
  49.                     }
  50.                 }
  51.             }
  52.         }
  53.     }
  54. }
  56. GET human
  58. DELETE human
  1. DELETE test_object_nested
  3. PUT test_object_nested
  4. {
  5.     "mappings": {
  6.         "dynamic": "false",
  7.         "properties": {
  8.             "name_object": {
  9.               "type": "object",
  10.                 "properties": {
  11.                     "first": {
  12.                         "type": "keyword"
  13.                     },
  14.                     "last": {
  15.                         "type": "keyword"
  16.                     }
  17.                 }
  18.             },
  19.             "name_nested": {
  20.               "type": "nested",
  21.                 "properties": {
  22.                     "first": {
  23.                         "type": "keyword"
  24.                     },
  25.                     "last": {
  26.                         "type": "keyword"
  27.                     }
  28.                 }
  29.             }
  30.         }
  31.     }
  32. }
  34. GET test_object_nested/_mapping
  36. POST test_object_nested/_doc/1
  37. {
  38.   "name_object":[
  39.     {
  40.       "first" : "John",
  41.       "last" :  "Smith"
  42.     },
  43.     {
  44.       "first" : "Alice",
  45.       "last" :  "White"
  46.     }
  47.     ],
  48.     "name_nested":[
  49.     {
  50.       "first" : "John",
  51.       "last" :  "Smith"
  52.     },
  53.     {
  54.       "first" : "Alice",
  55.       "last" :  "White"
  56.     }
  57.     ]
  58. }
  60. GET test_object_nested/_search
  62. # 对象数组查询
  63. GET test_object_nested/_search
  64. {
  65.     "query": {
  66.         "bool": {
  67.             "must": [
  68.                 {
  69.                     "term": {
  70.                         "name_object.first": {
  71.                             "value": "John"
  72.                         }
  73.                     }
  74.                 },
  75.                 {
  76.                     "term": {
  77.                         "name_object.last": {
  78.                             "value": "White"
  79.                         }
  80.                     }
  81.                 }
  82.             ]
  83.         }
  84.     }
  85. }
  87. # 嵌套对象数组查询
  88. GET test_object_nested/_search
  89. {
  90.   "query": {
  91.     "bool": {
  92.       "must": [
  93.         {
  94.           "nested": {
  95.             "path": "name_nested",
  96.             "query": {
  97.               "bool": {
  98.                 "must": [
  99.                 {
  100.                     "term": {
  101.                         "name_nested.first": {
  102.                             "value": "John"
  103.                         }
  104.                     }
  105.                 },
  106.                 {
  107.                     "term": {
  108.                         "name_nested.last": {
  109.                             "value": "White"
  110.                         }
  111.                     }
  112.                 }
  113.             ]
  114.               }
  115.             }
  116.           }
  117.         }
  118.       ]
  119.     }
  120.   }
  121. }
  1. DELETE book
  3. # 索引添加文档
  4. POST book/_doc/1
  5. {
  6.   "name": "ES in aciton",
  7.   "price": 11.22,
  8.   "stockFlag": true,
  9.   "count": 12,
  10.   "author": {
  11.     "name": "some gay",
  12.     "age": 30
  13.   },
  14.   "labelList": ["ES", "IT"],
  15.   "date": null
  17. }
  19. # 查看文档
  20. GET book/_search
  22. # 查看指定索引的Mapping
  23. GET book/_mapping?pretty
  25. # 新增文档新字段
  26. POST book/_doc/2
  27. {
  28.   "country": "China"
  30. }
  1. DELETE book
  3. # 设置索引Mapping
  4. PUT book
  5. {
  6.     "mappings": {
  7.       "dynamic": "false",
  8.       "properties": {
  9.         "country": {
  10.           "type": "keyword"
  11.         }
  12.       }
  13.     }
  14. }
  17. # 查看指定索引的Mapping
  18. GET book/_mapping?pretty
  20. # 索引添加文档
  21. POST book/_doc/1
  22. {
  23.   "name": "ES in aciton",
  24.   "type": "IT",
  25.   "country": "china"
  26. }
  28. # 查看文档
  29. GET book/_search
  32. # 搜索Mapping有的字段
  33. GET book/_search?q=country:china
  35. # 搜索Mapping没有的字段
  36. GET book/_search?q=type:IT
  39. # 新增Mapping里面没有的字段
  40. POST book/_doc/2
  41. {
  42.   "age": 110
  43. }
  45. # 搜索Mapping没有的字段
  46. GET book/_search?q=age:110
  1. DELETE book
  3. # 设置索引Mapping
  4. PUT book
  5. {
  6.     "mappings": {
  7.       "dynamic": "strict",
  8.       "properties": {
  9.         "country": {
  10.           "type": "keyword"
  11.         }
  12.       }
  13.     }
  14. }
  17. # 查看指定索引的Mapping
  18. GET book/_mapping?pretty
  20. # 新增Mapping里面有的字段
  21. POST book/_doc/1
  22. {
  23.   "country": "china"
  24. }
  26. # 查看文档
  27. GET book/_search
  29. # 索引添加文档
  30. POST book/_doc/1
  31. {
  32.   "name": "ES in aciton",
  33.   "type": "IT",
  34.   "country": "china"
  35. }
  38. # 搜索Mapping有的字段
  39. GET book/_search?q=country:china
  1. DELETE book
  3. # 设置索引Mapping
  4. PUT book
  5. {
  6.     "mappings": {
  7.       "dynamic": "strict",
  8.       "properties": {
  9.         "country": {
  10.           "type": "keyword"
  11.         }
  12.       }
  13.     }
  14. }
  16. # 新增Mapping里面有的字段
  17. POST book/_doc/1
  18. {
  19.   "country": "china"
  20. }
  22. # 查看指定索引的Mapping
  23. GET book/_mapping?pretty
  27. # 查看文档
  28. GET book/_search
  29. GET book_alias/_search
  31. POST _aliases
  32. {
  33.     "actions": [
  34.         {
  35.             "add": {
  36.                 "index": "book",
  37.                 "alias": "book_alias"
  38.             }
  39.         }
  40.     ]
  41. }
  44. # 别名列表
  45. GET _cat/aliases?v

文档操作

  1. DELETE book
  3. # 设置索引Mapping
  4. PUT book
  5. {
  6.     "mappings": {
  7.       "dynamic": "false",
  8.       "properties": {
  9.         "country": {
  10.           "type": "keyword"
  11.         }
  12.       }
  13.     }
  14. }
  17. # 查看指定索引的Mapping
  18. GET book/_mapping?pretty
  21. # 指定 IP 创建文档
  22. # 再次请求就是覆盖更新
  23. POST book/_doc/1
  24. {
  25.   "name": "ES in aciton",
  26.   "type": "IT",
  27.   "country": "china"
  28. }
  31. # 不指定 ID 创建，ES会随机分配ID
  32. # 再次请求就继续创建，不幂等
  33. POST book/_doc
  34. {
  35.   "name": "ES in aciton",
  36.   "type": "IT",
  37.   "country": "china"
  38. }
  41. # 查看文档
  42. GET book/_search
  44. # 部分更新
  45. POST book/_update/1
  46. {
  47.   "doc": {
  48.     "name": "Lucene",
  49.     "age": 12
  50.   }
  51. }
  54. # 使内外部版本号，_seq_no 与 _primary_term
  55. # 可确一个文档的版本号，两者要跟文档一致
  56. PUT book/_doc/1?if_seq_no=16&if_primary_term=1
  57. {
  58.   "name": "ES in aciton1",
  59.   "type": "IT",
  60.   "country": "china"
  61. }
  63. # 使用外部版本号，一定要比内部version 大
  64. PUT book/_doc/1?version=19&version_type=external
  65. {
  66.   "name": "ES in aciton1",
  67.   "type": "IT",
  68.   "country": "china"
  69. }
  71. # 根据 id 查找
  72. GET book/_doc/1

搜索与聚合

  1. # 删除指定索引
  2. DELETE book
  4. GET book
  6. # 设置索引Mapping
  7. PUT book
  8. {
  9.     "mappings": {
  10.         "dynamic": "false",
  11.         "properties": {
  12.             "nameText": {
  13.                 "type": "text",
  14.                 "analyzer": "standard"
  15.             },
  16.             "nameKeyWord": {
  17.                 "type": "keyword"
  18.             },
  19.             "country": {
  20.                 "type": "keyword"
  21.             },
  22.             "price": {
  23.                 "type": "float"
  24.             }
  25.         }
  26.     }
  27. }
  29. # 查看指定索引的Mapping
  30. GET book/_mapping?pretty
  32. # 索引添加文档
  33. POST book/_bulk
  34. {"create" : {"_id": 1}}
  35. { "nameText": "ES in action ES","nameKeyWord": "ES in action ES","country": "China","price":100}
  36. {"create" : {"_id": 2}}
  37. { "nameText": "ES in one action","nameKeyWord": "ES in one action","country": "Japan","price":200}
  38. {"create" : {"_id": 3}}
  39. { "nameText": "ES in one two action","nameKeyWord": "ES in one two action","country": "America","price":300}
  40. {"create" : {"_id": 4}}
  41. { "nameText": "What is ES","nameKeyWord": "What is ES","country": "China","price":400}
  42. {"create" : {"_id": 5}}
  43. { "nameText": "one thing is good","nameKeyWord": "one thing is good","country": "America","price":500}
  46. # 查看文档
  47. GET book/_search
  50. # 查看指定索引指定字段的分词效果
  51. GET book/_analyze
  52. {
  53.   "field": "nameText",
  54.   //"field": "nameKeyWord",
  55.   "text": "china"
  56. }
  59. # 全文检索
  60. GET book/_search
  61. {
  62.   "query": {
  63.     "match": {
  64.       "nameText": "ES"
  65.     }
  66.   }
  67. }
  69. # 带有 operator
  70. GET book/_search
  71. {
  72.   "query": {
  73.     "match": {
  74.       "nameText": {
  75.         "query": "what is",
  76.         "operator": "and"
  77.       }
  78.     }
  79.   }
  80. }
  82. # match_phrase
  83. GET book/_search
  84. {
  85.   "query": {
  86.     "match_phrase": {
  87.       "nameText": {
  88.         "query": "in action"
  89.         , "slop": 0
  90.       }
  91.     }
  92.   }
  93. }
  95. # match_phrase_prefix
  96. GET book/_search
  97. {
  98.   "query": {
  99.     "match_phrase_prefix": {
  100.       "nameText": {
  101.         "query": "in a",
  102.         "slop": 0
  103.       }
  104.     }
  105.   }
  106. }
  109. # 精确检索
  110. GET book/_search
  111. {
  112.   "query": {
  113.     "term": {
  114.       "country": "china"
  116.     }
  117.   }
  118. }
  120. # 精确检索
  121. GET book/_search
  122. {
  123.   "query": {
  124.     "term": {
  125.       "nameKeyWord": "ES in one two"
  127.     }
  128.   }
  129. }
  131. # Range Query
  132. GET book/_search
  133. {
  134.   "query": {
  135.     "range": {
  136.       "price": {
  137.         "gte": 400,
  138.         "lte": 500
  139.       }
  140.     }
  141.   }
  142. }
  144. # Prefix Query
  145. GET book/_search
  146. {
  147.   "query": {
  148.     "prefix": {
  149.       "nameKeyWord": "ES in a"
  150.     }
  151.   }
  152. }
  155. # constant_score 转成 filtering
  156. GET book/_search
  157. {
  158.   "query": {
  159.     "constant_score": {
  160.       "filter": {
  161.         "term": {
  162.           "country": "China"
  163.         }
  164.       }
  165.     }
  166.   }
  167. }
  169. # bool query
  170. GET book/_search
  171. {
  172.     "query": {
  173.         "bool": {
  174.             "must": {
  175.                 "match": {
  176.                     "nameText": "ES"
  177.                 }
  178.             },
  179.             "must_not": {
  180.                 "match": {
  181.                     "nameText": "two"
  182.                 }
  183.             },
  184.             "filter": {
  185.                 "range": {
  186.                     "price": {
  187.                         "gte": 300
  188.                     }
  189.                 }
  190.             },
  191.             "should": [
  192.                 {
  193.                     "term": {
  194.                         "country": "China"
  195.                     }
  196.                 },
  197.                 {
  198.                     "term": {
  199.                         "country": "America"
  200.                     }
  201.                 }
  202.             ],
  203.             "minimum_should_match": 1
  204.         }
  205.     }
  206. }
  208. # Bucket 聚合
  209. GET book/_search
  210. {
  211.   "size": 0,
  212.   "aggs": {
  213.     "country_aggs": {
  214.       "terms": {
  215.         "field": "country"
  216.       }
  217.     }
  218.   }
  219. }
  221. # Metric 聚合
  222. GET book/_search
  223. {
  224.   "size": 0,
  225.   "aggs": {
  226.     "average_price": {
  227.      "avg": {
  228.        "field": "price"
  229.      }
  230.     },
  231.     "max_price": {
  232.      "max": {
  233.        "field": "price"
  234.      }
  235.     },
  236.     "min_price": {
  237.      "min": {
  238.        "field": "price"
  239.      }
  240.     }
  241.   }
  242. }