exportRecordsToTable - Kinetica Docs

◆ exportRecordsToTable() [1/4]

ExportRecordsToTableResponse gpudb::GPUdb::exportRecordsToTable ( const ExportRecordsToTableRequest & request_ ) const

Exports records from source table to the specified target table in an external database.

Parameters

[in] request_ Request object containing the parameters for the operation.

Returns

Response object containing the result of the operation.

◆ exportRecordsToTable() [2/4]

ExportRecordsToTableResponse & gpudb::GPUdb::exportRecordsToTable	(	const ExportRecordsToTableRequest &	request_,
		ExportRecordsToTableResponse &	response_ ) const

Exports records from source table to the specified target table in an external database.

Parameters

[in]	request_	Request object containing the parameters for the operation.
[out]	response_	Response object containing the results of the operation.

Returns

Response object containing the result of the operation (initially passed in by reference).

◆ exportRecordsToTable() [3/4]

ExportRecordsToTableResponse gpudb::GPUdb::exportRecordsToTable	(	const std::string &	tableName,
		const std::string &	remoteQuery,
		const std::map< std::string, std::string > &	options ) const

Exports records from source table to the specified target table in an external database.

Parameters

[in]	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.
[in]	remoteQuery	Parameterized insert query to export gpudb table data into remote database. The default value is ”.
[in]	options	Optional parameters. export_records_to_table_batch_size: Batch size, which determines how many rows to export per round trip. The default value is ‘200000’. export_records_to_table_datasink_name: Name of an existing external data sink to which table name specified in tableName will be exported. export_records_to_table_jdbc_session_init_statement: Executes the statement per each JDBC session before doing actual load. The default value is ”. export_records_to_table_jdbc_connection_init_statement: Executes the statement once before doing actual load. The default value is ”. export_records_to_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 ”. export_records_to_table_use_st_geomfrom_casts: Wraps parameterized variables with st_geomfromtext or st_geomfromwkb based on source column type. Supported values: export_records_to_table_true export_records_to_table_false The default value is export_records_to_table_false. export_records_to_table_use_indexed_parameters: Uses $n style syntax when generating insert query for remote_table option. Supported values: export_records_to_table_true export_records_to_table_false The default value is export_records_to_table_false. The default value is an empty map.

Returns

Response object containing the result of the operation.

◆ exportRecordsToTable() [4/4]

ExportRecordsToTableResponse & gpudb::GPUdb::exportRecordsToTable	(	const std::string &	tableName,
		const std::string &	remoteQuery,
		const std::map< std::string, std::string > &	options,
		ExportRecordsToTableResponse &	response_ ) const

Exports records from source table to the specified target table in an external database.

Parameters

[in]	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.
[in]	remoteQuery	Parameterized insert query to export gpudb table data into remote database. The default value is ”.
[in]	options	Optional parameters. export_records_to_table_batch_size: Batch size, which determines how many rows to export per round trip. The default value is ‘200000’. export_records_to_table_datasink_name: Name of an existing external data sink to which table name specified in tableName will be exported. export_records_to_table_jdbc_session_init_statement: Executes the statement per each JDBC session before doing actual load. The default value is ”. export_records_to_table_jdbc_connection_init_statement: Executes the statement once before doing actual load. The default value is ”. export_records_to_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 ”. export_records_to_table_use_st_geomfrom_casts: Wraps parameterized variables with st_geomfromtext or st_geomfromwkb based on source column type. Supported values: export_records_to_table_true export_records_to_table_false The default value is export_records_to_table_false. export_records_to_table_use_indexed_parameters: Uses $n style syntax when generating insert query for remote_table option. Supported values: export_records_to_table_true export_records_to_table_false The default value is export_records_to_table_false. The default value is an empty map.
[out]	response_	Response object containing the results of the operation.

Returns

Response object containing the result of the operation (initially passed in by reference).

​◆ exportRecordsToTable() [1/4]

​◆ exportRecordsToTable() [2/4]

​◆ exportRecordsToTable() [3/4]

​◆ exportRecordsToTable() [4/4]

◆ exportRecordsToTable() [1/4]

◆ exportRecordsToTable() [2/4]

◆ exportRecordsToTable() [3/4]

◆ exportRecordsToTable() [4/4]