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 
72  public const string OPTIMIZE_LOOKUPS = "optimize_lookups";
73 
77  public const string STRATEGY_DEFINITION = "strategy_definition";
78 
82  public const string TTL = "ttl";
83 
86  public const string VIEW_ID = "view_id";
87 
94  public const string NO_COUNT = "no_count";
95 
100  public const string CHUNK_SIZE = "chunk_size";
101 
105  public const string ENABLE_VIRTUAL_CHUNKING = "enable_virtual_chunking";
106 
111  public const string MAX_VIRTUAL_CHUNK_SIZE = "max_virtual_chunk_size";
112 
117  public const string MIN_VIRTUAL_CHUNK_SIZE = "min_virtual_chunk_size";
118 
122  public const string ENABLE_SPARSE_VIRTUAL_CHUNKING = "enable_sparse_virtual_chunking";
123 
129  public const string ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_equi_join_lazy_result_store";
130 
136  public const string ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_predicate_equi_join_lazy_result_store";
137 
140  public const string ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join";
141  } // end struct Options
142 
149  public string join_table_name { get; set; }
150 
157  public IList<string> table_names { get; set; } = new List<string>();
158 
169  public IList<string> column_names { get; set; } = new List<string>();
170 
177  public IList<string> expressions { get; set; } = new List<string>();
178 
336  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
337 
341 
529  IList<string> table_names,
530  IList<string> column_names,
531  IList<string> expressions = null,
532  IDictionary<string, string> options = null)
533  {
534  this.join_table_name = join_table_name ?? "";
535  this.table_names = table_names ?? new List<string>();
536  this.column_names = column_names ?? new List<string>();
537  this.expressions = expressions ?? new List<string>();
538  this.options = options ?? new Dictionary<string, string>();
539  } // end constructor
540  } // end class CreateJoinTableRequest
541 
545  public class CreateJoinTableResponse : KineticaData
546  {
550  public struct Info
551  {
554  public const string QUALIFIED_JOIN_TABLE_NAME = "qualified_join_table_name";
555  } // end struct Info
556 
560  public string join_table_name { get; set; }
561 
564  public long count { get; set; }
565 
577  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
578  } // end class CreateJoinTableResponse
579 } // 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 OPTIMIZE_LOOKUPS
Use more memory to speed up the joining of tables.
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.