7 using System.Collections.Generic;
72 public class AggregateGroupByRequest : KineticaData
78 public struct Encoding
82 public const string BINARY =
"binary";
86 public const string JSON =
"json";
111 public const string TRUE =
"true";
112 public const string FALSE =
"false";
127 public const string EXPRESSION =
"expression";
146 public const string HAVING =
"having";
168 public const string SORT_ORDER =
"sort_order";
172 public const string ASCENDING =
"ascending";
176 public const string DESCENDING =
"descending";
203 public const string SORT_BY =
"sort_by";
210 public const string KEY =
"key";
217 public const string VALUE =
"value";
223 public const string ORDER_BY =
"order_by";
316 public const string TTL =
"ttl";
323 public const string CHUNK_SIZE =
"chunk_size";
349 public const string VIEW_ID =
"view_id";
352 public const string PIVOT =
"pivot";
371 public const string ROLLUP =
"rollup";
375 public const string CUBE =
"cube";
383 public const string SHARD_KEY =
"shard_key";
394 public IList<string>
column_names {
get;
set; } =
new List<string>();
401 public long offset {
get;
set; } = 0;
416 public long limit {
get;
set; } = -9999;
434 public string encoding {
get;
set; } = Encoding.BINARY;
775 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
1150 IDictionary<string, string>
options =
null)
1153 this.column_names =
column_names ??
new List<string>();
1546 IDictionary<string, string>
options =
null)
1549 this.column_names =
column_names ??
new List<string>();
1560 public class RawAggregateGroupByResponse : KineticaData
1604 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
1610 public class AggregateGroupByResponse : KineticaData
1623 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
1647 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.