Hive, mail # user - Re: Export data with column names

Re: Export data with column names

Matthew Rathbone 2011-05-03, 14:45

If you use the thrift client you can call connection.getSchema()

--
Matthew Rathbone
Foursquare | Software Engineer | Server Engineering Team
[EMAIL PROTECTED] | @rathboma | 4sq

On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
Does anyone know how to export data out with column names? Any help here is appreciated.
>
> Thanks,
> Ranjith
>

Re: Export data with column names

Raghunath, Ranjith 2011-05-03, 18:03

Thanks. Is there something I can do with cli?

Thanks,
Ranjith

----- Original Message -----
From: Matthew Rathbone <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Sent: Tue May 03 09:45:58 2011
Subject: Re: Export data with column names

If you use the thrift client you can call connection.getSchema()

--
Matthew Rathbone
Foursquare | Software Engineer | Server Engineering Team
[EMAIL PROTECTED] | @rathboma | 4sq

On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
Does anyone know how to export data out with column names? Any help here is appreciated.
>
> Thanks,
> Ranjith
>

RE: Export data with column names

Steven Wong 2011-05-03, 18:10

set hive.cli.print.header=true;
-----Original Message-----
From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 11:03 AM
To: '[EMAIL PROTECTED]'
Subject: Re: Export data with column names

Thanks. Is there something I can do with cli?

Thanks,
Ranjith

----- Original Message -----
From: Matthew Rathbone <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Sent: Tue May 03 09:45:58 2011
Subject: Re: Export data with column names

If you use the thrift client you can call connection.getSchema()

--
Matthew Rathbone
Foursquare | Software Engineer | Server Engineering Team
[EMAIL PROTECTED] | @rathboma | 4sq

On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
Does anyone know how to export data out with column names? Any help here is appreciated.
>
> Thanks,
> Ranjith
>

Re: Export data with column names

Loren Siebert 2011-05-03, 18:23

Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:

> set hive.cli.print.header=true;
>
>
> -----Original Message-----
> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 11:03 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Export data with column names
>
> Thanks. Is there something I can do with cli?
>
> Thanks,
> Ranjith
>
> ----- Original Message -----
> From: Matthew Rathbone <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Sent: Tue May 03 09:45:58 2011
> Subject: Re: Export data with column names
>
> If you use the thrift client you can call connection.getSchema()
>
> --
> Matthew Rathbone
> Foursquare | Software Engineer | Server Engineering Team
> [EMAIL PROTECTED] | @rathboma | 4sq
>
> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
> Does anyone know how to export data out with column names? Any help here is appreciated.
>>
>> Thanks,
>> Ranjith
>>
>
>

RE: Export data with column names

Raghunath, Ranjith 2011-05-03, 19:23

Thanks Loren. Pardon my ignorance but what is an NPE?

Thank you,
Ranjith N. Raghunath

-----Original Message-----
From: Loren Siebert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 1:23 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Export data with column names

Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:

> set hive.cli.print.header=true;
>
>
> -----Original Message-----
> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 11:03 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Export data with column names
>
> Thanks. Is there something I can do with cli?
>
> Thanks,
> Ranjith
>
> ----- Original Message -----
> From: Matthew Rathbone <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Sent: Tue May 03 09:45:58 2011
> Subject: Re: Export data with column names
>
> If you use the thrift client you can call connection.getSchema()
>
> --
> Matthew Rathbone
> Foursquare | Software Engineer | Server Engineering Team
> [EMAIL PROTECTED] | @rathboma | 4sq
>
> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
> Does anyone know how to export data out with column names? Any help here is appreciated.
>>
>> Thanks,
>> Ranjith
>>
>
>

Re: Export data with column names

Loren Siebert 2011-05-03, 19:38

Sorry, null pointer exception

On May 3, 2011, at 12:23, "Raghunath, Ranjith" <[EMAIL PROTECTED]> wrote:

