Hi everyone, I am trying to import data from postgre to hdfs but unfortunately, I am taking this error. What should I do? I would be really obliged if you can help. I am struggling more than 3 days.
------------------------------------------- Command that I used ------------------------------------------- [hadoop@ADUAE042-LAP-V ~]$ sqoop import-all-tables --direct --connect jdbc:postgresql://192.168.194.158:5432/IMS --username pgsql -P -- --schema LiveIPs -------------------------------------------- Result --------------------------------------- Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: $HADOOP_HOME is deprecated. 13/07/22 15:01:05 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 13/07/22 15:01:06 INFO manager.SqlManager: Using default fetchSize of 1000 13/07/22 15:01:06 INFO manager.PostgresqlManager: We will use schema LiveIPs 13/07/22 15:01:06 INFO tool.CodeGenTool: Beginning code generation 13/07/22 15:01:06 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM "LiveIPs"."2013-04-01" AS t LIMIT 1 13/07/22 15:01:06 ERROR orm.ClassWriter: Cannot resolve SQL type 1111 13/07/22 15:01:06 ERROR orm.ClassWriter: Cannot resolve SQL type 1111 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR orm.ClassWriter: No Java type for SQL type 1111 for column ip 13/07/22 15:01:06 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException java.lang.NullPointerException at org.apache.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:912) at org.apache.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:937) at org.apache.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:1011) at org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1342) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1153) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390) at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:64) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
