Loading and unloading
ALTER LOAD
ALTER LOAD changes the priority of a Broker Load job that is in the QUEUEING or LOADING state. This statement is supported since v2.5.
BROKER_LOAD
StarRocks provides the MySQL-based loading method Broker Load. After you submit a load job, StarRocks asynchronously runs the job. You can use SELECT * FROM informationschema.loads to query the job result. This feature is supported from v3.1 onwards. For more information about the background information, principles, supported data file formats, how to perform single-table loads and multi-table loads, and how to view job results, see loading overview.
CANCEL LOAD
CANCEL LOAD cancels a given load job: Broker Load, Spark Load, or INSERT. A load job in the PREPARED, CANCELLED or FINISHED state cannot be canceled.
ETL
2 items
INSERT
Inserts data into a specific table or overwrites a specific table with data. From v3.2.0 onwards, INSERT supports writing data into files in remote storage. You can use INSERT INTO FILES() to unload data from StarRocks to remote storage.
SHOW LOAD
SHOW LOAD displays information of all load jobs or given load jobs in a database. This statement can only display load jobs that are created by using Broker Load, INSERT, and SPARKLOAD. You can also view load job information via the curl command. From v3.1 onwards, we recommend that you use the SELECT statement to query the results of Broker Load or Insert jobs from the loads table in the informationschema database. For more information, see Loading.
SHOW TRANSACTION
SHOW TRANSACTION is used to view the transaction details of the specified transaction id.
SPARK LOAD
SPARK LOAD preprocesses the imported data through external spark resources, improves the import performance of a large amount of StarRocks data, and saves the computing resources of StarRocks cluster. It is mainly used in the scenario of initial migration and large amount of data import into StarRocks.
STREAM LOAD
STREAM LOAD allows you to load data from a local file system or a streaming data source. After you submit a load job, the system synchronously runs the job, and returns the result of the job after the job finishes. You can determine whether the job is successful based on the job result. For information about the application scenarios, limits, and supported data file formats of Stream Load, see Loading from a local file system via Stream Load.
pipe
6 items
routine_load
7 items
unloading
3 items