Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB