_source,是否启用原始数据，默认启用

includes,选择包含哪些字段，excludes：去除哪些字段

字段

不分词

  • keyword
  • constant_keyword
  • wildcard


数值类型

  • long
  • integer
  • short
  • byte
  • unsigned_long
  • double
  • float
  • half_float
  • scaled_float: 收缩浮点类型，可以指定收缩因子

日期类型

  • date
  • date_nanos


Object类型

array类型

range类型

  • integer_range
  • float_range
  • long_range
  • double_range
  • date_range
  • ip_range

适用场景：体重、日期范围，身高

join父子类型

  1. PUT ckiss-company-001
  2. {
  3.   "mappings": {
  4.     "properties": {
  5.       "companyId": {
  6.         "type": "integer"
  7.       },
  8.       "companyName": {
  9.         "type": "keyword"
  10.       },
  11.       "join_father_child": {
  12.         "type": "join",
  13.         "relations": {
  14.           "father": "child"
  15.         }
  16.       }
  17.     }
  18.   }
  19. }
  22. #填充集团数据
  23. PUT ckiss-company-001/_doc/1
  24. {
  25.   "companyId": 1,
  26.   "companyName": "华住会集团",
  27.   "join_father_child":{
  28.     "name": "father"
  29.   }
  30. }
  32. #子公司数据， routing保证父子文档处于同一分片中
  33. PUT ckiss-company-001/_doc/2?routing=1
  34. {
  35.   "companyId": 2,
  36.   "companyName": "上海华住",
  37.   "join_father_child": {
  38.     "name": "child",
  39.     "parent": "1"
  40.   }
  41. }
  43. #子公司数据
  44. PUT ckiss-company-001/_doc/3?routing=1
  45. {
  46.   "companyId": 3,
  47.   "companyName": "杭州华住",
  48.   "join_father_child": {
  49.     "name": "child",
  50.     "parent": "1"
  51.   }
  52. }
  55. # 查询：根据父ID查询所有子节点
  56. GET ckiss-company-001/_search
  57. {
  58.   "query": {
  59.     "parent_id": {
  60.       "type": "child",
  61.       "id": 1
  62.     }
  63.   }
  64. }
  66. # 查询具有子数据的父数据列表
  67. GET ckiss-company-001/_search
  68. {
  69.   "query": {
  70.     "has_child": {
  71.       "type": "child",
  72.       "query": {
  73.         "match_all": {}
  74.       }
  75.     }
  76.   }
  77. }
  79. # 查询具有父节点的子数据列表
  80. GET ckiss-company-001/_search
  81. {
  82.   "query": {
  83.     "has_parent": {
  84.       "parent_type": "father",
  85.       "query": {
  86.         "match_all": {}
  87.       }
  88.     }
  89.   }
  90. }

Nested 嵌套键值对

案例练习：

  1. 假设一个公司有很多区域信息，每一组都是一个键值对，包括省份与城市
  2. 错误的案例查询使用array类型

错误情况

  1. PUT ckiss-company-002
  2. {
  3.   "mappings": {
  4.     "properties": {
  5.       "companyId": {
  6.         "type": "integer"
  7.       },
  8.       "companyName": {
  9.         "type": "keyword"
  10.       },
  11.       "area": {
  12.         "properties": {
  13.           "province": {
  14.             "type": "keyword"
  15.           },
  16.           "city": {
  17.             "type": "keyword"
  18.           }
  19.         }
  20.       }
  21.     }
  22.   }
  23. }
  25. # 填充数组
  26. PUT ckiss-company-002/_doc/1
  27. {
  28.   "companyId": 1,
  29.   "companyName": "华住集团",
  30.   "area": [
  31.     {
  32.       "province": "HN",
  33.       "city": "CS"
  34.     },
  35.     {
  36.       "province": "ZJ",
  37.       "city": "HZ"
  38.     }
  39.   ]
  40. }
  42. # 按照省份与城市查询
  43. GET ckiss-company-002/_search
  44. {
  45.   "query": {
  46.     "bool": {
  47.       "must": [
  48.         {
  49.           "term": {
  50.             "area.province": {
  51.               "value": "HN"
  52.             }
  53.           }
  54.         },
  55.         {
  56.           "term": {
  57.             "area.city": {
  58.               "value": "HZ"
  59.             }
  60.           }
  61.         }
  62.       ]
  63.     }
  64.   }
  65. }

响应结果有问题：

  1.   "hits" : [
  2.     {
  3.       "_index" : "ckiss-company-002",
  4.       "_type" : "_doc",
  5.       "_id" : "1",
  6.       "_score" : 0.723315,
  7.       "_source" : {
  8.         "companyId" : 1,
  9.         "companyName" : "华住集团",
  10.         "area" : [
  11.           {
  12.             "province" : "HN",
  13.             "city" : "CS"
  14.           },
  15.           {
  16.             "province" : "ZJ",
  17.             "city" : "HZ"
  18.           }
  19.         ]
  20.       }
  21.     }
  22.   ]

