Kinetica   C#   API  Version 7.2.3.1
AggregateStatistics.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 using System.Collections.Generic;
8 
9 namespace kinetica;
10 
60 {
65  public struct Stats
66  {
69  public const string COUNT = "count";
70 
73  public const string MEAN = "mean";
74 
77  public const string STDV = "stdv";
78 
81  public const string VARIANCE = "variance";
82 
84  public const string SKEW = "skew";
85 
87  public const string KURTOSIS = "kurtosis";
88 
90  public const string SUM = "sum";
91 
93  public const string MIN = "min";
94 
96  public const string MAX = "max";
97 
101  public const string WEIGHTED_AVERAGE = "weighted_average";
102 
104  public const string CARDINALITY = "cardinality";
105 
108  public const string ESTIMATED_CARDINALITY = "estimated_cardinality";
109 
115  public const string PERCENTILE = "percentile";
116 
121  public const string PERCENTILE_RANK = "percentile_rank";
122  } // end struct Stats
123 
127  public struct Options
128  {
136  public const string ADDITIONAL_COLUMN_NAMES = "additional_column_names";
137 
140  public const string WEIGHT_COLUMN_NAME = "weight_column_name";
141  } // end struct Options
142 
147  public string table_name { get; set; }
148 
151  public string column_name { get; set; }
152 
235  public string stats { get; set; }
236 
259  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
260 
264 
379  string column_name,
380  string stats,
381  IDictionary<string, string> options = null)
382  {
383  this.table_name = table_name ?? "";
384  this.column_name = column_name ?? "";
385  this.stats = stats ?? "";
386  this.options = options ?? new Dictionary<string, string>();
387  } // end constructor
388 } // end class AggregateStatisticsRequest
389 
394 {
397  public IDictionary<string, double> stats { get; set; } = new Dictionary<string, double>();
398 
400  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
401 } // end class AggregateStatisticsResponse
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
Definition: KineticaData.cs:14
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.