Tag: <span>Sqoop</span>

Tag: Sqoop

Sqoop export to Teradata Error: Parameter 11 length is 113941 bytes, which is greater than the maximum 64000 bytes that can be set

Recently I have found an issue in Sqoop that when exporting data to Teradata with data value larger than 64KB to CLOB data type, job will be failed with error similar to below: After contacting with Teradata Support, it turned out to be a limitation/restriction from Teradata side, that for …


Sqoop Job Failed with Error: java.lang.NoClassDefFoundError: org/json/JSONObject

If your Sqoop job fails with below error message: This is very likely caused by conflicting JAR files being loaded by sqoop, and mostly related to JAR files under /usr/lib/hive directory, which is normally created by package installation of Sqoop, rather than via Parcels through Cloudera Manager. The solution is …


My Patch for SQOOP-3330 Committed

In the last few weeks, I have been working on an issue in Sqoop that Sqoop’s “–append” options does not work well with parameter “-Dmapreduce.output.basename”. The goal of adding “-Dmapreduce.output.basename” is to ask Sqoop to generate custom file names for the target file in HDFS, rather than using the default …


My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!