Description
In the current implementation of the first_value function, it's not allowed to have more than one (1) order by column, as so:
select distinct
first_value(kastr.DEWNKNR) over ( partition by kastr.DEKTRNR order by kastr.DETRADT, kastr.DEVPDNR )
from RTAVP_DRKASTR kastr
;
Error given:
FAILED: SemanticException Range based Window Frame can have only 1 Sort Key
Attachments
Attachments
Issue Links
- relates to
-
HIVE-13242 DISTINCT keyword is dropped by the parser for windowing
- Closed
- links to