9951 explained code solutions for 126 technologies


clickhouseHow to select Tuple as table columns


SELECT untuple(person) FROM tbl4ctrl + c
tbl4

name of the table with Tuple column

person

name of the created Tuple column

untuple

will expand tuple elements to table columns in a result set


Usage example

SELECT untuple(person) FROM tbl4
output
┌─tupleElement(person, 1)─┬─tupleElement(person, 2)─┐
│ Donald                  │                       1 │
│ Joe                     │                       2 │
└─────────────────────────┴─────────────────────────┘