7 using System.Collections.Generic;
118 public const string JSON =
"json";
435 public const string KEY =
"key";
442 public const string VALUE =
"value";
473 public const string TRUE =
"true";
474 public const string FALSE =
"false";
515 public const string TTL =
"ttl";
555 public const string PIVOT =
"pivot";
575 public const string CUBE =
"cube";
604 public long limit {
get; set; } = -9999;
861 public IDictionary<string, string>
options {
get; set; } =
new Dictionary<string, string>();
1129 IDictionary<string, string>
options = null)
1131 this.table_name = table_name ??
"";
1132 this.column_names = column_names ??
new List<string>();
1133 this.offset =
offset ?? 0;
1134 this.limit =
limit ?? -9999;
1136 this.options =
options ??
new Dictionary<string, string>();
1421 IDictionary<string, string>
options = null)
1423 this.table_name = table_name ??
"";
1424 this.column_names = column_names ??
new List<string>();
1425 this.offset =
offset ?? 0;
1426 this.limit =
limit ?? -9999;
1428 this.options =
options ??
new Dictionary<string, string>();
1458 public IDictionary<string, string>
info {
get; set; } =
new Dictionary<string, string>();
1471 public IList<KineticaRecord>
data {
get; set; } =
new List<KineticaRecord>();
1480 public IDictionary<string, string>
info {
get; set; } =
new Dictionary<string, string>();
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.
Specifies the encoding for returned records.
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(string,IList{string},long,long,IDictionary{string, string}).
bool has_more_records
Too many records. Returned a partial set.
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()
Constructs an AggregateGroupByRequest object with default parameters.
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.
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...
long offset
A positive integer indicating the number of initial results to skip (this can be useful for paging th...
IList< KineticaRecord > data
Avro binary encoded response.
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.
IDictionary< string, string > info
Additional information.
long total_number_of_records
Total/Filtered number of records.
const string SORT_ORDER
String indicating how the returned values should be sorted - ascending or descending.
bool has_more_records
Too many records. Returned a partial set.
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.
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.
const string MATERIALIZE_ON_GPU
No longer used.
A set of results returned by Kinetica.aggregateGroupBy(string,IList{string},long,long,IDictionary{string, string}).
const string JSON
Indicates that the returned records should be json encoded.
const string HAVING
Filter expression to apply to the aggregated results.
const string SORT_BY
String determining how the results are sorted.
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.
KineticaData - class to help with Avro Encoding for Kinetica
IDictionary< string, string > info
Additional information.
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 the table used to store the results.
const string GROUPING_SETS
Customize the grouping attribute sets to compute the aggregates.
string response_schema_str
Avro schema of <member name="binary_encoded_response"> or <member name="json_encoded_response">.
const string PIVOT_VALUES
The value list provided will become the column headers in the output.
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(string,IList{string},long,long,IDictionary{string, string}).
const string COLLECTION_NAME
Name of a collection which is to contain the table specified in result_table.