> Thanks Loren. Pardon my ignorance but what is an NPE?
>
> Thank you,
> Ranjith N. Raghunath
>
> -----Original Message-----
> From: Loren Siebert [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 1:23 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Export data with column names
>
> Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
>
>
> On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:
>
>> set hive.cli.print.header=true;
>>
>>
>> -----Original Message-----
>> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, May 03, 2011 11:03 AM
>> To: '[EMAIL PROTECTED]'
>> Subject: Re: Export data with column names
>>
>> Thanks. Is there something I can do with cli?
>>
>> Thanks,
>> Ranjith
>>
>> ----- Original Message -----
>> From: Matthew Rathbone <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> Sent: Tue May 03 09:45:58 2011
>> Subject: Re: Export data with column names
>>
>> If you use the thrift client you can call connection.getSchema()
>>
>> --
>> Matthew Rathbone
>> Foursquare | Software Engineer | Server Engineering Team
>> [EMAIL PROTECTED] | @rathboma | 4sq
>>
>> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
>> Does anyone know how to export data out with column names? Any help here is appreciated.
>>>
>>> Thanks,
>>> Ranjith
>>>
>>
>>

RE: Export data with column names

Steven Wong 2011-05-03, 20:20

Loren, can you point me to the jira that describes the problem/symptom in more detail? If there is no jira yet, can you describe it?

Thanks.
-----Original Message-----
From: Loren Siebert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 11:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Export data with column names

Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:

> set hive.cli.print.header=true;
>
>
> -----Original Message-----
> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 11:03 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Export data with column names
>
> Thanks. Is there something I can do with cli?
>
> Thanks,
> Ranjith
>
> ----- Original Message -----
> From: Matthew Rathbone <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Sent: Tue May 03 09:45:58 2011
> Subject: Re: Export data with column names
>
> If you use the thrift client you can call connection.getSchema()
>
> --
> Matthew Rathbone
> Foursquare | Software Engineer | Server Engineering Team
> [EMAIL PROTECTED] | @rathboma | 4sq
>
> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
> Does anyone know how to export data out with column names? Any help here is appreciated.
>>
>> Thanks,
>> Ranjith
>>
>
>

RE: Export data with column names

Raghunath, Ranjith 2011-05-03, 22:29

Thanks for the help on this. The option to set the header worked out great. Is there a way that I can export data out to the local file system with the header information?

Thank you,
Ranjith N. Raghunath
-----Original Message-----
From: Steven Wong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 3:20 PM
To: [EMAIL PROTECTED]
Subject: RE: Export data with column names

Loren, can you point me to the jira that describes the problem/symptom in more detail? If there is no jira yet, can you describe it?

Thanks.
-----Original Message-----
From: Loren Siebert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 11:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Export data with column names

Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:

> set hive.cli.print.header=true;
>
>
> -----Original Message-----
> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 11:03 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Export data with column names
>
> Thanks. Is there something I can do with cli?
>
> Thanks,
> Ranjith
>
> ----- Original Message -----
> From: Matthew Rathbone <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Sent: Tue May 03 09:45:58 2011
> Subject: Re: Export data with column names
>
> If you use the thrift client you can call connection.getSchema()
>
> --
> Matthew Rathbone
> Foursquare | Software Engineer | Server Engineering Team
> [EMAIL PROTECTED] | @rathboma | 4sq
>
> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
> Does anyone know how to export data out with column names? Any help here is appreciated.
>>
>> Thanks,
>> Ranjith
>>
>
>

RE: Export data with column names

Steven Wong 2011-05-04, 01:20

I'm not aware.
-----Original Message-----
From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 3:29 PM
To: [EMAIL PROTECTED]
Subject: RE: Export data with column names

Thanks for the help on this. The option to set the header worked out great. Is there a way that I can export data out to the local file system with the header information?

Thank you,
Ranjith N. Raghunath
-----Original Message-----
From: Steven Wong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 3:20 PM
To: [EMAIL PROTECTED]
Subject: RE: Export data with column names

Loren, can you point me to the jira that describes the problem/symptom in more detail? If there is no jira yet, can you describe it?

Thanks.
-----Original Message-----
From: Loren Siebert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 03, 2011 11:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Export data with column names

Look out for NPEs if you happen to set this option to true before doing add/drop table statements.
On May 3, 2011, at 11:10, Steven Wong <[EMAIL PROTECTED]> wrote:

> set hive.cli.print.header=true;
>
>
> -----Original Message-----
> From: Raghunath, Ranjith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 03, 2011 11:03 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Export data with column names
>
> Thanks. Is there something I can do with cli?
>
> Thanks,
> Ranjith
>
> ----- Original Message -----
> From: Matthew Rathbone <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Sent: Tue May 03 09:45:58 2011
> Subject: Re: Export data with column names
>
> If you use the thrift client you can call connection.getSchema()
>
> --
> Matthew Rathbone
> Foursquare | Software Engineer | Server Engineering Team
> [EMAIL PROTECTED] | @rathboma | 4sq
>
> On Monday, May 2, 2011 at 11:12 PM, Raghunath, Ranjith wrote:
> Does anyone know how to export data out with column names? Any help here is appreciated.
>>
>> Thanks,
>> Ranjith
>>
>
>