v.22.12Improvement

Support MySQL Compatible Queries in ClickHouse

Official CH changelog text
Support queries like SHOW FULL TABLES ... for MySQL compatibility. #43910 (Filatenkov Artur).
Added support for SHOW FULL TABLES queries to enhance MySQL compatibility in ClickHouse.

Why it matters

This feature enables users migrating from MySQL or working in mixed environments to run SHOW FULL TABLES queries natively in ClickHouse. It simplifies compatibility and reduces the need for query rewriting by supporting this common MySQL command.

How to use it

Users can execute the SHOW FULL TABLES command directly in ClickHouse as they would in MySQL. No additional configuration is required.

Related resources

PreviousNext