Kinetica   C#   API  Version 7.2.3.1
CreateUnion.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 using System.Collections.Generic;
8 
9 namespace kinetica;
10 
32 {
36  public struct Options
37  {
52  public const string CREATE_TEMP_TABLE = "create_temp_table";
53 
54  public const string TRUE = "true";
55  public const string FALSE = "false";
56 
64  public const string COLLECTION_NAME = "collection_name";
65 
117  public const string MODE = "mode";
118 
120  public const string UNION_ALL = "union_all";
121 
125  public const string UNION = "union";
126 
129  public const string UNION_DISTINCT = "union_distinct";
130 
133  public const string EXCEPT = "except";
134 
138  public const string EXCEPT_ALL = "except_all";
139 
142  public const string INTERSECT = "intersect";
143 
146  public const string INTERSECT_ALL = "intersect_all";
147 
150  public const string CHUNK_SIZE = "chunk_size";
151 
154  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
155 
158  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
159 
164  public const string CREATE_INDEXES = "create_indexes";
165 
202  public const string PARTITION_TYPE = "partition_type";
203 
207  public const string RANGE = "RANGE";
208 
212  public const string INTERVAL = "INTERVAL";
213 
217  public const string LIST = "LIST";
218 
222  public const string HASH = "HASH";
223 
227  public const string SERIES = "SERIES";
228 
234  public const string PARTITION_KEYS = "partition_keys";
235 
251  public const string PARTITION_DEFINITIONS = "partition_definitions";
252 
267  public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";
268 
272  public const string TTL = "ttl";
273 
289  public const string PERSIST = "persist";
290 
294  public const string VIEW_ID = "view_id";
295 
310  public const string FORCE_REPLICATED = "force_replicated";
311 
315  public const string STRATEGY_DEFINITION = "strategy_definition";
316 
321  public const string COMPRESSION_CODEC = "compression_codec";
322 
327  public const string NO_COUNT = "no_count";
328  } // end struct Options
329 
336  public string table_name { get; set; }
337 
344  public IList<string> table_names { get; set; } = new List<string>();
345 
348  public IList<IList<string>> input_column_names { get; set; } = new List<IList<string>>();
349 
352  public IList<string> output_column_names { get; set; } = new List<string>();
353 
643  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
644 
647  public CreateUnionRequest() { }
648 
958  IList<string> table_names,
959  IList<IList<string>> input_column_names,
960  IList<string> output_column_names,
961  IDictionary<string, string> options = null)
962  {
963  this.table_name = table_name ?? "";
964  this.table_names = table_names ?? new List<string>();
965  this.input_column_names = input_column_names ?? new List<IList<string>>();
966  this.output_column_names = output_column_names ?? new List<string>();
967  this.options = options ?? new Dictionary<string, string>();
968  } // end constructor
969 } // end class CreateUnionRequest
970 
975 {
979  public struct Info
980  {
982  public const string COUNT = "count";
983 
986  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
987  } // end struct Info
988 
991  public string table_name { get; set; }
992 
1009  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1010 } // end class CreateUnionResponse
const string MODE
The mode describes what rows of the tables being unioned will be retained.
Definition: CreateUnion.cs:117
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
Definition: CreateUnion.cs:164
const string RANGE
Use range partitioning.
Definition: CreateUnion.cs:207
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
Definition: CreateUnion.cs:129
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
Definition: CreateUnion.cs:234
IList< string > table_names
The list of table names to merge, in [schema_name.
Definition: CreateUnion.cs:344
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this output table.
Definition: CreateUnion.cs:158
const string EXCEPT_ALL
Retains all rows(including duplicates) from the first table that do not appear in the second table (o...
Definition: CreateUnion.cs:138
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string INTERSECT_ALL
Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 t...
Definition: CreateUnion.cs:146
string table_name
Value of table_name.
Definition: CreateUnion.cs:991
const string LIST
Use list partitioning.
Definition: CreateUnion.cs:217
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
Definition: CreateUnion.cs:150
A set of parameters for Kinetica.createUnion.
Definition: CreateUnion.cs:31
const string PERSIST
If TRUE, then the output table specified in table_name will be persisted and will not expire unless a...
Definition: CreateUnion.cs:289
const string FORCE_REPLICATED
If TRUE, then the output table specified in table_name will be replicated even if the source tables a...
Definition: CreateUnion.cs:310
const string EXCEPT
Retains all unique rows from the first table that do not appear in the second table (only works on 2 ...
Definition: CreateUnion.cs:133
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
Definition: CreateUnion.cs:142
A set of string constants for the parameter info.
Definition: CreateUnion.cs:979
string table_name
Name of the table to be created, in [schema_name.
Definition: CreateUnion.cs:336
const string COMPRESSION_CODEC
The default compression codec for this table's columns.
Definition: CreateUnion.cs:321
IDictionary< string, string > options
Optional parameters.
Definition: CreateUnion.cs:643
const string SERIES
Use series partitioning.
Definition: CreateUnion.cs:227
const string IS_AUTOMATIC_PARTITION
If TRUE, a new partition will be created for values which don't fall into an existing partition.
Definition: CreateUnion.cs:267
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.
Definition: CreateUnion.cs:957
const string NO_COUNT
Return a count of 0 for the union table response to avoid the cost of counting; optimization needed f...
Definition: CreateUnion.cs:327
const string UNION_ALL
Retains all rows from the specified tables.
Definition: CreateUnion.cs:120
const string TTL
Sets the TTL of the output table specified in table_name.
Definition: CreateUnion.cs:272
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
Definition: CreateUnion.cs:251
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of table_name and use Kin...
Definition: CreateUnion.cs:64
const string VIEW_ID
ID of view of which this output table is a member.
Definition: CreateUnion.cs:294
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 ...
Definition: CreateUnion.cs:52
const string PARTITION_TYPE
Partitioning scheme to use for the output table.
Definition: CreateUnion.cs:202
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
Definition: CreateUnion.cs:315
const string UNION
Retains all unique rows from the specified tables (synonym for UNION_DISTINCT).
Definition: CreateUnion.cs:125
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
Definition: CreateUnion.cs:986
A set of string constants for the parameter options.
Definition: CreateUnion.cs:36
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
Definition: CreateUnion.cs:348
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.
Definition: CreateUnion.cs:154
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
Definition: CreateUnion.cs:647
const string COUNT
Number of records in the final table.
Definition: CreateUnion.cs:982
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
Definition: CreateUnion.cs:352
const string HASH
Use hash partitioning.
Definition: CreateUnion.cs:222
const string INTERVAL
Use interval partitioning.
Definition: CreateUnion.cs:212
A set of results returned by Kinetica.createUnion.
Definition: CreateUnion.cs:974