Kinetica   C#   API  Version 7.2.3.0
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  public class CreateJoinTableRequest : KineticaData
21  {
25  public struct Options
26  {
41  public const string CREATE_TEMP_TABLE = "create_temp_table";
42 
43  public const string TRUE = "true";
44  public const string FALSE = "false";
45 
54  public const string COLLECTION_NAME = "collection_name";
55 
57  public const string MAX_QUERY_DIMENSIONS = "max_query_dimensions";
58 
62  public const string STRATEGY_DEFINITION = "strategy_definition";
63 
67  public const string TTL = "ttl";
68 
71  public const string VIEW_ID = "view_id";
72 
79  public const string NO_COUNT = "no_count";
80 
85  public const string CHUNK_SIZE = "chunk_size";
86 
90  public const string ENABLE_VIRTUAL_CHUNKING = "enable_virtual_chunking";
91 
96  public const string MAX_VIRTUAL_CHUNK_SIZE = "max_virtual_chunk_size";
97 
102  public const string MIN_VIRTUAL_CHUNK_SIZE = "min_virtual_chunk_size";
103 
107  public const string ENABLE_SPARSE_VIRTUAL_CHUNKING = "enable_sparse_virtual_chunking";
108 
114  public const string ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_equi_join_lazy_result_store";
115 
121  public const string ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_predicate_equi_join_lazy_result_store";
122 
125  public const string ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join";
126  } // end struct Options
127 
134  public string join_table_name { get; set; }
135 
142  public IList<string> table_names { get; set; } = new List<string>();
143 
154  public IList<string> column_names { get; set; } = new List<string>();
155 
162  public IList<string> expressions { get; set; } = new List<string>();
163 
303  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
304 
308 
478  IList<string> table_names,
479  IList<string> column_names,
480  IList<string> expressions = null,
481  IDictionary<string, string> options = null)
482  {
483  this.join_table_name = join_table_name ?? "";
484  this.table_names = table_names ?? new List<string>();
485  this.column_names = column_names ?? new List<string>();
486  this.expressions = expressions ?? new List<string>();
487  this.options = options ?? new Dictionary<string, string>();
488  } // end constructor
489  } // end class CreateJoinTableRequest
490 
494  public class CreateJoinTableResponse : KineticaData
495  {
499  public struct Info
500  {
503  public const string QUALIFIED_JOIN_TABLE_NAME = "qualified_join_table_name";
504  } // end struct Info
505 
509  public string join_table_name { get; set; }
510 
513  public long count { get; set; }
514 
526  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
527  } // end class CreateJoinTableResponse
528 } // end namespace kinetica
const string MAX_QUERY_DIMENSIONS
No longer used.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
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.
const string MAX_VIRTUAL_CHUNK_SIZE
Maximum number of records per virtual-chunk.
const string MIN_VIRTUAL_CHUNK_SIZE
Minimum number of records per virtual-chunk.
IList< string > expressions
An optional list of expressions to combine and filter the joined tables.
CreateJoinTableRequest()
Constructs a CreateJoinTableRequest object with default parameters.
long count
The number of records in the join table filtered by the given select expression.
const string TTL
Sets the TTL of the join table specified in join_table_name.
IList< string > table_names
The list of table names composing the join, each in [schema_name.
const string NO_COUNT
Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed fo...
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 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 ENABLE_VIRTUAL_CHUNKING
Collect chunks with accumulated size less than chunk_size into a single chunk.
IDictionary< string, string > options
Optional parameters.
string join_table_name
Value of join_table_name.
const string CHUNK_SIZE
Maximum number of records per joined-chunk for this table.
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...
const string ENABLE_SPARSE_VIRTUAL_CHUNKING
materialize virtual chunks with only non-deleted values.
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.
const string VIEW_ID
view this projection is part of.
string join_table_name
Name of the join table to be created, in [schema_name.
const string QUALIFIED_JOIN_TABLE_NAME
The fully qualified name of the join table (i.e.