7 using System.Collections.Generic;
118 public const string JSON =
"json";
393 public const string TRUE =
"true";
394 public const string FALSE =
"false";
473 public const string KEY =
"key";
480 public const string VALUE =
"value";
559 public const string TTL =
"ttl";
576 public const string PIVOT =
"pivot";
596 public const string CUBE =
"cube";
630 public long limit {
get; set; } = -9999;
898 public IDictionary<string, string>
options {
get; set; } =
new Dictionary<string, string>();
1183 IDictionary<string, string>
options = null)
1185 this.table_name = table_name ??
"";
1186 this.column_names = column_names ??
new List<string>();
1187 this.offset =
offset ?? 0;
1188 this.limit =
limit ?? -9999;
1190 this.options =
options ??
new Dictionary<string, string>();
1492 IDictionary<string, string>
options = null)
1494 this.table_name = table_name ??
"";
1495 this.column_names = column_names ??
new List<string>();
1496 this.offset =
offset ?? 0;
1497 this.limit =
limit ?? -9999;
1499 this.options =
options ??
new Dictionary<string, string>();
1559 public IDictionary<string, string>
info {
get; set; } =
new Dictionary<string, string>();
1593 public IList<KineticaRecord>
data {
get; set; } =
new List<KineticaRecord>();
1611 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 QUALIFIED_RESULT_TABLE_NAME
The fully qualified name of the table (i.e.
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 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.
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.
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(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 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.
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 <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
[DEPRECATED–please specify the containing schema as part of result_table and use Kinetica.createSchema(string,IDictionary{string, string}) to create the schema if non-existent] Name of a schema which is to contain the table specified in result_table.