Fusion Server

Version 4.2
How To
    Learn More

      Fusion SQL Aggregation

      Table of Contents

      SQL aggregations are translated to Solr facet queries to take advantage of Solr’s distributed aggregation capabilities. This allows for interactive data analysis over large data sets.

      Single and multi-dimension aggregation using supported aggregation functions operate over the entire query result and are designed to return accurate results. The supported aggregation functions that are fully pushed down to the search engine are: count(*), count(distinct), sum, avg, min, max.

      An example of a SQL aggregation that is translated to a Solr facet query is below:

      select company_name, count(*) as cnt from orders group by company_name
      order by cnt desc

      Having Clause

      A HAVING clause can also be applied to single and multi-dimension aggregations.