v.25.11Improvement

Replace TABLE queries

Official CH changelog text
You can see a progress bar, logs and performance statistics for CREATE OR REPLACE TABLE queries with SELECT in clickhouse-client. This query will no longer lead to timeout even if the SELECT is quite time consuming. Resolves #38416. #87247 (Diskein).
Added progress bar, logs, and performance statistics visualization for CREATE OR REPLACE TABLE queries with SELECT in clickhouse-client, preventing timeouts on long-running select operations.

Why it matters

This feature addresses the issue where CREATE OR REPLACE TABLE queries containing SELECT could lead to client timeouts if the SELECT operation is time consuming. By providing progress indicators and detailed logging, it improves user experience and visibility into query execution progress.

How to use it

Run CREATE OR REPLACE TABLE queries with SELECT in clickhouse-client as usual. The client will automatically display a progress bar, execution logs, and performance statistics, and the query will no longer timeout regardless of the SELECT's duration.

Related resources

PreviousNext