Skip to Content
0

Too few results for an SQL query - SAP Hana Fourier Transformation / DFT

Dec 02, 2016 at 09:49 AM

23

avatar image
Former Member

Hi,

I have a table with 34000 rows and I want to do a Fourier transformation.

This is my query:

select 
*
from UNNEST(
(SELECT DFT(weighted, 32768 ORDER BY rel_id).REAL FROM :fith)
) with ordinality AS UNNESTED_DFT(real);

Now I'm getting just 1024 results. Whats wrong?
I tried all possibles output parameters and also differently constructed queries...

Thanks!

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

0 Answers