topic Re: How could I use a window function median() in a sql console in Application Development and Automation Discussions

How could I use a window function median() in a sql console

Former Member — Tue, 13 Jan 2015 10:42:05 GMT

Hi, everyone

I got an error message" feature not supported: not supported window function:" when I try to run a sql script in SPS08.

SELECT

MEDIAN(DURA) OVER(PARTITION BY TIME2) as MedianValue,

TIME2

FROM

(

SELECT

TO_INT((HOUR(TIME_2)*60+MINUTE(TIME_2))/5) AS TIME2,

DURA

FROM

TRAFFIC.D26PAIRSCER

);

HANA gave me an error: :

Could not execute 'SELECT MEDIAN(DURA) OVER(PARTITION BY TIME2) as MedianValue, TIME2 FROM ( SELECT ...' in 11 ms 603 µs .

SAP DBTech JDBC: [7] (at 8): feature not supported: not supported window function: line 2 col 2 (at pos 😎

according to the windows function page, it looks right.

Thanks a lot!

Re: How could I use a window function median() in a sql console

Laszlo_B — Wed, 14 Jan 2015 11:10:00 GMT

Hello Shu,

if I understand correctly and the problem happens during HANA SQL development, this question might be sooner answered on the Space http://scn.sap.com/community/hana-in-memory, as that Space handles HANA-related questions.

Perhaps you want to post this question there too.

Best regards,
Laszlo

Re: How could I use a window function median() in a sql console

lbreddemann — Mon, 19 Jan 2015 13:30:49 GMT

The MEDIAN aggregation is available as of SAP HANA SPS9.

- Lars

Re: How could I use a window function median() in a sql console

Former Member — Mon, 19 Jan 2015 14:36:38 GMT

Dear Laszlo Badovszky,

Yes, it happens when I am in the SQL command window:).

Thanks a lot.

Best regards,

Laszlo

Re: How could I use a window function median() in a sql console

Former Member — Mon, 19 Jan 2015 14:38:01 GMT

Dear Lars,

Thank you. Now, I need to finish it in other ways.

Best,

Shu