7 using System.Collections.Generic;
39 public const string BINARY =
"binary";
43 public const string JSON =
"json";
68 public const string TRUE =
"true";
69 public const string FALSE =
"false";
145 public const string LIMIT =
"limit";
150 public const string TTL =
"ttl";
224 public string encoding {
get;
set; } = Encoding.BINARY;
396 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
595 IDictionary<string, string>
options =
null)
816 IDictionary<string, string>
options =
null)
876 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
899 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
920 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
byte [] binary_encoded_response
Avro binary encoded response.
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 ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
IDictionary< string, string > info
Additional information.
bool has_more_records
Too many records.
A set of string constants for the parameter info.
string variable_column_name
Specifies the variable/parameter column name.
long total_number_of_records
Total/Filtered number of records.
A set of results returned by Kinetica.aggregateUnpivot.
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.
const string RESULT_TABLE_FORCE_REPLICATED
Force the result table to be replicated (ignores any sharding).
string value_column_name
Specifies the value column name.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
IDictionary< string, string > options
Optional parameters.
IList< KineticaRecord > data
Avro binary encoded response.
A set of string constants for the parameter options.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
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.
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....
AggregateUnpivotRequest()
Constructs an AggregateUnpivotRequest object with default parameters.
string table_name
Name of the table on which the operation will be performed.
const string VIEW_ID
view this result table is part of.
A set of parameters for Kinetica.aggregateUnpivot.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
const string BINARY
Indicates that the returned records should be binary encoded.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for the result table.
IDictionary< string, string > info
Additional information.
long total_number_of_records
Total/Filtered number of records.
bool has_more_records
Too many records.
const string EXPRESSION
Filter expression to apply to the table prior to unpivot processing.
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
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.
string json_encoded_response
Avro JSON encoded response.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the table specified in RESULT_TABLE.
A set of string constants for the parameter encoding.
const string RESULT_TABLE
The name of a table used to store the results, in [schema_name.
const string LIMIT
The number of records to keep.
A set of string constants for the parameter info.
KineticaData - class to help with Avro Encoding for Kinetica
const string JSON
Indicates that the returned records should be json encoded.
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.
IList< string > column_names
List of column names or expressions.
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 ...