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 >> RE: [sqoop-user] Sqoop export - Date issue with Oracle


Copy link to this message
-
RE: [sqoop-user] Sqoop export - Date issue with Oracle
Hi Nago,

I just tried this out with a file the same as you specified and got the same error as you.

The good news is when I used the Quest Data Connector for Oracle and Hadoop it worked fine - so perhaps you could use that instead?

You can download it from here: http://toadforcloud.com/entry.jspa?categoryID=677&externalID=4298
Source code is available here under Apache 2.0 license: https://github.com/QuestSoftwareTCD/OracleSQOOPconnector

Let us know if this resolves your issue.

Regards,

David

-----Original Message-----
From: nago [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 January 2012 3:16 AM
To: Sqoop Users
Subject: [sqoop-user] Sqoop export - Date issue with Oracle

Hello Friends,

I am trying to do sqooping the data from HDFC file to Oracle (10.2g) table.
I could do sqooping if no date value in the file.

But, if i have date value in the file , it throws exception that "Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] ".
what is the problem ?What should i do , so that i can avoid this issue ?
This the sqoop command i have :
--------------------------------------------------
 sqoop export  --connect jdbc:oracle:thin:@//16.48.140.88/aggint --
username NAGO  -P  --table WD1   --export-dir /services/location/
mapskpi/reporting/data/test/ --fields-terminated-by ,

data in the file will look alike:
----------------------------------------
2012-01-06,2012,1,1,258665,2012-01-13

Oracle Table WD1:
--------------------------
FI_DT        DATE
YR        NUMBER(38)
CNT1      NUMBER(38)
CNT2      NUMBER(38)
CNT3      NUMBER(38)
SE_DT      DATE

can you please help ?

Thanks
nago

--
NOTE: The mailing list [EMAIL PROTECTED] is deprecated in favor of Apache Sqoop mailing list [EMAIL PROTECTED]. Please subscribe to it by sending an email to [EMAIL PROTECTED].
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