Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
FilterByTable.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 
34  {
35 
168  public struct Options
169  {
170 
189  public const string CREATE_TEMP_TABLE = "create_temp_table";
190  public const string TRUE = "true";
191  public const string FALSE = "false";
192 
199  public const string COLLECTION_NAME = "collection_name";
200 
216  public const string FILTER_MODE = "filter_mode";
217  public const string IN_TABLE = "in_table";
218  public const string NOT_IN_TABLE = "not_in_table";
219 
235  public const string MODE = "mode";
236  public const string NORMAL = "normal";
237  public const string SPATIAL = "spatial";
238 
241  public const string BUFFER = "buffer";
242 
260  public const string BUFFER_METHOD = "buffer_method";
261 
263  public const string GEOS = "geos";
264 
267  public const string MAX_PARTITION_SIZE = "max_partition_size";
268 
272  public const string MAX_PARTITION_SCORE = "max_partition_score";
273 
277  public const string X_COLUMN_NAME = "x_column_name";
278 
282  public const string Y_COLUMN_NAME = "y_column_name";
283  } // end struct Options
284 
285 
291  public string table_name { get; set; }
292 
300  public string view_name { get; set; } = "";
301 
305  public string column_name { get; set; }
306 
313  public string source_table_name { get; set; }
314 
322  public string source_table_column_name { get; set; }
323 
454  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
455 
456 
459  public FilterByTableRequest() { }
460 
626  string view_name,
627  string column_name,
628  string source_table_name,
630  IDictionary<string, string> options = null)
631  {
632  this.table_name = table_name ?? "";
633  this.view_name = view_name ?? "";
634  this.column_name = column_name ?? "";
635  this.source_table_name = source_table_name ?? "";
636  this.source_table_column_name = source_table_column_name ?? "";
637  this.options = options ?? new Dictionary<string, string>();
638  } // end constructor
639 
640  } // end class FilterByTableRequest
641 
642 
643 
648  {
649 
662  public struct Info
663  {
664 
667  public const string QUALIFIED_VIEW_NAME = "qualified_view_name";
668  } // end struct Info
669 
670 
677  public long count { get; set; }
678 
689  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
690 
691  } // end class FilterByTableResponse
692 
693 
694 
695 
696 } // end namespace kinetica
IDictionary< string, string > options
Optional parameters.
FilterByTableRequest()
Constructs a FilterByTableRequest object with default parameters.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the view as part of view_name and use Kinetica...
string source_table_name
Name of the table whose data will be compared against in the table called , in [schema_name.
long count
The number of records in that have values matching values in .
const string BUFFER
Buffer size, in meters.
string source_table_column_name
Name of the column in the whose values will be used as the filter for table .
const string FILTER_MODE
String indicating the filter mode, either in_table or not_in_table.
const string MAX_PARTITION_SIZE
Maximum number of points in a partition.
string view_name
If provided, then this will be the name of the view containing the results, in [schema_name.
const string MODE
Mode - should be either spatial or normal.
const string X_COLUMN_NAME
Name of column containing x value of point being filtered in spatial mode.
A set of results returned by Kinetica.filterByTable(string,string,string,string,string,IDictionary{string, string}).
const string QUALIFIED_VIEW_NAME
The fully qualified name of the view (i.e.
string table_name
Name of the table whose data will be filtered, in [schema_name.
FilterByTableRequest(string table_name, string view_name, string column_name, string source_table_name, string source_table_column_name, IDictionary< string, string > options=null)
Constructs a FilterByTableRequest object with the specified parameters.
string column_name
Name of the column by whose value the data will be filtered from the table designated by ...
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 GEOS
Use geos 1 edge per corner algorithm
const string Y_COLUMN_NAME
Name of column containing y value of point being filtered in spatial mode.
IDictionary< string, string > info
Additional information.
const string MAX_PARTITION_SCORE
Maximum number of points * edges in a partition.
const string BUFFER_METHOD
Method used to buffer polygons.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
A set of parameters for Kinetica.filterByTable(string,string,string,string,string,IDictionary{string, string}).