Sqoop job failed with ClassNotFoundException

In the last few weeks, I was dealing with an issue that when importing data from DB2 into HDFS, it kept failing with NoClassDefFoundError. Below was the command details: sqoop import –connect jdbc:db2://<db2-host-url>:3700/db1 –username user1 –password changeme –table ZZZ001$.part_table –target-dir /path/in/hdfs –fields-terminated-by \001 -m 1 –validate And the error message …

Unable to Import Data as Parquet into Encrypted HDFS Zone

Recently I have discovered an issue in Sqoop that when it is importing data into Hive table, whose location is in an encrypted HDFS zone, the Sqoop command will fail with the following errors: Command: sqoop import –connect <postgres_url> –username <username> –password <password> \ –table sourceTable –split-by id –hive-import –hive-database …

Unable to Import Data as Parquet into Encrypted HDFS Zone | Sqoop Parquet Import

Recently I discovered an issue in Sqoop that when importing data into Hive table, whose location is in an encrypted HDFS zone, it will fail with “can’t be moved into an encryption zone” error: Command: sqoop import –connect <postgres_url> –username <username> –password <password> \ –table sourceTable –split-by id –hive-import –hive-database …