Hi Bipin, I believe this issue will be fixed in the next release 1.99.6. Here is the jira https://issues.apache.org/jira/browse/SQOOP-2213
Qian (Stanley) Xu From: Bipin Nag [mailto:[email protected]] Sent: Tuesday, April 07, 2015 5:53 PM To: [email protected] Subject: Sqoop Import: Error when importing from ms-sql server 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
