v.22.1Experimental Feature

Add EXPLAIN TABLE OVERRIDE Query

Official CH changelog text
Add EXPLAIN TABLE OVERRIDE query. #32836 (Stig Bakken).
Introduces the EXPLAIN TABLE OVERRIDE query in ClickHouse to allow users to override table structure descriptions during query explanation.

Why it matters

This feature enables users to customize how table schemas are represented in EXPLAIN output. It addresses the need for flexible query analysis and debugging by letting users simulate different table schemas without modifying the actual tables.

How to use it

Use the EXPLAIN TABLE OVERRIDE syntax followed by table schema overrides when running an EXPLAIN query. This allows you to specify alternative table definitions for the purpose of query explanation.

Related resources

PreviousNext