- See Also:
Field SummaryModifier and TypeFieldDescription
final booleanWhether to use an optimization algorithm to suggest and populate an initial set of tiles.
final longMaximum time (in milliseconds) to run the algorithm.
final booleanWhether to materialize tiles on demand as queries are executed.List of measures that a tile should have by default.
final StringThe name of this lattice.
final @Nullable DoubleEstimated number of rows.
final ObjectSQL query that defines the lattice.
final @Nullable StringName of a class that provides estimates of the number of distinct values in each column.List of materialized aggregates to create up front.
namepublic final String nameThe name of this lattice.
sqlpublic final Object sqlSQL query that defines the lattice.
Must be a string or a list of strings (which are concatenated into a multi-line SQL string, separated by newlines).
The structure of the SQL statement, and in particular the order of items in the FROM clause, defines the fact table, dimension tables, and join paths for this lattice.
autopublic final boolean autoWhether to materialize tiles on demand as queries are executed.
Optional; default is true.
algorithmpublic final boolean algorithmWhether to use an optimization algorithm to suggest and populate an initial set of tiles.
Optional; default is false.
algorithmMaxMillispublic final long algorithmMaxMillisMaximum time (in milliseconds) to run the algorithm.
Optional; default is -1, meaning no timeout.
When the timeout is reached, Calcite uses the best result that has been obtained so far.
rowCountEstimatepublic final @Nullable Double rowCountEstimateEstimated number of rows.
If null, Calcite will a query to find the real value.
statisticProviderpublic final @Nullable String statisticProviderName of a class that provides estimates of the number of distinct values in each column.
The class must implement the
Or, you can use a class name plus a static field, for example "org.apache.calcite.materialize.Lattices#CACHING_SQL_STATISTIC_PROVIDER".
If not set, Calcite will generate and execute a SQL query to find the real value, and cache the results.
tilesList of materialized aggregates to create up front.
defaultMeasuresList of measures that a tile should have by default.
A tile can define its own measures, including measures not in this list.
Optional. The default list is just "count(*)".