正确做法

  • 使用nested 类型
  • 在area字段下增加 type=nested
  • 查询语法中增加 nested 标记 ```json DELETE ckiss-company-002

PUT ckiss-company-002 { “mappings”: { “properties”: { “companyId”: { “type”: “integer” }, “companyName”: { “type”: “keyword” }, “area”: { “type”: “nested”, “properties”: { “province”: { “type”: “keyword” }, “city”: { “type”: “keyword” } } } } } }

  1. 造数据
  2. ```json
  3. PUT ckiss-company-002/_doc/1
  4. {
  5.   "companyId": 1,
  6.   "companyName": "华住集团",
  7.   "area": [
  8.     {
  9.       "province": "HN",
  10.       "city": "CS"
  11.     },
  12.     {
  13.       "province": "ZJ",
  14.       "city": "HZ"
  15.     }
  16.   ]
  17. }
  19. GET ckiss-company-002/_search
  20. {
  21.   "query": {
  22.     "nested": {
  23.       "path": "area",
  24.       "query": {
  25.         "bool": {
  26.           "must": [
  27.             {
  28.               "term": {
  29.                 "area.province": {
  30.                   "value": "HN"
  31.                 }
  32.               }
  33.             },
  34.             {
  35.               "term": {
  36.                 "area.city": {
  37.                   "value": "HZ"
  38.                 }
  39.               }
  40.             }
  41.           ]
  42.         }
  43.       }
  44.     }
  45.   }
  46. }

无响应内容

字段别名

  • alias: 字段类型关键字
  • path：设定别名代理的字段

    案例：假定基本信息，其中部分字段原来定义的是一个意思，后续又改变了

// TODO

fields 单值多字段

假设需要依据一个字段提供多种不同的检索要求，fields可以解决这种问题

案例： 假定一个基本信息，公司名称既能提供精确检锁，也能提供范围查询；公司收入也需要提供精确检索和数值比对的范围检索

  1. DELETE ckiss-company-002
  3. PUT ckiss-company-002
  4. {
  5.   "mappings": {
  6.     "properties": {
  7.       "companyId": {
  8.         "type": "integer"
  9.       },
  10.       "companyName": {
  11.         "type": "keyword",
  12.         "fields": {
  13.           "text": {
  14.             "type": "text"
  15.           }
  16.         }
  17.       },
  18.       "income": {
  19.         "type": "integer",
  20.         "fields": {
  21.           "sortKey": {
  22.             "type": "keyword"
  23.           }
  24.         }
  25.       }
  26.     }
  27.   }
  28. }
  30. PUT ckiss-company-002/_doc/1
  31. {
  32.   "companyId": 1,
  33.   "companyName" : "华住集团",
  34.   "income": 100000
  35. }
  37. PUT ckiss-company-002/_doc/2
  38. {
  39.   "companyId": 2,
  40.   "companyName" : "美团集团",
  41.   "income": 1000
  42. }
  44. # 范围查询
  45. GET ckiss-company-002/_search
  46. {
  47.   "query": {
  48.     "bool": {
  49.       "filter": {
  50.         "range": {
  51.           "income": {
  52.             "gte": 1000,
  53.             "lte": 20000
  54.           }
  55.         }
  56.       }
  57.     }
  58.   }
  59. }
  60. # 键值查询
  61. GET ckiss-company-002/_search
  62. {
  63.   "query": {
  64.     "bool": {
  65.       "filter": {
  66.         "term": {
  67.           "income.sortKey": "1000"
  68.         }
  69.       }
  70.     }
  71.   }
  72. }

Copy_to 字段复制

  • 原始值 ，可以指定复制多个字段，且按照顺序复制
  • 历史版本是_all字段，后来取消；增加了copy_to 弥补
  • copy_to，数据字段关键字

案例:

假定公司基本信息有地址，地址信息需要省份、城市、区县、等组成

  1. DELETE ckiss-company-002
  3. PUT ckiss-company-002
  4. {
  5.   "mappings": {
  6.     "properties": {
  7.       "companyId": {
  8.         "type": "integer"
  9.       },
  10.       "companyName": {
  11.         "type": "keyword"
  12.       },
  13.       "province": {
  14.         "type": "text",
  15.         "copy_to": "address"
  16.       },
  17.       "city": {
  18.         "type": "text",
  19.         "copy_to": "address"
  20.       },
  21.       "county":{
  22.         "type": "text",
  23.          "copy_to": "address"
  24.       },
  25.       "address": {
  26.         "type": "text"
  27.       }
  28.     }
  29.   }
  30. }
  32. PUT ckiss-company-002/_doc/1
  33. {
  34.   "companyId": 1,
  35.   "companyName": "美团集团",
  36.   "province": "HN",
  37.   "city": "CS",
  38.   "county": "Yuelu"
  39. }
  41. PUT ckiss-company-002/_doc/2
  42. {
  43.   "companyId": 2,
  44.   "companyName": "美团集团",
  45.   "province": "HN",
  46.   "city": "CS",
  47.   "county": "Yuelu",
  48.   "address": "Hello"
  49. }
  51. GET ckiss-company-002/_search
  52. {
  53.   "query": {
  54.     "match": {
  55.       "address": "Hello"
  56.     }
  57.   }
  58. }