Frans Drijver created HIVE-4661: ----------------------------------- Summary: Unable to wrap analytical function in another function Key: HIVE-4661 URL: https://issues.apache.org/jira/browse/HIVE-4661 Project: Hive Issue Type: Bug Components: SQL Affects Versions: 0.11.0 Reporter: Frans Drijver
I am unable to wrap an analytical function in another function as so: {quote} 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 {quote} This produces the following error: {quote} 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 {quote} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira