Package com.exasol.adapter.capabilities

Enum AggregateFunctionCapability

java.lang.Object

java.lang.Enum<AggregateFunctionCapability>

com.exasol.adapter.capabilities.AggregateFunctionCapability

All Implemented Interfaces:

Serializable, Comparable<AggregateFunctionCapability>

public enum AggregateFunctionCapability
extends Enum<AggregateFunctionCapability>

List of all aggregation function capabilities supported by EXASOL.

Enum Constant Summary

Enum Constants

Enum Constant	Description
APPROXIMATE_COUNT_DISTINCT	Approximate count distinct aggregate function capability.
AVG	Avg aggregate function capability.
AVG_DISTINCT	Avg distinct aggregate function capability.
COUNT	Required for any kind of COUNT(...) with expressions.
COUNT_DISTINCT	Required for COUNT(DISTINCT ...).
COUNT_STAR	Required only for COUNT(*).
COUNT_TUPLE	Count tuple aggregate function capability.
EVERY	Every aggregate function capability.
FIRST_VALUE	First value aggregate function capability.
GEO_INTERSECTION_AGGREGATE	Deprecated. The FN_AGG_GEO_INTERSECTION capability was renamed to FN_AGG_ST_INTERSECTION in Exasol 7.1.alpha1.
GEO_UNION_AGGREGATE	Deprecated. The FN_AGG_GEO_UNION capability was renamed to FN_AGG_ST_UNION in Exasol 7.1.alpha1.
GROUP_CONCAT	Group concat aggregate function capability.
GROUP_CONCAT_DISTINCT	Group concat distinct aggregate function capability.
GROUP_CONCAT_ORDER_BY	Group concat order by aggregate function capability.
GROUP_CONCAT_SEPARATOR	Group concat separator aggregate function capability.
LAST_VALUE	Last value aggregate function capability.
LISTAGG	Listagg aggregate function capability.
LISTAGG_DISTINCT	Listagg distinct aggregate function capability.
LISTAGG_ON_OVERFLOW_ERROR	Listagg on overflow error aggregate function capability.
LISTAGG_ON_OVERFLOW_TRUNCATE	Listagg on overflow truncate aggregate function capability.
LISTAGG_ORDER_BY	Listagg order by aggregate function capability.
LISTAGG_SEPARATOR	Listagg separator aggregate function capability.
MAX	Max aggregate function capability.
MEDIAN	Median aggregate function capability.
MIN	Min aggregate function capability.
MUL	Mul aggregate function capability.
MUL_DISTINCT	Mul distinct aggregate function capability.
SOME	Some aggregate function capability.
ST_INTERSECTION	Geometric intersection aggregate function capability.
ST_UNION	St union aggregate function capability.
STDDEV	Stddev aggregate function capability.
STDDEV_DISTINCT	Stddev distinct aggregate function capability.
STDDEV_POP	Stddev pop aggregate function capability.
STDDEV_POP_DISTINCT	Stddev pop distinct aggregate function capability.
STDDEV_SAMP	Stddev samp aggregate function capability.
STDDEV_SAMP_DISTINCT	Stddev samp distinct aggregate function capability.
SUM	Sum aggregate function capability.
SUM_DISTINCT	Sum distinct aggregate function capability.
VAR_POP	Var pop aggregate function capability.
VAR_POP_DISTINCT	Var pop distinct aggregate function capability.
VAR_SAMP	Var samp aggregate function capability.
VAR_SAMP_DISTINCT	Var samp distinct aggregate function capability.
VARIANCE	Variance aggregate function capability.
VARIANCE_DISTINCT	Variance distinct aggregate function capability.

Method Summary

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

Enum Constant Detail

COUNT

public static final AggregateFunctionCapability COUNT

Required for any kind of COUNT(...) with expressions.

COUNT_STAR

public static final AggregateFunctionCapability COUNT_STAR

Required only for COUNT(*).

COUNT_DISTINCT

public static final AggregateFunctionCapability COUNT_DISTINCT

Required for COUNT(DISTINCT ...).

COUNT_TUPLE

public static final AggregateFunctionCapability COUNT_TUPLE

Count tuple aggregate function capability.

SUM

public static final AggregateFunctionCapability SUM

Sum aggregate function capability.

SUM_DISTINCT

public static final AggregateFunctionCapability SUM_DISTINCT

Sum distinct aggregate function capability.

MIN

public static final AggregateFunctionCapability MIN

Min aggregate function capability.

MAX

public static final AggregateFunctionCapability MAX

Max aggregate function capability.

AVG

public static final AggregateFunctionCapability AVG

Avg aggregate function capability.

AVG_DISTINCT

public static final AggregateFunctionCapability AVG_DISTINCT

Avg distinct aggregate function capability.

MEDIAN

public static final AggregateFunctionCapability MEDIAN

Median aggregate function capability.

FIRST_VALUE

public static final AggregateFunctionCapability FIRST_VALUE

First value aggregate function capability.

LAST_VALUE

