com.hazelcast.org.apache.calcite.model.JsonLattice Maven / Gradle / Ivy
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to you under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.hazelcast.org.apache.calcite.model;
import com.hazelcast.com.fasterxml.jackson.annotation.JsonCreator;
import com.hazelcast.com.fasterxml.jackson.annotation.JsonProperty;
import com.hazelcast.com.google.common.collect.ImmutableList;
import com.hazelcast.org.checkerframework.checker.nullness.qual.Nullable;
import java.util.ArrayList;
import java.util.List;
import java.util.StringJoiner;
import static java.util.Objects.requireNonNull;
/**
* Element that describes a star schema and provides a framework for defining,
* recognizing, and recommending materialized views at various levels of
* aggregation.
*
* Occurs within {@link JsonSchema#lattices}.
*
* @see JsonRoot Description of schema elements
*/
public class JsonLattice {
/** The name of this lattice.
*
*
Required.
*/
public final String name;
/** SQL 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.
*/
public final Object sql;
/** Whether to materialize tiles on demand as queries are executed.
*
*
Optional; default is true.
*/
public final boolean auto;
/** Whether to use an optimization algorithm to suggest and populate an
* initial set of tiles.
*
*
Optional; default is false.
*/
public final boolean algorithm;
/** Maximum 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.
*/
public final long algorithmMaxMillis;
/** Estimated number of rows.
*
*
If null, Calcite will a query to find the real value. */
public final @Nullable Double rowCountEstimate;
/** Name of a class that provides estimates of the number of distinct values
* in each column.
*
*
The class must implement the
* {@link com.hazelcast.org.apache.calcite.materialize.LatticeStatisticProvider} interface.
*
*
Or, you can use a class name plus a static field, for example
* "com.hazelcast.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. */
public final @Nullable String statisticProvider;
/** List of materialized aggregates to create up front. */
public final List tiles = new ArrayList<>();
/** List 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(*)".
*/
public final List defaultMeasures;
@JsonCreator
public JsonLattice(
@JsonProperty(value = "name", required = true) String name,
@JsonProperty(value = "sql", required = true) Object sql,
@JsonProperty("auto") @Nullable Boolean auto,
@JsonProperty("algorithm") @Nullable Boolean algorithm,
@JsonProperty("algorithmMaxMillis") @Nullable Long algorithmMaxMillis,
@JsonProperty("rowCountEstimate") @Nullable Double rowCountEstimate,
@JsonProperty("statisticProvider") @Nullable String statisticProvider,
@JsonProperty("defaultMeasures") @Nullable List defaultMeasures) {
this.name = requireNonNull(name, "name");
this.sql = requireNonNull(sql, "sql");
this.auto = auto == null || auto;
this.algorithm = algorithm != null && algorithm;
this.algorithmMaxMillis = algorithmMaxMillis == null ? -1 : algorithmMaxMillis;
this.rowCountEstimate = rowCountEstimate;
this.statisticProvider = statisticProvider;
this.defaultMeasures = defaultMeasures == null
? ImmutableList.of(new JsonMeasure("count", null)) : defaultMeasures;
}
public void accept(ModelHandler handler) {
handler.visit(this);
}
@Override public String toString() {
return "JsonLattice(name=" + name + ", sql=" + getSql() + ")";
}
/** Returns the SQL query as a string, concatenating a list of lines if
* necessary. */
public String getSql() {
return toString(sql);
}
/** Converts a string or a list of strings to a string. The list notation
* is a convenient way of writing long multi-line strings in JSON. */
static String toString(Object o) {
requireNonNull(o, "argument must not be null");
//noinspection unchecked
return o instanceof String ? (String) o
: concatenate((List) o);
}
/** Converts a list of strings into a multi-line string. */
private static String concatenate(List list) {
final StringJoiner buf = new StringJoiner("\n", "", "\n");
for (Object o : list) {
if (!(o instanceof String)) {
throw new RuntimeException(
"each element of a string list must be a string; found: " + o);
}
buf.add((String) o);
}
return buf.toString();
}
public void visitChildren(ModelHandler modelHandler) {
for (JsonMeasure jsonMeasure : defaultMeasures) {
jsonMeasure.accept(modelHandler);
}
for (JsonTile jsonTile : tiles) {
jsonTile.accept(modelHandler);
}
}
}