Kinetica C# API  Version 6.2.0.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 
10 
11 namespace kinetica
12 {
13 
25  {
26 
177  public struct Options
178  {
179 
184  public const string COLLECTION_NAME = "collection_name";
185 
189  public const string MAX_QUERY_DIMENSIONS = "max_query_dimensions";
190 
205  public const string OPTIMIZE_LOOKUPS = "optimize_lookups";
206  public const string TRUE = "true";
207  public const string FALSE = "false";
208 
246  public const string REFRESH_METHOD = "refresh_method";
247 
251  public const string MANUAL = "manual";
252 
261  public const string ON_QUERY = "on_query";
262 
270  public const string ON_INSERT = "on_insert";
271 
276  public const string REFRESH = "refresh";
277 
279  public const string NO_REFRESH = "no_refresh";
280 
285  public const string FULL_REFRESH = "full_refresh";
286 
291  public const string TTL = "ttl";
292 
295  public const string VIEW_ID = "view_id";
296 
300  public const string NO_COUNT = "no_count";
301 
304  public const string CHUNK_SIZE = "chunk_size";
305 
311  public const string ALLOW_RIGHT_PRIMARY_KEY_JOIN = "allow_right_primary_key_join";
312  } // end struct Options
313 
314 
318  public string join_table_name { get; set; }
319 
322  public IList<string> table_names { get; set; } = new List<string>();
323 
333  public IList<string> column_names { get; set; } = new List<string>();
334 
340  public IList<string> expressions { get; set; } = new List<string>();
341 
490  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
491 
492 
496 
671  IList<string> table_names,
672  IList<string> column_names,
673  IList<string> expressions = null,
674  IDictionary<string, string> options = null)
675  {
676  this.join_table_name = join_table_name ?? "";
677  this.table_names = table_names ?? new List<string>();
678  this.column_names = column_names ?? new List<string>();
679  this.expressions = expressions ?? new List<string>();
680  this.options = options ?? new Dictionary<string, string>();
681  } // end constructor
682 
683  } // end class CreateJoinTableRequest
684 
685 
686 
691  {
692 
695  public string join_table_name { get; set; }
696 
699  public long count { get; set; }
700 
701  } // end class CreateJoinTableResponse
702 
703 
704 
705 
706 } // end namespace kinetica
const string VIEW_ID
view this projection is part of.
const string ON_QUERY
incrementally refresh (refresh just those records added) whenever a new query is issued and new data ...
const string ALLOW_RIGHT_PRIMARY_KEY_JOIN
When true allows right joins from a key to a primary key to be done as primary key joins...
IList< string > table_names
The list of table names composing the join.
string join_table_name
Name of the join table to be created.
const string NO_REFRESH
don&#39;t refresh
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 REFRESH
incrementally refresh (refresh just those records added) if new data has been inserted into the base ...
const string MAX_QUERY_DIMENSIONS
The maximum number of tables in a join that can be accessed by a query and are not equated by a forei...
CreateJoinTableRequest()
Constructs a CreateJoinTableRequest object with default parameters.
const string ON_INSERT
incrementally refresh (refresh just those records added) whenever new data is inserted into a base ta...
IDictionary< string, string > options
Optional parameters.
const string COLLECTION_NAME
Name of a collection which is to contain the join.
const string MANUAL
refresh only occurs when manually requested by calling this endpoint with refresh option set to refre...
A set of results returned by Kinetica.createJoinTable(string,IList<string>,IList<string>,IList<string>,IDictionary<string, string>).
const string REFRESH_METHOD
Method by which the join can be refreshed when the data in underlying member tables have changed...
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 show_table.
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.
A set of parameters for Kinetica.createJoinTable(string,IList<string>,IList<string>,IList<string>,IDictionary<string, string>).
const string CHUNK_SIZE
Maximum size of a joined-chunk for this table.
const string FULL_REFRESH
always refresh even if no new records have been added.