Kinetica   C#   API  Version 7.2.3.1
CreateJoinTable.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 
20 {
24  public struct Options
25  {
40  public const string CREATE_TEMP_TABLE = "create_temp_table";
41 
42  public const string TRUE = "true";
43  public const string FALSE = "false";
44 
52  public const string COLLECTION_NAME = "collection_name";
53 
55  public const string MAX_QUERY_DIMENSIONS = "max_query_dimensions";
56 
60  public const string STRATEGY_DEFINITION = "strategy_definition";
61 
65  public const string TTL = "ttl";
66 
69  public const string VIEW_ID = "view_id";
70 
77  public const string NO_COUNT = "no_count";
78 
83  public const string CHUNK_SIZE = "chunk_size";
84 
88  public const string ENABLE_VIRTUAL_CHUNKING = "enable_virtual_chunking";
89 
93  public const string MAX_VIRTUAL_CHUNK_SIZE = "max_virtual_chunk_size";
94 
98  public const string MIN_VIRTUAL_CHUNK_SIZE = "min_virtual_chunk_size";
99 
103  public const string ENABLE_SPARSE_VIRTUAL_CHUNKING = "enable_sparse_virtual_chunking";
104 
110  public const string ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_equi_join_lazy_result_store";
111 
117  public const string ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_predicate_equi_join_lazy_result_store";
118 
121  public const string ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join";
122  } // end struct Options
123 
130  public string join_table_name { get; set; }
131 
138  public IList<string> table_names { get; set; } = new List<string>();
139 
150  public IList<string> column_names { get; set; } = new List<string>();
151 
158  public IList<string> expressions { get; set; } = new List<string>();
159 
292  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
293 
297 
459  IList<string> table_names,
460  IList<string> column_names,
461  IList<string> expressions = null,
462  IDictionary<string, string> options = null)
463  {
464  this.join_table_name = join_table_name ?? "";
465  this.table_names = table_names ?? new List<string>();
466  this.column_names = column_names ?? new List<string>();
467  this.expressions = expressions ?? new List<string>();
468  this.options = options ?? new Dictionary<string, string>();
469  } // end constructor
470 } // end class CreateJoinTableRequest
471 
476 {
480  public struct Info
481  {
484  public const string QUALIFIED_JOIN_TABLE_NAME = "qualified_join_table_name";
485  } // end struct Info
486 
490  public string join_table_name { get; set; }
491 
494  public long count { get; set; }
495 
507  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
508 } // end class CreateJoinTableResponse
IDictionary< string, string > options
Optional parameters.
const string ENABLE_EQUI_JOIN_LAZY_RESULT_STORE
Allow using the lazy result store to cache computation of one side of a multichunk equi-join.
long count
The number of records in the join table filtered by the given select expression.
A set of results returned by Kinetica.createJoinTable.
A set of parameters for Kinetica.createJoinTable.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
A set of string constants for the parameter info.
CreateJoinTableRequest()
Constructs a CreateJoinTableRequest object with default parameters.
const string MAX_VIRTUAL_CHUNK_SIZE
Maximum number of records per virtual-chunk.
const string ENABLE_VIRTUAL_CHUNKING
Collect chunks with accumulated size less than chunk_size into a single chunk.
const string TTL
Sets the TTL of the join table specified in join_table_name.
string join_table_name
Value of join_table_name.
const string MAX_QUERY_DIMENSIONS
No longer used.
IList< string > expressions
An optional list of expressions to combine and filter the joined tables.
A set of string constants for the parameter options.
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
Maximum number of records per joined-chunk for this table.
const string QUALIFIED_JOIN_TABLE_NAME
The fully qualified name of the join table (i.e.
const string ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE
Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-joi...
IList< string > table_names
The list of table names composing the join, each in [schema_name.
const string MIN_VIRTUAL_CHUNK_SIZE
Minimum number of records per virtual-chunk.
CreateJoinTableRequest(string join_table_name, IList< string > table_names, IList< string > column_names, IList< string > expressions=null, IDictionary< string, string > options=null)
Constructs a CreateJoinTableRequest object with the specified parameters.
IList< string > column_names
List of member table columns or column expressions to be included in the join.
IDictionary< string, string > info
Additional information.
const string ENABLE_PK_EQUI_JOIN
Use equi-join to do primary key joins rather than using primary key index.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the join as part of join_table_name and use Kine...
const string NO_COUNT
Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed fo...
string join_table_name
Name of the join table to be created, in [schema_name.
const string ENABLE_SPARSE_VIRTUAL_CHUNKING
Materialize virtual chunks with only non-deleted values.
const string VIEW_ID
View this projection is part of.