Package com.exasol.adapter.sql

Enum AggregateFunction

java.lang.Object

java.lang.Enum<AggregateFunction>

com.exasol.adapter.sql.AggregateFunction

All Implemented Interfaces:

Serializable, Comparable<AggregateFunction>

public enum AggregateFunction
extends Enum<AggregateFunction>

List of all aggregation functions supported by EXASOL.

Enum Constant Summary

Enum Constants

Enum Constant	Description
APPROXIMATE_COUNT_DISTINCT	Approximate count distinct aggregate function.
AVG	Avg aggregate function.
COUNT	Count aggregate function.
EVERY	Every aggregate function.
FIRST_VALUE	First value aggregate function.
GEO_INTERSECTION_AGGREGATE	Geo intersection aggregate aggregate function.
GEO_UNION_AGGREGATE	Geo union aggregate aggregate function.
GROUP_CONCAT	Group concat aggregate function.
LAST_VALUE	Last value aggregate function.
LISTAGG	Listagg aggregate function.
MAX	Max aggregate function.
MEDIAN	Median aggregate function.
MIN	Min aggregate function.
MUL	Mul aggregate function.
SOME	Some aggregate function.
ST_INTERSECTION	St intersection aggregate function.
ST_UNION	St union aggregate function.
STDDEV	Stddev aggregate function.
STDDEV_POP	Stddev pop aggregate function.
STDDEV_SAMP	Stddev samp aggregate function.
SUM	Sum aggregate function.
VAR_POP	Var pop aggregate function.
VAR_SAMP	Var samp aggregate function.
VARIANCE	Variance aggregate function.

Method Summary

Modifier and Type	Method	Description
boolean	isSimple()	True if the function is simple, i.e.
String	toString()
static AggregateFunction	valueOf(String name)	Returns the enum constant of this type with the specified name.
static AggregateFunction[]	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, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

COUNT

public static final AggregateFunction COUNT

Count aggregate function.

SUM

public static final AggregateFunction SUM

Sum aggregate function.

MIN

public static final AggregateFunction MIN

Min aggregate function.

MAX

public static final AggregateFunction MAX

Max aggregate function.

AVG

public static final AggregateFunction AVG

Avg aggregate function.

MEDIAN

public static final AggregateFunction MEDIAN

Median aggregate function.

FIRST_VALUE

public static final AggregateFunction FIRST_VALUE

First value aggregate function.

LAST_VALUE

public static final AggregateFunction LAST_VALUE

Last value aggregate function.

STDDEV

public static final AggregateFunction STDDEV

Stddev aggregate function.

STDDEV_POP

public static final AggregateFunction STDDEV_POP

Stddev pop aggregate function.

STDDEV_SAMP

public static final AggregateFunction STDDEV_SAMP

Stddev samp aggregate function.

VARIANCE

public static final AggregateFunction VARIANCE

Variance aggregate function.

VAR_POP

public static final AggregateFunction VAR_POP

Var pop aggregate function.

VAR_SAMP

public static final AggregateFunction VAR_SAMP

Var samp aggregate function.

GROUP_CONCAT

public static final AggregateFunction GROUP_CONCAT

Group concat aggregate function.

APPROXIMATE_COUNT_DISTINCT

public static final AggregateFunction APPROXIMATE_COUNT_DISTINCT

Approximate count distinct aggregate function.

GEO_INTERSECTION_AGGREGATE

public static final AggregateFunction GEO_INTERSECTION_AGGREGATE

Geo intersection aggregate aggregate function.

GEO_UNION_AGGREGATE

public static final AggregateFunction GEO_UNION_AGGREGATE

Geo union aggregate aggregate function.

ST_INTERSECTION

public static final AggregateFunction ST_INTERSECTION

St intersection aggregate function.

ST_UNION

public static final AggregateFunction ST_UNION

St union aggregate function.

MUL

public static final AggregateFunction MUL

Mul aggregate function.

EVERY

public static final AggregateFunction EVERY

Every aggregate function.

SOME

public static final AggregateFunction SOME

Some aggregate function.

LISTAGG

public static final AggregateFunction LISTAGG

Listagg aggregate function.

Method Detail

values

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

Returns:

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

valueOf

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

isSimple

public boolean isSimple()

True if the function is simple, i.e. is handled by SqlFunctionAggregate, and false if it has it's own implementation.

Returns:

true if the function is simple

toString

public String toString()

Overrides:

toString in class Enum<AggregateFunction>