Kinetica C# API  Version 6.1.0.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 
10 
11 namespace kinetica
12 {
13 
22  {
23 
147  public struct Options
148  {
149 
154  public const string COLLECTION_NAME = "collection_name";
155 
159  public const string MAX_QUERY_DIMENSIONS = "max_query_dimensions";
160 
175  public const string OPTIMIZE_LOOKUPS = "optimize_lookups";
176  public const string TRUE = "true";
177  public const string FALSE = "false";
178 
212  public const string REFRESH_METHOD = "refresh_method";
213 
217  public const string MANUAL = "manual";
218 
224  public const string ON_QUERY = "on_query";
225 
231  public const string ON_INSERT = "on_insert";
232 
237  public const string REFRESH = "refresh";
238 
240  public const string NO_REFRESH = "no_refresh";
241 
246  public const string FULL_REFRESH = "full_refresh";
247 
251  public const string TTL = "ttl";
252 
256  public const string NO_COUNT = "no_count";
257  } // end struct Options
258 
259 
263  public string join_table_name { get; set; }
264 
267  public IList<string> table_names { get; set; } = new List<string>();
268 
278  public IList<string> column_names { get; set; } = new List<string>();
279 
284  public IList<string> expressions { get; set; } = new List<string>();
285 
407  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
408 
409 
413 
560  IList<string> table_names = null,
561  IList<string> column_names = null,
562  IList<string> expressions = null,
563  IDictionary<string, string> options = null)
564  {
565  this.join_table_name = join_table_name ?? "";
566  this.table_names = table_names ?? new List<string>();
567  this.column_names = column_names ?? new List<string>();
568  this.expressions = expressions ?? new List<string>();
569  this.options = options ?? new Dictionary<string, string>();
570  } // end constructor
571 
572  } // end class CreateJoinTableRequest
573 
574 
575 
580  {
581 
584  public string join_table_name { get; set; }
585 
588  public long count { get; set; }
589 
590  } // end class CreateJoinTableResponse
591 
592 
593 
594 
595 } // end namespace kinetica
const string ON_QUERY
incrementally refresh (refresh just those records added) whenever a new query is issued and new data ...
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>).
CreateJoinTableRequest(string join_table_name, IList< string > table_names=null, IList< string > column_names=null, IList< string > expressions=null, IDictionary< string, string > options=null)
Constructs a CreateJoinTableRequest object with the specified parameters.
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
A set of parameters for Kinetica.createJoinTable(string,IList<string>,IList<string>,IList<string>,IDictionary<string, string>).
const string FULL_REFRESH
always refresh even if no new records have been added.