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.

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

StarRocks provides the loading method HTTP-based STREAM LOAD to help you load data from a local file system or a streaming data source. After you submit a load job, StarRocks 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, principles, and supported data file formats of Stream Load, see Loading from a local file system via Stream Load.

Loading and unloading

📄️ ALTER LOAD

📄️ BROKER_LOAD