VeloDB Cloud
SQL Manual
Statments
Show-Statements
SHOW-STREAM-LOAD

SHOW-STREAM-LOAD

Name

SHOW STREAM LOAD

Description

This statement is used to display the execution of the specified Stream Load task

Syntax:

SHOW STREAM LOAD
[FROM db_name]
[
  WHERE
  [LABEL [ = "your_label" | LIKE "label_matcher"]]
  [STATUS = ["SUCCESS"|"FAIL"]]
]
[ORDER BY...]
[LIMIT limit][OFFSET offset];

Note:

  1. By default, BE does not record Stream Load records. If you want to view records that need to be enabled on BE, the configuration parameter is: enable_stream_load_record=true. For details, please refer to BE Configuration Items (opens in a new tab)
  2. If db_name is not specified, the current default db is used
  3. If LABEL LIKE is used, it will match the tasks whose label of the Stream Load task contains label_matcher
  4. If LABEL = is used, it will match the specified label exactly
  5. If STATUS is specified, matches STREAM LOAD status
  6. You can use ORDER BY to sort on any combination of columns
  7. If LIMIT is specified, limit matching records are displayed. Otherwise show all
  8. If OFFSET is specified, the query results are displayed starting at offset offset. By default the offset is 0.

Example

  1. Show all Stream Load tasks of the default db

      SHOW STREAM LOAD;
  2. Display the earliest 10 Stream Load tasks of the specified db, of which the label contains the string "2014_01_02"

    SHOW STREAM LOAD FROM example_db WHERE LABEL LIKE "2014_01_02" LIMIT 10;
  3. Display the Stream Load task of the specified db and specify the label as "load_example_db_20140102"

    SHOW STREAM LOAD FROM example_db WHERE LABEL = "load_example_db_20140102";
  4. Display the Stream Load tasks of the specified db that are in "success" status, and sort them by StartTime in descending order

    SHOW STREAM LOAD FROM example_db WHERE STATUS = "success" ORDER BY StartTime DESC;
  5. Display the import tasks of the specified db and sort them by StartTime in descending order, and display 10 query results starting from offset 5

    SHOW STREAM LOAD FROM example_db ORDER BY StartTime DESC limit 5,10;
    SHOW STREAM LOAD FROM example_db ORDER BY StartTime DESC limit 10 offset 5;

Keywords

SHOW, STREAM, LOAD

Best Practice