com.gpudb.protocol

Class ExportRecordsToTableRequest.Options

java.lang.Object

com.gpudb.protocol.ExportRecordsToTableRequest.Options

Enclosing class:

ExportRecordsToTableRequest

public static final class ExportRecordsToTableRequest.Options
extends Object

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 tableName 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:
  • TRUE
  • FALSE
  The default value is FALSE.
• USE_INDEXED_PARAMETERS: Uses $n style syntax when generating insert query for remote_table option Supported values:
  • TRUE
  • FALSE
  The default value is TRUE.

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

Field Summary

Fields

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

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

BATCH_SIZE

public static final String BATCH_SIZE

Batch size, which determines how many rows to export per round trip. The default value is '200000'.

See Also:

Constant Field Values

DATASINK_NAME

public static final String DATASINK_NAME

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

See Also:

Constant Field Values

JDBC_SESSION_INIT_STATEMENT

public static final String JDBC_SESSION_INIT_STATEMENT

Executes the statement per each jdbc session before doing actual load. The default value is ''.

See Also:

Constant Field Values

JDBC_CONNECTION_INIT_STATEMENT

public static final String JDBC_CONNECTION_INIT_STATEMENT

Executes the statement once before doing actual load. The default value is ''.

See Also:

Constant Field Values

REMOTE_TABLE

public static final String 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 ''.

See Also:

Constant Field Values

USE_ST_GEOMFROM_CASTS

public static final String USE_ST_GEOMFROM_CASTS

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

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

TRUE

public static final String TRUE

See Also:

Constant Field Values

FALSE

public static final String FALSE

See Also:

Constant Field Values

USE_INDEXED_PARAMETERS

public static final String USE_INDEXED_PARAMETERS

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

• TRUE
• FALSE

The default value is TRUE.

See Also:

Constant Field Values