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

Enum ExasolAnalyticAggregateFunctions

java.lang.Object

java.lang.Enum<ExasolAnalyticAggregateFunctions>

com.exasol.sql.expression.function.exasol.ExasolAnalyticAggregateFunctions

All Implemented Interfaces:

FunctionName, Serializable, Comparable<ExasolAnalyticAggregateFunctions>

public enum ExasolAnalyticAggregateFunctions
extends Enum<ExasolAnalyticAggregateFunctions>
implements FunctionName

This enum is a list of Analytic and Aggregate Functions that the Exasol database supports.

Enum Constant Summary

Enum Constants

Enum Constant	Description
ANY	See documentation.
APPROXIMATE_COUNT_DISTINCT	See documentation.
AVG	See documentation.
CORR	See documentation.
COUNT	See documentation.
COVAR_POP	See documentation.
COVAR_SAMP	See documentation.
CUME_DIST	See documentation.
DENSE_RANK	See documentation.
EVERY	See documentation.
FIRST_VALUE	See documentation.
GROUP_CONCAT	See documentation.
GROUPING	See documentation.
GROUPING_ID	See documentation.
LAG	See documentation.
LAST_VALUE	See documentation.
LEAD	See documentation.
LISTAGG	See documentation.
MAX	See documentation.
MEDIAN	See documentation.
MIN	See documentation.
MUL	See documentation.
NTH_VALUE	See documentation.
NTILE	See documentation.
PERCENT_RANK	See documentation.
PERCENTILE_CONT	See documentation.
PERCENTILE_DISC	See documentation.
RANK	See documentation.
RATIO_TO_REPORT	See documentation.
REGR_AVGX	See documentation.
REGR_AVGY	See documentation.
REGR_COUNT	See documentation.
REGR_INTERCEPT	See documentation.
REGR_R2	See documentation.
REGR_SLOPE	See documentation.
REGR_SXX	See documentation.
REGR_SXY	See documentation.
REGR_SYY	See documentation.
ROW_NUMBER	See documentation.
SOME	This is an alias for ANY.
STDDEV	See documentation.
STDDEV_POP	See documentation.
STDDEV_SAMP	See documentation.
SUM	See documentation.
VAR_POP	See documentation.
VAR_SAMP	See documentation.
VARIANCE	See documentation.

Method Summary

Modifier and Type	Method	Description
static ExasolAnalyticAggregateFunctions	valueOf(String name)	Returns the enum constant of this type with the specified name.
static ExasolAnalyticAggregateFunctions[]	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

ANY

public static final ExasolAnalyticAggregateFunctions ANY

See documentation.

AVG

public static final ExasolAnalyticAggregateFunctions AVG

See documentation.

CORR

public static final ExasolAnalyticAggregateFunctions CORR

See documentation.

COUNT

public static final ExasolAnalyticAggregateFunctions COUNT

See documentation.

COVAR_POP

public static final ExasolAnalyticAggregateFunctions COVAR_POP

See documentation.

COVAR_SAMP

public static final ExasolAnalyticAggregateFunctions COVAR_SAMP

See documentation.

EVERY

public static final ExasolAnalyticAggregateFunctions EVERY

See documentation.

FIRST_VALUE

public static final ExasolAnalyticAggregateFunctions FIRST_VALUE

See documentation.

GROUP_CONCAT

public static final ExasolAnalyticAggregateFunctions GROUP_CONCAT

See documentation.

LAST_VALUE

public static final ExasolAnalyticAggregateFunctions LAST_VALUE

See documentation.

LISTAGG

public static final ExasolAnalyticAggregateFunctions LISTAGG

See documentation.

MAX

public static final ExasolAnalyticAggregateFunctions MAX

See documentation.

MEDIAN

public static final ExasolAnalyticAggregateFunctions MEDIAN

See documentation.

MIN

public static final ExasolAnalyticAggregateFunctions MIN

