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 │
└──────────────────────┴─────────────────────┘