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

Switch to Plain View
Hive, mail # user - Hive help on the update


+
Kumar Chinnakali 2013-06-28, 12:52
Copy link to this message
-
Re: Hive help on the update
Stephen Sprague 2013-06-28, 16:30
what version of hive are you running? and show us your attempts - don't be
shy!

On Fri, Jun 28, 2013 at 5:52 AM, Kumar Chinnakali <
[EMAIL PROTECTED]> wrote:

>  Hi Hive Team,****
>
> ** **
>
> I have Teradata Query as below and my intention is to convert in to Hive
> Query(HQL). Tried but it’s vain. ****
>
> ** **
>
> SELECT Col_1, Col_2, Col_3,  MIN(Col_3) OVER(Partition by Col_1 ORDER BY
> Col_3, Col_2 rows between 1 preceding and 1 preceding) prev_Col_3 FROM
> work_table ;****
>
> ** **
>
> *Example:*****
>
> ** **
>
> *Actual Work table: *****
>
> Col_1    ****
>
> Col_3****
>
> Prev_Col_3****
>
> P1****
>
> 9:00****
>
> Null****
>
> P1****
>
> 10:00****
>
> Null****
>
> P2****
>
> 11:00****
>
> Null****
>
> P2****
>
> 12:00****
>
> Null****
>
> ** **
>
> *Expected result**:*****
>
> Col_1    ****
>
> Col_3****
>
> Prev_Col_3****
>
> P1****
>
> 9:00****
>
> Null****
>
> P1****
>
> 10:00****
>
> 9:00****
>
> P2****
>
> 11:00****
>
> Null****
>
> P2****
>
> 12:00****
>
> 11:00****
>
> ** **
>
> Any help will be much help full.****
>
> ** **
>
> Regards, Kumar Chinnakali J****
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further, you are not
> to copy, disclose, or distribute this e-mail or its contents to any other person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
> every reasonable precaution to minimize this risk, but is not liable for any damage
> you may sustain as a result of any virus in this e-mail. You should carry out your
> own virus checks before opening the e-mail or attachment. Infosys reserves the
> right to monitor and review the content of all messages sent to or from this e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
>
+
Christopher Wirt 2013-06-28, 16:44