Kinetica C# API  Version 6.2.0.1
AggregateUnpivot.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 
36  {
37 
58  public struct Encoding
59  {
60 
63  public const string BINARY = "binary";
64 
67  public const string JSON = "json";
68  } // end struct Encoding
69 
70 
204  public struct Options
205  {
206 
211  public const string COLLECTION_NAME = "collection_name";
212 
217  public const string RESULT_TABLE = "result_table";
218 
237  public const string RESULT_TABLE_PERSIST = "result_table_persist";
238  public const string TRUE = "true";
239  public const string FALSE = "false";
240 
243  public const string EXPRESSION = "expression";
244 
250  public const string ORDER_BY = "order_by";
251 
255  public const string CHUNK_SIZE = "chunk_size";
256 
259  public const string LIMIT = "limit";
260 
264  public const string TTL = "ttl";
265 
268  public const string VIEW_ID = "view_id";
269 
285  public const string MATERIALIZE_ON_GPU = "materialize_on_gpu";
286 
292  public const string CREATE_INDEXES = "create_indexes";
293 
310  public const string RESULT_TABLE_FORCE_REPLICATED = "result_table_force_replicated";
311  } // end struct Options
312 
313 
316  public string table_name { get; set; }
317 
321  public IList<string> column_names { get; set; } = new List<string>();
322 
325  public string variable_column_name { get; set; } = "";
326 
329  public string value_column_name { get; set; } = "";
330 
334  public IList<string> pivoted_columns { get; set; } = new List<string>();
335 
355  public string encoding { get; set; } = Encoding.BINARY;
356 
488  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
489 
490 
494 
643  IList<string> column_names,
644  string variable_column_name,
645  string value_column_name,
646  IList<string> pivoted_columns,
647  IDictionary<string, string> options = null)
648  {
649  this.table_name = table_name ?? "";
650  this.column_names = column_names ?? new List<string>();
651  this.variable_column_name = variable_column_name ?? "";
652  this.value_column_name = value_column_name ?? "";
653  this.pivoted_columns = pivoted_columns ?? new List<string>();
654  this.encoding = Encoding.BINARY;
655  this.options = options ?? new Dictionary<string, string>();
656  } // end constructor
657 
658 
826  IList<string> column_names,
827  string variable_column_name,
828  string value_column_name,
829  IList<string> pivoted_columns,
830  string encoding = null,
831  IDictionary<string, string> options = null)
832  {
833  this.table_name = table_name ?? "";
834  this.column_names = column_names ?? new List<string>();
835  this.variable_column_name = variable_column_name ?? "";
836  this.value_column_name = value_column_name ?? "";
837  this.pivoted_columns = pivoted_columns ?? new List<string>();
838  this.encoding = encoding ?? Encoding.BINARY;
839  this.options = options ?? new Dictionary<string, string>();
840  } // end full constructor
841 
842  } // end class AggregateUnpivotRequest
843 
844 
845 
850  {
851 
854  public string table_name { get; set; }
855 
858  public string response_schema_str { get; set; }
859 
861  public byte[] binary_encoded_response { get; set; }
862 
864  public string json_encoded_response { get; set; }
865 
867  public long total_number_of_records { get; set; }
868 
870  public bool has_more_records { get; set; }
871 
872  } // end class RawAggregateUnpivotResponse
873 
874 
875 
880  {
881 
884  public string table_name { get; set; }
885 
887  public IList<KineticaRecord> data { get; set; } = new List<KineticaRecord>();
888 
890  public long total_number_of_records { get; set; }
891 
893  public bool has_more_records { get; set; }
894 
895  } // end class AggregateUnpivotResponse
896 
897 
898 
899 
900 } // end namespace kinetica
string variable_column_name
Specifies the variable/parameter column name.
A set of results returned by Kinetica.aggregateUnpivot(string,IList<string>,string,string,IList<string>,IDictionary<string, string>).
string encoding
Specifies the encoding for returned records.
AggregateUnpivotRequest(string table_name, IList< string > column_names, string variable_column_name, string value_column_name, IList< string > pivoted_columns, string encoding=null, IDictionary< string, string > options=null)
Constructs an AggregateUnpivotRequest object with the specified parameters.
A set of results returned by Kinetica.aggregateUnpivot(string,IList<string>,string,string,IList<string>,IDictionary<string, string>).
string value_column_name
Specifies the value column name.
IDictionary< string, string > options
Optional parameters.
AggregateUnpivotRequest()
Constructs an AggregateUnpivotRequest object with default parameters.
string table_name
Name of the table on which the operation will be performed.
A set of parameters for Kinetica.aggregateUnpivot(string,IList<string>,string,string,IList<string>,IDictionary<string, string>).
const string BINARY
Indicates that the returned records should be binary encoded.
AggregateUnpivotRequest(string table_name, IList< string > column_names, string variable_column_name, string value_column_name, IList< string > pivoted_columns, IDictionary< string, string > options=null)
Constructs an AggregateUnpivotRequest object with the specified parameters.
IList< string > pivoted_columns
List of one or more values typically the column names of the input table.
Specifies the encoding for returned records.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string JSON
Indicates that the returned records should be json encoded.
IList< string > column_names
List of column names or expressions.