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 {
40  public class CreateUnionRequest : KineticaData
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 
132  public const string MODE = "mode";
133 
135  public const string UNION_ALL = "union_all";
136 
140  public const string UNION = "union";
141 
144  public const string UNION_DISTINCT = "union_distinct";
145 
149  public const string EXCEPT = "except";
150 
154  public const string EXCEPT_ALL = "except_all";
155 
158  public const string INTERSECT = "intersect";
159 
163  public const string INTERSECT_ALL = "intersect_all";
164 
168  public const string LONG_HASH = "long_hash";
169 
172  public const string CHUNK_SIZE = "chunk_size";
173 
176  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
177 
180  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
181 
186  public const string CREATE_INDEXES = "create_indexes";
187 
191  public const string TTL = "ttl";
192 
208  public const string PERSIST = "persist";
209 
213  public const string VIEW_ID = "view_id";
214 
229  public const string FORCE_REPLICATED = "force_replicated";
230 
234  public const string STRATEGY_DEFINITION = "strategy_definition";
235 
240  public const string COMPRESSION_CODEC = "compression_codec";
241 
246  public const string NO_COUNT = "no_count";
247  } // end struct Options
248 
255  public string table_name { get; set; }
256 
263  public IList<string> table_names { get; set; } = new List<string>();
264 
267  public IList<IList<string>> input_column_names { get; set; } = new List<IList<string>>();
268 
271  public IList<string> output_column_names { get; set; } = new List<string>();
272 
487  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
488 
491  public CreateUnionRequest() { }
492 
727  IList<string> table_names,
728  IList<IList<string>> input_column_names,
729  IList<string> output_column_names,
730  IDictionary<string, string> options = null)
731  {
732  this.table_name = table_name ?? "";
733  this.table_names = table_names ?? new List<string>();
734  this.input_column_names = input_column_names ?? new List<IList<string>>();
735  this.output_column_names = output_column_names ?? new List<string>();
736  this.options = options ?? new Dictionary<string, string>();
737  } // end constructor
738  } // end class CreateUnionRequest
739 
743  public class CreateUnionResponse : KineticaData
744  {
748  public struct Info
749  {
751  public const string COUNT = "count";
752 
755  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
756  } // end struct Info
757 
760  public string table_name { get; set; }
761 
778  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
779  } // end class CreateUnionResponse
780 } // 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:726
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 LONG_HASH
When true use 128 bit hash for union-distinct, except, except_all, intersect and intersect_all modes.
Definition: CreateUnion.cs:168
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:491
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