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

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

• COUNT: Number of objects (independent of the given column(s)).
• MEAN: Arithmetic mean (average), equivalent to sum/count.
• STDV: Sample standard deviation (denominator is count-1).
• VARIANCE: Unbiased sample variance (denominator is count-1).
• SKEW: Skewness (third standardized moment).
• KURTOSIS: Kurtosis (fourth standardized moment).
• SUM: Sum of all values in the column(s).
• MIN: Minimum value of the column(s).
• MAX: Maximum value of the column(s).
• WEIGHTED_AVERAGE: Weighted arithmetic mean (using the option weight_column_name as the weighting column).
• CARDINALITY: Number of unique values in the column(s).
• ESTIMATED_CARDINALITY: Estimate (via hyperloglog technique) of the number of unique values in the column(s).
• 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)'
• 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() will return approximately 50.0).

A set of string constants for the parameter stats.

Field Summary

Fields

Modifier and Type	Field and 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() 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() will return approximately 50.0).

See Also:

Constant Field Values