Skip to Content
avatar image
Former Member

unnest with more than 1024 items - it is possible?

Hi,

it is possible to use the unnest function for more than 1024 items?

My array has 32768 items but unnest() just returns 1024.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2016 at 01:59 PM

    UNNEST has no limitation to 1024 entries.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Okay but why I'm getting just 1024 of my 32768 items?
      The DFT function returns 32K items...

      select 
      * from
      unnest(
      (select dft(wertb, 32768 order by werta).amplitude from "XXYYZZ"."test")
      ) as unnested(amplitude)

      Tobias