Kinetica C# API  Version 6.1.0.0
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 
10 
11 namespace kinetica
12 {
13 
56  {
57 
150  public struct Stats
151  {
152 
155  public const string COUNT = "count";
156 
159  public const string MEAN = "mean";
160 
163  public const string STDV = "stdv";
164 
167  public const string VARIANCE = "variance";
168 
170  public const string SKEW = "skew";
171 
173  public const string KURTOSIS = "kurtosis";
174 
176  public const string SUM = "sum";
177 
179  public const string MIN = "min";
180 
182  public const string MAX = "max";
183 
186  public const string WEIGHTED_AVERAGE = "weighted_average";
187 
189  public const string CARDINALITY = "cardinality";
190 
193  public const string ESTIMATED_CARDINALITY = "estimated_cardinality";
194 
198  public const string PERCENTILE = "percentile";
199 
204  public const string PERCENTILE_RANK = "percentile_rank";
205  } // end struct Stats
206 
207 
231  public struct Options
232  {
233 
240  public const string ADDITIONAL_COLUMN_NAMES = "additional_column_names";
241 
244  public const string WEIGHT_COLUMN_NAME = "weight_column_name";
245  } // end struct Options
246 
247 
250  public string table_name { get; set; }
251 
254  public string column_name { get; set; }
255 
346  public string stats { get; set; }
347 
369  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
370 
371 
375 
496  string column_name,
497  string stats,
498  IDictionary<string, string> options = null)
499  {
500  this.table_name = table_name ?? "";
501  this.column_name = column_name ?? "";
502  this.stats = stats ?? "";
503  this.options = options ?? new Dictionary<string, string>();
504  } // end constructor
505 
506  } // end class AggregateStatisticsRequest
507 
508 
509 
514  {
515 
518  public IDictionary<string, double> stats { get; set; } = new Dictionary<string, double>();
519 
520  } // end class AggregateStatisticsResponse
521 
522 
523 
524 
525 } // end namespace kinetica
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
Definition: KineticaData.cs:14
A set of results returned by Kinetica.aggregateStatistics(string,string,string,IDictionary<string, string>).
const string STDV
Sample standard deviation (denominator is count-1).