Sqoop1 Import Job Failed With Error “java.io.IOException: No columns to generate for ClassWriter”

Recently when I was testing Sqoop1 command in my CDH cluster, I kept getting “java.io.IOException: No columns to generate for ClassWriter” error. The full command was like below: And full stacktrace: Although I do not have the RCA yet for this issue, I do have a workaround, which is adding …

Sqoop Hive Import Failed After Upgrading to CDH5.4.x or CDH5.5.x

This article explains the root cause of Sqoop Hive Import failure after upgrading to CDH5.4.x or CDh5.5.x and the solution to fix the issue. After upgrading to CDH5.5.x from CDh5.3.x, Sqoop Hive Import got the following error: After upgrading to CDH5.4.x from CDh5.3.x, Sqoop Hive Import got the following error: …

Unable to import Oracle table with CLOB column into HDFS using Sqoop

If you encountered the following error while importing Oracle table into HDFS: Chances are that you are hitting a Sqoop bug: SQOOP-117 At the time of writing, it is not fixed yet, but we can have a very simple workaround for this issue. Simply use –map-column-java option supported by Sqoop, …