load_file_start
Destructive
Load a local file into a SingleStore table after user confirmation, creating a new table or appending to an existing one. Validates rows first and runs in the background.
Instructions
Load a file from this computer into a table – only after the user confirmed in the wizard (confirmed; above
the size limit also confirmed_large, the second confirmation).
``mode`` "new" runs ``create_sql`` (one CREATE TABLE for ``database.table``) first, "append" adds to the existing
table. ``columns`` / ``width`` / ``options`` come from load_file_preview; ``expected_size`` is the file size the user
saw (a file that changed since is refused). Every row is checked first; bad rows stop the load before anything is
written unless ``skip_bad``. ``method``: "auto" (LOAD DATA LOCAL INFILE, else INSERTs), "local_infile" or "insert".
Runs in the background: follow it with load_file_status, stop it with load_file_cancel.Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | Yes | ||
| path | Yes | ||
| table | Yes | ||
| width | Yes | ||
| method | No | auto | |
| columns | Yes | ||
| formats | No | ||
| mapping | No | ||
| options | Yes | ||
| database | Yes | ||
| skip_bad | No | ||
| confirmed | No | ||
| create_sql | No | ||
| expected_size | Yes | ||
| confirmed_large | No |