Sqoop : Lzo compression not working for importing data from oracle to HDFS

[#1]

Sqoop Command :

sqoop import --connect jdbc:oracle:thin:@//**.***.***.***:1521/*** --username ***** --password ******* --table COUNTRIES --target-dir /user/aps/test --compress --compression-codec com.hadoop.compression.lzo.LzopCodec -m 1

I am getting below error

16/09/14 12:32:41 ERROR tool.ImportTool: Encountered IOException running import job: com.cloudera.sqoop.io.UnsupportedCodecException: com.hadoop.compression.lzo.LzopCodec at org.apache.sqoop.io.CodecMap.getCodecClassName(CodecMap.java:79) at org.apache.sqoop.io.CodecMap.getCodec(CodecMap.java:101) at com.cloudera.sqoop.io.CodecMap.getCodec(CodecMap.java:64) at org.apache.sqoop.mapreduce.ImportJobBase.configureOutputFormat(ImportJobBase.java:116) at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:259) at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:673) at org.apache.sqoop.manager.OracleManager.importTable(OracleManager.java:445) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:148) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235) at org.apache.sqoop.Sqoop.main(Sqoop.java:244)

Please help.

Thanks, Arkaprova

[#2 · Accepted solution]

Hi,

Could you try:

sqoop import --connect jdbc:oracle:thin:@//**.***.***.***:1521/*** --username ***** --password ******* --table COUNTRIES --target-dir /user/aps/test --compress --compression-codec LZOP -m 1

Or LZO if you want LZO instead of LZOP.

[#3]

@Pierre Villard

Thanks a lot. This is working now with lower case.

[#4]

@Pierre Villard

I am getting below error now if I use --compression-codec LZOP

16/09/14 14:36:29 ERROR tool.ImportTool: Encountered IOException running import job: com.cloudera.sqoop.io.UnsupportedCodecException: LZOP at org.apache.sqoop.io.CodecMap.getCodecClassName(CodecMap.java:79) at org.apache.sqoop.io.CodecMap.getCodec(CodecMap.java:101) at com.cloudera.sqoop.io.CodecMap.getCodec(CodecMap.java:64) at org.apache.sqoop.mapreduce.ImportJobBase.configureOutputFormat(ImportJobBase.java:116) at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:259) at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:673) at org.apache.sqoop.manager.OracleManager.importTable(OracleManager.java:445) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:148) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235) at org.apache.sqoop.Sqoop.main(Sqoop.java:244)

Please suggest.

[#5]

Could you try with lower case?

--compression-codec lzop

Based on the code:

https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/io/CodecMap.java

it may be case sensitive...

[#6]

Thanks a lot . This is working for lower case.