Package mondrian.rolap.agg

Class AbstractQuerySpec

java.lang.Object
mondrian.rolap.agg.AbstractQuerySpec
All Implemented Interfaces:
QuerySpec
public abstract class AbstractQuerySpec extends Object implements QuerySpec
Base class for QuerySpec implementations.
Author:
jhyde, Richard M. Emberson

  • Field Details

    • countOnly

      protected final boolean countOnly

  • Constructor Details

    • AbstractQuerySpec

      protected AbstractQuerySpec(RolapStar star, boolean countOnly)
      Creates an AbstractQuerySpec.
      Parameters:
      star - Star which defines columns of interest and their relationships
      countOnly - If true, generate no GROUP BY clause, so the query returns a single row containing a grand total

  • Method Details

    • newSqlQuery

      protected SqlQuery newSqlQuery()
      Creates a query object.
      Returns:
      a new query object

    • getStar

      public RolapStar getStar()
      Specified by:
      getStar in interface QuerySpec

    • addMeasure

      protected void addMeasure(int i, SqlQuery sqlQuery)
      Adds a measure to a query.
      Parameters:
      i - Ordinal of measure
      sqlQuery - Query object

    • isAggregate

      protected abstract boolean isAggregate()

    • nonDistinctGenerateSql

      protected Map<String,String> nonDistinctGenerateSql(SqlQuery sqlQuery)

    • isPartOfSelect

      protected boolean isPartOfSelect(RolapStar.Column col)
      Allows subclasses to specify if a given column must be returned as part of the result set, in the select clause.

    • isPartOfSelect

      protected boolean isPartOfSelect(RolapStar.Measure measure)
      Allows subclasses to specify if a given column must be returned as part of the result set, in the select clause.

    • isOrdered

      protected boolean isOrdered()
      Whether to add an ORDER BY clause to make results deterministic. Necessary if query returns more than one row and results are for human consumption.
      Returns:
      whether to sort query

    • generateSqlQuery

      public Pair<String,List<SqlStatement.Type>> generateSqlQuery()
      Specified by:
      generateSqlQuery in interface QuerySpec

    • addGroupingFunction

      protected void addGroupingFunction(SqlQuery sqlQuery)

    • addGroupingSets

      protected void addGroupingSets(SqlQuery sqlQuery, Map<String,String> groupingSetsAliases)

    • getDistinctMeasureCount

      protected int getDistinctMeasureCount()
      Returns the number of measures whose aggregation function is distinct-count.
      Returns:
      Number of distinct-count measures

    • distinctGenerateSql

      protected Map<String,String> distinctGenerateSql(SqlQuery outerSqlQuery, boolean countOnly)
      Generates a SQL query to retrieve the values in this segment using an algorithm which converts distinct-aggregates to non-distinct aggregates over subqueries.
      Parameters:
      outerSqlQuery - Query to modify
      countOnly - If true, only generate a single row: no need to generate a GROUP BY clause or put any constraining columns in the SELECT clause
      Returns:
      A map of aliases used in the inner query if grouping sets were enabled.

    • extraPredicates

      protected void extraPredicates(SqlQuery sqlQuery)
      Adds predicates not associated with columns.
      Parameters:
      sqlQuery - Query

    • getPredicateList

      protected List<StarPredicate> getPredicateList()
      Returns a list of predicates not associated with a particular column.
      Returns:
      list of non-column predicates