public static final AggregateFunctionCapability LAST_VALUE

Last value aggregate function capability.

STDDEV

public static final AggregateFunctionCapability STDDEV

Stddev aggregate function capability.

STDDEV_DISTINCT

public static final AggregateFunctionCapability STDDEV_DISTINCT

Stddev distinct aggregate function capability.

STDDEV_POP

public static final AggregateFunctionCapability STDDEV_POP

Stddev pop aggregate function capability.

STDDEV_POP_DISTINCT

public static final AggregateFunctionCapability STDDEV_POP_DISTINCT

Stddev pop distinct aggregate function capability.

STDDEV_SAMP

public static final AggregateFunctionCapability STDDEV_SAMP

Stddev samp aggregate function capability.

STDDEV_SAMP_DISTINCT

public static final AggregateFunctionCapability STDDEV_SAMP_DISTINCT

Stddev samp distinct aggregate function capability.

VARIANCE

public static final AggregateFunctionCapability VARIANCE

Variance aggregate function capability.

VARIANCE_DISTINCT

public static final AggregateFunctionCapability VARIANCE_DISTINCT

Variance distinct aggregate function capability.

VAR_POP

public static final AggregateFunctionCapability VAR_POP

Var pop aggregate function capability.

VAR_POP_DISTINCT

public static final AggregateFunctionCapability VAR_POP_DISTINCT

Var pop distinct aggregate function capability.

VAR_SAMP

public static final AggregateFunctionCapability VAR_SAMP

Var samp aggregate function capability.

VAR_SAMP_DISTINCT

public static final AggregateFunctionCapability VAR_SAMP_DISTINCT

Var samp distinct aggregate function capability.

GROUP_CONCAT

public static final AggregateFunctionCapability GROUP_CONCAT

Group concat aggregate function capability.

GROUP_CONCAT_DISTINCT

public static final AggregateFunctionCapability GROUP_CONCAT_DISTINCT

Group concat distinct aggregate function capability.

GROUP_CONCAT_SEPARATOR

public static final AggregateFunctionCapability GROUP_CONCAT_SEPARATOR

Group concat separator aggregate function capability.

GROUP_CONCAT_ORDER_BY

public static final AggregateFunctionCapability GROUP_CONCAT_ORDER_BY

Group concat order by aggregate function capability.

GEO_INTERSECTION_AGGREGATE

@Deprecated(since="Exasol 7.1.alpha1")
public static final AggregateFunctionCapability GEO_INTERSECTION_AGGREGATE

Deprecated.

The FN_AGG_GEO_INTERSECTION capability was renamed to FN_AGG_ST_INTERSECTION in Exasol 7.1.alpha1.

Geo intersection aggregate aggregate function capability.

GEO_UNION_AGGREGATE

@Deprecated(since="Exasol 7.1.alpha1")
public static final AggregateFunctionCapability GEO_UNION_AGGREGATE

Deprecated.

The FN_AGG_GEO_UNION capability was renamed to FN_AGG_ST_UNION in Exasol 7.1.alpha1.

Geo union aggregate aggregate function capability.

ST_INTERSECTION

public static final AggregateFunctionCapability ST_INTERSECTION

Geometric intersection aggregate function capability.

ST_UNION

public static final AggregateFunctionCapability ST_UNION

St union aggregate function capability.

APPROXIMATE_COUNT_DISTINCT

public static final AggregateFunctionCapability APPROXIMATE_COUNT_DISTINCT

Approximate count distinct aggregate function capability.

MUL

public static final AggregateFunctionCapability MUL

Mul aggregate function capability.

MUL_DISTINCT

public static final AggregateFunctionCapability MUL_DISTINCT

Mul distinct aggregate function capability.

EVERY

public static final AggregateFunctionCapability EVERY

Every aggregate function capability.

SOME

public static final AggregateFunctionCapability SOME

Some aggregate function capability.

LISTAGG

public static final AggregateFunctionCapability LISTAGG

Listagg aggregate function capability.

LISTAGG_DISTINCT

public static final AggregateFunctionCapability LISTAGG_DISTINCT

Listagg distinct aggregate function capability.

LISTAGG_SEPARATOR

public static final AggregateFunctionCapability LISTAGG_SEPARATOR

Listagg separator aggregate function capability.

LISTAGG_ON_OVERFLOW_ERROR

public static final AggregateFunctionCapability LISTAGG_ON_OVERFLOW_ERROR

Listagg on overflow error aggregate function capability.

LISTAGG_ON_OVERFLOW_TRUNCATE

public static final AggregateFunctionCapability LISTAGG_ON_OVERFLOW_TRUNCATE

Listagg on overflow truncate aggregate function capability.

LISTAGG_ORDER_BY

public static final AggregateFunctionCapability LISTAGG_ORDER_BY

Listagg order by aggregate function capability.

Method Detail

values

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

Returns:

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

valueOf

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

getFunction

public AggregateFunction getFunction()

Gets function.

Returns:

the function