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 {
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 
109  public const string ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join";
110  } // end struct Options
111 
118  public string join_table_name { get; set; }
119 
126  public IList<string> table_names { get; set; } = new List<string>();
127 
138  public IList<string> column_names { get; set; } = new List<string>();
139 
146  public IList<string> expressions { get; set; } = new List<string>();
147 
262  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
263 
267 
412  IList<string> table_names,
413  IList<string> column_names,
414  IList<string> expressions = null,
415  IDictionary<string, string> options = null)
416  {
417  this.join_table_name = join_table_name ?? "";
418  this.table_names = table_names ?? new List<string>();
419  this.column_names = column_names ?? new List<string>();
420  this.expressions = expressions ?? new List<string>();
421  this.options = options ?? new Dictionary<string, string>();
422  } // end constructor
423  } // end class CreateJoinTableRequest
424 
429  {
433  public struct Info
434  {
437  public const string QUALIFIED_JOIN_TABLE_NAME = "qualified_join_table_name";
438  } // end struct Info
439 
443  public string join_table_name { get; set; }
444 
447  public long count { get; set; }
448 
460  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
461  } // end class CreateJoinTableResponse
462 } // end namespace kinetica
const string VIEW_ID
view this projection is part of.
IList< string > table_names
The list of table names composing the join, each in [schema_name.
const string ENABLE_PK_EQUI_JOIN
Use equi-join to do primary key joins rather than using primary-key-index
string join_table_name
Name of the join table to be created, in [schema_name.
const string OPTIMIZE_LOOKUPS
Use more memory to speed up the joining of tables.
const string TTL
Sets the TTL of the join table specified in join_table_name.
IList< string > expressions
An optional list of expressions to combine and filter the joined tables.
const string MAX_QUERY_DIMENSIONS
No longer used.
CreateJoinTableRequest()
Constructs a CreateJoinTableRequest object with default parameters.
const string QUALIFIED_JOIN_TABLE_NAME
The fully qualified name of the join table (i.e.
string join_table_name
Value of join_table_name.
IDictionary< string, string > options
Optional parameters.
IDictionary< string, string > info
Additional information.
A set of string constants for the parameter options.
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 ...
A set of results returned by Kinetica.createJoinTable.
A set of string constants for the parameter info.
IList< string > column_names
List of member table columns or column expressions to be included in the join.
const string NO_COUNT
Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed fo...
long count
The number of records in the join table filtered by the given select expression.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
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 STRATEGY_DEFINITION
The tier strategy for the table and its columns.
A set of parameters for Kinetica.createJoinTable.
const string CHUNK_SIZE
Maximum number of records per joined-chunk for this table.
const string ENABLE_VIRTUAL_CHUNKING
Collect chunks with accumulated size less than chunk_size into a single chunk.