This is SQL query.
Let’s assume that you have column having the data type map of arrays
<code> profiles map(int, array(int))
</code>
<code> profiles map(int, array(int))
</code>
profiles map(int, array(int))
so in the table, you see
<code> profiles
{1: [1, 2]}
{2: [3, 4]}
{3: [10]}
{4: []}
</code>
<code> profiles
{1: [1, 2]}
{2: [3, 4]}
{3: [10]}
{4: []}
</code>
profiles
{1: [1, 2]}
{2: [3, 4]}
{3: [10]}
{4: []}
Let’s assume that you just wanna pick the first value from each (none if empty), so in the above case
<code> profiles
{1: 1}
{2: 3}
{3: 10}
{4: NULL}
</code>
<code> profiles
{1: 1}
{2: 3}
{3: 10}
{4: NULL}
</code>
profiles
{1: 1}
{2: 3}
{3: 10}
{4: NULL}
and the new data type would be
<code> profiles map(int, int)
</code>
<code> profiles map(int, int)
</code>
profiles map(int, int)
is there a way to do this?