Error Stack:
Error:java.io.IOException:Cannection Handler cannot recover Failure:at org.apache.sqoop.mapreduce.db.SQLSer Verdbrecordreader.nextkeyvalue (Sqlserverdbrecordreader.java:169) at Org.apache.hadoop.mapred.maptask$newtrackingrecordreader.nextkeyvalue (Maptask.java:556) at Org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue (Mapcontextimpl.java: the) at Org.apache.hadoop.mapreduce.lib.map.wrappedmapper$context.nextkeyvalue (Wrappedmapper.java: the) at Org.apache.hadoop.mapreduce.Mapper.run (Mapper.java:145) at Org.apache.sqoop.mapreduce.AutoProgressMapper.run (Autoprogressmapper.java: -) at Org.apache.hadoop.mapred.MapTask.runNewMapper (Maptask.java:787) at Org.apache.hadoop.mapred.MapTask.run (Maptask.java:341) at org.apache.hadoop.mapred.yarnchild$2. Run (Yarnchild.java:164) at java.security.AccessController.doPrivileged (Native Method) at Javax.security.auth.Subject.doAs (subj Ect.java:422) at Org.apache.hadoop.security.UserGroupInformation.doAs (Usergroupinformation.java:1657) at Org.apache.hadoop.mapred.YarnChild.main (Yarnchild.java:158) caused By:java.io.IOException:SQLExceptioninchNextkeyvalue at Org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue (Dbrecordreader.java:277) at Org.apache.sqoop.mapreduce.db.SQLServerDBRecordReader.nextKeyValue (Sqlserverdbrecordreader.java:148) ... Amorecaused by:com.microsoft.sqlserver.jdbc.SQLServerException: Failed to convert string to uniqueidentifier. At Com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (Sqlserverexception.java:216) at Com.microsoft.sqlserver.jdbc.sqlserverresultset$fetchbuffer.nextrow (Sqlserverresultset.java:4853) at Com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext (Sqlserverresultset.java:1781) at Com.microsoft.sqlserver.jdbc.SQLServerResultSet.next (Sqlserverresultset.java:1034) at Org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue (Dbrecordreader.java:237) ... -More
FIX: A column of type uniqueidentifier cannot be the value of a parameter--split-by
Fix Sqoop Error: sqlserverexception: Failed to convert string to uniqueidentifier.