TREE
Written by
Updated at October 11, 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, PostgreSQL 9.3.