# Elasticsearch 聚合加条件搜索一起检索

**URL:** <https://discuss.elastic.co/t/elasticsearch/205981>\
**Category:** 中文提问与讨论\
**Created:** [October 31, 2019, 6:26am UTC](https://discuss.elastic.co/t/elasticsearch/205981 "2019-10-31T06:26:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wwl1](https://avatars.discourse-cdn.com/v4/letter/w/0ea827/32.png) [@wwl1](https://discuss.elastic.co/u/wwl1)\
**Post date:** [October 31, 2019, 6:26am UTC](https://discuss.elastic.co/t/elasticsearch/205981/1 "2019-10-31T06:26:19Z")

</div>

例如：根据一个产品名称查相关的产品信息，多个，页数为10，然后根据产品的公司再查公司信息，公司名称不能重复但返回的条数必须为10条，该怎么处理

---

<div class="post-metadata">

**Author:** ![liuxg](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@liuxg](https://discuss.elastic.co/u/liuxg)\
**Post date:** [November 19, 2019, 9:49am UTC](https://discuss.elastic.co/t/elasticsearch/205981/2 "2019-11-19T09:49:09Z")

</div>

使用Elasticsearch最好的方法是使我们的文档扁平化，也就是通常所说的denormalization，使用臃余的数据来提高搜索效率。你可以参考文章https://elasticstack.blog.csdn.net/article/details/100068659 我们采用nested object可以帮我们提高搜索的效率，但是，我们也可以采用joined 数据类型。你可以阅读文章：[https://elasticstack.blog.csdn.net/article/details/100162379。通常情况下并不建议使用这种。](https://elasticstack.blog.csdn.net/article/details/100162379%E3%80%82%E9%80%9A%E5%B8%B8%E6%83%85%E5%86%B5%E4%B8%8B%E5%B9%B6%E4%B8%8D%E5%BB%BA%E8%AE%AE%E4%BD%BF%E7%94%A8%E8%BF%99%E7%A7%8D%E3%80%82)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 17, 2019, 9:49am UTC](https://discuss.elastic.co/t/elasticsearch/205981/3 "2019-12-17T09:49:22Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.