問題描述

我正在嘗試以嵌套方式按多個字段執行搜索結果聚合(計數和總和)分組.

I am trying to perform search result aggregation (count and sum) grouping by several fields in a nested fashion.

例如，使用本文末尾顯示的架構，我希望能夠獲得按類別"分組并按子類別"進一步分組的大小"總和，并得到類似這個:

For example, with the schema shown at the end of this post, I'd like to be able to get the sum of "size" grouped by "category" and sub-grouped further by "subcategory" and get something like this:

<category name="X">
  <subcategory name="X_A">
    <size sum="..." />
  </subcategory>
  <subcategory name="X_B">
    <size sum="..." />
  </subcategory>
</category>
....

我主要關注 Solr 的 Stats 組件，據我所知，它不允許嵌套聚合.

I've been looking primarily at Solr's Stats component which, as far as I can see, doesn't allow nested aggregation.

如果有人知道使用或不使用 Stats 組件的某種方式來實現這一點，我將不勝感激.

I'd appreciate it if anyone knows of some way to implement this, with or without the Stats component.

這是目標架構的精簡版:

Here is a cut-down version of the target schema:

<types>
  <fieldType name="string" class="solr.StrField" />
  <fieldType name="text" class="solr.TextField">
    <analyzer><tokenizer class="solr.StandardTokenizerFactory" /></analyzer>
  </fieldType>
  <fieldType name="date" class="solr.DateField" />
  <fieldType name="int" class="solr.TrieIntField" precisionStep="0" omitNorms="true" positionIncrementGap="0" />
</types>

<fields>
  <field name="id" type="string" indexed="true" stored="true" />
  <field name="category" type="text" indexed="true" stored="true" />
  <field name="subcategory" type="text" indexed="true" stored="true" />
  <field name="pdate" type="date" indexed="true" stored="true" />
  <field name="size" type="int" indexed="true" stored="true" />
</fields>

推薦答案

Solr 5.1 中新的 faceting 模塊可以做到這一點，它被添加到 https://issues.apache.org/jira/browse/SOLR-7214

The new faceting module in Solr 5.1 can do this, it was added in https://issues.apache.org/jira/browse/SOLR-7214

以下是如何將 sum(size) 添加到每個構面桶，并按該統計數據降序排序.

Here is how you would add sum(size) to every facet bucket, and sort descending by that statistic.

json.facet={
  categories:{terms:{
    field:category,
    sort:"total_size desc",  // this will sort the facet buckets by your stat 
    facet:{
      total_size:"sum(size)"  // this calculates the stat per bucket
    }
  }}
}

這就是您在子類別中添加子方面的方式:

And this is how you would add in the subfacet on subcategory:

json.facet={
  categories:{terms:{
    field:category,
    sort:"total_size desc",
    facet:{
      total_size:"sum(size)",
      subcat:{terms:{ // this will facet on the subcategory field for each bucket
        field:subcategory,
        facet:{
         sz:"sum(size)"  // this calculates the sum per sub-cat bucket          
      }}
    }
  }}
}

因此，以上內容將為您提供類別和子類別級別的總和(大小).新 facet 模塊的文檔目前位于 http://yonik.com/json-facet-api/

So the above will give you the sum(size) at both the category and subcategory levels. Documentation for the new facet module is currently at http://yonik.com/json-facet-api/

這篇關于如何對 Solr 中的多個字段執行嵌套聚合?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！