Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB