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 {
41  {
45  public struct Options
46  {
61  public const string CREATE_TEMP_TABLE = "create_temp_table";
62 
63  public const string TRUE = "true";
64  public const string FALSE = "false";
65 
75  public const string COLLECTION_NAME = "collection_name";
76 
146  public const string MODE = "mode";
147 
149  public const string UNION_ALL = "union_all";
150 
154  public const string UNION = "union";
155 
158  public const string UNION_DISTINCT = "union_distinct";
159 
163  public const string EXCEPT = "except";
164 
168  public const string EXCEPT_ALL = "except_all";
169 
172  public const string INTERSECT = "intersect";
173 
177  public const string INTERSECT_ALL = "intersect_all";
178 
189  public const string MERGE_VIEWS = "merge_views";
190 
193  public const string CHUNK_SIZE = "chunk_size";
194 
197  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
198 
201  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
202 
207  public const string CREATE_INDEXES = "create_indexes";
208 
212  public const string TTL = "ttl";
213 
229  public const string PERSIST = "persist";
230 
234  public const string VIEW_ID = "view_id";
235 
250  public const string FORCE_REPLICATED = "force_replicated";
251 
255  public const string STRATEGY_DEFINITION = "strategy_definition";
256  } // end struct Options
257 
264  public string table_name { get; set; }
265 
272  public IList<string> table_names { get; set; } = new List<string>();
273 
276  public IList<IList<string>> input_column_names { get; set; } = new List<IList<string>>();
277 
280  public IList<string> output_column_names { get; set; } = new List<string>();
281 
493  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
494 
497  public CreateUnionRequest() { }
498 
730  IList<string> table_names,
731  IList<IList<string>> input_column_names,
732  IList<string> output_column_names,
733  IDictionary<string, string> options = null)
734  {
735  this.table_name = table_name ?? "";
736  this.table_names = table_names ?? new List<string>();
737  this.input_column_names = input_column_names ?? new List<IList<string>>();
738  this.output_column_names = output_column_names ?? new List<string>();
739  this.options = options ?? new Dictionary<string, string>();
740  } // end constructor
741  } // end class CreateUnionRequest
742 
747  {
751  public struct Info
752  {
754  public const string COUNT = "count";
755 
758  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
759  } // end struct Info
760 
763  public string table_name { get; set; }
764 
781  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
782  } // end class CreateUnionResponse
783 } // end namespace kinetica
const string TTL
Sets the TTL of the output table specified in table_name.
Definition: CreateUnion.cs:212
A set of results returned by Kinetica.createUnion.
Definition: CreateUnion.cs:746
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:163
const string MERGE_VIEWS
Merge two or more views (or views of views) of the same base data set into a new view.
Definition: CreateUnion.cs:189
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:729
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
Definition: CreateUnion.cs:172
const string MODE
If MERGE_VIEWS, then this operation will merge the provided views.
Definition: CreateUnion.cs:146
A set of string constants for the parameter info.
Definition: CreateUnion.cs:751
const string UNION
Retains all unique rows from the specified tables (synonym for UNION_DISTINCT).
Definition: CreateUnion.cs:154
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
Definition: CreateUnion.cs:207
A set of parameters for Kinetica.createUnion.
Definition: CreateUnion.cs:40
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
Definition: CreateUnion.cs:158
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:229
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:201
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:250
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
Definition: CreateUnion.cs:255
IDictionary< string, string > info
Additional information.
Definition: CreateUnion.cs:781
const string COUNT
Number of records in the final table
Definition: CreateUnion.cs:754
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
Definition: CreateUnion.cs:193
string table_name
Value of table_name.
Definition: CreateUnion.cs:763
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 VIEW_ID
ID of view of which this output table is a member.
Definition: CreateUnion.cs:234
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
Definition: CreateUnion.cs:758
IList< string > table_names
The list of table names to merge, in [schema_name.
Definition: CreateUnion.cs:272
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
Definition: CreateUnion.cs:280
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:177
IDictionary< string, string > options
Optional parameters.
Definition: CreateUnion.cs:493
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:197
A set of string constants for the parameter options.
Definition: CreateUnion.cs:45
const string UNION_ALL
Retains all rows from the specified tables.
Definition: CreateUnion.cs:149
string table_name
Name of the table to be created, in [schema_name.
Definition: CreateUnion.cs:264
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:168
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
Definition: CreateUnion.cs:497
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
Definition: CreateUnion.cs:276
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
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