TREE
Written by
Updated at November 6, 2024
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
, Yandex Documents
.