org.apache.flink.table.api.WindowGroupedTable Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of flink-table-api-java Show documentation
This module contains the Table/SQL API for writing table programs within the table ecosystem using the Java programming language.
The newest version!
/*
 * 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 org.apache.flink.table.api;

import org.apache.flink.annotation.PublicEvolving;
import org.apache.flink.table.expressions.Expression;

/**
 * A table that has been windowed and grouped for {@link GroupWindow}s.
 */
@PublicEvolving
public interface WindowGroupedTable {

	/**
	 * Performs a selection operation on a window grouped table. Similar to an SQL SELECT statement.
	 * The field expressions can contain complex expressions and aggregations.
	 *
	 * Example:
	 *
	 * 
	 * {@code
	 *   windowGroupedTable.select("key, window.start, value.avg as valavg")
	 * }
	 * 
	 */
	Table select(String fields);

	/**
	 * Performs a selection operation on a window grouped table. Similar to an SQL SELECT statement.
	 * The field expressions can contain complex expressions and aggregations.
	 *
	 * Scala Example:
	 *
	 * 
	 * {@code
	 *   windowGroupedTable.select('key, 'window.start, 'value.avg as 'valavg)
	 * }
	 * 
	 */
	Table select(Expression... fields);

	/**
	 * Performs an aggregate operation on a window grouped table. You have to close the
	 * {@link #aggregate(String)} with a select statement. The output will be flattened if the
	 * output type is a composite type.
	 *
	 * Example:
	 *
	 * 
	 * {@code
	 *   AggregateFunction aggFunc = new MyAggregateFunction();
	 *   tableEnv.registerFunction("aggFunc", aggFunc);
	 *   windowGroupedTable
	 *     .aggregate("aggFunc(a, b) as (x, y, z)")
	 *     .select("key, window.start, x, y, z")
	 * }
	 * 
	 */
	AggregatedTable aggregate(String aggregateFunction);

	/**
	 * Performs an aggregate operation on a window grouped table. You have to close the
	 * {@link #aggregate(Expression)} with a select statement. The output will be flattened if the
	 * output type is a composite type.
	 *
	 * Scala Example:
	 *
	 * 
	 * {@code
	 *   val aggFunc = new MyAggregateFunction
	 *   windowGroupedTable
	 *     .aggregate(aggFunc('a, 'b) as ('x, 'y, 'z))
	 *     .select('key, 'window.start, 'x, 'y, 'z)
	 * }
	 * 
	 */
	AggregatedTable aggregate(Expression aggregateFunction);

	/**
	 * Performs a flatAggregate operation on a window grouped table. FlatAggregate takes a
	 * TableAggregateFunction which returns multiple rows. Use a selection after flatAggregate.
	 *
	 * Example:
	 *
	 * 
	 * {@code
	 *   TableAggregateFunction tableAggFunc = new MyTableAggregateFunction();
	 *   tableEnv.registerFunction("tableAggFunc", tableAggFunc);
	 *   windowGroupedTable
	 *     .flatAggregate("tableAggFunc(a, b) as (x, y, z)")
	 *     .select("key, window.start, x, y, z")
	 * }
	 * 
	 */
	FlatAggregateTable flatAggregate(String tableAggregateFunction);

	/**
	 * Performs a flatAggregate operation on a window grouped table. FlatAggregate takes a
	 * TableAggregateFunction which returns multiple rows. Use a selection after flatAggregate.
	 *
	 * Scala Example:
	 *
	 * 
	 * {@code
	 *   val tableAggFunc = new MyTableAggregateFunction
	 *   windowGroupedTable
	 *     .flatAggregate(tableAggFunc('a, 'b) as ('x, 'y, 'z))
	 *     .select('key, 'window.start, 'x, 'y, 'z)
	 * }
	 * 
	 */
	FlatAggregateTable flatAggregate(Expression tableAggregateFunction);
}