TREE
Written by
Updated at December 19, 2025
Syntax
TREE( array )
Description
Converts the array expression to Tree of strings format. Can be used to create tree hierarchies.
Argument types:
array—Array of strings
Return type: Any
Example
TREE(ARRAY([Country], [Region], [City]))
Data source support
ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Trino, Yandex Documents.