Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Wrapping an analytical function


Copy link to this message
-
Re: Wrapping an analytical function
Nitin Pawar 2013-09-23, 12:28
Abhishek,

Frans has already raised JIRA for this.
https://issues.apache.org/jira/browse/HIVE-4661
On Mon, Sep 23, 2013 at 5:19 PM, Abhishek Gayakwad <[EMAIL PROTECTED]>wrote:

> Hi Frans,
>
> I am also getting same error while using analytical functions with case
> expression
>
> FAILED: ParseException line 3:19 missing KW_END at 'over' near '<EOF>'
>
> it is not allowing to use arithmetic operators with analytical function as
> well
>
> NoViableAltException(273@[129:7: ( ( ( KW_AS )? identifier ) | ( KW_AS
> LPAREN identifier ( COMMA identifier )* RPAREN ) )?])
> FAILED: ParseException line 3:120 cannot recognize input near '+' 'lag'
> '(' in selection target
>
> were you able to fine any fix or workaround for this problem?
> Thanks
> Abhishek
>
>
> On Mon, May 27, 2013 at 9:12 PM, Frans Drijver <[EMAIL PROTECTED]>wrote:
>
>> Hi there,
>>
>>
>> I am trying the following:
>>
>> 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 ea_end_datetime,
>> ta_insert_datetime, ta_update_datetime from
>> tmp_wtdh_bestedingsklasse_10_s2_stap2
>>
>> However, when I try that, I get 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
>>
>> Would I be correct in assuming that it's not possible to wrap an
>> analytical function in another function?
>>
>> This is with Hive 0.11.
>>
>> Any feedback is appreciated!
>>
>>
>> Kind regards,
>>
>>
>> Frans Drijver
>
>
>
--
Nitin Pawar