7 using System.Collections.Generic;
63 public class AggregateStatisticsRequest : KineticaData
73 public const string COUNT =
"count";
77 public const string MEAN =
"mean";
81 public const string STDV =
"stdv";
85 public const string VARIANCE =
"variance";
88 public const string SKEW =
"skew";
91 public const string KURTOSIS =
"kurtosis";
94 public const string SUM =
"sum";
97 public const string MIN =
"min";
100 public const string MAX =
"max";
120 public const string PERCENTILE =
"percentile";
132 public struct Options
245 public string stats {
get;
set; }
269 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
398 IDictionary<string, string>
options =
null)
402 this.stats =
stats ??
"";
410 public class AggregateStatisticsResponse : KineticaData
414 public IDictionary<string, double>
stats {
get;
set; } =
new Dictionary<string, double>();
417 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string MIN
Minimum value of the column(s).
const string STDV
Sample standard deviation (denominator is count-1).
string stats
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 SUM
Sum of all values in the column(s).
IDictionary< string, string > options
Optional parameters.
AggregateStatisticsRequest()
Constructs an AggregateStatisticsRequest object with default parameters.
const string SKEW
Skewness (third standardized moment).
const string COUNT
Number of objects (independent of the given column(s)).
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...
const string MEAN
Arithmetic mean (average), equivalent to sum/count.
const string WEIGHT_COLUMN_NAME
Name of column used as weighting attribute for the weighted average statistic.
const string CARDINALITY
Number of unique values in the column(s).
IDictionary< string, string > info
Additional information.
const string PERCENTILE
Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approxi...
const string KURTOSIS
Kurtosis (fourth standardized moment).
string column_name
Name of the primary column for which the statistics are to be calculated.
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).
string table_name
Name of the table on which the statistics operation will be performed, in [schema_name.
IDictionary< string, double > stats
(statistic name, double value) pairs of the requested statistics, including the total count by defaul...
const string VARIANCE
Unbiased sample variance (denominator is count-1).
const string MAX
Maximum value of the column(s).