LOAD filename INTO tablename [ THROTTLE throughput ]
LOAD archive.p INTO mytable; LOAD dump.json.gz INTO mytable;
Take the results of a
SELECT ... SAVE outfile and insert all of the records
into a table.
- The file containing the records to upload
- The name of the table(s) to upload the records into
- Limit the amount of throughput this query can consume. This is a pair of
(read_throughput, write_throughput). You can use a flat number or a percentage (e.g.
*means no limit (typically useless unless you have set a default throttle in the Options).