热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

解决sqoop报错:SQLServerException:将字符串转换为uniqueidentifier时失败。

报错栈:Error:java.io.IOException:Cannectionhandlercannotrecoverfailure:atorg.apache.sqo

报错栈:

Error: java.io.IOException: Cannection handler cannot recover failure: 
at org.apache.sqoop.mapreduce.db.SQLServerDBRecordReader.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:
80)
at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:
91)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:
145)
at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:
64)
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(Subject.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: SQLException
in nextKeyValue
at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:
277)
at org.apache.sqoop.mapreduce.db.SQLServerDBRecordReader.nextKeyValue(SQLServerDBRecordReader.java:
148)
...
12 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 将字符串转换为 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)
...
13 more
解决:uniqueidentifier类型的列不能作为参数--split-by的值
推荐阅读
author-avatar
朱小小喵喵_972
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有