insert_records_from_query - Kinetica Docs

insert_records_from_query

insert_records_from_query(
table_name: string,
remote_query: string,
modify_columns?: Record<string, Record<string, string>>,
create_table_options?: Record<string, string>,
options?: Record<string, string>,
callback?: GPUdbCallback,
): Promise<InsertRecordsFromQueryResponse>
Computes remote query result and inserts the result data into a new or existing table.
Parameters
- table_name: string
  Name of the table into which the data will be inserted, in [schema_name.]table_name format, using standard name resolution rules. If the table does not exist, the table will be created using either an existing type_id or the type inferred from the remote query, and the new table name will have to meet standard table naming criteria.
- remote_query: string
  Query for which result data needs to be imported.
- Optionalmodify_columns: Record<string, Record<string, string>>
  Not implemented yet.
- Optionalcreate_table_options: Record<string, string>
  Options used when creating the target table.
- Optionaloptions: Record<string, string>
  Optional parameters.
- Optionalcallback: GPUdbCallback
  Optional callback function
Returns Promise<InsertRecordsFromQueryResponse>
Promise<Types.InsertRecordsFromQueryResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:11614

insert_records_from_query_request

insert_records_from_query_request(
request: InsertRecordsFromQueryRequest,
callback?: GPUdbCallback,
): Promise<InsertRecordsFromQueryResponse>
Computes remote query result and inserts the result data into a new or existing table.
Parameters
- request: InsertRecordsFromQueryRequest
  Request object containing the parameters for the operation
- Optionalcallback: GPUdbCallback
  Optional callback function
Returns Promise<InsertRecordsFromQueryResponse>
Promise<Types.InsertRecordsFromQueryResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:11579