Skip to main content
Skip table of contents

CHECK TABLES

Description

CHECK TABLES performs a consistency check of each table and index in the warehouse, to identify and report potential causes of failure.

Syntax

Syntax

BASH
CHECK TABLES

Output

ColumnNamedescription

schema

schema name

table

table name

index

index name (if error concerns an index)

error

error description

threshold

threshold above which the error is reported

trigger

number of occurrences of the error in the check

Example

Listed Error types

This consistency check can raise the following errors:

  • Partitions number is not the same as defined in the configuration: The structure has not the same partitions count as the configuration.
  • One or more dictionaries appear to be corrupted: One or a few dictionaries seem corrupted (Loading has failed).
  • There are some missing partitions for dictionaries. Check logs for 'Different dictionaries report different #partitions' to find what partitions are missing. 
  • We have found available dictionaries, but none for our partitions: We have found dictionaries on disk, but none to register with our partitions.
  • One or more index metadata files appear to be corrupted: One or a few indexes seem corrupted (Loading has failed).
  • The index is on error because fields are corrupted: Some fields seem corrupted.
  • Unable to merge dictionaries: Problem during the merging of dictionaries.
  • The view relies on a table that is in error: Problem during loading table for view
  • Unknown: Default value if structure can't be loaded for an unexpected reason.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.