You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by foo bar <cl...@gmail.com> on 2014/10/02 20:13:45 UTC

Sqoop to write column names as headers

Hi,

I'm importing a table of data from Oracle into HDFS.
I need to have Sqoop to write the column names as headers into the import
files (files that end up in HDFS). Is there a way to do that? I basically
need the import file to look like the following:

ID, Country, City
1,USA,Palo Alto
2,Czech Republic,Brno
3,USA,Sunnyvale

instead of the following:

1,USA,Palo Alto
2,Czech Republic,Brno
3,USA,Sunnyvale

Thank you,

Re: Sqoop to write column names as headers

Posted by Abraham Elmahrek <ab...@cloudera.com>.

Hey there,

This is not something Sqoop currently does. Is this just for readability?
If so, have you thought about importing into Hive or HBase?

-Abe

On Thu, Oct 2, 2014 at 11:13 AM, foo bar <cl...@gmail.com> wrote:

> Hi,
>
> I'm importing a table of data from Oracle into HDFS.
> I need to have Sqoop to write the column names as headers into the import
> files (files that end up in HDFS). Is there a way to do that? I basically
> need the import file to look like the following:
>
> ID, Country, City
> 1,USA,Palo Alto
> 2,Czech Republic,Brno
> 3,USA,Sunnyvale
>
> instead of the following:
>
> 1,USA,Palo Alto
> 2,Czech Republic,Brno
> 3,USA,Sunnyvale
>
> Thank you,
>