Hi Jarek, Here is the output with --verbose option.
[hadoop@ADUAE042-LAP-V ~]$ sqoop import-all-tables --verbose --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 /IndiaMachine_InferDB/InterestingIPs --direct --connect jdbc:postgresql://ipAddress:5432/IITNYUDB --username itnyu --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/25 14:15:09 DEBUG tool.BaseSqoopTool: Enabled debug logging. 13/07/25 14:15:09 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory 13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory 13/07/25 14:15:09 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:postgresql: 13/07/25 14:15:09 INFO manager.SqlManager: Using default fetchSize of 1000 13/07/25 14:15:09 INFO manager.PostgresqlManager: We will use schema InterestingIPs 13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.DirectPostgresqlManager@676bd8ea 13/07/25 14:15:09 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection. 13/07/25 14:15:11 INFO tool.CodeGenTool: Beginning code generation 13/07/25 14:15:11 DEBUG manager.SqlManager: Using fetchSize for next query: 1000 13/07/25 14:15:11 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM "InterestingIPs"."2013-07-18" AS t LIMIT 1 13/07/25 14:15:14 DEBUG orm.ClassWriter: selected columns: 13/07/25 14:15:14 DEBUG orm.ClassWriter: ip 13/07/25 14:15:14 DEBUG orm.ClassWriter: names 13/07/25 14:15:14 DEBUG orm.ClassWriter: steppingStoneScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: muleContactScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: infectedContactScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: evasiveTrafficScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: darkSpaceSourceScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: darkSpaceTargetScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: nonDNSTrafficScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: rebootScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: malwareSourceScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: malwareTargetScore 13/07/25 14:15:14 DEBUG orm.ClassWriter: minVirulence 13/07/25 14:15:14 DEBUG orm.ClassWriter: maxVirulence 13/07/25 14:15:14 DEBUG orm.ClassWriter: currentVirulence 13/07/25 14:15:14 DEBUG orm.ClassWriter: rank 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge getter for Java type 13/07/25 14:15:14 ERROR orm.ClassWriter: No db getter method for Java type 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge getter for Java type 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 ERROR orm.ClassWriter: Could not infer PreparedStatement setter for Java type 13/07/25 14:15:14 ERROR orm.ClassWriter: No db setter method for Java type 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 ERROR orm.ClassWriter: No ResultSet method for Java type 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column infectedContactScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column evasiveTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column darkSpaceTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column nonDNSTrafficScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rebootScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareSourceScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column malwareTargetScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to String 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column steppingStoneScore to Long 13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column muleContactScore to 13/07/25 14:15:14 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) On Wed, Jul 24, 2013 at 7:02 PM, Jarek Jarcec Cecho <[email protected]>wrote: > 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) >
