Package com.exasol.sql.expression.function.exasol

Enum ExasolAggregateFunction

java.lang.Object

java.lang.Enum<ExasolAggregateFunction>

com.exasol.sql.expression.function.exasol.ExasolAggregateFunction

All Implemented Interfaces:

FunctionName, Serializable, Comparable<ExasolAggregateFunction>

public enum ExasolAggregateFunction
extends Enum<ExasolAggregateFunction>
implements FunctionName

This class is a list of Aggregate Functions that the Exasol database supports.

Currently unsupported functions: GROUPING, PERCENTILE_CONT, PERCENTILE_DISC, OVER clause for all aggregate functions and keywords. See github issue # 72.

Enum Constant Summary

Enum Constants

Enum Constant	Description
APPROXIMATE_COUNT_DISTINCT
AVG
CORR
COUNT
COVAR_POP
COVAR_SAMP
FIRST_VALUE
GROUP_CONCAT
LAST_VALUE
MAX
MEDIAN
MIN
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
VARIANCE

Method Summary

Modifier and Type	Method	Description
static ExasolAggregateFunction	valueOf(String name)	Returns the enum constant of this type with the specified name.
static ExasolAggregateFunction[]	values()	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.exasol.sql.expression.function.FunctionName

name

Enum Constant Detail

APPROXIMATE_COUNT_DISTINCT

public static final ExasolAggregateFunction APPROXIMATE_COUNT_DISTINCT

AVG

public static final ExasolAggregateFunction AVG

CORR

public static final ExasolAggregateFunction CORR

COUNT

public static final ExasolAggregateFunction COUNT

COVAR_POP

public static final ExasolAggregateFunction COVAR_POP

COVAR_SAMP

public static final ExasolAggregateFunction COVAR_SAMP

FIRST_VALUE

public static final ExasolAggregateFunction FIRST_VALUE

GROUP_CONCAT

public static final ExasolAggregateFunction GROUP_CONCAT

LAST_VALUE

public static final ExasolAggregateFunction LAST_VALUE

MAX

public static final ExasolAggregateFunction MAX

MEDIAN

public static final ExasolAggregateFunction MEDIAN

MIN

public static final ExasolAggregateFunction MIN

REGR_SLOPE

public static final ExasolAggregateFunction REGR_SLOPE

REGR_INTERCEPT

public static final ExasolAggregateFunction REGR_INTERCEPT

REGR_COUNT

public static final ExasolAggregateFunction REGR_COUNT

REGR_R2

public static final ExasolAggregateFunction REGR_R2

REGR_AVGX

public static final ExasolAggregateFunction REGR_AVGX

REGR_AVGY

public static final ExasolAggregateFunction REGR_AVGY

REGR_SXX

public static final ExasolAggregateFunction REGR_SXX

REGR_SXY

public static final ExasolAggregateFunction REGR_SXY

REGR_SYY

public static final ExasolAggregateFunction REGR_SYY

STDDEV

public static final ExasolAggregateFunction STDDEV

STDDEV_POP

public static final ExasolAggregateFunction STDDEV_POP

STDDEV_SAMP

public static final ExasolAggregateFunction STDDEV_SAMP

SUM

public static final ExasolAggregateFunction SUM

VAR_POP

public static final ExasolAggregateFunction VAR_POP

VAR_SAMP

public static final ExasolAggregateFunction VAR_SAMP

VARIANCE

public static final ExasolAggregateFunction VARIANCE

Method Detail

values

public static ExasolAggregateFunction[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (ExasolAggregateFunction c : ExasolAggregateFunction.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static ExasolAggregateFunction valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null