Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-471

Not able to export blob datatype from HDFS to MySQL

    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

        Attachments

          Activity

            People

            • Assignee:
              jarcec Jarek Jarcec Cecho
              Reporter:
              prashanthi prashanthi
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: