Skip to main content
Skip to main content

ARRAY_AGG

ARRAY_AGG

description

Syntax

ARRAY_AGG(col)

Concatenation of values in a column (including the null value) into an array can be used for multiple rows to one row (row to column).

notice

  • The order of the elements in an array is not guaranteed.
  • Returns the array generated by the transformation. The element type in the array is the same as the col type.

example

mysql> select * from test_doris_array_agg;

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

| c1 | c2 |

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

| 1 | a |

| 1 | b |

| 2 | c |

| 2 | NULL |

| 3 | NULL |

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

mysql> 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] |

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

keywords

ARRAY_AGG