[jira] [Assigned] (SQOOP-991) Not able to export blob datatype from HDFS to MySQL

["Chiwan Park (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chiwan Park reassigned SQOOP-991:
---------------------------------

    Assignee:     (was: Chiwan Park)

> 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)