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 15:44:53 GMT
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]
Sent: Monday, May 04, 2015 11:35 AM
To: 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