7 using System.Collections.Generic;
78 public const string BINARY =
"binary";
82 public const string JSON =
"json";
107 public const string TRUE =
"true";
108 public const string FALSE =
"false";
202 public const string KEY =
"key";
209 public const string VALUE =
"value";
307 public const string TTL =
"ttl";
378 public const string RANGE =
"RANGE";
388 public const string LIST =
"LIST";
393 public const string HASH =
"HASH";
446 public const string PIVOT =
"pivot";
468 public const string CUBE =
"cube";
507 public long limit {
get;
set; } = -9999;
525 public string encoding {
get;
set; } = Encoding.BINARY;
945 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
1398 IDictionary<string, string>
options =
null)
1401 this.column_names =
column_names ??
new List<string>();
1871 IDictionary<string, string>
options =
null)
1874 this.column_names =
column_names ??
new List<string>();
1928 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
1947 public IList<KineticaRecord>
data {
get;
set; } =
new List<KineticaRecord>();
1970 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 SORT_ORDER
[DEPRECATED–use order_by instead] String indicating how the returned values should be sorted - ascend...
long total_number_of_records
Total/Filtered number of records.
const string RESULT_TABLE_GENERATE_PK
If TRUE then set a primary key for the result table.
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 ...
byte [] binary_encoded_response
Avro binary encoded response.
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.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the result table.
const string DESCENDING
Indicates that the returned values should be sorted in descending order.
const string CUBE
This option is used to specify the multidimensional aggregates.
const string RESULT_TABLE
The name of a table used to store the results, in [schema_name.
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
long total_number_of_records
Total/Filtered number of records.
A set of string constants for the parameter encoding.
const string IS_AUTOMATIC_PARTITION
If TRUE, a new partition will be created for values which don't fall into an existing partition.
KineticaData - class to help with Avro Encoding for Kinetica
const string BINARY
Indicates that the returned records should be binary encoded.
const string ROLLUP
This option is used to specify the multilevel aggregates.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string GROUPING_SETS
Customize the grouping attribute sets to compute the aggregates.
const string RANGE
Use range partitioning.
string response_schema_str
Avro schema of binary_encoded_response or json_encoded_response.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string SERIES
Use series partitioning.
A set of results returned by Kinetica.aggregateGroupBy.
const string ASCENDING
Indicates that the returned values should be sorted in ascending order.
const string INTERVAL
Use interval partitioning.
const string EXPRESSION
Filter expression to apply to the table prior to computing the aggregate group by.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
const string VIEW_ID
ID of view of which the result table will be a member.
IList< string > column_names
List of one or more column names, expressions, and aggregate expressions.
IDictionary< string, string > info
Additional information.
string encoding
Specifies the encoding for returned records.
long offset
A positive integer indicating the number of initial results to skip (this can be useful for paging th...
const string VALUE
Indicates that the returned values should be sorted by value, which corresponds to the aggregates.
const string JSON
Indicates that the returned records should be JSON-encoded.
const string LIST
Use list partitioning.
long limit
A positive integer indicating the maximum number of results to be returned, or END_OF_SET (-9999) to ...
A set of string constants for the parameter info.
IList< KineticaRecord > data
Avro binary encoded response.
const string PARTITION_TYPE
Partitioning scheme to use for the result table.
const string PIVOT_VALUES
Comma-separated list of the values in the PIVOT column.
const string ORDER_BY
Comma-separated list of the columns to be sorted by as well as the sort direction,...
const string SORT_BY
[DEPRECATED–use order_by instead] String determining how the results are sorted.
bool has_more_records
Too many 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 PIVOT
Pivot column.
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.
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.
A set of string constants for the parameter options.
A set of parameters for Kinetica.aggregateGroupBy.
const string KEY
Indicates that the returned values should be sorted by key, which corresponds to the grouping columns...
string table_name
Name of an existing table or view on which the operation will be performed, in [schema_name.
IDictionary< string, string > info
Additional information.
string json_encoded_response
Avro JSON encoded response.
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.
const string PIPELINED_EXPRESSION_EVALUATION
Evaluate the group-by during last JoinedSet filter plan step.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
const string QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of RESULT_TABLE and use Kinetica....
const string TTL
Sets the TTL of the table specified in RESULT_TABLE.
IDictionary< string, string > options
Optional parameters.
const string HASH
Use hash partitioning.
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.
A set of results returned by Kinetica.aggregateGroupBy.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for the result table.
AggregateGroupByRequest()
Constructs an AggregateGroupByRequest object with default parameters.
A set of string constants for the parameter info.
bool has_more_records
Too many records.