Kinetica   C#   API  Version 7.2.3.0
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  public class CreateUnionRequest : KineticaData
33  {
37  public struct Options
38  {
53  public const string CREATE_TEMP_TABLE = "create_temp_table";
54 
55  public const string TRUE = "true";
56  public const string FALSE = "false";
57 
67  public const string COLLECTION_NAME = "collection_name";
68 
124  public const string MODE = "mode";
125 
127  public const string UNION_ALL = "union_all";
128 
132  public const string UNION = "union";
133 
136  public const string UNION_DISTINCT = "union_distinct";
137 
141  public const string EXCEPT = "except";
142 
146  public const string EXCEPT_ALL = "except_all";
147 
150  public const string INTERSECT = "intersect";
151 
155  public const string INTERSECT_ALL = "intersect_all";
156 
159  public const string CHUNK_SIZE = "chunk_size";
160 
163  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
164 
167  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
168 
173  public const string CREATE_INDEXES = "create_indexes";
174 
178  public const string TTL = "ttl";
179 
195  public const string PERSIST = "persist";
196 
200  public const string VIEW_ID = "view_id";
201 
216  public const string FORCE_REPLICATED = "force_replicated";
217 
221  public const string STRATEGY_DEFINITION = "strategy_definition";
222 
227  public const string COMPRESSION_CODEC = "compression_codec";
228 
233  public const string NO_COUNT = "no_count";
234  } // end struct Options
235 
242  public string table_name { get; set; }
243 
250  public IList<string> table_names { get; set; } = new List<string>();
251 
254  public IList<IList<string>> input_column_names { get; set; } = new List<IList<string>>();
255 
258  public IList<string> output_column_names { get; set; } = new List<string>();
259 
468  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
469 
472  public CreateUnionRequest() { }
473 
702  IList<string> table_names,
703  IList<IList<string>> input_column_names,
704  IList<string> output_column_names,
705  IDictionary<string, string> options = null)
706  {
707  this.table_name = table_name ?? "";
708  this.table_names = table_names ?? new List<string>();
709  this.input_column_names = input_column_names ?? new List<IList<string>>();
710  this.output_column_names = output_column_names ?? new List<string>();
711  this.options = options ?? new Dictionary<string, string>();
712  } // end constructor
713  } // end class CreateUnionRequest
714 
718  public class CreateUnionResponse : KineticaData
719  {
723  public struct Info
724  {
726  public const string COUNT = "count";
727 
730  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
731  } // end struct Info
732 
735  public string table_name { get; set; }
736 
753  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
754  } // end class CreateUnionResponse
755 } // end namespace kinetica
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:701
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
Definition: CreateUnion.cs:234
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:149
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:163
const string UNION
Retains all unique rows from the specified tables (synonym for UNION_DISTINCT).
Definition: CreateUnion.cs:140
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
Definition: CreateUnion.cs:158
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of table_name and use Kin...
Definition: CreateUnion.cs:75
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:154
const string COUNT
Number of records in the final table
Definition: CreateUnion.cs:751
const string COMPRESSION_CODEC
The default compression codec for this table's columns.
Definition: CreateUnion.cs:240
string table_name
Name of the table to be created, in [schema_name.
Definition: CreateUnion.cs:255
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
Definition: CreateUnion.cs:186
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:61
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
Definition: CreateUnion.cs:172
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
Definition: CreateUnion.cs:755
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:246
IDictionary< string, string > info
Additional information.
Definition: CreateUnion.cs:778
const string VIEW_ID
ID of view of which this output table is a member.
Definition: CreateUnion.cs:213
const string UNION_ALL
Retains all rows from the specified tables.
Definition: CreateUnion.cs:135
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
Definition: CreateUnion.cs:271
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:229
IList< string > table_names
The list of table names to merge, in [schema_name.
Definition: CreateUnion.cs:263
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
Definition: CreateUnion.cs:267
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:176
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
Definition: CreateUnion.cs:472
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
Definition: CreateUnion.cs:144
const string MODE
The mode describes what rows of the tables being unioned will be retained.
Definition: CreateUnion.cs:132
const string TTL
Sets the TTL of the output table specified in table_name.
Definition: CreateUnion.cs:191
IDictionary< string, string > options
Optional parameters.
Definition: CreateUnion.cs:487
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:208
string table_name
Value of table_name.
Definition: CreateUnion.cs:760
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:180