See documentation.

MUL

public static final ExasolAnalyticAggregateFunctions MUL

See documentation.

REGR_AVGX

public static final ExasolAnalyticAggregateFunctions REGR_AVGX

See documentation.

REGR_AVGY

public static final ExasolAnalyticAggregateFunctions REGR_AVGY

See documentation.

REGR_COUNT

public static final ExasolAnalyticAggregateFunctions REGR_COUNT

See documentation.

REGR_INTERCEPT

public static final ExasolAnalyticAggregateFunctions REGR_INTERCEPT

See documentation.

REGR_R2

public static final ExasolAnalyticAggregateFunctions REGR_R2

See documentation.

REGR_SLOPE

public static final ExasolAnalyticAggregateFunctions REGR_SLOPE

See documentation.

REGR_SXX

public static final ExasolAnalyticAggregateFunctions REGR_SXX

See documentation.

REGR_SXY

public static final ExasolAnalyticAggregateFunctions REGR_SXY

See documentation.

REGR_SYY

public static final ExasolAnalyticAggregateFunctions REGR_SYY

See documentation.

SOME

public static final ExasolAnalyticAggregateFunctions SOME

This is an alias for ANY. See documentation.

STDDEV

public static final ExasolAnalyticAggregateFunctions STDDEV

See documentation.

STDDEV_POP

public static final ExasolAnalyticAggregateFunctions STDDEV_POP

See documentation.

STDDEV_SAMP

public static final ExasolAnalyticAggregateFunctions STDDEV_SAMP

See documentation.

SUM

public static final ExasolAnalyticAggregateFunctions SUM

See documentation.

VAR_POP

public static final ExasolAnalyticAggregateFunctions VAR_POP

See documentation.

VAR_SAMP

public static final ExasolAnalyticAggregateFunctions VAR_SAMP

See documentation.

VARIANCE

public static final ExasolAnalyticAggregateFunctions VARIANCE

See documentation.

CUME_DIST

public static final ExasolAnalyticAggregateFunctions CUME_DIST

See documentation.

DENSE_RANK

public static final ExasolAnalyticAggregateFunctions DENSE_RANK

See documentation.

LAG

public static final ExasolAnalyticAggregateFunctions LAG

See documentation.

LEAD

public static final ExasolAnalyticAggregateFunctions LEAD

See documentation.

NTH_VALUE

public static final ExasolAnalyticAggregateFunctions NTH_VALUE

See documentation.

NTILE

public static final ExasolAnalyticAggregateFunctions NTILE

See documentation.

PERCENT_RANK

public static final ExasolAnalyticAggregateFunctions PERCENT_RANK

See documentation.

PERCENTILE_CONT

public static final ExasolAnalyticAggregateFunctions PERCENTILE_CONT

See documentation.

PERCENTILE_DISC

public static final ExasolAnalyticAggregateFunctions PERCENTILE_DISC

See documentation.

RANK

public static final ExasolAnalyticAggregateFunctions RANK

See documentation.

RATIO_TO_REPORT

public static final ExasolAnalyticAggregateFunctions RATIO_TO_REPORT

See documentation.

ROW_NUMBER

public static final ExasolAnalyticAggregateFunctions ROW_NUMBER

See documentation.

APPROXIMATE_COUNT_DISTINCT

public static final ExasolAnalyticAggregateFunctions APPROXIMATE_COUNT_DISTINCT

See documentation.

GROUPING

public static final ExasolAnalyticAggregateFunctions GROUPING

See documentation.

GROUPING_ID

public static final ExasolAnalyticAggregateFunctions GROUPING_ID

See documentation.

Method Detail

values

public static ExasolAnalyticAggregateFunctions[] 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 (ExasolAnalyticAggregateFunctions c : ExasolAnalyticAggregateFunctions.values())
    System.out.println(c);

Returns:

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

valueOf

public static ExasolAnalyticAggregateFunctions 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