REPAIR TABLE - Kinetica Docs

Repairs one or more corrupted tables. Tables are specified as a comma-separated list of table names.

REPAIR TABLE Syntax

REPAIR TABLE[S] [<schema name>.]<table name>[,...]
WITH OPTIONS (REPAIR_POLICY = '<repair type>')

Parameters

Name of the schema containing the table to repair

Name of the table to repair

REPAIR_POLICY

Specifies the type of table repair to perform. The following are available:

Type	Description
`delete_chunks`	Deletes any corrupted chunks
`shrink_columns`	Shrinks corrupted chunks to the shortest column
`replay_wal`	Manually invokes WAL replay on the table

To manually replay the WAL on two tables:

REPAIR TABLE Example

REPAIR TABLES example.rt_product, example.rt_order
WITH OPTIONS (REPAIR_POLICY = 'replay_wal')

⌘I