7 using System.Collections.Generic;
40 public class CreateUnionRequest : KineticaData
63 public const string TRUE =
"true";
64 public const string FALSE =
"false";
132 public const string MODE =
"mode";
135 public const string UNION_ALL =
"union_all";
140 public const string UNION =
"union";
149 public const string EXCEPT =
"except";
154 public const string EXCEPT_ALL =
"except_all";
158 public const string INTERSECT =
"intersect";
168 public const string LONG_HASH =
"long_hash";
172 public const string CHUNK_SIZE =
"chunk_size";
191 public const string TTL =
"ttl";
208 public const string PERSIST =
"persist";
213 public const string VIEW_ID =
"view_id";
246 public const string NO_COUNT =
"no_count";
263 public IList<string>
table_names {
get;
set; } =
new List<string>();
267 public IList<IList<string>>
input_column_names {
get;
set; } =
new List<IList<string>>();
487 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
730 IDictionary<string, string>
options =
null)
733 this.table_names =
table_names ??
new List<string>();
743 public class CreateUnionResponse : KineticaData
751 public const string COUNT =
"count";
778 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
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.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string EXCEPT
Retains all unique rows from the first table that do not appear in the second table (only works on 2 ...
const string INTERSECT_ALL
Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 t...
const string UNION
Retains all unique rows from the specified tables (synonym for UNION_DISTINCT).
const string INTERSECT
Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of table_name and use Kin...
const string EXCEPT_ALL
Retains all rows(including duplicates) from the first table that do not appear in the second table (o...
const string COUNT
Number of records in the final table
const string COMPRESSION_CODEC
The default compression codec for this table's columns.
string table_name
Name of the table to be created, in [schema_name.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the output table.
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 ...
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this output table.
const string QUALIFIED_TABLE_NAME
The fully qualified name of the result table (i.e.
const string LONG_HASH
When true use 128 bit hash for union-distinct, except, except_all, intersect and intersect_all modes.
const string NO_COUNT
Return a count of 0 for the union table response to avoid the cost of counting; optimization needed f...
IDictionary< string, string > info
Additional information.
const string VIEW_ID
ID of view of which this output table is a member.
const string UNION_ALL
Retains all rows from the specified tables.
IList< string > output_column_names
The list of names of the columns to be stored in the output table.
const string FORCE_REPLICATED
If TRUE, then the output table specified in table_name will be replicated even if the source tables a...
IList< string > table_names
The list of table names to merge, in [schema_name.
IList< IList< string > > input_column_names
The list of columns from each of the corresponding input tables.
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.
CreateUnionRequest()
Constructs a CreateUnionRequest object with default parameters.
const string UNION_DISTINCT
Retains all unique rows from the specified tables.
const string MODE
The mode describes what rows of the tables being unioned will be retained.
const string TTL
Sets the TTL of the output table specified in table_name.
IDictionary< string, string > options
Optional parameters.
const string PERSIST
If TRUE, then the output table specified in table_name will be persisted and will not expire unless a...
string table_name
Value of table_name.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this output table.