sqoop能否将blob类型从HDFS导出到Mysql？

Question

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

我有一个具有blob类型列的表，我可以将其导入HDFS，但当将其导回时会引发异常：

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)

Answer 1

这是Sqoop的一个主要错误，它仍然处于打开状态。

有关更多详细信息，请参阅Not able to export blob datatype from HDFS to MySQL

希望这篇文章能提供关于你的问题的信息。