Skip to main content
Skip to main content

groupArrayArray

Aggregates arrays into a larger array of those arrays. Combines the groupArray function with the Array combinator.

Alias: array_concat_agg

Example

We have data which captures user browsing sessions. Each session records the sequence of pages a specific user visited. We can use the groupArrayArray function to analyze the patterns of page visits for each user.

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free