7 using System.Collections.Generic;
54 public const string TRUE =
"true";
55 public const string FALSE =
"false";
117 public const string MODE =
"mode";
125 public const string UNION =
"union";
207 public const string RANGE =
"RANGE";
217 public const string LIST =
"LIST";
222 public const string HASH =
"HASH";
272 public const string TTL =
"ttl";
344 public IList<string>
table_names {
get;
set; } =
new List<string>();
643 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
961 IDictionary<string, string>
options =
null)
964 this.table_names =
table_names ??
new List<string>();
982 public const string COUNT =
"count";
1009 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string MODE
The mode describes what rows of the tables being unioned will be retained.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
const string RANGE
Use range partitioning.
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
IList< string > table_names
The list of table names to merge, in [schema_name.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this output table.
const string EXCEPT_ALL
Retains all rows(including duplicates) from the first table that do not appear in the second table (o...
KineticaData - class to help with Avro Encoding for Kinetica
const string INTERSECT_ALL
Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 t...
string table_name
Value of table_name.
const string LIST
Use list partitioning.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
A set of parameters for Kinetica.createUnion.
const string PERSIST
If TRUE, then the output table specified in table_name will be persisted and will not expire unless a...
const string FORCE_REPLICATED
If TRUE, then the output table specified in table_name will be replicated even if the source tables a...
const string EXCEPT
Retains all unique rows from the first table that do not appear in the second table (only works on 2 ...
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
A set of string constants for the parameter info.
string table_name
Name of the table to be created, in [schema_name.
const string COMPRESSION_CODEC
The default compression codec for this table's columns.
IDictionary< string, string > options
Optional parameters.
const string SERIES
Use series partitioning.
const string IS_AUTOMATIC_PARTITION
If TRUE, a new partition will be created for values which don't fall into an existing partition.
IDictionary< string, string > info
Additional information.
CreateUnionRequest(string table_name, IList< string > table_names, IList< IList< string >> input_column_names, IList< string > output_column_names, IDictionary< string, string > options=null)
Constructs a CreateUnionRequest object with the specified parameters.
const string NO_COUNT
Return a count of 0 for the union table response to avoid the cost of counting; optimization needed f...
const string UNION_ALL
Retains all rows from the specified tables.
const string TTL
Sets the TTL of the output table specified in table_name.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of table_name and use Kin...
const string VIEW_ID
ID of view of which this output table is a member.
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 PARTITION_TYPE
Partitioning scheme to use for the output table.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string UNION
Retains all unique rows from the specified tables (synonym for UNION_DISTINCT).
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
A set of string constants for the parameter options.
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
const string CHUNK_COLUMN_MAX_MEMORY
Indicates the target maximum data size for each column in a chunk to be used for this output table.
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
const string COUNT
Number of records in the final table.
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
const string HASH
Use hash partitioning.
const string INTERVAL
Use interval partitioning.
A set of results returned by Kinetica.createUnion.