SHOW-LOAD-WARNINGS

Name

SHOW LOAD WARNINGS

Description

If the import task fails and the error message is ETL_QUALITY_UNSATISFIED, it means that there is an import quality problem. If you want to see these import tasks with quality problems, change the statement to complete this operation.

grammar:

  1. SHOW LOAD WARNINGS
  2. [FROM db_name]
  3. [
  4.     WHERE
  5.     [LABEL[="your_label"]]
  6.     [LOAD_JOB_ID = ["job id"]]
  7. ]

1) If db_name is not specified, the current default db is used 1) If LABEL = is used, it matches the specified label exactly 1) If LOAD_JOB_ID is specified, match the specified JOB ID exactly

Example

  1. Display the data with quality problems in the import task of the specified db, and specify the label as “load_demo_20210112”

    1. SHOW LOAD WARNINGS FROM demo WHERE LABEL = "load_demo_20210112"

Keywords

  1. SHOW, LOAD, WARNINGS

Best Practice