ElasticSearch（filter方式查询数据）

最新推荐文章于 2025-02-05 15:32:43 发布

转载最新推荐文章于 2025-02-05 15:32:43 发布 · 186 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/keke412/blog/906722

文章标签：

#大数据 #python

本文介绍了使用Elasticsearch QueryBuilders进行多种查询的方法，包括精确查询、模糊查询、多字段查询等，并展示了如何组合这些查询以实现复杂的数据检索需求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

        QueryBuilder queryBuilder = null;
	// 1.查询name为zhangsan的数据
	queryBuilder = QueryBuilders.termQuery("name", "zhangsan");
	// name前缀为zhang的数据
	queryBuilder = QueryBuilders.disMaxQuery()
			.add(QueryBuilders.termQuery("name", "zhangsan"))
			.add(QueryBuilders.prefixQuery("name", "zhang"));
	// 查询name 为zhangsan,lis1的数据，有两者中的任一个即为匹配
	queryBuilder = QueryBuilders.termsQuery("name", "zhangsan", "lis1");
	// 常用词查询
	queryBuilder = QueryBuilders.commonTermsQuery("name", "zhangsan");
	// age/name/address中包含2的记录
	queryBuilder = QueryBuilders.multiMatchQuery("2", "age", "name",
			"address");
	// 条件组合查询
	queryBuilder = QueryBuilders
			.boolQuery()
			.must(QueryBuilders.disMaxQuery().add(
					QueryBuilders.prefixQuery("name", "jmk")))
			.mustNot(QueryBuilders.termQuery("address", false));
	// .should(QueryBuilders.termQuery("age", "23"));
	// 正则匹配 查询name中包含jmk的记录
	queryBuilder = QueryBuilders.regexpQuery("name", ".*?jmk.?+");
	String[] likeTexts = { "jmk" };
	queryBuilder = QueryBuilders.moreLikeThisQuery(likeTexts);
	// 查询所有
	queryBuilder = QueryBuilders.matchAllQuery();

	// SearchRequestBuilder builder = client.prepareSearch(index)
	// .setTypes(type).setQuery(queryBuilder)
	// .addSort("age", SortOrder.DESC);
	SearchResponse response = client.prepareSearch().setIndices(index)
			.setTypes(type).setQuery(queryBuilder).setFrom(0).setSize(100)
			// .addSort("createTime", SortOrder.DESC)
			// .addSort(SortBuilders.fieldSort("age").order(SortOrder.DESC))
			//
			// addSort(SortBuilders.fieldSort("title.untouched").order(SortOrder.ASC))
			.execute().actionGet();

	client.close();
	// SearchResponse response = builder.execute().actionGet();
	SearchHits result = response.getHits();
	// 结果总数
	long total = result.getTotalHits();
	System.out.println("total:" + total);
	List<String> resultList = new ArrayList<String>();
	for (SearchHit hit : result) {
		resultList.add(hit.getSourceAsString());
	}
	return resultList;

转载于:https://my.oschina.net/keke412/blog/906722