Skip to main content

  • ​
    exportRecordsToTable

    public ExportRecordsToTableResponse exportRecordsToTable(ExportRecordsToTableRequest request) throws GPUdbException
    Exports records from source table to the specified target table in an external database.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    exportRecordsToTable

    public ExportRecordsToTableResponse exportRecordsToTable(String tableName, String remoteQuery, Map<String,String> options) throws GPUdbException
    Exports records from source table to the specified target table in an external database.
    Parameters:
    tableName - Name of the table from which the data will be exported to remote database, in [schema_name.]table_name format, using standard name resolution rules.
    remoteQuery - Parameterized insert query to export gpudb table data into remote database. The default value is ”.
    options - 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 parameterized 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 FALSE.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.