Skip to Content
0

unnest with more than 1024 items - it is possible?

Dec 07, 2016 at 12:45 PM

40

avatar image
Former Member

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
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

0