[
https://issues.apache.org/jira/browse/SQOOP-991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14551072#comment-14551072
]
karan commented on SQOOP-991:
-----------------------------
I get the same error exporting blob data to mysql with sqoop1. Is there any
workaround or patch?
org.apache.sqoop.mapreduce.TextExportMapper: Exception:
java.io.IOException: Could not buffer record
at
org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:218)
....
Caused by: java.lang.CloneNotSupportedException: com.cloudera.sqoop.lib.BlobRef
> Not able to export blob datatype from HDFS to MySQL
> ---------------------------------------------------
>
> Key: SQOOP-991
> URL: https://issues.apache.org/jira/browse/SQOOP-991
> Project: Sqoop
> Issue Type: Bug
> Reporter: prashanthi
>
> Inserted a .txt/pdf/jpg/jpeg file to blob column and trying to import it to
> HDFS. and it is fine. while exporting the same to MySql it is giving
> java.io.IOException: Could not buffer record Caused by:
> java.lang.CloneNotSupportedException: com.cloudera.sqoop.lib.BlobRef
> Ifi import the file as sequence file to HDFS then also import is fine but
> when exporting same to MySQL it says that java.lang.RuntimeException:
> java.io.IOException: WritableName can't load class: pdffile
> Please help me on resolving the issue.
> Commands which i am using to import and export are
> sqoop import --connect jdbc:mysql://localhost/test --table Image
> --fields-terminated-by '\t' --username root --password naveen@123 -m 1
> sqoop export --connect jdbc:mysql://localhost/test --table Image_new
> --export-dir /user/naveen/Image --fields-terminated-by '\t' --username root
> --password naveen@123 -m 1
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
