Kinetica C# API  Version 7.0.19.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 
29  {
30 
138  public struct Options
139  {
140 
145  public const string COLLECTION_NAME = "collection_name";
146 
162  public const string FILTER_MODE = "filter_mode";
163  public const string IN_TABLE = "in_table";
164  public const string NOT_IN_TABLE = "not_in_table";
165 
181  public const string MODE = "mode";
182  public const string NORMAL = "normal";
183  public const string SPATIAL = "spatial";
184 
187  public const string BUFFER = "buffer";
188 
206  public const string BUFFER_METHOD = "buffer_method";
207 
209  public const string GEOS = "geos";
210 
213  public const string MAX_PARTITION_SIZE = "max_partition_size";
214 
218  public const string MAX_PARTITION_SCORE = "max_partition_score";
219 
223  public const string X_COLUMN_NAME = "x_column_name";
224 
228  public const string Y_COLUMN_NAME = "y_column_name";
229  } // end struct Options
230 
231 
234  public string table_name { get; set; }
235 
240  public string view_name { get; set; } = "";
241 
245  public string column_name { get; set; }
246 
250  public string source_table_name { get; set; }
251 
259  public string source_table_column_name { get; set; }
260 
366  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
367 
368 
371  public FilterByTableRequest() { }
372 
503  string view_name,
504  string column_name,
505  string source_table_name,
507  IDictionary<string, string> options = null)
508  {
509  this.table_name = table_name ?? "";
510  this.view_name = view_name ?? "";
511  this.column_name = column_name ?? "";
512  this.source_table_name = source_table_name ?? "";
513  this.source_table_column_name = source_table_column_name ?? "";
514  this.options = options ?? new Dictionary<string, string>();
515  } // end constructor
516 
517  } // end class FilterByTableRequest
518 
519 
520 
525  {
526 
533  public long count { get; set; }
534 
536  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
537 
538  } // end class FilterByTableResponse
539 
540 
541 
542 
543 } // end namespace kinetica
IDictionary< string, string > options
Optional parameters.
FilterByTableRequest()
Constructs a FilterByTableRequest object with default parameters.
const string COLLECTION_NAME
Name of a collection which is to contain the newly created view.
string source_table_name
Name of the table whose data will be compared against in the table called .
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.
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}).
string table_name
Name of the table whose data will be filtered.
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 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}).