下载Elasticsearch：

https://www.elastic.co/cn/downloads/elasticsearch

下载kibana可视化插件：

https://www.elastic.co/cn/downloads/kibana

Elasticsearch配置文件：

安装目录—config目录下—elasticsearch.yml：

  1. cluster.name: Ealdan   #配置elasticsearch的集群名称，默认是elasticsearch。建议修改成一个有意义的名称。
  2. node.name: Ealdan_node_1  #节点名，通常一台物理服务器就是一个节点，es会默认随机指定一个名字，建议指定一个有意义的名称，方便管理
  3. network.host: 127.0.0.1  #绑定ip地址
  4. http.port: 9200  #暴露的http端口
  5. transport.tcp.port: 9300  #内部端口
  6. transport.host: localhost
  7. node.master: true  #主节点
  8. node.data: true  #数据节点
  9. node.ingest: true
  10. #discovery.zen.ping.unicast.hosts: ["0.0.0.0:9300", "0.0.0.0:9301", "0.0.0.0:9302"]  #设置集群中master节点的初始列表
  11. #discovery.zen.minimum_master_nodes: 1  #主结点数量的最少值 ,此值的公式为：(master_eligible_nodes / 2) + 1 ，比如：有3个符合要求的主结点，那么这里要设置为2。
  12. bootstrap.memory_lock: false  #内存的锁定只给es用
  13. node.max_local_storage_nodes: 1 #单机允许的最大存储结点数，通常单机启动一个结点建议设置为1，开发环境如果单机启动多个节点可设置大于1
  14. path.data: D:\编程软件\elasticsearch-7.8.0\data  #索引目录
  15. path.logs: D:\编程软件\elasticsearch-7.8.0\logs    #日志
  16. #http.cors.enabled: true #  跨域设置
  17. #http.cors.allow‐origin: /.*/

kibana配置文件：

安装目录—config目录下—elasticsearch.yml：

  1. server.port: 5601
  2. server.host: "0.0.0.0"
  3. elasticsearch.hosts: ["http://localhost:9200"]
  4. elasticsearch.requestTimeout: 90000

启动Elasticsearch：

在安装目录的bin目录下，启动elasticsearch.bat文件
浏览器输入：http://localhost:9200/
查看集群：http://localhost:9200/_cat/nodes?pretty

启动kibana：

