Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Wrapping an analytical function


+
Frans Drijver 2013-05-27, 15:42
+
Abhishek Gayakwad 2013-09-23, 11:49
Copy link to this message
-
Re: Wrapping an analytical function
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB