Skip to Content
0

unnest with more than 1024 items - it is possible?

Dec 07, 2016 at 12:45 PM

39

avatar image

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!

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Dec 07, 2016 at 01:59 PM
0

UNNEST has no limitation to 1024 entries.

Regards,
Florian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0