Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - ERROR orm.ClassWriter: No db getter method for Java type


Copy link to this message
-
ERROR orm.ClassWriter: No db getter method for Java type
Fatih Haltas 2013-07-24, 11:32
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)