You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "prashanthi (JIRA)" <ji...@apache.org> on 2013/04/18 09:21:23 UTC
[jira] [Created] (SQOOP-991) Not able to export blob datatype from
HDFS to MySQL
prashanthi created SQOOP-991:
--------------------------------
Summary: 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira