7 using System.Collections.Generic;
69 public const string COUNT =
"count";
73 public const string MEAN =
"mean";
77 public const string STDV =
"stdv";
84 public const string SKEW =
"skew";
90 public const string SUM =
"sum";
93 public const string MIN =
"min";
96 public const string MAX =
"max";
259 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
381 IDictionary<string, string>
options =
null)
385 this.stats =
stats ??
"";
397 public IDictionary<string, double>
stats {
get;
set; } =
new Dictionary<string, double>();
400 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string VARIANCE
Unbiased sample variance (denominator is count-1).
const string PERCENTILE_RANK
Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given valu...
const string ESTIMATED_CARDINALITY
Estimate (via hyperloglog technique) of the number of unique values in the column(s).
KineticaData - class to help with Avro Encoding for Kinetica
const string MIN
Minimum value of the column(s).
IDictionary< string, string > info
Additional information.
A set of parameters for Kinetica.aggregateStatistics.
string table_name
Name of the table on which the statistics operation will be performed, in [schema_name.
const string MEAN
Arithmetic mean (average), equivalent to sum/count.
string stats
Comma separated list of the statistics to calculate, e.g.
const string WEIGHTED_AVERAGE
Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column).
const string ADDITIONAL_COLUMN_NAMES
A list of comma separated column names over which statistics can be accumulated along with the primar...
A set of string constants for the parameter stats.
IDictionary< string, double > stats
(statistic name, double value) pairs of the requested statistics, including the total count by defaul...
A set of results returned by Kinetica.aggregateStatistics.
A set of string constants for the parameter options.
AggregateStatisticsRequest()
Constructs an AggregateStatisticsRequest object with default parameters.
const string PERCENTILE
Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approxi...
const string MAX
Maximum value of the column(s).
const string WEIGHT_COLUMN_NAME
Name of column used as weighting attribute for the weighted average statistic.
const string KURTOSIS
Kurtosis (fourth standardized moment).
const string STDV
Sample standard deviation (denominator is count-1).
const string SKEW
Skewness (third standardized moment).
const string CARDINALITY
Number of unique values in the column(s).
const string SUM
Sum of all values in the column(s).
string column_name
Name of the primary column for which the statistics are to be calculated.
const string COUNT
Number of objects (independent of the given column(s)).
AggregateStatisticsRequest(string table_name, string column_name, string stats, IDictionary< string, string > options=null)
Constructs an AggregateStatisticsRequest object with the specified parameters.
IDictionary< string, string > options
Optional parameters.