Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
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 
10 
11 namespace kinetica
12 {
13 
49  {
50 
238  public struct Options
239  {
240 
260  public const string CREATE_TEMP_TABLE = "create_temp_table";
261  public const string TRUE = "true";
262  public const string FALSE = "false";
263 
272  public const string COLLECTION_NAME = "collection_name";
273 
341  public const string MODE = "mode";
342 
344  public const string UNION_ALL = "union_all";
345 
348  public const string UNION = "union";
349 
352  public const string UNION_DISTINCT = "union_distinct";
353 
357  public const string EXCEPT = "except";
358 
362  public const string EXCEPT_ALL = "except_all";
363 
366  public const string INTERSECT = "intersect";
367 
371  public const string INTERSECT_ALL = "intersect_all";
372 
382  public const string MERGE_VIEWS = "merge_views";
383 
386  public const string CHUNK_SIZE = "chunk_size";
387 
391  public const string CREATE_INDEXES = "create_indexes";
392 
396  public const string TTL = "ttl";
397 
416  public const string PERSIST = "persist";
417 
420  public const string VIEW_ID = "view_id";
421 
438  public const string FORCE_REPLICATED = "force_replicated";
439 
443  public const string STRATEGY_DEFINITION = "strategy_definition";
444  } // end struct Options
445 
446 
453  public string table_name { get; set; }
454 
460  public IList<string> table_names { get; set; } = new List<string>();
461 
464  public IList<IList<string>> input_column_names { get; set; } = new List<IList<string>>();
465 
468  public IList<string> output_column_names { get; set; } = new List<string>();
469 
655  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
656 
657 
660  public CreateUnionRequest() { }
661 
867  IList<string> table_names,
868  IList<IList<string>> input_column_names,
869  IList<string> output_column_names,
870  IDictionary<string, string> options = null)
871  {
872  this.table_name = table_name ?? "";
873  this.table_names = table_names ?? new List<string>();
874  this.input_column_names = input_column_names ?? new List<IList<string>>();
875  this.output_column_names = output_column_names ?? new List<string>();
876  this.options = options ?? new Dictionary<string, string>();
877  } // end constructor
878 
879  } // end class CreateUnionRequest
880 
881 
882 
887  {
888 
907  public struct Info
908  {
909 
911  public const string COUNT = "count";
912 
915  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
916  } // end struct Info
917 
918 
921  public string table_name { get; set; }
922 
939  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
940 
941  } // end class CreateUnionResponse
942 
943 
944 
945 
946 } // end namespace kinetica
const string TTL
Sets the TTL of the output table specified in table_name.
Definition: CreateUnion.cs:396
A set of results returned by Kinetica.createUnion(string,IList{string},IList{IList{string}},IList{string},IDictionary{string, string}).
Definition: CreateUnion.cs:886
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:357
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:382
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:866
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables)...
Definition: CreateUnion.cs:366
const string MODE
If merge_views, then this operation will merge the provided views.
Definition: CreateUnion.cs:341
Additional information.
Definition: CreateUnion.cs:907
const string UNION
Retains all unique rows from the specified tables (synonym for union_distinct).
Definition: CreateUnion.cs:348
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
Definition: CreateUnion.cs:391
A set of parameters for Kinetica.createUnion(string,IList{string},IList{IList{string}},IList{string},IDictionary{string, string}).
Definition: CreateUnion.cs:48
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
Definition: CreateUnion.cs:352
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:416
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:438
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
Definition: CreateUnion.cs:443
IDictionary< string, string > info
Additional information.
Definition: CreateUnion.cs:939
const string COUNT
Number of records in the final table
Definition: CreateUnion.cs:911
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
Definition: CreateUnion.cs:386
string table_name
Value of .
Definition: CreateUnion.cs:921
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:260
const string VIEW_ID
ID of view of which this output table is a member.
Definition: CreateUnion.cs:420
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
Definition: CreateUnion.cs:915
IList< string > table_names
The list of table names to merge, in [schema_name.
Definition: CreateUnion.cs:460
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
Definition: CreateUnion.cs:468
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:371
IDictionary< string, string > options
Optional parameters.
Definition: CreateUnion.cs:655
const string UNION_ALL
Retains all rows from the specified tables.
Definition: CreateUnion.cs:344
string table_name
Name of the table to be created, in [schema_name.
Definition: CreateUnion.cs:453
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:362
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
Definition: CreateUnion.cs:660
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
Definition: CreateUnion.cs:464
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:272