sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bipin Nag <bipin....@gmail.com>
Subject Sqoop Import: Error when importing from ms-sql server
Date Tue, 07 Apr 2015 09:52:35 GMT
Hi,

I get the following error when I try to import a table from mssql server. I
am using Sqoop 1.99.5.

2015-04-07 14:58:51,414 INFO org.apache.hadoop.mapred.TaskStatus:
task-diagnostic-info for task attempt_201504071244_0008_m_000000_2 :
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:672)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
        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:1642)
        at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: java.lang.ClassCastException: java.lang.Short cannot be cast to
java.lang.Integer
        at
org.apache.sqoop.connector.common.SqoopIDFUtils.toCSVFixedPoint(SqoopIDFUtils.java:117)
        at
org.apache.sqoop.connector.idf.CSVIntermediateDataFormat.toCSV(CSVIntermediateDataFormat.java:223)
        at
org.apache.sqoop.connector.idf.CSVIntermediateDataFormat.setObjectData(CSVIntermediateDataFormat.java:165)
        at
org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeArrayRecord(SqoopMapper.java:125)
        at
org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:96)
        at
org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:38)
        at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:95)
        ... 7 more

How can I fix this and load the table properly ?

Thanks
Bipin

Mime
View raw message