clickhouseHow to select Tuple as table columns
SELECT untuple(person) FROM tbl4ctrl + ctbl4name of the table with Tuple column | personname of the created Tuple column |
untuplewill expand tuple elements to table columns in a result set | |
Usage example
SELECT untuple(person) FROM tbl4output
┌─tupleElement(person, 1)─┬─tupleElement(person, 2)─┐
│ Donald │ 1 │
│ Joe │ 2 │
└─────────────────────────┴─────────────────────────┘
Related
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Create table example
- Add row number to results
- String concat
- List all tables from all database
- Select rows with certain value in array column
- Select where date column is between dates
- Create table with UUID column
See more codes...