[HIVE-4661] Unable to wrap analytical function in another function

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.11.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Frans Drijver
• Created: 05/Jun/13 10:55
• Updated: 24/Sep/13 01:45

Description

I am unable to wrap an analytical function in another function as so:

select
case when ta_end_datetime_berekenen = 'Y'
then lead(ta_update_datetime) over ( partition by dn_waarde_van, dn_waarde_tot order by ta_update_datetime )
else ea_end_datetime end as ea_end_datetime
, ta_insert_datetime
, ta_update_datetime
from tmp_wtdh_bestedingsklasse_10_s2_stap2

This produces the following error:

NoViableAltException(86@[129:7: ( ( ( KW_AS )? identifier ) | ( KW_AS LPAREN identifier ( COMMA identifier )* RPAREN ) )?])

FAILED: ParseException line 1:175 missing KW_END at 'over' near ')' in selection target line 1:254 cannot recognize input near 'else' 'ea_end_datetime' 'end' in selection target