A set of string constants for the parameter stats. More...

Public Attributes
const string	COUNT = "count"
	Number of objects (independent of the given column(s)). More...

const string	MEAN = "mean"
	Arithmetic mean (average), equivalent to sum/count. More...

const string	STDV = "stdv"
	Sample standard deviation (denominator is count-1). More...

const string	VARIANCE = "variance"
	Unbiased sample variance (denominator is count-1). More...

const string	SKEW = "skew"
	Skewness (third standardized moment). More...

const string	KURTOSIS = "kurtosis"
	Kurtosis (fourth standardized moment). More...

const string	SUM = "sum"
	Sum of all values in the column(s). More...

const string	MIN = "min"
	Minimum value of the column(s). More...

const string	MAX = "max"
	Maximum value of the column(s). More...

const string	WEIGHTED_AVERAGE = "weighted_average"
	Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column). More...

const string	CARDINALITY = "cardinality"
	Number of unique values in the column(s). More...

const string	ESTIMATED_CARDINALITY = "estimated_cardinality"
	Estimate (via hyperloglog technique) of the number of unique values in the column(s). More...

const string	PERCENTILE = "percentile"
	Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median). More...

const string	PERCENTILE_RANK = "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). More...

Detailed Description

A set of string constants for the parameter stats.

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

Definition at line 69 of file AggregateStatistics.cs.

Member Data Documentation

◆ CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.CARDINALITY = "cardinality"

Number of unique values in the column(s).

Definition at line 108 of file AggregateStatistics.cs.

◆ COUNT

const string kinetica.AggregateStatisticsRequest.Stats.COUNT = "count"

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

Definition at line 73 of file AggregateStatistics.cs.

◆ ESTIMATED_CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.ESTIMATED_CARDINALITY = "estimated_cardinality"

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

Definition at line 112 of file AggregateStatistics.cs.

◆ KURTOSIS

const string kinetica.AggregateStatisticsRequest.Stats.KURTOSIS = "kurtosis"

Kurtosis (fourth standardized moment).

Definition at line 91 of file AggregateStatistics.cs.

◆ MAX

const string kinetica.AggregateStatisticsRequest.Stats.MAX = "max"

Maximum value of the column(s).

Definition at line 100 of file AggregateStatistics.cs.

◆ MEAN

const string kinetica.AggregateStatisticsRequest.Stats.MEAN = "mean"

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

Definition at line 77 of file AggregateStatistics.cs.

◆ MIN

const string kinetica.AggregateStatisticsRequest.Stats.MIN = "min"

Minimum value of the column(s).

Definition at line 97 of file AggregateStatistics.cs.

◆ PERCENTILE

const string kinetica.AggregateStatisticsRequest.Stats.PERCENTILE = "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)'

Definition at line 120 of file AggregateStatistics.cs.

◆ PERCENTILE_RANK

const string kinetica.AggregateStatisticsRequest.Stats.PERCENTILE_RANK = "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).

Definition at line 126 of file AggregateStatistics.cs.

◆ SKEW

const string kinetica.AggregateStatisticsRequest.Stats.SKEW = "skew"

Skewness (third standardized moment).

Definition at line 88 of file AggregateStatistics.cs.

◆ STDV

const string kinetica.AggregateStatisticsRequest.Stats.STDV = "stdv"

Sample standard deviation (denominator is count-1).

Definition at line 81 of file AggregateStatistics.cs.

◆ SUM

const string kinetica.AggregateStatisticsRequest.Stats.SUM = "sum"

Sum of all values in the column(s).

Definition at line 94 of file AggregateStatistics.cs.

◆ VARIANCE

const string kinetica.AggregateStatisticsRequest.Stats.VARIANCE = "variance"

Unbiased sample variance (denominator is count-1).

Definition at line 85 of file AggregateStatistics.cs.

◆ WEIGHTED_AVERAGE

const string kinetica.AggregateStatisticsRequest.Stats.WEIGHTED_AVERAGE = "weighted_average"

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

Definition at line 105 of file AggregateStatistics.cs.

The documentation for this struct was generated from the following file:

Kinetica/Protocol/AggregateStatistics.cs

Public Attributes