Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
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 
10 
11 namespace kinetica
12 {
13 
25  {
26 
125  public struct Options
126  {
127 
146  public const string CREATE_TEMP_TABLE = "create_temp_table";
147  public const string TRUE = "true";
148  public const string FALSE = "false";
149 
156  public const string COLLECTION_NAME = "collection_name";
157 
159  public const string MAX_QUERY_DIMENSIONS = "max_query_dimensions";
160 
175  public const string OPTIMIZE_LOOKUPS = "optimize_lookups";
176 
180  public const string STRATEGY_DEFINITION = "strategy_definition";
181 
185  public const string TTL = "ttl";
186 
189  public const string VIEW_ID = "view_id";
190 
196  public const string NO_COUNT = "no_count";
197 
200  public const string CHUNK_SIZE = "chunk_size";
201  } // end struct Options
202 
203 
210  public string join_table_name { get; set; }
211 
217  public IList<string> table_names { get; set; } = new List<string>();
218 
228  public IList<string> column_names { get; set; } = new List<string>();
229 
235  public IList<string> expressions { get; set; } = new List<string>();
236 
333  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
334 
335 
339 
467  IList<string> table_names,
468  IList<string> column_names,
469  IList<string> expressions = null,
470  IDictionary<string, string> options = null)
471  {
472  this.join_table_name = join_table_name ?? "";
473  this.table_names = table_names ?? new List<string>();
474  this.column_names = column_names ?? new List<string>();
475  this.expressions = expressions ?? new List<string>();
476  this.options = options ?? new Dictionary<string, string>();
477  } // end constructor
478 
479  } // end class CreateJoinTableRequest
480 
481 
482 
487  {
488 
501  public struct Info
502  {
503 
506  public const string QUALIFIED_JOIN_TABLE_NAME = "qualified_join_table_name";
507  } // end struct Info
508 
509 
512  public string join_table_name { get; set; }
513 
516  public long count { get; set; }
517 
528  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
529 
530  } // end class CreateJoinTableResponse
531 
532 
533 
534 
535 } // 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.
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.
IDictionary< string, string > options
Optional parameters.
IDictionary< string, string > info
Additional information.
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(string,IList{string},IList{string},IList{string},IDictionary{string, string}).
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(string,IDictionary{string, string}); optimization needed for large overlapped equi-join stencils.
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(string,IList{string},IList{string},IList{string},IDictionary{string, string}).
const string CHUNK_SIZE
Maximum number of records per joined-chunk for this table.