Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop from/to Oracle


+
Martin, Nick 2013-09-30, 22:32
Copy link to this message
-
Re: Sqoop from/to Oracle
Nick,

What is the exact command you are using and the exact error you are seeing?
Also, what version of sqoop are you using?

-Abe
On Mon, Sep 30, 2013 at 3:32 PM, Martin, Nick <[EMAIL PROTECTED]> wrote:

> Hi all,
>
> I have a table I've imported from Oracle into HDFS and now I want to
> export it into an Oracle Db (import and export table schemas are identical).
>
> My initial attempt at exporting from HDFS (using Sqoop) to Oracle failed
> (data types failures). So, my question is what's the best way for me to
> accomplish this? My source table is a mixture of NUMBER, VARCHAR, DATE
> fields. Am I better off importing into a Hive table I define and then
> exporting into Oracle from there? Or do I just need to do some export
> formatting in my Sqoop export statement?
>
> Any other intel you'd need to make a recommendation?
>
> Thanks in advance,
> Nick
>
> Sent from my iPhone
+
Martin, Nick 2013-09-30, 22:58
+
Martin, Nick 2013-10-01, 23:11
+
Abraham Elmahrek 2013-10-01, 23:31
+
Martin, Nick 2013-10-02, 00:03
+
Venkat Ranganathan 2013-10-02, 01:06
+
Martin, Nick 2013-10-02, 01:53
+
Martin, Nick 2013-10-28, 16:55
+
Abraham Elmahrek 2013-10-29, 23:06
+
Martin, Nick 2013-10-30, 00:32
+
Venkat Ranganathan 2013-10-30, 04:55
+
Martin, Nick 2013-10-30, 19:38
+
Venkat Ranganathan 2013-10-30, 20:44
+
Jarek Jarcec Cecho 2013-10-31, 06:07
+
Venkat Ranganathan 2013-11-01, 07:49