v.21.7Improvement
Respect insert_allow_materialized_columns for INSERT into Distributed table
Respectinsert_allow_materialized_columns(allows materialized columns) for INSERT intoDistributedtable. #23349 (Azat Khuzhin).
Why it matters
This feature addresses the limitation where inserting data intoDistributed tables did not honor the insert_allow_materialized_columns setting, preventing insertion into materialized columns. It allows users to insert data that includes materialized columns through distributed tables, improving data insertion flexibility and consistency.How to use it
To use this feature, set theinsert_allow_materialized_columns setting to true when inserting into a Distributed table. For example, use the following setting in your client or query:SET insert_allow_materialized_columns = 1;
INSERT INTO distributed_table VALUES (...);