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.TheFN_AGG_GEO_INTERSECTION
capability was renamed toFN_AGG_ST_INTERSECTION
in Exasol 7.1.alpha1.GEO_UNION_AGGREGATE
Deprecated.TheFN_AGG_GEO_UNION
capability was renamed toFN_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
All Methods Static Methods Instance Methods Concrete Methods 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.
-
-
-
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.TheFN_AGG_GEO_INTERSECTION
capability was renamed toFN_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.TheFN_AGG_GEO_UNION
capability was renamed toFN_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 nameNullPointerException
- if the argument is null
-
getFunction
public AggregateFunction getFunction()
Gets function.- Returns:
- the function
-
-