At those columns, I am using uint type. I tried to cast them via sqoop option still it gave the same error.
For other columns having type int, text etc, I am able to import them but I have hundreds of data in uint type that I need. While looking at some solutions, I saw that sqoop does not support uint type, is it correct or is there any update related uint type? Thanks you all, especially to Jarcec, you helped me a lot ;) On Mon, Jul 22, 2013 at 7:04 PM, Jarek Jarcec Cecho <jar...@apache.org>wrote: > Hi Fatih, > per JDBC documentation [1] the code 1111 stands for type OTHER which > basically means "unknown". As Sqoop do not know the type, it do not know > how to transfer it to Hadoop. Would you mind sharing your table definition? > > The possible workaround is to use query based import and cast the > problematic columns to known and supported data types. > > Jarcec > > Links: > 1: > http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.OTHER > > On Mon, Jul 22, 2013 at 04:03:42PM +0400, Fatih Haltas wrote: > > 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) >
