Exporting From Hive

["Bale, Michael" <mi...@cwc.com>]

Hi,

I was wondering if anyone could help me?

Does anyone know if it is possible to include the column headers in an
output from a Hive Query? I've had a look through the internet but can't
seem to find an answer.

If not, is it possible to export the result from a describe table query? If
so I could then run that at the same tie and join up at a future date.

Thanks for your help

-- 
*Mike Bale*
Graduate Insight Analyst
*Cable and Wireless Communications*
Tel: +44 (0)20 7315 4437
www.cwc.com

The information contained in this email (and any attachments) is confidential and may be privileged. If you are not the intended recipient
and have received this email in error, please notify the sender immediately by reply email and delete the message and any attachments.
If you are not the named addressee, you must not copy, disclose, forward or otherwise use the information contained in this email.
Cable & Wireless Communications Plc and its affiliates reserve the right to monitor all email communications through their networks to
ensure regulatory compliance.
 
Cable & Wireless Communications Plc is a company registered in England & Wales with number:
07130199 and offices located at 3rd Floor, 26 Red Lion Square, London WC1R 4HQ

Re: Exporting From Hive

[Ayon Sinha <ay...@yahoo.com>]

This is for CLI
      
Use this:
set hive.cli.print.header=true;

Instead of doing this on the prompt everytime you can change your hive start command to:
hive -hiveconf hive.cli.print.header=true

But be careful with this setting as quite a few commands stop working with NPE with this on. I think describe doesn't work.
 
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.



________________________________
From: "Bale, Michael" <mi...@cwc.com>
To: common-user@hadoop.apache.org
Sent: Thursday, July 28, 2011 8:54 AM
Subject: Exporting From Hive

Hi,

I was wondering if anyone could help me?

Does anyone know if it is possible to include the column headers in an
output from a Hive Query? I've had a look through the internet but can't
seem to find an answer.

If not, is it possible to export the result from a describe table query? If
so I could then run that at the same tie and join up at a future date.

Thanks for your help

-- 
*Mike Bale*
Graduate Insight Analyst
*Cable and Wireless Communications*
Tel: +44 (0)20 7315 4437
www.cwc.com

The information contained in this email (and any attachments) is confidential and may be privileged. If you are not the intended recipient
and have received this email in error, please notify the sender immediately by reply email and delete the message and any attachments.
If you are not the named addressee, you must not copy, disclose, forward or otherwise use the information contained in this email.
Cable & Wireless Communications Plc and its affiliates reserve the right to monitor all email communications through their networks to
ensure regulatory compliance.

Cable & Wireless Communications Plc is a company registered in England & Wales with number:
07130199 and offices located at 3rd Floor, 26 Red Lion Square, London WC1R 4HQ