[SQOOP-991] Not able to export blob datatype from HDFS to MySQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: prashanthi
• Created: 18/Apr/13 07:20
• Updated: 12/Jan/16 07:56

Description

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