Kinetica C# API  Version 6.1.0.0
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 
32  {
33 
54  public struct Encoding
55  {
56 
59  public const string BINARY = "binary";
60 
63  public const string JSON = "json";
64  } // end struct Encoding
65 
66 
145  public struct Options
146  {
147 
152  public const string COLLECTION_NAME = "collection_name";
153 
159  public const string RESULT_TABLE = "result_table";
160 
179  public const string RESULT_TABLE_PERSIST = "result_table_persist";
180  public const string TRUE = "true";
181  public const string FALSE = "false";
182 
185  public const string EXPRESSION = "expression";
186 
192  public const string ORDER_BY = "order_by";
193 
197  public const string CHUNK_SIZE = "chunk_size";
198 
200  public const string LIMIT = "limit";
201 
205  public const string TTL = "ttl";
206  } // end struct Options
207 
208 
211  public string table_name { get; set; }
212 
214  public string variable_column_name { get; set; } = "";
215 
217  public string value_column_name { get; set; } = "";
218 
222  public IList<string> pivoted_columns { get; set; } = new List<string>();
223 
243  public string encoding { get; set; } = Encoding.BINARY;
244 
321  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
322 
323 
327 
418  string variable_column_name,
419  string value_column_name,
420  IList<string> pivoted_columns,
421  IDictionary<string, string> options = null)
422  {
423  this.table_name = table_name ?? "";
424  this.variable_column_name = variable_column_name ?? "";
425  this.value_column_name = value_column_name ?? "";
426  this.pivoted_columns = pivoted_columns ?? new List<string>();
427  this.encoding = Encoding.BINARY;
428  this.options = options ?? new Dictionary<string, string>();
429  } // end constructor
430 
431 
541  string variable_column_name,
542  string value_column_name,
543  IList<string> pivoted_columns,
544  string encoding = null,
545  IDictionary<string, string> options = null)
546  {
547  this.table_name = table_name ?? "";
548  this.variable_column_name = variable_column_name ?? "";
549  this.value_column_name = value_column_name ?? "";
550  this.pivoted_columns = pivoted_columns ?? new List<string>();
551  this.encoding = encoding ?? Encoding.BINARY;
552  this.options = options ?? new Dictionary<string, string>();
553  } // end full constructor
554 
555  } // end class AggregateUnpivotRequest
556 
557 
558 
563  {
564 
567  public string table_name { get; set; }
568 
571  public string response_schema_str { get; set; }
572 
574  public byte[] binary_encoded_response { get; set; }
575 
577  public string json_encoded_response { get; set; }
578 
580  public long total_number_of_records { get; set; }
581 
583  public bool has_more_records { get; set; }
584 
585  } // end class RawAggregateUnpivotResponse
586 
587 
588 
593  {
594 
597  public string table_name { get; set; }
598 
600  public IList<KineticaRecord> data { get; set; } = new List<KineticaRecord>();
601 
603  public long total_number_of_records { get; set; }
604 
606  public bool has_more_records { get; set; }
607 
608  } // end class AggregateUnpivotResponse
609 
610 
611 
612 
613 } // end namespace kinetica
string variable_column_name
Specifies the variable/parameter column name.
A set of results returned by Kinetica.aggregateUnpivot(string,string,string,IList<string>,IDictionary<string, string>).
AggregateUnpivotRequest(string table_name, 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.
string encoding
Specifies the encoding for returned records.
A set of results returned by Kinetica.aggregateUnpivot(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,string,string,IList<string>,IDictionary<string, string>).
AggregateUnpivotRequest(string table_name, 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.
const string BINARY
Indicates that the returned records should be binary encoded.
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.