Does ClickHouse support recursive CTE?

[hueiyuan]

Description

Because we want to execute trace query like jaeger to show dependency graph on grafana (like below image), and it seems that need to use Recursive CTE to achieve it, we refer to timescale can achieve similar objective, But we are not sure current ClickHouse is support this?

Hope someone can assist to give some suggestion or answer, we will be appreciated it, thank you.

• Jaeger Dependency Graph
  

[alexey-milovidov]

No, as of 2024-03-25, ClickHouse does not support recursive CTE.
A workaround could be using a temporary table and a loop.

[rschu1ze]

#62074