v.23.10New Feature

Improved CHECK TABLE Performance and Usability in ClickHouse

Official CH changelog text
QueryCHECK TABLE has better performance and usability (sends progress updates, cancellable). Support checking particular part with CHECK TABLE ... PART 'part_name'. #53404 (vdimir).
Improved CHECK TABLE query with enhanced performance, usability, and support for checking specific parts using CHECK TABLE ... PART 'part_name'.

Why it matters

The feature addresses the need for more efficient and user-friendly table integrity checks. It improves performance, allows progress monitoring, supports cancellation, and enables users to verify individual parts of tables, which increases flexibility and control during table validation.

How to use it

Run the CHECK TABLE query as usual. To check a specific part of a table, use the syntax:

CHECK TABLE <table_name> PART '<part_name>'

The command now also provides progress updates and can be cancelled if needed.

Related resources

PreviousNext