v.22.1Experimental Feature

Add TABLE OVERRIDE Feature for MaterializedMySQL Table Customization

Add "TABLE OVERRIDE" feature for customizing MaterializedMySQL table schemas. #32325 (Stig Bakken).
Added a TABLE OVERRIDE feature to customize MaterializedMySQL table schemas in ClickHouse.

Why it matters

This feature allows users to override the default schema mappings of MySQL tables when using the MaterializedMySQL engine. It solves the problem of rigid schema replication by enabling customizations, thus providing flexibility to adapt the table structures to specific needs or optimize performance.

How to use it

Users can apply the feature by specifying the TABLE OVERRIDE clause in the MaterializedMySQL setup configuration. This clause lets users define customized schema details for selected tables, overriding the automatic schema replication behavior.