v.22.3Improvement

Support for Distributed INSERT SELECT Queries in View() Function

Official CH changelog text
Support distributed INSERT SELECT queries (the setting parallel_distributed_insert_select) table function view(). #35132 (Azat Khuzhin).
Introduces support for distributed INSERT SELECT queries with the parallel_distributed_insert_select setting and enables the view() table function.

Why it matters

This feature allows parallel execution of distributed INSERT SELECT operations to improve performance and efficiency in processing large datasets across distributed tables. It also adds the view() table function to facilitate more flexible query constructions.

How to use it

Enable the feature by setting parallel_distributed_insert_select to 1 in your configuration or query settings. Use the view() table function within your SQL queries as needed to leverage this functionality.

Related resources

PreviousNext