[
https://issues.apache.org/jira/browse/SQOOP-991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13635017#comment-13635017
]
prashanthi commented on SQOOP-991:
----------------------------------
Adding to the above issue, the command am using to import as sequence file is
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
> 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
