sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dhandapani, Karthik" <Karthik.Dhandap...@CVSCaremark.com>
Subject RE: Sqoop import to hive with additional column
Date Mon, 04 May 2015 16:07:24 GMT
Try using –query option

Thanks,
Karthik

From: Suresh Kumar Sethuramaswamy [mailto:rockssk@gmail.com]
Sent: Monday, May 04, 2015 11:57 AM
To: user@sqoop.apache.org
Subject: Re: Sqoop import to hive with additional column

Thanks for the suggestions Karthik, but I don't have access to create in oracle, is there
a way I can pass an additional column in sqoop command line?


Regards
Suresh

On Monday, May 4, 2015, Dhandapani, Karthik <Karthik.Dhandapani@cvscaremark.com<mailto:Karthik.Dhandapani@cvscaremark.com>>
wrote:
Hi,

You can create a view on top of Oracle Table with the 10th column and use view as the source
to Sqoop.

Thanks,
Karthik

From: Suresh Kumar Sethuramaswamy [mailto:rockssk@gmail.com<javascript:_e(%7B%7D,'cvml','rockssk@gmail.com');>]
Sent: Monday, May 04, 2015 11:35 AM
To: user@sqoop.apache.org<javascript:_e(%7B%7D,'cvml','user@sqoop.apache.org');>
Subject: Sqoop import to hive with additional column

hi


    I need to source data from oracle to hive, oracle has 9 columns and hive 10 columns ,
the 10th column need to be a constant value(ex. Date)

How do I hardcode the value for 10th column while import , suggestions please


Regards
Suresh
Mime
View raw message