Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
kinetica.ExportRecordsToTableRequest.Options Struct Reference

Optional parameters. More...

Public Attributes

const string BATCH_SIZE = "batch_size"
 Batch size, which determines how many rows to export per round trip. More...
 
const string DATASINK_NAME = "datasink_name"
 Name of an existing external data sink to which table name specified in table_name will be exported More...
 
const string JDBC_SESSION_INIT_STATEMENT = "jdbc_session_init_statement"
 Executes the statement per each jdbc session before doing actual load. More...
 
const string JDBC_CONNECTION_INIT_STATEMENT = "jdbc_connection_init_statement"
 Executes the statement once before doing actual load. More...
 
const string REMOTE_TABLE = "remote_table"
 Name of the target table to which source table is exported. More...
 
const string USE_ST_GEOMFROM_CASTS = "use_st_geomfrom_casts"
 Wraps parametrized variables with st_geomfromtext or st_geomfromwkb based on source column type Supported values:

The default value is FALSE. More...

 
const string TRUE = "true"
 
const string FALSE = "false"
 
const string USE_INDEXED_PARAMETERS = "use_indexed_parameters"
 Uses $n style syntax when generating insert query for remote_table option Supported values:

The default value is TRUE. More...

 

Detailed Description

Optional parameters.

  • BATCH_SIZE: Batch size, which determines how many rows to export per round trip. The default value is '200000'.
  • DATASINK_NAME: Name of an existing external data sink to which table name specified in will be exported
  • JDBC_SESSION_INIT_STATEMENT: Executes the statement per each jdbc session before doing actual load. The default value is ''.
  • JDBC_CONNECTION_INIT_STATEMENT: Executes the statement once before doing actual load. The default value is ''.
  • REMOTE_TABLE: Name of the target table to which source table is exported. When this option is specified remote_query cannot be specified. The default value is ''.
  • USE_ST_GEOMFROM_CASTS: Wraps parametrized variables with st_geomfromtext or st_geomfromwkb based on source column type Supported values: The default value is FALSE.
  • USE_INDEXED_PARAMETERS: Uses $n style syntax when generating insert query for remote_table option Supported values: The default value is TRUE.

The default value is an empty Dictionary. A set of string constants for the parameter options.

Definition at line 101 of file ExportRecordsToTable.cs.

Member Data Documentation

const string kinetica.ExportRecordsToTableRequest.Options.BATCH_SIZE = "batch_size"

Batch size, which determines how many rows to export per round trip.

The default value is '200000'.

Definition at line 106 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.DATASINK_NAME = "datasink_name"

Name of an existing external data sink to which table name specified in table_name will be exported

Definition at line 111 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.FALSE = "false"

Definition at line 143 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.JDBC_CONNECTION_INIT_STATEMENT = "jdbc_connection_init_statement"

Executes the statement once before doing actual load.

The default value is ''.

Definition at line 119 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.JDBC_SESSION_INIT_STATEMENT = "jdbc_session_init_statement"

Executes the statement per each jdbc session before doing actual load.

The default value is ''.

Definition at line 115 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.REMOTE_TABLE = "remote_table"

Name of the target table to which source table is exported.

When this option is specified remote_query cannot be specified. The default value is ''.

Definition at line 124 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.TRUE = "true"

Definition at line 142 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.USE_INDEXED_PARAMETERS = "use_indexed_parameters"

Uses $n style syntax when generating insert query for remote_table option Supported values:

The default value is TRUE.

Definition at line 160 of file ExportRecordsToTable.cs.

const string kinetica.ExportRecordsToTableRequest.Options.USE_ST_GEOMFROM_CASTS = "use_st_geomfrom_casts"

Wraps parametrized variables with st_geomfromtext or st_geomfromwkb based on source column type Supported values:

The default value is FALSE.

Definition at line 141 of file ExportRecordsToTable.cs.


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