v.21.11Improvements

ClickHouse Client Introduces Native Multi-Line Editing Support

Official CH changelog text
Now clickhouse-client supports native multi-line editing. #30143 (Amos Bird).
The clickhouse-client now supports native multi-line editing, allowing users to input and edit SQL queries that span multiple lines directly within the interactive client.

Why it matters

This feature improves the user experience by enabling easier composition and editing of complex, multi-line SQL queries without breaking them into single-line inputs. It simplifies query writing and debugging in the clickhouse-client interface.

How to use it

Users can directly enter multi-line SQL statements in the clickhouse-client interactive shell by pressing Enter to create new lines as needed before executing the complete query.

Related resources

PreviousNext