GPUdb C++ API  Version 7.0.19.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Pages
gpudb::InsertRecordsFromFilesRequest Struct Reference

A set of input parameters for const. More...

#include <gpudb/protocol/insert_records_from_files.h>

Public Member Functions

 InsertRecordsFromFilesRequest ()
 Constructs an InsertRecordsFromFilesRequest object with default parameter values. More...
 
 InsertRecordsFromFilesRequest (const std::string &tableName_, const std::vector< std::string > &filepaths_, const std::map< std::string, std::string > &createTableOptions_, const std::map< std::string, std::string > &options_)
 Constructs an InsertRecordsFromFilesRequest object with the specified parameters. More...
 

Public Attributes

std::string tableName
 
std::vector< std::string > filepaths
 
std::map< std::string,
std::string > 
createTableOptions
 
std::map< std::string,
std::string > 
options
 

Detailed Description

A set of input parameters for const.

Reads from one or more files located on the server and inserts the data into a new or existing table.

For CSV files, there are two loading schemes: positional and name-based. The name-based loading scheme is enabled when the file has a header present and text_has_header is set to true. In this scheme, the source file(s) field names must match the target table's column names exactly; however, the source file can have more fields than the target table has columns. If error_handling is set to permissive, the source file can have fewer fields than the target table has columns. If the name-based loading scheme is being used, names matching the file header's names may be provided to columns_to_load instead of numbers, but ranges are not supported.

Returns once all files are processed.

Definition at line 32 of file insert_records_from_files.h.

Constructor & Destructor Documentation

gpudb::InsertRecordsFromFilesRequest::InsertRecordsFromFilesRequest ( )
inline

Constructs an InsertRecordsFromFilesRequest object with default parameter values.

Definition at line 39 of file insert_records_from_files.h.

gpudb::InsertRecordsFromFilesRequest::InsertRecordsFromFilesRequest ( const std::string &  tableName_,
const std::vector< std::string > &  filepaths_,
const std::map< std::string, std::string > &  createTableOptions_,
const std::map< std::string, std::string > &  options_ 
)
inline

Constructs an InsertRecordsFromFilesRequest object with the specified parameters.

Parameters
[in]tableName_Name of the table into which the data will be inserted. If the table does not exist, the table will be created using either an existing type_id or the type inferred from the file.
[in]filepaths_Absolute or relative filepath(s) from where files will be loaded. Relative filepaths are relative to the defined external_files_directory parameter in the server configuration. The filepaths may include wildcards (*). If the first path ends in .tsv, the text delimiter will be defaulted to a tab character. If the first path ends in .psv, the text delimiter will be defaulted to a pipe character (|).
[in]createTableOptions_Options used when creating a new table.
[in]options_Optional parameters.

Definition at line 480 of file insert_records_from_files.h.

Member Data Documentation

std::map<std::string, std::string> gpudb::InsertRecordsFromFilesRequest::createTableOptions

Definition at line 490 of file insert_records_from_files.h.

std::vector<std::string> gpudb::InsertRecordsFromFilesRequest::filepaths

Definition at line 489 of file insert_records_from_files.h.

std::map<std::string, std::string> gpudb::InsertRecordsFromFilesRequest::options

Definition at line 491 of file insert_records_from_files.h.

std::string gpudb::InsertRecordsFromFilesRequest::tableName

Definition at line 488 of file insert_records_from_files.h.


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