v.23.5New Feature

Clickhouse-client now supports multiquery mode without a specified query

Official CH changelog text
Clickhouse-client now accepts queries after "--multiquery" when "--query" (or "-q") is absent. example: clickhouse-client --multiquery "select 1; select 2;". #49870 (Alexey Gerasimchuk).
The clickhouse-client utility now supports executing multiple queries even when the --query (or -q) option is not provided, as long as --multiquery is used.

Why it matters

This feature allows users to run multiple queries in one command without explicitly specifying the --query option. It simplifies batch query execution, making it more convenient to execute multiple statements directly through clickhouse-client.

How to use it

Use the clickhouse-client with the --multiquery option followed by the queries inside quotes, without the need to provide --query or -q. For example:

clickhouse-client --multiquery "select 1; select 2;"

Related resources

PreviousNext