文章目录
一、ElasticSearch基础元素概念
索引(Index):索引是一种逻辑上的概念,类似于mysql中的表。 它是对具有相似特征的文档的逻辑分组。 每个索引具有唯一的名称,用于在Elasticsearch中存储、搜索和聚合数据。
文档(Document):文档是Elasticsearch中的基本数据单元,类似于mysql的某一张表的某一条记录。
二、简单搭建demo
新建一个简单的spring boot项目来学习一下ES的简单使用。项目demo已经给出,在文章头部即可点击下载学习。
1.引入ES相关jar包
<dependency>
<groupId>org.elasticsearch</groupId>
<artifactId>elasticsearch</artifactId>
<version>7.6.2</version>
</dependency>
<dependency>
<groupId>org.elasticsearch.client</groupId>
<artifactId>elasticsearch-rest-high-level-client</artifactId>
<version>7.6.2</version>
</dependency>
2.添加相关application配置
server.port=8080
elasticsearch.host=localhost
elasticsearch.port=9200
elasticsearch.connTimeout=3000
elasticsearch.socketTimeout=5000
elasticsearch.connectionRequestTimeout=500
3.连接配置config
public class ElasticsearchConfiguration {
@Value("${elasticsearch.host}")
private String host;
@Value("${elasticsearch.port}")
private int port;
@Value("${elasticsearch.connTimeout}")
private int connTimeout;
@Value("${elasticsearch.socketTimeout}")
private int socketTimeout;
@Value("${elasticsearch.connectionRequestTimeout}")
private int connectionRequestTimeout;
@Bean(destroyMethod = "close", name = "client")
public RestHighLevelClient initRestClient() {
RestClientBuilder builder = RestClient.builder(new HttpHost(host, port))
.setRequestConfigCallback(requestConfigBuilder -> requestConfigBuilder
.setConnectTimeout(connTimeout)
.setSocketTimeout(socketTimeout)
.setConnectionRequestTimeout(connectionRequestTimeout));
return new RestHighLevelClient(builder);
}
}
4.添加相关document
public class UserDocument {
private String id;
/**
* 姓名
*/
private String name;
/**
* 性别
*/
private String sex;
/**
* 年龄
*/
private Integer age;
/**
* 城市
*/
private String city;
}
5.添加相关dto
private static final long serialVersionUID = 5281938193022905426L;
/**
* 城市
*/
private String city;
/**
* 用户数
*/
private Long count;
/**
* 平均年龄
*/
private Double avgAge;
@Override
public String toString() {
return "UserCityDTO{" +
"city='" + city + '\'' +
", count=" + count +
", avgAge=" + avgAge +
'}';
}
6.controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
/**
* 创建索引
*
* @return
* @throws Exception
*/
@PostMapping("/createUserIndex")
public ResponseEntity<Boolean> createUserIndex(@RequestParam(value = "index") String index) throws Exception {
return ResponseEntity.status(HttpStatus.CREATED).body(userService.createUserIndex(index));
}
/**
* 删除索引
*
* @return
* @throws Exception
*/
@PostMapping("/deleteUserIndex")
public ResponseEntity<Boolean> deleteUserIndex(@RequestParam(value = "index") String index) throws Exception {
return ResponseEntity.status(HttpStatus.CREATED).body(userService.deleteUserIndex(index));
}
/**
* 新增文档
*
* @param document
* @return
* @throws Exception
*/
@PostMapping("/createUserDocument")
public ResponseEntity<Boolean> createUserDocument(@RequestBody UserDocument document) throws Exception {
return ResponseEntity.status(HttpStatus.CREATED).body(userService.createUserDocument(document));
}
/**
* 批量新增文档
*
* @param document
* @return
* @throws Exception
*/
@PostMapping("/bulkCreateUserDocument")
public ResponseEntity<Boolean> bulkCreateUserDocument(@RequestBody List<UserDocument> document) throws Exception {
return ResponseEntity.status(HttpStatus.CREATED).body(userService.bulkCreateUserDocument(document));
}
/**
* 删除文档
*
* @param id
* @return
* @throws Exception
*/
@PostMapping("/deleteUserDocument")
public String deleteUserDocument(@RequestParam String id) throws Exception {
return userService.deleteUserDocument(id);
}
/**
* 更新文档
*
* @param document
* @return
* @throws Exception
*/
@PostMapping("/updateUserDocument")
public ResponseEntity<Boolean> updateUserDocument(@RequestBody UserDocument document) throws Exception {
return ResponseEntity.status(HttpStatus.CREATED).body(userService.updateUserDocument(document));
}
/**
* 获取文档
*
* @param id
* @return
* @throws Exception
*/
@GetMapping("/getUserDocument")
public UserDocument getUserDocument(@RequestParam String id) throws Exception {
return userService.getUserDocument(id);
}
/**
* 用户列表
*
* @return
* @throws Exception
*/
@GetMapping("/getUserList")
public List<UserDocument> getUserList() throws Exception {
return userService.getUserList();
}
/**
* 城市聚合
*
* @return
* @throws Exception
*/
@GetMapping("/aggregationsSearchUser")
public List<UserCityDTO> aggregationsSearchUser() throws Exception {
return userService.aggregationsSearchUser();
}
/**
* 根据姓名搜索用户
*
* @param city
* @return
* @throws Exception
*/
@GetMapping("/searchUserByCity")
public List<UserDocument> searchUserByCity(@RequestParam(value = "city") String city) throws Exception {
return userService.searchUserByCity(city);
}
}
7.service实现
public class UserService {
private static final Logger logger = LoggerFactory.getLogger(UserService.class);
@Autowired
private RestHighLevelClient client;
public Boolean createUserDocument(UserDocument document) throws Exception {
UUID uuid = UUID.randomUUID();
document.setId(uuid.toString());
IndexRequest indexRequest = new IndexRequest(Constant.INDEX)
.id(document.getId())
.source(JSON.toJSONString(document), XContentType.JSON);
IndexResponse indexResponse = client.index(indexRequest, RequestOptions.DEFAULT);
return indexResponse.status().equals(RestStatus.CREATED);
}
public Boolean bulkCreateUserDocument(List<UserDocument> documents) throws IOException {
BulkRequest bulkRequest = new BulkRequest();
for (UserDocument document : documents) {
String id = UUID.randomUUID().toString();
document.setId(id);
IndexRequest indexRequest = new IndexRequest(Constant.INDEX)
.id(id)
.source(JSON.toJSONString(document), XContentType.JSON);
bulkRequest.add(indexRequest);
}
BulkResponse bulkResponse = client.bulk(bulkRequest, RequestOptions.DEFAULT);
return bulkResponse.status().equals(RestStatus.CREATED);
}
public UserDocument getUserDocument(String id) throws IOException {
GetRequest getRequest = new GetRequest(Constant.INDEX, id);
GetResponse getResponse = client.get(getRequest, RequestOptions.DEFAULT);
UserDocument result = new UserDocument();
if (getResponse.isExists()) {
String sourceAsString = getResponse.getSourceAsString();
result = JSON.parseObject(sourceAsString, UserDocument.class);
} else {
logger.error("没有找到该 id 的文档");
}
return result;
}
public Boolean updateUserDocument(UserDocument document) throws Exception {
UserDocument resultDocument = getUserDocument(document.getId());
UpdateRequest updateRequest = new UpdateRequest(Constant.INDEX, resultDocument.getId());
updateRequest.doc(JSON.toJSONString(document), XContentType.JSON);
UpdateResponse updateResponse = client.update(updateRequest, RequestOptions.DEFAULT);
return updateResponse.status().equals(RestStatus.OK);
}
public List<UserDocument> getUserList() throws Exception {
SearchRequest searchRequest = new SearchRequest(Constant.INDEX);
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
searchSourceBuilder.query(QueryBuilders.matchAllQuery());
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
return getSearchResult(searchResponse);
}
public List<UserDocument> searchUserByCity(String city) throws Exception {
SearchRequest searchRequest = new SearchRequest();
searchRequest.indices(Constant.INDEX);
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
TermQueryBuilder termQueryBuilder = QueryBuilders.termQuery("city", city);
searchSourceBuilder.query(termQueryBuilder);
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
return getSearchResult(searchResponse);
}
public String deleteUserDocument(String id) throws Exception {
DeleteRequest deleteRequest = new DeleteRequest(Constant.INDEX, id);
DeleteResponse response = client.delete(deleteRequest, RequestOptions.DEFAULT);
return response.getResult().name();
}
public List<UserCityDTO> aggregationsSearchUser() throws Exception {
SearchRequest searchRequest = new SearchRequest(Constant.INDEX);
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
TermsAggregationBuilder aggregation = AggregationBuilders.terms("by_city")
.field("city")
.subAggregation(AggregationBuilders
.avg("average_age")
.field("age"));
searchSourceBuilder.aggregation(aggregation);
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
Aggregations aggregations = searchResponse.getAggregations();
Terms byCityAggregation = aggregations.get("by_city");
List<UserCityDTO> userCityList = new ArrayList<>();
for (Terms.Bucket buck : byCityAggregation.getBuckets()) {
UserCityDTO userCityDTO = new UserCityDTO();
userCityDTO.setCity(buck.getKeyAsString());
userCityDTO.setCount(buck.getDocCount());
// 获取子聚合
Avg averageBalance = buck.getAggregations().get("average_age");
userCityDTO.setAvgAge(averageBalance.getValue());
userCityList.add(userCityDTO);
}
return userCityList;
}
private List<UserDocument> getSearchResult(SearchResponse response) {
SearchHit[] searchHit = response.getHits().getHits();
List<UserDocument> userDocuments = new ArrayList<>();
for (SearchHit hit : searchHit) {
userDocuments.add(JSON.parseObject(hit.getSourceAsString(), UserDocument.class));
}
return userDocuments;
}
public boolean createUserIndex(String index) throws IOException {
CreateIndexRequest createIndexRequest = new CreateIndexRequest(index);
createIndexRequest.settings(Settings.builder()
.put("index.number_of_shards", 1)
.put("index.number_of_replicas", 0)
);
createIndexRequest.mapping("{\n" +
" \"properties\": {\n" +
" \"city\": {\n" +
" \"type\": \"keyword\"\n" +
" },\n" +
" \"sex\": {\n" +
" \"type\": \"keyword\"\n" +
" },\n" +
" \"name\": {\n" +
" \"type\": \"keyword\"\n" +
" },\n" +
" \"id\": {\n" +
" \"type\": \"keyword\"\n" +
" },\n" +
" \"age\": {\n" +
" \"type\": \"integer\"\n" +
" }\n" +
" }\n" +
"}", XContentType.JSON);
CreateIndexResponse createIndexResponse = client.indices().create(createIndexRequest, RequestOptions.DEFAULT);
return createIndexResponse.isAcknowledged();
}
public Boolean deleteUserIndex(String index) throws IOException {
DeleteIndexRequest deleteIndexRequest = new DeleteIndexRequest(index);
AcknowledgedResponse deleteIndexResponse = client.indices().delete(deleteIndexRequest, RequestOptions.DEFAULT);
return deleteIndexResponse.isAcknowledged();
}
}
三、简单test
1.创建索引
2.新增文档
新增后可在kibana工具查询出来
3.查询文档
总结
ElasticSearch的基础使用还是比较简单的,重点难点是在实际业务场景中的聚合搜索。
后期跟进一下kibana工具的使用教程。