RE: A question goes on my mind : Can we (other applications) use HDFS without MapReduce ?

2013-07-15 Thread Kumar Chinnakali
Yes, we can with the help of YARN.

From: Matouk IFTISSEN [mailto:matouk.iftis...@ysance.com]
Sent: Monday, July 15, 2013 3:40 PM
To: user@hive.apache.org
Subject: A question goes on my mind : Can we (other applications) use HDFS 
without MapReduce ?

Hello,
Can we (other applications) use HDFS without invoking MapReduce operations?

Thanks for your answers.

 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***


Hortonworks HDP 1.3 vs. HDP 1.1

2013-07-04 Thread Kumar Chinnakali
Hi Hive Team,

Currently am developing and testing the Hive queries in HDP 1.1 with Hadoop 
1.0.3 and Hive 0.9.0

However, it seems that my production is going to get upgraded to HDP 1.3 in 
near future. Will it will impact with respect to design, optimization?

Please suggest.

Regards, Kumar Chinnakali

 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***


Hive help on the update

2013-06-28 Thread Kumar Chinnakali
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 :)

 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***