---

{ “title”: “ARRAY_AGG”, “language”: “en” }

Description

Concatenates the values (including null values) in a column into an array, which can be used for pivoting rows into columns.

Syntax

ARRAY_AGG(<col>)

Parameters

Parameter	Description
<col>	An expression that determines the values to be placed into the array (usually column names).

Return Value

Returns a value of ARRAY type.Special cases:

• The order of elements in the array is not guaranteed.
• Returns the array generated by the conversion. The element type in the array is consistent with the type of col.

Example

select * from test_doris_array_agg;

+------+------+

| c1   | c2   |

+------+------+

|    1 | a    |

|    1 | b    |

|    2 | c    |

|    2 | NULL |

|    3 | NULL |

+------+------+

select c1, array_agg(c2) from test_doris_array_agg group by c1;

+------+-----------------+

| c1   | array_agg(`c2`) |

+------+-----------------+

|    1 | ["a","b"]       |

|    2 | [NULL,"c"]      |

|    3 | [NULL]          |

+------+-----------------+