[jira] [Created] (SQOOP-2569) Problem with Oracle input table with TIMESTAMP columns

[Mirek Szymanski (JIRA)]

Mirek Szymanski created SQOOP-2569:
--------------------------------------

             Summary: 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
            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

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)