clickhouseConvert array to rows
SELECT arrayJoin([1, 2, 3])ctrl + carrayJoinwill expand array to rows (each row for each array element) | [1, 2, 3]sample array to convert to rows |
Usage example
SELECT arrayJoin([1, 2, 3]);
SELECT arrayJoin([1, 2, 3]), now();
output
┌─arrayJoin([1, 2, 3])─┐
│ 1 │
│ 2 │
│ 3 │
└──────────────────────┘
┌─arrayJoin([1, 2, 3])─┬───────────────now()─┐
│ 1 │ 2022-01-14 17:53:02 │
│ 2 │ 2022-01-14 17:53:02 │
│ 3 │ 2022-01-14 17:53:02 │
└──────────────────────┴─────────────────────┘Related
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select rows with certain value in array column
- Create table example
- Using variables in queries
- Add row number to results
- List all tables from all database
- Select where date column is between dates
- Create table with UUID column
- String concat
See more codes...