oracle blob 表导出,从oracle导出blob数据到hbase中的问题

weixin_39565910

于 2021-04-06 17:47:57 发布

阅读量198

点赞数

文章标签： oracle blob 表导出

大家好，最近在做数据的迁移，使用sqoop从oracle中把数据导出到hbase中，如果oracle表没有blob字段，可以正常导出；但是如果表中包含blob字段，则sqoop命令直接出错，错误如下：哪位大侠有碰到过这个问题呀？

15/08/14 12:38:28 DEBUG manager.OracleManager: Using column names query: SELECT t.* FROM doc_list t WHERE 1=0

15/08/14 12:38:28 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : SELECT t.* FROM doc_list t WHERE 1=0

15/08/14 12:38:28 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@192.168.14.77:1521:orcl, using username: test

15/08/14 12:38:28 DEBUG manager.OracleManager: No connection paramenters specified. Using regular API for making connection.

15/08/14 12:38:28 INFO manager.OracleManager: Time zone has been set to GMT

15/08/14 12:38:28 DEBUG manager.SqlManager: Using fetchSize for next query: 1000

15/08/14 12:38:28 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM doc_list t WHERE 1=0

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column DOC_ID of type [2, 9, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column DOC_NAME of type [12, 255, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column DOC_TYPE of type [12, 30, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column DOC_DESC of type [12, 4000, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column DOC_VER of type [12, 30, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column FILE_NAME of type [12, 255, 0]

15/08/14 12:38:28 DEBUG manager.SqlManager: Found column FILE_SIZE of type [2, 9, 0]

15/08/14 12:38:28 ERROR tool.ImportTool: Imported Failed: For input string: "4294967295"

关注