Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> ERROR orm.ClassWriter: Cannot resolve SQL type 1111


Copy link to this message
-
ERROR orm.ClassWriter: Cannot resolve SQL type 1111
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB