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)