在安装目录的bin目录下，启动kibana.bat文件
浏览器输入：http://localhost:5601/app/kibana#
7.0版本之后put型式添加文档，必须要指定id

  1. GET _search
  2. {
  3.   "query": {
  4.     "match_all": {}
  5.   }
  6. }
  8. #查看所有节点信息
  9. GET _cat/nodes?v&s
  10. #查看所有索引状态
  11. GET _cat/indices
  12. GET _cat/indices?v&s
  13. #查看所以年相关信息
  14. GET users
  15. #查看索引的前十条文档
  16. GET movies/_search
  17. #查看状态为绿的索引
  18. GET _cat/indices?v&health=green
  19. #按照文档个数排序
  20. GET _cat/indices?v&s=docs.count:desc
  21. #查看具体的字段
  22. GET _cat/indices?pri&v&h=health,index,pri,rep,docs,count,mt
  23. GET _cat/nodes
  24. #添加索引库
  25. PUT blog
  26. {
  27. "mappings": {
  28.   "properties": {
  29.     "title": {
  30.       "type": "text",
  31.       "index": true,
  32.       "store": true,
  33.       "analyzer": "standard"
  34.     },
  35.     "comment":{
  36.       "type": "keyword",
  37.       "store": true,
  38.       "index": false
  39.     }
  40.   }
  41. }
  42. }
  44. GET blog
  46. POST blog/_doc
  47. {
  48.   "name": "text"
  49. }
  51. GET blog/_search
  53. DELETE blog
  55. PUT /blog
  56. {
  57.   "settings": {
  58.     "number_of_shards": 3,
  59.     "number_of_replicas": 1
  60.   },
  61.   "mappings": {
  62.     "properties": {
  63.       "title":{
  64.         "type": "text",
  65.         "index": true,
  66.         "store": true,
  67.         "analyzer": "standard"
  68.       },
  69.       "comment":{
  70.         "type":"keyword",
  71.         "store": true,
  72.         "index": true
  73.       }
  74.     }
  75.   }
  76. }
  77. #查询索引库
  78. GET blog/_search
  79. #添加一条内容，put必须指定id
  80. PUT blog/_doc/1
  81. {
  82.   "title":"Ealdan",
  83.   "comment":"elastic kibana"
  84. }
  85. #添加一条内容
  86. POST blog/_doc/2
  87. {
  88.   "title":"测试实例",
  89.   "comment":"搜索引擎",
  90.   "name":"Ealdan"
  91. }
  92. #删除一条内容
  93. DELETE blog/_doc/2
  94. #查询索引库中包含该字段的数据
  95. GET blog/_search?q=name:"Ealdan"
  97. #分词器测试
  98. POST _analyze
  99. {
  100.   "analyzer": "standard",
  101.   "text":"Ealdan Test"
  102. }
  104. POST movies/_analyze
  105. {
  106.   "field": "title",
  107. }
  108. #查询包含的数据
  109. GET /_search
  110. {
  111.   "query": {
  112.     "match": {
  113.       "name": "Ealdan"
  114.     }
  115.   }
  116. }
  117. #分词器
  118. POST _analyze
  119. {
  120.   "analyzer":"ik_smart",
  121.   "text":"大吉大利"
  122. }
  123. POST _analyze
  124. {
  125.   "analyzer":"ik_max_word",
  126.   "text":"大吉大利"
  127. }
  1. # 创建索引
  2.  PUT test
  3.  {
  4.  "settings": {
  5.  "index":{
  6.  "number_of_shards":5,
  7.  "number_of_replicas":1
  8. }
  9. }
  10. }
  12. # 使用默认配置创建索引pretty只是为了如果json返回打印更  加的漂亮一点
  13. PUT test2?pretty
  14. # 更改索引值
  15. PUT test/_settings 
  16. {
  17. "number_of_replicas":0
  18. }
  20. # 查看指定的索引配置信息
  21. GET test/_settings
  23. # 查看所有的索引配置信息
  24. GET _all/_settings
  26. # 查看所有的索引的健康信息
  27. GET /_cat/indices?v
  29. # 向索引库中添加文档
  30. PUT /test/zjj/1
  31. {
  32. "name":"xiaou",
  33. "age":18,
  34. "desc":"我是xiaou"
  35. }
  37. # 通过id获得信息
  38. GET /test/zjj/1
  40. # GET /test/zjj出现问题
  41. # 对查询数据筛选
  42. GET /test/zjj/1?_source=age,desc
  44. # 修改文档 
  45. # 1覆盖id
  46. PUT /test/zjj/1
  47. {
  48. "age":"20"
  49. }
  51. # 2修改
  52. POST /test/zjj/1
  53. {
  54.   "age":18
  55. }
  57. # 更新
  59. POST /test/zjj/1/_update?pretty
  60. {
  61. "script" : "ctx._source.age += 5"
  62. }
  63. # 删除
  65. DELETE test/zjj/2
  67. # 删除索引库
  68. DELETE test
  70. PUT xiaou
  71. {
  73.   "settings":{
  75.     "index":{
  76.       "number_of_shards": 3,
  77.       "number_of_replicas": 0
  78.     }
  79.   }
  80. }
  83. POST /xiaou/test/_bulk
  84. {"index":{"_id":1}}
  85. {"title":"Java","price":55}
  86. {"index":{"_id":2}}
  87. {"title":"php","price":60}
  88. {"index":{"_id":3}}
  89. {"title":"ww","price":75}
  91. GET xiaou/test/_mget
  92. {
  93.   "ids":["1","2","3","4"]
  94. }
  96. POST /xiaou/test/_bulk
  97. {"delete":{"_id":1}}
  98. {"create":{"_id":4}}
  99. {"title":"javascript","price":75}
  100. {"index":{"_index":"test3","_type":"t","_id":1}}
  101. {"name":"xiaou"}
  102. {"update":{"_index":"xiaou","_type":"test","_id":3}}
  103. {"doc":{"price":58}}
  105. POST /xiaou/test/_bulk
  106. {"index":{"_id":1}}
  107. {"title":"i love java"}
  108. GET /xiaou/_mapping
  110. GET xiaou/test/_search?q=java
  112. PUT test4
  113. {
  114. "settings": {
  115.   "index":{
  116.     "number_of_shards": 3,
  117.     "number_of_replicas": 0
  118.   }
  119. },"mappings": {
  120.   "books":{
  121.     "properties": {
  122.       "title":{"type":"text"},
  123.       "name":{"type":"text","index":false},
  124.       "price":{"type":"double"},
  125.       "number":{"type":"object",
  126.                 "dynamic":true}
  127.     }
  128.   }
  129. }
  130. }
  132. GET test4/_mapping
  134. PUT test4/books/1
  135. {
  136.   "name":"xiaou",
  137.   "number":{"1":1,"2":3},
  138.   "price":56.55,
  139.   "title":"this java"
  140. }
  142. GET /test4/books/1
  144. # 数据准备
  145. PUT /lib3
  146. {
  147.   "settings":{
  148.     "number_of_shards" : 3,
  149.     "number_of_replicas" : 0
  150.   },
  151.   "mappings":{
  152.     "user":{
  153.       "properties":{
  154.         "name": {"type":"text",
  155.                  "analyzer": "ik_max_word"},
  156.         "address": {"type":"text",
  157.                     "analyzer": "ik_max_word"},
  158.         "age": {"type":"integer"},
  159.         "desc": {"type":"text",
  160.                  "analyzer": "ik_max_word"},
  161.         "birthday": {"type":"date"}
  162.       }
  163.     }
  164.   }
  165. }
  167. PUT /lib3/user/1
  168. {"name":"小美",
  169.  "address":"浙江桐乡",
  170.  "age":18,
  171.  "desc":"喜欢唱歌，吃饭，睡觉",
  172.  "birthday":"1999-03-05"}
  174. PUT /lib3/user/2
  175. {"name":"小u",
  176.  "address":"浙江杭州",
  177.  "age": 25,
  178.  "desc":"喜欢唱歌，睡觉",
  179.  "birthday":"1999-03-05"}
  181. PUT /lib3/user/3
  182. {"name":"小啦",
  183.  "address":"浙江下沙",
  184.  "age":16,
  185.  "desc":"喜欢玩游戏，睡觉",
  186.  "birthday":"1999-03-05"}
  188. PUT /lib3/user/4
  189. {"name":"小打",
  190.  "address":"浙江呜呜",
  191.  "age":12,
  192.  "desc":"喜欢玩游戏",
  193.  "birthday":"2000-03-05"}
  195. # term查询
  196. GET /lib3/user/_search
  197. {
  198.   "query": {
  199.     "term": {"name":"小美"}
  200.   }
  201. }
  203. # terms查询
  204. GET /lib3/user/_search
  205. {
  206.   "query": {
  207.     "terms": {"desc":["吃饭","游戏"]}
  208.   }
  209. }
  211. # 分页
  212. GET /lib3/user/_search
  213. {
  214.   "from": 0,
  215.   "size": 2, 
  216.   "query": {
  217.     "terms": {"desc":["吃饭","游戏"]}
  218.   }
  219. } 
  221. # 返回版本号
  222. GET /lib3/user/_search
  223. {
  224.   "from": 0,
  225.   "size": 2,
  226.   "version": true, 
  227.   "query": {
  228.     "terms": {"desc":["吃饭","游戏"]}
  229.   }
  230. } 
  232. # match查询
  233. GET /lib3/user/_search
  234. {
  235.   "query": {
  236.     "match": {
  237.       "address": "拉你桐乡"
  238.     }
  239.   }
  240. }
  242. # 查询所有文档
  243. GET /lib3/user/_search
  244. {
  245.   "query": {
  246.     "match_all": {}
  247.   }
  248. }
  250. # 指定多个字段
  251. GET lib3/user/_search
  252. {
  253.   "query": {
  254.     "multi_match": {
  255.       "query": "游戏桐乡",
  256.       "fields": ["address","desc"]
  257.     }
  258.   }
  259. }
  261. # 短语匹配查询
  262. GET  lib3/user/_search
  263. {
  264.   "query": {
  265.     "match_phrase": {
  266.       "desc": "玩游戏"
  267.     }
  268.   }
  269. }
  271. # 指定返回的字段
  272. GET  lib3/user/_search
  273. {
  274.   "_source": ["address","desc"], 
  275.   "query": {
  276.     "match_phrase": {
  277.       "desc": "玩游戏"
  278.     }
  279.   }
  280. }
  282. # 控制加载的字段
  283. GET /lib3/user/_search
  284. {
  285.   "query": {
  286.     "match_all": {}
  287.   },
  288.   "_source": {
  289.     "includes": ["name"],
  290.     "excludes": ["age"]
  291.   }
  292. }
  294. # 通配符
  295. GET /lib3/user/_search
  296. {
  297.   "query": {
  298.     "match_all": {}
  299.   },
  300.   "_source": {
  301.     "includes": ["n*"],
  302.     "excludes": ["a?e"]
  303.   }
  304. }
  306. # sort
  307. GET /lib3/user/_search
  308. {
  309.   "query": {
  310.     "match_all": {}
  311.   },
  312.   "sort": [
  313.     {
  314.       "age": {"order": "asc"}
  315.     }
  316.   ]
  317. }
  319. # 前缀匹配查询
  320. GET /lib3/user/_search
  321. {
  322.   "query": {
  323.     "match_phrase_prefix": {
  324.       "name": "小"
  325.     }
  326.   }
  327. }
  329. # 范围查询
  330. GET /lib3/user/_search
  331. {
  332.   "query": {
  333.     "range": {
  334.       "birthday": {
  335.         "gte": "1999-01-01",
  336.         "lte": "2000-01-01"
  337.       }
  338.     }
  339.   }
  340. }
  342. # wildcard查询
  343. GET /lib3/user/_search
  344. {
  345.   "query": {
  346.     "wildcard": {
  347.       "name": {
  348.         "value": "*u"
  349.       }
  350.     }
  351.   }
  352. }
  354. # fuzzy实现模糊查询
  355. GET /lib3/user/_search
  356. {
  357.   "query": {
  358.     "fuzzy": {"name":"u"}
  359.   }
  360. }
  362. # 高亮
  363. GET /lib3/user/_search
  364. {
  365.   "query": {
  366.     "match": {
  367.       "desc": "唱歌"
  368.     }
  369.   },
  370.   "highlight": {
  371.     "fields": {
  372.       "desc": {}  
  373.     }
  374.   }
  375. }
  377. POST /lib4/items/_bulk
  378. {"index": {"_id": 1}}
  379. {"price": 40,"itemID": "ID100123"}
  380. {"index": {"_id": 2}}
  381. {"price": 50,"itemID": "ID100124"}
  382. {"index": {"_id": 3}}
  383. {"price": 25,"itemID": "ID100124"}
  384. {"index": {"_id": 4}}
  385. {"price": 30,"itemID": "ID100125"}
  386. {"index": {"_id": 5}}
  387. {"price": null,"itemID": "ID100127"}
  389. GET lib4/items/_search
  390. {
  391.   "post_filter": {
  392.     "term": {
  393.       "price": "40"
  394.     }
  395.   }
  396. }
  398. GET lib4/items/_search
  399. {
  400.   "post_filter": {
  401.     "terms": {
  402.       "price":[25,40]
  403.     }
  404.   }
  405. }
  407. GET lib4/items/_search
  408. {
  409.   "post_filter": {
  410.     "term": {
  411.       "itemID": "id100123"
  412.     }
  413.   }
  414. } 
  416. # 组合过滤查询
  417. GET lib4/items/_search
  418. {
  419.   "post_filter": {
  420.     "bool": {
  421.       "should":[
  422.         {"term":{"price":25}},
  423.         {"term":{"itemID":"id100123"}}
  424.       ],
  425.       "must_not":{"term":{"price":30}}
  426.     }
  427.   }
  428. }
  430. GET lib4/items/_search
  431. {
  432.   "post_filter": {
  433.     "bool": {
  434.       "should":[{"term":{"price":25}}],
  435.       "must_not":{"term":{"price":30}}
  436.     }
  437.   }
  438. }
  440. # 嵌套使用bool
  441. GET lib4/items/_search
  442. {
  443.   "post_filter": {
  444.     "bool": {
  445.       "should":[{"term":{"itemID":"id100123"}},
  446.                 {"bool":{
  447.                   "must":[
  448.                     {"term":{"itemID":"id100124"}},
  449.                     {"term":{"price":40}}
  450.                   ]
  451.                 }
  452.                 }
  453.                ]
  454.     }
  455.   }
  456. }
  458. # 范围过滤
  459. GET lib4/items/_search
  460. {
  461.   "post_filter": {
  462.     "range": {
  463.       "price": {
  464.         "gte": 40,
  465.         "lt": 50
  466.       }
  467.     }
  468.   }
  469. }
  471. # 过滤非空
  472. GET lib4/items/_search
  473. {
  474.   "query": {
  475.     "bool": {
  476.       "filter": {
  477.         "exists": {
  478.           "field": "price"
  479.         }
  480.       }
  481.     }
  482.   }
  483. }
  485. # sum
  486. GET lib4/items/_search
  487. {
  488.   "size": 0,
  489.   "aggs": {
  490.     "price_sum": {
  491.       "sum": {
  492.         "field": "price"
  493.       }
  494.     }
  495.   }
  496. }
  498. # avg
  499. GET lib4/items/_search
  500. {
  501.   "size": 0,
  502.   "aggs": {
  503.     "price_avg": {
  504.       "avg": {
  505.         "field": "price"
  506.       }
  507.     }
  508.   }
  509. }
  511. #max
  512. GET lib4/items/_search
  513. {
  514.   "size": 0,
  515.   "aggs": {
  516.     "price_max": {
  517.       "max": {
  518.         "field": "price"
  519.       }
  520.     }
  521.   }
  522. }
  524. #min
  525. GET lib4/items/_search
  526. {
  527.   "size": 0,
  528.   "aggs": {
  529.     "price_min": {
  530.       "min": {
  531.         "field": "price"
  532.       }
  533.     }
  534.   }
  535. }
  537. # cardinality:求基数
  538. GET lib4/items/_search
  539. {
  540.   "size": 0,
  541.   "aggs": {
  542.     "price_card": {
  543.       "cardinality": {
  544.         "field": "price"
  545.       }
  546.     }
  547.   }
  548. }
  550. # 分组
  551. GET lib4/items/_search
  552. {
  553.   "size": 0,
  554.   "aggs":{
  555.     "price_group":{
  556.       "terms": {
  557.         "field": "price"
  558.       }
  559.     }
  560.   }
  561. }
  563. #
  564. GET lib3/user/_search
  565. {
  566.   "query": {
  567.     "match": {
  568.       "desc": "唱歌"
  569.     }
  570.   }, 
  571.   "size": 0
  572.   , "aggs": {
  573.     "avg_group_by": {
  574.       "terms": {
  575.         "field": "age",
  576.         "order": {"avg_of_age": "desc"}
  577.       },
  578.       "aggs": {
  579.         "avg_of_age": {
  580.           "avg": {
  581.             "field": "age"
  582.           }
  583.         }
  584.       }
  585.     }
  586.   }
  587. }
  589. # 复合查询
  590. GET lib3/user/_search
  591. {
  592.   "query": {
  593.     "bool": {
  594.       "must": [
  595.         {"match": {
  596.           "desc": "唱歌"
  597.         }}
  598.       ],
  599.       "must_not": [
  600.         {"match": {
  601.           "desc": "吃饭"
  602.         }}
  603.       ],
  604.       "should": [
  605.         {"match": {
  606.           "address": "杭州"
  607.         }},
  608.         {"range": {
  609.           "birthday": {
  610.             "gte": "1999-03-05",
  611.             "lte": "2000-03-05"
  612.           }
  613.         }}
  614.       ]
  615.     } 
  616.   }
  617. }
  619. GET lib3/user/_search
  620. {
  621.   "query": {
  622.     "bool": {
  623.       "must": [
  624.         {"match": {
  625.           "desc": "唱歌"
  626.         }}
  627.       ],
  628.       "filter": {
  629.         "bool": {
  630.           "must":{
  631.             "range": {
  632.               "birthday": {
  633.                 "gte": "1999-03-05",
  634.                 "lt": "2000-03-05"
  635.               }
  636.             }
  637.           }
  638.         }
  639.       }
  640.     }
  641.   }
  642. }