/admin/repair/table - Kinetica Docs

URL: http://<db.host>:<db.port>/admin/repair/table

Manually repair a corrupted table. Returns information about affected tables.

Input Parameter Description

table_names

array of strings

List of tables to query. An asterisk returns all tables.

table_types

map of string to strings

ID of the type per table.

options

map of string to strings

Optional parameters.The default value is an empty map ( {} ).

Show options

repair_policy

Corrective action to take.

delete_chunks: Deletes any corrupted chunks.
shrink_columns: Shrinks corrupted chunks to the shortest column.
replay_wal: Manually invokes write-ahead log (WAL) replay on the table.
alter_table: Reset columns modification after incomplete alter column.

verify_all

If false only table chunk data already known to be corrupted will be repaired. Otherwise the database will perform a full table scan to check for correctness.The default value is false.The supported values are:

true
false

Output Parameter Description

The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:

status

String

‘OK’ or ‘ERROR’

message

String

Empty if success or an error message

data_type

String

‘admin_repair_table_response’ or ‘none’ in case of an error

data

String

Empty string

data_str

JSON or String

This embedded JSON represents the result of the /admin/repair/table endpoint:

Show data_str

table_names

array of strings

List of repaired tables.

repair_status

array of strings

List of repair status by table.

info

map of string to strings

Additional information.

Empty string in case of an error.

​Input Parameter Description

​Output Parameter Description

Input Parameter Description

Output Parameter Description