7 using System.Collections.Generic;
75 public class AggregateGroupByRequest : KineticaData
81 public struct Encoding
85 public const string BINARY =
"binary";
89 public const string JSON =
"json";
114 public const string TRUE =
"true";
115 public const string FALSE =
"false";
130 public const string EXPRESSION =
"expression";
149 public const string HAVING =
"having";
171 public const string SORT_ORDER =
"sort_order";
175 public const string ASCENDING =
"ascending";
179 public const string DESCENDING =
"descending";
206 public const string SORT_BY =
"sort_by";
213 public const string KEY =
"key";
220 public const string VALUE =
"value";
226 public const string ORDER_BY =
"order_by";
319 public const string TTL =
"ttl";
326 public const string CHUNK_SIZE =
"chunk_size";
352 public const string VIEW_ID =
"view_id";
355 public const string PIVOT =
"pivot";
374 public const string ROLLUP =
"rollup";
378 public const string CUBE =
"cube";
386 public const string SHARD_KEY =
"shard_key";
397 public IList<string>
column_names {
get;
set; } =
new List<string>();
404 public long offset {
get;
set; } = 0;
419 public long limit {
get;
set; } = -9999;
437 public string encoding {
get;
set; } = Encoding.BINARY;
778 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
1153 IDictionary<string, string>
options =
null)
1156 this.column_names =
column_names ??
new List<string>();
1549 IDictionary<string, string>
options =
null)
1552 this.column_names =
column_names ??
new List<string>();
1563 public class RawAggregateGroupByResponse : KineticaData
1607 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
1613 public class AggregateGroupByResponse : KineticaData
1626 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
1650 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
A set of string constants for the parameter encoding.
const string ORDER_BY
Comma-separated list of the columns to be sorted by as well as the sort direction,...
const string KEY
Indicates that the returned values should be sorted by key, which corresponds to the grouping columns...
long total_number_of_records
Total/Filtered number of records.
const string PIPELINED_EXPRESSION_EVALUATION
evaluate the group-by during last JoinedSet filter plan step.
long limit
A positive integer indicating the maximum number of results to be returned, or END_OF_SET (-9999) to ...
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 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.
const string RESULT_TABLE_GENERATE_SOFT_PK
If TRUE then set a soft primary key for the result table.
bool has_more_records
Too many records.
string response_schema_str
Avro schema of binary_encoded_response or json_encoded_response.
string encoding
Specifies the encoding for returned records.
const string BINARY
Indicates that the returned records should be binary encoded.
const string SORT_BY
[DEPRECATED–use order_by instead] String determining how the results are sorted.
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 EXPRESSION
Filter expression to apply to the table prior to computing the aggregate group by.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string RESULT_TABLE_FORCE_REPLICATED
Force the result table to be replicated (ignores any sharding).
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 PIVOT_VALUES
The value list provided will become the column headers in the output.
const string ASCENDING
Indicates that the returned values should be sorted in ascending order.
const string SORT_ORDER
[DEPRECATED–use order_by instead] String indicating how the returned values should be sorted - ascend...
const string CUBE
This option is used to specify the multidimensional aggregates.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
IDictionary< string, string > info
Additional information.
string table_name
Name of an existing table or view on which the operation will be performed, in [schema_name.
bool has_more_records
Too many records.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the result table.
const string ROLLUP
This option is used to specify the multilevel aggregates.
IDictionary< string, string > info
Additional information.
const string DESCENDING
Indicates that the returned values should be sorted in descending order.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
byte [] binary_encoded_response
Avro binary encoded response.
IDictionary< string, string > options
Optional parameters.
const string GROUPING_SETS
Customize the grouping attribute sets to compute the aggregates.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....
const string PIVOT
pivot column
const string VIEW_ID
ID of view of which the result table will be a member.
const string JSON
Indicates that the returned records should be json encoded.
const string VALUE
Indicates that the returned values should be sorted by value, which corresponds to the aggregates.
long offset
A positive integer indicating the number of initial results to skip (this can be useful for paging th...
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.
long total_number_of_records
Total/Filtered number of records.
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.
IList< string > column_names
List of one or more column names, expressions, and aggregate expressions.
const string HAVING
Filter expression to apply to the aggregated results.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for the result table.
IList< KineticaRecord > data
Avro binary encoded response.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
string json_encoded_response
Avro JSON encoded response.