7 using System.Collections.Generic;
155 public const string COUNT =
"count";
159 public const string MEAN =
"mean";
163 public const string STDV =
"stdv";
170 public const string SKEW =
"skew";
176 public const string SUM =
"sum";
179 public const string MIN =
"min";
182 public const string MAX =
"max";
240 public const string ADDITIONAL_COLUMN_NAMES =
"additional_column_names";
244 public const string WEIGHT_COLUMN_NAME =
"weight_column_name";
369 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
498 IDictionary<string, string>
options = null)
500 this.table_name = table_name ??
"";
501 this.column_name = column_name ??
"";
502 this.stats = stats ??
"";
518 public IDictionary<string, double>
stats {
get;
set; } =
new Dictionary<string, double>();
const string SUM
Sum of all values in the column(s).
Comma separated list of the statistics to calculate, e.g.
AggregateStatisticsRequest(string table_name, string column_name, string stats, IDictionary< string, string > options=null)
Constructs an AggregateStatisticsRequest object with the specified parameters.
const string WEIGHTED_AVERAGE
Weighted arithmetic mean (using the option weight_column_name as the weighting column).
const string MEAN
Arithmetic mean (average), equivalent to sum/count.
const string PERCENTILE
Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approxi...
const string ESTIMATED_CARDINALITY
Estimate (via hyperloglog technique) of the number of unique values in the column(s).
AggregateStatisticsRequest()
Constructs an AggregateStatisticsRequest object with default parameters.
const string CARDINALITY
Number of unique values in the column(s).
const string SKEW
Skewness (third standardized moment).
const string VARIANCE
Unbiased sample variance (denominator is count-1).
const string MAX
Maximum value of the column(s).
string column_name
Name of the primary column for which the statistics are to be calculated.
IDictionary< string, string > options
Optional parameters.
const string COUNT
Number of objects (independent of the given column(s)).
string stats
Comma separated list of the statistics to calculate, e.g.
const string KURTOSIS
Kurtosis (fourth standardized moment).
const string MIN
Minimum value of the column(s).
const string PERCENTILE_RANK
Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given valu...
string table_name
Name of the table on which the statistics operation will be performed.
A set of parameters for Kinetica.aggregateStatistics(string,string,string,IDictionary<string, string>).
KineticaData - class to help with Avro Encoding for Kinetica
A set of results returned by Kinetica.aggregateStatistics(string,string,string,IDictionary<string, string>).
const string STDV
Sample standard deviation (denominator is count-1).