[
https://issues.apache.org/jira/browse/SQOOP-2569?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15098760#comment-15098760
]
Srini Pindi commented on SQOOP-2569:
------------------------------------
Here is the temp. solution that worked for me. Create a view on top the table
or recreate the table as below for date columns:
CASE DateColumn WHEN NULL THEN NULL ELSE to_char(DateColumn , 'YYYY-MM-DD
HH24:MI:SS') END AS "DateColumn"
> Problem with Oracle input table with TIMESTAMP columns
> ------------------------------------------------------
>
> Key: SQOOP-2569
> URL: https://issues.apache.org/jira/browse/SQOOP-2569
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.99.6
> Environment: Oracle 11g
> Reporter: Mirek Szymanski
>
> While transferring data from Oracle database from table with Timestamp
> column, exception is thrown - oracle.sql.TIMESTAMP cannot be cast to
> java.sql.Timestamp
> Similar problems have been already reported for Sqoop 1 (SQOOP-935,
> SQOOP-1600).
> Stack trace:
> 2015-09-14 13:23:26,421 INFO [AsyncDispatcher event handler]
> org.apache.hadoop.mapreduce.v2.app.job.impl.TaskAttemptImpl: Diagnostics
> report from attempt_1441804561641_0241_m_000001_0: Error:
> org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during
> extractor run
> at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:99)
> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
> Caused by: java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast
> to java.sql.Timestamp
> at
> org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:79)
> at
> org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:38)
> at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:95)
> ... 7 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
