About unnest, not support yet?


I do create table ta (f1 int, f2 int), and insert into ta values (1, {1,2,3}), I run query “select unnest(f2) from ta;”, but it shows “Exception: UNNEST not supported in the projection list yet.” . Is the “UNNEST” can not use in mapd now ? I use then lastest version 4.2.2


Hi @giverking,

UNNEST requires a GROUP BY to work, its a known issue. Here is the workaround:



thank u, it can works, the key is “as a”.