7 using System.Collections.Generic;
29 public class AggregateUnpivotRequest : KineticaData
35 public struct Encoding
39 public const string BINARY =
"binary";
43 public const string JSON =
"json";
68 public const string TRUE =
"true";
69 public const string FALSE =
"false";
112 public const string EXPRESSION =
"expression";
120 public const string ORDER_BY =
"order_by";
127 public const string CHUNK_SIZE =
"chunk_size";
151 public const string LIMIT =
"limit";
156 public const string TTL =
"ttl";
160 public const string VIEW_ID =
"view_id";
198 public IList<string>
column_names {
get;
set; } =
new List<string>();
212 public IList<string>
pivoted_columns {
get;
set; } =
new List<string>();
230 public string encoding {
get;
set; } = Encoding.BINARY;
411 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
619 IDictionary<string, string>
options =
null)
849 IDictionary<string, string>
options =
null)
864 public class RawAggregateUnpivotResponse : KineticaData
909 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
915 public class AggregateUnpivotResponse : KineticaData
932 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
953 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
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.
bool has_more_records
Too many records.
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.