7 using System.Collections.Generic;
38 public const string BINARY =
"binary";
42 public const string JSON =
"json";
67 public const string TRUE =
"true";
68 public const string FALSE =
"false";
149 public const string LIMIT =
"limit";
154 public const string TTL =
"ttl";
228 public string encoding {
get;
set; } = Encoding.BINARY;
401 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
601 IDictionary<string, string>
options =
null)
822 IDictionary<string, string>
options =
null)
881 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
904 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
924 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string RESULT_TABLE_FORCE_REPLICATED
Force the result table to be replicated (ignores any sharding).
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.
A set of string constants for the parameter encoding.
IDictionary< string, string > options
Optional parameters.
string json_encoded_response
Avro JSON encoded response.
A set of string constants for the parameter info.
IList< KineticaRecord > data
Avro binary encoded response.
const string RESULT_TABLE
The name of a table used to store the results, in [schema_name.
byte [] binary_encoded_response
Avro binary encoded response.
long total_number_of_records
Total/Filtered number of records.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
A set of results returned by Kinetica.aggregateUnpivot.
string variable_column_name
Specifies the variable/parameter column name.
KineticaData - class to help with Avro Encoding for Kinetica
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 encoding
Specifies the encoding for returned records.
const string BINARY
Indicates that the returned records should be binary encoded.
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
IList< string > column_names
List of column names or expressions.
string value_column_name
Specifies the value column name.
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 ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
IDictionary< string, string > info
Additional information.
A set of string constants for the parameter info.
A set of string constants for the parameter options.
const string EXPRESSION
Filter expression to apply to the table prior to unpivot processing.
IDictionary< string, string > info
Additional information.
bool has_more_records
Too many records.
const string LIMIT
The number of records to keep.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
string response_schema_str
Avro schema of binary_encoded_response or json_encoded_response.
const string VIEW_ID
View this result table is part of.
IList< string > pivoted_columns
List of one or more values typically the column names of the input table.
long total_number_of_records
Total/Filtered number of records.
bool has_more_records
Too many records.
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.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
string table_name
Name of the table on which the operation will be performed.
A set of results returned by Kinetica.aggregateUnpivot.
const string COMPRESSION_CODEC
The default compression codec for the result table's columns.
AggregateUnpivotRequest()
Constructs an AggregateUnpivotRequest object with default parameters.
const string RESULT_TABLE_PERSIST
If TRUE, then the result table specified in RESULT_TABLE will be persisted and will not expire unless...
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the table specified in RESULT_TABLE.
const string JSON
Indicates that the returned records should be JSON-encoded.
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 parameters for Kinetica.aggregateUnpivot.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....