sqoop 可以将 blob 类型从 HDFS 导出到 Mysql 吗? [英] Can sqoop export blob type from HDFS to Mysql?

查看:58
本文介绍了sqoop 可以将 blob 类型从 HDFS 导出到 Mysql 吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Sqoop 能否将 blob 类型从 HDFS 导出到 Mysql?

Can Sqoop export blob type from HDFS to Mysql?

我有一个带有 blob 类型列的表,我可以将它导入到 HDFS,但是在将其导出时会引发异常:

I have a table with blob type column, and I can import it to HDFS, but when export it back it raises exception:

Caused by: java.io.IOException: Could not buffer record
    at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:218)
    at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:46)
    at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:639)
    at org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
    at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:84)
    ... 6 more
Caused by: java.lang.CloneNotSupportedException: com.cloudera.sqoop.lib.BlobRef
    at java.lang.Object.clone(Native Method)
    at org.apache.sqoop.lib.LobRef.clone(LobRef.java:109)
    at TblPlugin.clone(TblPlugin.java:270)
    at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:213)

推荐答案

这是Sqoop的一个主要Bug,目前仍处于开放状态.

This is a Major Bug of Sqoop and it is still in open Status.

有关详细信息,请参阅无法将 blob 数据类型从 HDFS 导出到 MySQL

希望这能提供有关您的问题的信息.

Hope this gives information about your issue.

这篇关于sqoop 可以将 blob 类型从 HDFS 导出到 Mysql 吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