Details
-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Duplicate
-
Affects Version/s: CDH3u2
-
Fix Version/s: None
-
Component/s: Sqoop
-
Labels:None
Description
Inserted a 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
sqoop import --connect jdbc:mysql://localhost/test --table Image --fields-terminated-by '\t' --username root --password naveen@123 -m 1 --as-sequencefile
and for export am using
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