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.
There is a newer version: 2.0-preview1
Show 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")
     * }
     *
     * @deprecated use {@link #select(Expression...)}
     */
    @Deprecated
    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.
     *
     * Example:
     *
     * 
{@code
     * windowGroupedTable.select($("key"), $("window").start(), $("value").avg().as("valavg"));
     * }
     *
     * 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")
     * }
     *
     * @deprecated use {@link #aggregate(Expression)}
     */
    @Deprecated
    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.
     *
     * Example:
     *
     * 
{@code
     * windowGroupedTable.aggregate(call(MyAggregateFunction.class, $("a"), $("b")).as("x", "y", "z"))
     *   .select($("key"), $("window").start(), $("x"), $("y"), $("z"));
     * }
     *
     * 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")
     * }
     *
     * @deprecated use {@link #flatAggregate(Expression)}
     */
    @Deprecated
    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.
     *
     * Example:
     *
     * 
{@code
     * windowGroupedTable.flatAggregate(call(MyTableAggregateFunction.class, $("a"), $("b")).as("x", "y", "z"))
     *   .select($("key"), $("window").start(), $("x"), $("y"), $("z"));
     * }
     *
     * 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);
}