v.20.4Improvement

Allow literals for GLOBAL IN in ClickHouse queries

Official CH changelog text
Allow literals for GLOBAL IN (i.e. SELECT * FROM remote('localhost', system.one) WHERE dummy global in (0)) #10196 (Azat Khuzhin)
Allows the use of literal values in GLOBAL IN expressions, enabling queries like SELECT * FROM remote('localhost', system.one) WHERE dummy GLOBAL IN (0).

Why it matters

This feature simplifies query writing by allowing users to include literal values directly within GLOBAL IN clauses when querying remote tables, improving flexibility and usability in distributed query scenarios.

How to use it

Simply use literal values inside the GLOBAL IN clause in your queries as you would normally, for example:

SELECT * FROM remote('localhost', system.one) WHERE dummy GLOBAL IN (0)

Related resources

PreviousNext