Package com.gpudb.protocol

Class AggregateStatisticsRequest.Stats

java.lang.Object

com.gpudb.protocol.AggregateStatisticsRequest.Stats

Enclosing class:

AggregateStatisticsRequest

public static final class AggregateStatisticsRequest.Stats
extends Object

A set of string constants for the AggregateStatisticsRequest parameter stats.

Comma separated list of the statistics to calculate, e.g. "sum,mean".

Field Summary

Fields

Modifier and Type	Field	Description
static String	CARDINALITY	Number of unique values in the column(s).
static String	COUNT	Number of objects (independent of the given column(s)).
static String	ESTIMATED_CARDINALITY	Estimate (via hyperloglog technique) of the number of unique values in the column(s).
static String	KURTOSIS	Kurtosis (fourth standardized moment).
static String	MAX	Maximum value of the column(s).
static String	MEAN	Arithmetic mean (average), equivalent to sum/count.
static String	MIN	Minimum value of the column(s).
static String	PERCENTILE	Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median).
static String	PERCENTILE_RANK	Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given value is the median of the column(s), percentile_rank(<median>) will return approximately 50.0).
static String	SKEW	Skewness (third standardized moment).
static String	STDV	Sample standard deviation (denominator is count-1).
static String	SUM	Sum of all values in the column(s).
static String	VARIANCE	Unbiased sample variance (denominator is count-1).
static String	WEIGHTED_AVERAGE	Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column).

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COUNT

public static final String COUNT

Number of objects (independent of the given column(s)).

See Also:

Constant Field Values

MEAN

public static final String MEAN

Arithmetic mean (average), equivalent to sum/count.

See Also:

Constant Field Values

STDV

public static final String STDV

Sample standard deviation (denominator is count-1).

See Also:

Constant Field Values

VARIANCE

public static final String VARIANCE

Unbiased sample variance (denominator is count-1).

See Also:

Constant Field Values

SKEW

public static final String SKEW

Skewness (third standardized moment).

See Also:

Constant Field Values

KURTOSIS

public static final String KURTOSIS

Kurtosis (fourth standardized moment).

See Also:

Constant Field Values

SUM

public static final String SUM

Sum of all values in the column(s).

See Also:

Constant Field Values

MIN

public static final String MIN

Minimum value of the column(s).

See Also:

Constant Field Values

MAX

public static final String MAX

Maximum value of the column(s).

See Also:

Constant Field Values

WEIGHTED_AVERAGE

public static final String WEIGHTED_AVERAGE

Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column).

See Also:

Constant Field Values

CARDINALITY

public static final String CARDINALITY

Number of unique values in the column(s).

See Also:

Constant Field Values

ESTIMATED_CARDINALITY

public static final String ESTIMATED_CARDINALITY

Estimate (via hyperloglog technique) of the number of unique values in the column(s).

See Also:

Constant Field Values

PERCENTILE

public static final String PERCENTILE

Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median). Add a second, comma-separated value to calculate percentile resolution, e.g., 'percentile(75,150)'

See Also:

Constant Field Values

PERCENTILE_RANK

public static final String PERCENTILE_RANK

Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given value is the median of the column(s), percentile_rank(<median>) will return approximately 50.0).

See Also:

Constant Field Values