About unnest, not support yet?


#1

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


#2

Hi @giverking,

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

Regards,
Veda


#3

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