title: Aggregate function in mariaDB
body: <p>I am new to mariadb, and I was using MySQL to develop something, after switching to mariadb it is not working, the error part I find is located at 'JSON_ARRAYAGG', in previously I was using JSON_ARRAYAGG to combine result as array by Group by as below</p>
  
  <pre><code>SELECT column1, JSON_ARRAYAGG(column2) AS column2 FROM table GROUP BY column1;
  </code></pre>
  
  <p>Transformation</p>
  
  <pre><code>column1    column2               column1    column2
  1            a                      1       ['a','b']
  1            b                      2       ['cc','dd']
  2            cc          ---&gt;       3       ['e']
  2            dd
  3            e
  </code></pre>
  
  <p>Is there a way to do so in mariadb?
  Thank you in advance!</p>