Hi Fatih, would be helpful if you could rerun the Sqoop command with parameter --verbose and share the output with us.
Jarcec On Wed, Jul 24, 2013 at 03:32:07PM +0400, Fatih Haltas wrote: > Hi everyone, > > I am trying to import postgre data to hadoop, for other all tables there is > no problem. But for one table, I am getting the error below. > > What is the reason for it? What should i do? > > Thanks. > > [hadoop@ADUAE042-LAP-V ~]$ sqoop import-all-tables --map-column-java > ip=Long,names=String,steppingStoneScore=Long,muleContactScore==Long,infectedContactScore=Long,evasiveTrafficScore=Long,darkSpaceSourceScore=Long,darkSpaceTargetScore=Long,nonDNSTrafficScore=Long,rebootScore=Long,malwareSourceScore=Long,malwareTargetScore=Long,rank=Long > --warehouse-dir /IndDB/InterestingIPs --direct --connect > jdbc:postgresql://IP-Adress:5432/Database --username it --password XXX -- > --schema InterestingIPs > > > 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/24 14:43:53 WARN tool.BaseSqoopTool: Setting your password on the > command-line is insecure. Consider using -P instead. > 13/07/24 14:43:53 INFO manager.SqlManager: Using default fetchSize of 1000 > 13/07/24 14:43:53 INFO manager.PostgresqlManager: We will use schema > InterestingIPs > 13/07/24 14:43:55 INFO tool.CodeGenTool: Beginning code generation > 13/07/24 14:43:55 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM "InterestingIPs"."2013-07-18" AS t LIMIT 1 > 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge > getter for Java type > 13/07/24 14:43:58 ERROR orm.ClassWriter: No db getter method for Java type > 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge > getter for Java type > 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer PreparedStatement > setter for Java type > 13/07/24 14:43:58 ERROR orm.ClassWriter: No db setter method for Java type > 13/07/24 14:43:58 ERROR orm.ClassWriter: No ResultSet method for Java type > 13/07/24 14:43:58 ERROR sqoop.Sqoop: Got exception running Sqoop: > java.lang.IllegalArgumentException: No ResultSet method for Java type > java.lang.IllegalArgumentException: No ResultSet method for Java type > at org.apache.sqoop.orm.ClassWriter.rpcSetterForType(ClassWriter.java:457) > at > org.apache.sqoop.orm.ClassWriter.rpcSetterForMaybeNull(ClassWriter.java:472) > at > org.apache.sqoop.orm.ClassWriter.generateHadoopWrite(ClassWriter.java:1037) > at > org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1340) > 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)
signature.asc
Description: Digital signature
