v.18.14Improvement

LIKE and IN expressions with constant right half sent to remote server in MySQL and ODBC queries

Official CH changelog text
LIKE and IN expressions with a constant right half are passed to the remote server when querying from MySQL or ODBC tables. #3182
LIKE and IN expressions with a constant right operand are now pushed down to the remote server when querying MySQL or ODBC tables.

Why it matters

This feature improves query performance by offloading filtering operations involving constant values in LIKE and IN expressions to the remote MySQL or ODBC data source, reducing data transfer and processing load on ClickHouse.

How to use it

Users simply write queries against MySQL or ODBC tables that include LIKE or IN expressions with constant right-hand side values. These expressions will automatically be pushed down to the remote server without requiring additional configuration.

Related resources

PreviousNext