Skip to content

MergeInsertIntoTableRequest

Request for merging or inserting records into a table, excluding the Arrow IPC stream.

Properties

Name Type Description Notes
identity Identity [optional]
context Map<String, String> Arbitrary context for a request as key-value pairs. How to use the context is custom to the specific implementation. REST NAMESPACE ONLY Context entries are passed via HTTP headers using the naming convention `x-lance-ctx-<key>: <value>`. For example, a context entry `{\"trace_id\": \"abc123\"}` would be sent as the header `x-lance-ctx-trace_id: abc123`. [optional]
id List<String> [optional]
on String Column name to use for matching rows (required) [optional]
whenMatchedUpdateAll Boolean Update all columns when rows match [optional]
whenMatchedUpdateAllFilt String The row is updated (similar to UpdateAll) only for rows where the SQL expression evaluates to true [optional]
whenNotMatchedInsertAll Boolean Insert all columns when rows don't match [optional]
whenNotMatchedBySourceDelete Boolean Delete all rows from target table that don't match a row in the source table [optional]
whenNotMatchedBySourceDeleteFilt String Delete rows from the target table if there is no match AND the SQL expression evaluates to true [optional]
timeout String Timeout for the operation (e.g., \"30s\", \"5m\") [optional]
useIndex Boolean Whether to use index for matching rows [optional]