Skip to main content
Skip to main content

SHOW-EXPORT

SHOW-EXPORT​

Name​

SHOW EXPORT

Description​

This statement is used to display the execution of the specified export task

grammar:

SHOW EXPORT
[FROM db_name]
[
WHERE
[ID=your_job_id]
[STATE = ["PENDING"|"EXPORTING"|"FINISHED"|"CANCELLED"]]
[LABEL=your_label]
]
[ORDER BY...]
[LIMIT limit];

illustrate:

  1. If db_name is not specified, the current default db is used
2. If STATE is specified, matches EXPORT state
3. You can use ORDER BY to sort any combination of columns
4. If LIMIT is specified, limit matching records are displayed. Otherwise show all

Example​

  1. Show all export tasks of default db

    SHOW EXPORT;
  2. Display the export tasks of the specified db, sorted by StartTime in descending order

     SHOW EXPORT FROM example_db ORDER BY StartTime DESC;
  3. Display the export tasks of the specified db, the state is "exporting", and sort by StartTime in descending order

    SHOW EXPORT FROM example_db WHERE STATE = "exporting" ORDER BY StartTime DESC;
  4. Display the export task of the specified db and specified job_id

      SHOW EXPORT FROM example_db WHERE ID = job_id;
  5. Display the specified db and specify the export task of the label

     SHOW EXPORT FROM example_db WHERE LABEL = "mylabel";

Keywords​

SHOW, EXPORT

Best Practice​