Skip to main content

A set of string constants for the parameter FilterByTableRequest.options. More…

​
Static Public Attributes

const string CREATE_TEMP_TABLE = “create_temp_table”
 If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of FilterByTableRequest.view_name.
 
const string TRUE = “true”
 A boolean constant for the FilterByTableRequest.Options options.
 
const string FALSE = “false”
 A boolean constant for the FilterByTableRequest.Options options.
 
const string COLLECTION_NAME = “collection_name”
 [DEPRECATED–please specify the containing schema for the view as part of FilterByTableRequest.view_name and use Kinetica.createSchema to create the schema if non-existent] Name of a schema for the newly created view.
 
const string FILTER_MODE = “filter_mode”
 String indicating the filter mode, either IN_TABLE or NOT_IN_TABLE.
 
const string IN_TABLE = “in_table”
 A constant for the FilterByTableRequest.Options options.
 
const string NOT_IN_TABLE = “not_in_table”
 A constant for the FilterByTableRequest.Options options.
 
const string MODE = “mode”
 Mode - should be either SPATIAL or NORMAL.
 
const string NORMAL = “normal”
 A constant for the FilterByTableRequest.Options options.
 
const string SPATIAL = “spatial”
 A constant for the FilterByTableRequest.Options options.
 
const string BUFFER = “buffer”
 Buffer size, in meters.
 
const string BUFFER_METHOD = “buffer_method”
 Method used to buffer polygons.
 
const string GEOS = “geos”
 Use geos 1 edge per corner algorithm.
 
const string MAX_PARTITION_SIZE = “max_partition_size”
 Maximum number of points in a partition.
 
const string MAX_PARTITION_SCORE = “max_partition_score”
 Maximum number of points * edges in a partition.
 
const string X_COLUMN_NAME = “x_column_name”
 Name of column containing x value of point being filtered in SPATIAL mode.
 
const string Y_COLUMN_NAME = “y_column_name”
 Name of column containing y value of point being filtered in SPATIAL mode.
 

​
Detailed Description

A set of string constants for the parameter FilterByTableRequest.options.

Optional parameters.

Definition at line 29 of file FilterByTable.cs.

​
Member Data Documentation

​
◆ BUFFER

const string kinetica.FilterByTableRequest.Options.BUFFER = “buffer”
 static

Buffer size, in meters.

Only relevant for SPATIAL mode. The default value is ‘0’.

Definition at line 138 of file FilterByTable.cs.

​
◆ BUFFER_METHOD

const string kinetica.FilterByTableRequest.Options.BUFFER_METHOD = “buffer_method”
 static

Method used to buffer polygons.

Only relevant for SPATIAL mode. Supported values:

  • NORMAL
  • GEOS: Use geos 1 edge per corner algorithm.

The default value is NORMAL.

Definition at line 160 of file FilterByTable.cs.

​
◆ COLLECTION_NAME

const string kinetica.FilterByTableRequest.Options.COLLECTION_NAME = “collection_name”
 static

[DEPRECATED–please specify the containing schema for the view as part of FilterByTableRequest.view_name and use Kinetica.createSchema to create the schema if non-existent] Name of a schema for the newly created view.

If the schema is non-existent, it will be automatically created.

Definition at line 73 of file FilterByTable.cs.

​
◆ CREATE_TEMP_TABLE

const string kinetica.FilterByTableRequest.Options.CREATE_TEMP_TABLE = “create_temp_table”
 static

If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of FilterByTableRequest.view_name.

This is always allowed even if the caller does not have permission to create tables. The generated name is returned in QUALIFIED_VIEW_NAME. Supported values:

The default value is FALSE.

Definition at line 55 of file FilterByTable.cs.

​
◆ FALSE

const string kinetica.FilterByTableRequest.Options.FALSE = “false”
 static

A boolean constant for the FilterByTableRequest.Options options.

Definition at line 63 of file FilterByTable.cs.

​
◆ FILTER_MODE

const string kinetica.FilterByTableRequest.Options.FILTER_MODE = “filter_mode”
 static

String indicating the filter mode, either IN_TABLE or NOT_IN_TABLE.

Supported values:

The default value is IN_TABLE.

Definition at line 95 of file FilterByTable.cs.

​
◆ GEOS

const string kinetica.FilterByTableRequest.Options.GEOS = “geos”
 static

Use geos 1 edge per corner algorithm.

Definition at line 163 of file FilterByTable.cs.

​
◆ IN_TABLE

const string kinetica.FilterByTableRequest.Options.IN_TABLE = “in_table”
 static

A constant for the FilterByTableRequest.Options options.

Definition at line 99 of file FilterByTable.cs.

​
◆ MAX_PARTITION_SCORE

const string kinetica.FilterByTableRequest.Options.MAX_PARTITION_SCORE = “max_partition_score”
 static

Maximum number of points * edges in a partition.

Only relevant for SPATIAL mode. The default value is ‘8000000’.

Definition at line 175 of file FilterByTable.cs.

​
◆ MAX_PARTITION_SIZE

const string kinetica.FilterByTableRequest.Options.MAX_PARTITION_SIZE = “max_partition_size”
 static

Maximum number of points in a partition.

Only relevant for SPATIAL mode. The default value is ‘0’.

Definition at line 169 of file FilterByTable.cs.

​
◆ MODE

const string kinetica.FilterByTableRequest.Options.MODE = “mode”
 static

Mode - should be either SPATIAL or NORMAL.

Supported values:

The default value is NORMAL.

Definition at line 124 of file FilterByTable.cs.

​
◆ NORMAL

const string kinetica.FilterByTableRequest.Options.NORMAL = “normal”
 static

A constant for the FilterByTableRequest.Options options.

Definition at line 128 of file FilterByTable.cs.

​
◆ NOT_IN_TABLE

const string kinetica.FilterByTableRequest.Options.NOT_IN_TABLE = “not_in_table”
 static

A constant for the FilterByTableRequest.Options options.

Definition at line 103 of file FilterByTable.cs.

​
◆ SPATIAL

const string kinetica.FilterByTableRequest.Options.SPATIAL = “spatial”
 static

A constant for the FilterByTableRequest.Options options.

Definition at line 132 of file FilterByTable.cs.

​
◆ TRUE

const string kinetica.FilterByTableRequest.Options.TRUE = “true”
 static

A boolean constant for the FilterByTableRequest.Options options.

Definition at line 59 of file FilterByTable.cs.

​
◆ X_COLUMN_NAME

const string kinetica.FilterByTableRequest.Options.X_COLUMN_NAME = “x_column_name”
 static

Name of column containing x value of point being filtered in SPATIAL mode.

The default value is ‘x’.

Definition at line 181 of file FilterByTable.cs.

​
◆ Y_COLUMN_NAME

const string kinetica.FilterByTableRequest.Options.Y_COLUMN_NAME = “y_column_name”
 static

Name of column containing y value of point being filtered in SPATIAL mode.

The default value is ‘y’.

Definition at line 187 of file FilterByTable.cs.

The documentation for this struct was generated from the following files: