7 using System.Collections.Generic;
85 public const string BINARY =
"binary";
89 public const string JSON =
"json";
114 public const string TRUE =
"true";
115 public const string FALSE =
"false";
213 public const string KEY =
"key";
220 public const string VALUE =
"value";
298 public const string TTL =
"ttl";
334 public const string PIVOT =
"pivot";
357 public const string CUBE =
"cube";
398 public long limit {
get;
set; } = -9999;
416 public string encoding {
get;
set; } = Encoding.BINARY;
728 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
1074 IDictionary<string, string>
options =
null)
1077 this.column_names =
column_names ??
new List<string>();
1441 IDictionary<string, string>
options =
null)
1444 this.column_names =
column_names ??
new List<string>();
1499 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
1518 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
1542 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
A set of string constants for the parameter encoding.
long total_number_of_records
Total/Filtered number of records.
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
A set of results returned by Kinetica.aggregateGroupBy.
const string ORDER_BY
Comma-separated list of the columns to be sorted by as well as the sort direction,...
bool has_more_records
Too many records.
const string RESULT_TABLE_FORCE_REPLICATED
Force the result table to be replicated (ignores any sharding).
const string PIVOT
pivot column
const string CUBE
This option is used to specify the multidimensional aggregates.
AggregateGroupByRequest(string table_name, IList< string > column_names, long? offset=null, long? limit=null, IDictionary< string, string > options=null)
Constructs an AggregateGroupByRequest object with the specified parameters.
AggregateGroupByRequest()
Constructs an AggregateGroupByRequest object with default parameters.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
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 BINARY
Indicates that the returned records should be binary encoded.
const string KEY
Indicates that the returned values should be sorted by key, which corresponds to the grouping columns...
A set of string constants for the parameter info.
long offset
A positive integer indicating the number of initial results to skip (this can be useful for paging th...
const string CHUNKED_EXPRESSION_EVALUATION
evaluate the filter expression during group-by chunk processing.
A set of string constants for the parameter info.
IList< KineticaRecord > data
Avro binary encoded response.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
const string VALUE
Indicates that the returned values should be sorted by value, which corresponds to the aggregates.
IDictionary< string, string > options
Optional parameters.
const string DESCENDING
Indicates that the returned values should be sorted in descending order.
A set of string constants for the parameter options.
IDictionary< string, string > info
Additional information.
long total_number_of_records
Total/Filtered number of records.
const string SORT_ORDER
[DEPRECATED–use order_by instead] String indicating how the returned values should be sorted - ascend...
bool has_more_records
Too many records.
const string EXPRESSION
Filter expression to apply to the table prior to computing the aggregate group by.
string json_encoded_response
Avro JSON encoded response.
IList< string > column_names
List of one or more column names, expressions, and aggregate expressions.
const string ASCENDING
Indicates that the returned values should be sorted in ascending order.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
byte [] binary_encoded_response
Avro binary encoded response.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
A set of results returned by Kinetica.aggregateGroupBy.
const string JSON
Indicates that the returned records should be json encoded.
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 HAVING
Filter expression to apply to the aggregated results.
const string SORT_BY
[DEPRECATED–use order_by instead] String determining how the results are sorted.
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 ...
const string VIEW_ID
ID of view of which the result table will be a member.
string encoding
Specifies the encoding for returned records.
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 RESULT_TABLE_GENERATE_PK
If TRUE then set a primary key for the result table.
string table_name
Name of an existing table or view on which the operation will be performed, in [schema_name.
KineticaData - class to help with Avro Encoding for Kinetica
IDictionary< string, string > info
Additional information.
AggregateGroupByRequest(string table_name, IList< string > column_names, long? offset=null, long? limit=null, string encoding=null, IDictionary< string, string > options=null)
Constructs an AggregateGroupByRequest object with the specified parameters.
long limit
A positive integer indicating the maximum number of results to be returned, or END_OF_SET (-9999) to ...
const string ROLLUP
This option is used to specify the multilevel aggregates.
const string RESULT_TABLE
The name of a table used to store the results, in [schema_name.
const string GROUPING_SETS
Customize the grouping attribute sets to compute the aggregates.
string response_schema_str
Avro schema of binary_encoded_response or json_encoded_response.
const string PIVOT_VALUES
The value list provided will become the column headers in the output.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the result table.
A set of parameters for Kinetica.aggregateGroupBy.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....