Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
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 
79  {
80 
175  public struct Stats
176  {
177 
180  public const string COUNT = "count";
181 
184  public const string MEAN = "mean";
185 
188  public const string STDV = "stdv";
189 
192  public const string VARIANCE = "variance";
193 
195  public const string SKEW = "skew";
196 
198  public const string KURTOSIS = "kurtosis";
199 
201  public const string SUM = "sum";
202 
204  public const string MIN = "min";
205 
207  public const string MAX = "max";
208 
211  public const string WEIGHTED_AVERAGE = "weighted_average";
212 
214  public const string CARDINALITY = "cardinality";
215 
218  public const string ESTIMATED_CARDINALITY = "estimated_cardinality";
219 
224  public const string PERCENTILE = "percentile";
225 
230  public const string PERCENTILE_RANK = "percentile_rank";
231  } // end struct Stats
232 
233 
257  public struct Options
258  {
259 
266  public const string ADDITIONAL_COLUMN_NAMES = "additional_column_names";
267 
270  public const string WEIGHT_COLUMN_NAME = "weight_column_name";
271  } // end struct Options
272 
273 
278  public string table_name { get; set; }
279 
282  public string column_name { get; set; }
283 
376  public string stats { get; set; }
377 
399  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
400 
401 
405 
531  string column_name,
532  string stats,
533  IDictionary<string, string> options = null)
534  {
535  this.table_name = table_name ?? "";
536  this.column_name = column_name ?? "";
537  this.stats = stats ?? "";
538  this.options = options ?? new Dictionary<string, string>();
539  } // end constructor
540 
541  } // end class AggregateStatisticsRequest
542 
543 
544 
549  {
550 
553  public IDictionary<string, double> stats { get; set; } = new Dictionary<string, double>();
554 
556  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
557 
558  } // end class AggregateStatisticsResponse
559 
560 
561 
562 
563 } // 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.
IDictionary< string, string > info
Additional information.
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...
IDictionary< string, double > stats
(statistic name, double value) pairs of the requested statistics, including the total count by defaul...
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 WEIGHT_COLUMN_NAME
Name of column used as weighting attribute for the weighted average statistic.
const string ADDITIONAL_COLUMN_NAMES
A list of comma separated column names over which statistics can be accumulated along with the primar...
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, in [schema_name.
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).