v.25.4Improvement

Serialize query plan for Distributed queries

Official CH changelog text
Serialize query plan for Distributed queries. A new setting serialize_query_plan is added. When enabled, queries from Distributed table will use a serialized query plan for remote query execution. This introduces a new packet type to TCP protocol, <process_query_plan_packet>true</process_query_plan_packet> should be added to the server config to allow processing this packet. #69652 (Nikolai Kochetov).
Added support for serializing the query plan in Distributed queries to improve remote query execution.

Why it matters

This feature addresses the need to optimize the execution of Distributed table queries by sending a serialized query plan to remote servers. This can improve query execution efficiency and consistency across distributed nodes.

How to use it

Enable the new setting serialize_query_plan for queries on Distributed tables. Additionally, add <process_query_plan_packet>true</process_query_plan_packet> to the server TCP protocol configuration to allow the server to process the new serialized query plan packets.

Related resources

PreviousNext