SHOW INSPECT ERRORS displays errors recorded by an job.
SHOW INSPECT ERRORS shows results for a single INSPECT job at a time; it does not aggregate results across jobs. By default, it returns errors from the most recent completed, successful INSPECT job for the specified table. To view errors from a specific job, use SHOW INSPECT ERRORS FOR JOB {job_id}.
Required privileges
To runSHOW INSPECT ERRORS, the user must have:
- The
INSPECTsystem-level , which is required to run the .
Synopsis
Parameters
| Parameter | Syntax | Description |
|---|---|---|
opt\_for\_table\_clause | FOR TABLE {table\_name} | Optional. Show errors for the specified . |
opt\_for\_job\_clause | FOR JOB {job\_id} | Optional. Show errors produced by the job ID returned by the . |
opt\_with\_details | WITH DETAILS | Optional. Include structured error metadata from the details column () in the results. |
Response
SHOW INSPECT ERRORS returns the following columns, with one row per issue detected.
| Field | Description |
|---|---|
job\_id | The ID of the job that detected the issue. |
error\_type | The type of inconsistency detected. For more information, see Error types. |
aost | The timestamp used by the validation (if any). |
database\_name | The containing the schema object with an issue. |
schema\_name | The containing the object with an issue. |
object\_name | The or with an issue. |
primary\_key | The of the row involved in the issue, if applicable. |
details | This column is present only if WITH DETAILS is specified. It contains structured metadata () describing the issue. |
Error types
TheINSPECT implementation reports the following error_type values:
| Error type | Meaning |
|---|---|
missing\_secondary\_index\_entry | A row in the is missing a corresponding entry in a . If you see this error, . |
dangling\_secondary\_index\_entry | A entry exists, but the referenced row does not. If you see this error, . |
internal\_error | An error occurred while INSPECT was running its validation queries (for example, an ). The cause of this error type is usually not related to data validity. Investigate the underlying job error details and cluster logs to determine the cause before deciding whether to . |
Examples
Show the latest errors for a table
To see the errors found by the most recentINSPECT job, issue the following statement:
Show errors for a specific inspection job
When you issue the , aNOTICE message is returned to the client showing the job ID, e.g.,