v.22.2New Feature

Added Support for Shebang and Hash as Single Line Comment Indicators

Official CH changelog text
Added #! and # as a recognised start of a single line comment. Closes #34138. #34230 (Aaron Katz).
ClickHouse now supports #! and # as recognized prefixes for single-line comments in SQL queries.

Why it matters

This feature enhances SQL script readability and flexibility by allowing additional styles of single-line comments, improving compatibility with scripts and tools that use these comment conventions.

How to use it

Simply start a line in your SQL scripts or queries with #! or # to add a single-line comment. These lines will be ignored by the ClickHouse parser during query execution.

Related resources

PreviousNext