Skip to Content
avatar image
Former Member

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers