versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-LOAD-WARNINGS.md

{ “title”: “SHOW-LOAD-WARNINGS”, “language”: “en” }

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:

SHOW LOAD WARNINGS
[FROM db_name]
[
    WHERE
    [LABEL[="your_label"]]
    [LOAD_JOB_ID = ["job id"]]
]

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

Example

Display the data with quality problems in the import task of the specified db, and specify the label as “load_demo_20210112”
```
SHOW LOAD WARNINGS FROM demo WHERE LABEL = "load_demo_20210112"
```

Keywords