Kinetica   C#   API  Version 7.2.3.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 namespace kinetica
10 {
29  public class AggregateUnpivotRequest : KineticaData
30  {
35  public struct Encoding
36  {
39  public const string BINARY = "binary";
40 
43  public const string JSON = "json";
44  } // end struct Encoding
45 
49  public struct Options
50  {
66  public const string CREATE_TEMP_TABLE = "create_temp_table";
67 
68  public const string TRUE = "true";
69  public const string FALSE = "false";
70 
80  public const string COLLECTION_NAME = "collection_name";
81 
90  public const string RESULT_TABLE = "result_table";
91 
108  public const string RESULT_TABLE_PERSIST = "result_table_persist";
109 
112  public const string EXPRESSION = "expression";
113 
120  public const string ORDER_BY = "order_by";
121 
127  public const string CHUNK_SIZE = "chunk_size";
128 
134  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
135 
141  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
142 
147  public const string COMPRESSION_CODEC = "compression_codec";
148 
151  public const string LIMIT = "limit";
152 
156  public const string TTL = "ttl";
157 
160  public const string VIEW_ID = "view_id";
161 
169  public const string CREATE_INDEXES = "create_indexes";
170 
184  public const string RESULT_TABLE_FORCE_REPLICATED = "result_table_force_replicated";
185  } // end struct Options
186 
193  public string table_name { get; set; }
194 
198  public IList<string> column_names { get; set; } = new List<string>();
199 
202  public string variable_column_name { get; set; } = "";
203 
206  public string value_column_name { get; set; } = "";
207 
212  public IList<string> pivoted_columns { get; set; } = new List<string>();
213 
230  public string encoding { get; set; } = Encoding.BINARY;
231 
411  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
412 
416 
615  IList<string> column_names,
616  string variable_column_name,
617  string value_column_name,
618  IList<string> pivoted_columns,
619  IDictionary<string, string> options = null)
620  {
621  this.table_name = table_name ?? "";
622  this.column_names = column_names ?? new List<string>();
623  this.variable_column_name = variable_column_name ?? "";
624  this.value_column_name = value_column_name ?? "";
625  this.pivoted_columns = pivoted_columns ?? new List<string>();
626  this.encoding = Encoding.BINARY;
627  this.options = options ?? new Dictionary<string, string>();
628  } // end constructor
629 
844  IList<string> column_names,
845  string variable_column_name,
846  string value_column_name,
847  IList<string> pivoted_columns,
848  string encoding = null,
849  IDictionary<string, string> options = null)
850  {
851  this.table_name = table_name ?? "";
852  this.column_names = column_names ?? new List<string>();
853  this.variable_column_name = variable_column_name ?? "";
854  this.value_column_name = value_column_name ?? "";
855  this.pivoted_columns = pivoted_columns ?? new List<string>();
856  this.encoding = encoding ?? Encoding.BINARY;
857  this.options = options ?? new Dictionary<string, string>();
858  } // end full constructor
859  } // end class AggregateUnpivotRequest
860 
864  public class RawAggregateUnpivotResponse : KineticaData
865  {
869  public struct Info
870  {
873  public const string QUALIFIED_RESULT_TABLE_NAME = "qualified_result_table_name";
874  } // end struct Info
875 
878  public string table_name { get; set; }
879 
882  public string response_schema_str { get; set; }
883 
885  public byte[] binary_encoded_response { get; set; }
886 
888  public string json_encoded_response { get; set; }
889 
891  public long total_number_of_records { get; set; }
892 
895  public bool has_more_records { get; set; }
896 
909  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
910  } // end class RawAggregateUnpivotResponse
911 
915  public class AggregateUnpivotResponse : KineticaData
916  {
920  public struct Info
921  {
924  public const string QUALIFIED_RESULT_TABLE_NAME = "qualified_result_table_name";
925  } // end struct Info
926 
929  public string table_name { get; set; }
930 
932  public IList<KineticaRecord> data { get; set; } = new List<KineticaRecord>();
933 
935  public long total_number_of_records { get; set; }
936 
939  public bool has_more_records { get; set; }
940 
953  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
954  } // end class AggregateUnpivotResponse
955 } // end namespace kinetica
const string RESULT_TABLE
The name of a table used to store the results, in [schema_name.
const string COMPRESSION_CODEC
The default compression codec for the result table's columns.
byte [] binary_encoded_response
Avro binary encoded response.
IList< string > pivoted_columns
List of one or more values typically the column names of the input table.
const string RESULT_TABLE_FORCE_REPLICATED
Force the result table to be replicated (ignores any sharding).
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
string json_encoded_response
Avro JSON encoded response.
const string JSON
Indicates that the returned records should be json encoded.
const string VIEW_ID
view this result table is part of.
const string LIMIT
The number of records to keep.
string response_schema_str
Avro schema of binary_encoded_response or json_encoded_response.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....
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.
bool has_more_records
Too many records.
const string ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for the result table.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the table specified in RESULT_TABLE.
string value_column_name
Specifies the value column name.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
IDictionary< string, string > options
Optional parameters.
IDictionary< string, string > info
Additional information.
AggregateUnpivotRequest()
Constructs an AggregateUnpivotRequest object with default parameters.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
long total_number_of_records
Total/Filtered number of records.
const string BINARY
Indicates that the returned records should be binary encoded.
long total_number_of_records
Total/Filtered number of records.
const string RESULT_TABLE_PERSIST
If TRUE, then the result table specified in RESULT_TABLE will be persisted and will not expire unless...
IList< string > column_names
List of column names or expressions.
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.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
string variable_column_name
Specifies the variable/parameter column name.
IDictionary< string, string > info
Additional information.
const string EXPRESSION
Filter expression to apply to the table prior to unpivot processing.
A set of string constants for the parameter encoding.
const string CREATE_TEMP_TABLE
If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of ...
string table_name
Name of the table on which the operation will be performed.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
IList< KineticaRecord > data
Avro binary encoded response.
const string CHUNK_COLUMN_MAX_MEMORY
Indicates the target maximum data size for each column in a chunk to be used for the result table.
string encoding
Specifies the encoding for returned records.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.