Kinetica   C#   API  Version 7.2.3.0
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 namespace kinetica
10 {
25  {
29  public struct Options
30  {
45  public const string CREATE_TEMP_TABLE = "create_temp_table";
46 
47  public const string TRUE = "true";
48  public const string FALSE = "false";
49 
57  public const string COLLECTION_NAME = "collection_name";
58 
75  public const string FILTER_MODE = "filter_mode";
76 
77  public const string IN_TABLE = "in_table";
78  public const string NOT_IN_TABLE = "not_in_table";
79 
94  public const string MODE = "mode";
95 
96  public const string NORMAL = "normal";
97  public const string SPATIAL = "spatial";
98 
103  public const string BUFFER = "buffer";
104 
119  public const string BUFFER_METHOD = "buffer_method";
120 
122  public const string GEOS = "geos";
123 
128  public const string MAX_PARTITION_SIZE = "max_partition_size";
129 
135  public const string MAX_PARTITION_SCORE = "max_partition_score";
136 
141  public const string X_COLUMN_NAME = "x_column_name";
142 
147  public const string Y_COLUMN_NAME = "y_column_name";
148  } // end struct Options
149 
155  public string table_name { get; set; }
156 
165  public string view_name { get; set; } = "";
166 
170  public string column_name { get; set; }
171 
178  public string source_table_name { get; set; }
179 
186  public string source_table_column_name { get; set; }
187 
324  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
325 
328  public FilterByTableRequest() { }
329 
497  string view_name,
498  string column_name,
499  string source_table_name,
501  IDictionary<string, string> options = null)
502  {
503  this.table_name = table_name ?? "";
504  this.view_name = view_name ?? "";
505  this.column_name = column_name ?? "";
506  this.source_table_name = source_table_name ?? "";
507  this.source_table_column_name = source_table_column_name ?? "";
508  this.options = options ?? new Dictionary<string, string>();
509  } // end constructor
510  } // end class FilterByTableRequest
511 
516  {
520  public struct Info
521  {
524  public const string QUALIFIED_VIEW_NAME = "qualified_view_name";
525  } // end struct Info
526 
535  public long count { get; set; }
536 
548  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
549  } // end class FilterByTableResponse
550 } // 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 table_name,...
long count
The number of records in table_name that have column_name values matching source_table_column_name va...
const string BUFFER
Buffer size, in meters.
string source_table_column_name
Name of the column in the source_table_name whose values will be used as the filter for table table_n...
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.
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 table_name.
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 string constants for the parameter info.
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.
A set of string constants for the parameter options.
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.